Query Metrics
8264
Database Queries
12
Different statements
1468.53 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
258.75 ms (0.00%) |
721 |
SELECT IF( ctc.rowid IS NOT NULL, sp.rowid , sp.rowid ) AS contact_id , IF( ctc.rowid IS NOT NULL, sp.lastname , sp.lastname ) AS nom , IF( ctc.rowid IS NOT NULL, sp.firstname , sp.firstname ) AS prenom , IF( ctc.rowid IS NOT NULL, sp.phone_mobile , sp.phone_mobile ) AS telephone , IF( ctc.rowid IS NOT NULL, sp.email , sp.email ) AS email , IF( ctc.rowid IS NOT NULL, sp.address , sp.address ) AS `adresse` , IF( ctc.rowid IS NOT NULL, sp.zip , sp.zip ) AS code_postal , IF( ctc.rowid IS NOT NULL, sp.town , sp.town ) AS ville , IF( ctc.rowid IS NOT NULL, cc.code , sp.fk_pays ) AS pays , IF( ctc.rowid IS NOT NULL, sp.default_lang , sp.default_lang ) AS langue , IF( ctc.rowid IS NOT NULL, spe.mode_transport , spe.mode_transport ) AS mode_transport , IF( ctc.rowid IS NOT NULL, spe.format_livraison, spe.format_livraison ) AS format_livraison , IF( ctc.rowid IS NOT NULL, spe.lieu_livraison , spe.lieu_livraison ) AS lieu_livraison , IF( ctc.rowid IS NOT NULL, spe.societe , spe.societe ) AS societe -- , ctc.* FROM walkinn_dossier d LEFT JOIN walkinn_dossier_segment ds ON ds.dossier_id = d.id LEFT JOIN walkinn_dossier_segment_pax dsp ON dsp.segment_id = ds.id LEFT JOIN doli_socpeople sp1 ON sp1.rowid = dsp.contact_id LEFT JOIN doli_societe soc ON soc.rowid = sp1.fk_soc LEFT JOIN doli_socpeople sp ON soc.rowid = sp.fk_soc LEFT JOIN doli_c_country cc ON cc.rowid = sp.fk_pays LEFT JOIN doli_socpeople_extrafields spe ON spe.fk_object = sp.rowid LEFT JOIN doli_societe_contacts sc ON sc.fk_soc = soc.rowid AND sc.fk_socpeople = sp.rowid LEFT JOIN doli_c_type_contact ctc ON ctc.rowid = sc.fk_c_type_contact WHERE 1 = 1 AND d.id = :dossierId AND ctc.element = :element AND ctc.code = :code GROUP BY d.id, soc.rowid
Parameters:
[ ":dossierId" => "4097" ":element" => "facture" ":code" => "SHIPPING" ] |
|
241.33 ms (0.00%) |
721 |
SELECT IF( ctc.rowid IS NOT NULL, sp.rowid , sp.rowid ) AS contact_id , IF( ctc.rowid IS NOT NULL, sp.lastname , sp.lastname ) AS nom , IF( ctc.rowid IS NOT NULL, sp.firstname , sp.firstname ) AS prenom , IF( ctc.rowid IS NOT NULL, sp.phone_mobile , sp.phone_mobile ) AS telephone , IF( ctc.rowid IS NOT NULL, sp.email , sp.email ) AS email , IF( ctc.rowid IS NOT NULL, sp.address , sp.address ) AS `adresse` , IF( ctc.rowid IS NOT NULL, sp.zip , sp.zip ) AS code_postal , IF( ctc.rowid IS NOT NULL, sp.town , sp.town ) AS ville , IF( ctc.rowid IS NOT NULL, cc.code , sp.fk_pays ) AS pays , IF( ctc.rowid IS NOT NULL, sp.default_lang , sp.default_lang ) AS langue -- , ctc.* FROM walkinn_dossier d LEFT JOIN walkinn_dossier_segment ds ON ds.dossier_id = d.id LEFT JOIN walkinn_dossier_segment_pax dsp ON dsp.segment_id = ds.id LEFT JOIN doli_socpeople sp1 ON sp1.rowid = dsp.contact_id LEFT JOIN doli_societe soc ON soc.rowid = sp1.fk_soc LEFT JOIN doli_socpeople sp ON soc.rowid = sp.fk_soc LEFT JOIN doli_c_country cc ON cc.rowid = sp.fk_pays LEFT JOIN doli_socpeople_extrafields spe ON spe.fk_object = sp.rowid LEFT JOIN doli_societe_contacts sc ON sc.fk_soc = soc.rowid AND sc.fk_socpeople = sp.rowid LEFT JOIN doli_c_type_contact ctc ON ctc.rowid = sc.fk_c_type_contact WHERE 1 = 1 AND d.id = :dossierId AND ctc.element = :element AND ctc.code = :code GROUP BY d.id, soc.rowid
Parameters:
[ ":dossierId" => "4097" ":element" => "facture" ":code" => "BILLING" ] |
|
189.15 ms (0.00%) |
1442 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.reference_resa_client AS reference_resa_client_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.is_valide AS is_valide_12, t0.annee AS annee_13, t0.date_confirmation AS date_confirmation_14, t0.code_client AS code_client_15, t0.docs AS docs_16, t0.envoi_docs AS envoi_docs_17, t0.dossier_seen AS dossier_seen_18, t0.desc_devis AS desc_devis_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.dossier_type_id AS dossier_type_id_22, t0.dossier_etat_id AS dossier_etat_id_23, t0.destination_id AS destination_id_24, t0.charge_dossier_id AS charge_dossier_id_25, t26.id AS id_27, t26.html AS html_28, t26.dossier_id AS dossier_id_29, t0.charge_dossier2_id AS charge_dossier2_id_30, t0.theme_id AS theme_id_31, t0.categorie_id AS categorie_id_32, t33.id AS id_34, t33.code AS code_35, t33.libelle AS libelle_36, t33.langue AS langue_37, t33.date_expiration AS date_expiration_38, t33.client AS client_39, t33.client_id AS client_id_40, t33.commande_id AS commande_id_41, t33.montant_total AS montant_total_42, t33.montant_base AS montant_base_43, t33.date_depart AS date_depart_44, t33.date_retour AS date_retour_45, t33.facture AS facture_46, t33.statut_paiement AS statut_paiement_47, t33.propal_id AS propal_id_48, t33.propal_link AS propal_link_49, t33.commande_link AS commande_link_50, t33.actif AS actif_51, t33.facture_id AS facture_id_52, t33.pending AS pending_53, t33.created_at AS created_at_54, t33.updated_at AS updated_at_55, t33.type_reservation_id AS type_reservation_id_56, t33.statut_id AS statut_id_57, t33.voyage_id AS voyage_id_58, t33.formule_id AS formule_id_59, t33.dossier_id AS dossier_id_60, t33.created_by AS created_by_61, t33.updated_by AS updated_by_62, t0.created_by AS created_by_63, t0.updated_by AS updated_by_64 FROM walkinn_dossier t0 LEFT JOIN walkinn_dossier_guide t26 ON t26.dossier_id = t0.id LEFT JOIN kernix_reservation t33 ON t33.dossier_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"4097"
]
|
|
177.11 ms (0.00%) |
721 |
SELECT we.id AS id, dsp.contact_id AS contact_id FROM walkinn_service AS serv INNER JOIN walkinn_dossier_segment_service dss ON dss.service_id = serv.id AND dss.actif=1 INNER JOIN walkinn_dossier_segment ds ON ds.id = dss.segment_id AND ds.dossier_id = :dossierId AND ds.is_prestation_seche = 0 AND ds.actif = 1 INNER JOIN walkinn_voyage v ON v.id = ds.voyage_id INNER JOIN walkinn_voyage_service vs ON vs.voyage_id = v.id AND vs.service_id = serv.id AND vs.actif = 1 INNER JOIN walkinn_editorial we ON we.service_id = serv.id INNER JOIN walkinn_dossier_segment_service_pax dssp ON dssp.dossier_segment_service_id = dss.id AND dssp.actif = 1 INNER JOIN walkinn_dossier_segment_pax dsp ON dsp.id = dssp.dossier_segment_pax_id WHERE 1 = 1 AND serv.type_id = :serviceTypeId
Parameters:
[ ":dossierId" => "4097" ":serviceTypeId" => 3 ] |
|
159.20 ms (0.00%) |
721 |
SELECT sp.rowid AS contact_id , sp.lastname AS nom , sp.firstname AS prenom , sp.address AS `adresse` , sp.zip AS code_postal , sp.town AS ville , cc.code AS pays , sp.birthday AS date_naissance , sp.email AS email , sp.default_lang AS langue , spe.taille AS taille , spe.taille_pied AS taille_pied , spe.taille_pouce AS taille_pouce , spe.taille_pied_pouce AS taille_pied_pouce , spe.location_velo AS location_velo , spe.velo AS velo , spe.prix_velo AS prix_velo , spe.souscription_assurance AS souscription_assurance , spe.location_casque AS location_casque , IFNULL(dsp.is_sup_single,0) AS supp_single FROM walkinn_dossier d LEFT JOIN walkinn_dossier_segment ds ON ds.dossier_id = d.id INNER JOIN walkinn_dossier_segment_pax dsp ON dsp.segment_id = ds.id INNER JOIN doli_socpeople sp ON sp.rowid = dsp.contact_id LEFT JOIN doli_c_country cc ON cc.rowid = sp.fk_pays LEFT JOIN doli_societe soc ON soc.rowid = sp.fk_soc LEFT JOIN doli_socpeople_extrafields spe ON spe.fk_object = sp.rowid -- LEFT JOIN doli_societe_contacts sc ON sc.fk_soc = soc.rowid AND sc.fk_socpeople = sp.rowid -- LEFT JOIN doli_c_type_contact ctc ON ctc.rowid = sc.fk_c_type_contact WHERE 1 = 1 AND d.id = :dossierId AND ds.actif = 1 AND dsp.actif = 1 GROUP BY d.id, sp.rowid
Parameters:
[ ":dossierId" => "4097" ] |
|
116.59 ms (0.00%) |
721 |
SELECT a.id AS ajustement_id , ds.prix_vente AS montant , ds.dossier_id AS dossier_id , ds.id AS segment_id , ds.date_depart AS date_depart , DATE_ADD(ds.date_depart, INTERVAL ds.nb_jours DAY) AS date_retour , ds.nb_jours AS nb_jours , a.type_id AS type_id FROM walkinn_dossier_segment ds INNER JOIN walkinn_ajustement a ON a.prestation_id = ds.voyage_id INNER JOIN walkinn_voyage_ajustement va ON va.voyage_id = (SELECT MAX(voyage_id) FROM walkinn_dossier_segment WHERE walkinn_dossier_segment.dossier_id = :dossierId AND is_prestation_seche = 0) WHERE 1 = 1 AND ds.dossier_id = :dossierId AND ds.actif = 1 AND ds.is_prestation_seche = 1 AND va.ajustement_id = a.id
Parameters:
[ ":dossierId" => "4097" ] |
|
109.64 ms (0.00%) |
1052 |
SELECT p.contact_id AS contact_id, sp.service_id AS tarif_id FROM walkinn_dossier_segment ds INNER JOIN walkinn_dossier_segment_pax p ON p.segment_id = ds.id LEFT JOIN walkinn_dossier_segment_service_pax sp ON sp.dossier_segment_pax_id = p.id WHERE 1 = 1 AND p.actif = 1 AND ds.id = :segmentId GROUP BY p.contact_id
Parameters:
[ ":segmentId" => "6041" ] |
|
78.89 ms (0.00%) |
721 |
SELECT r.id, pr.code, r.numero_chambre, p.contact_id AS contact_id FROM walkinn_dossier_segment ds INNER JOIN walkinn_dossier_segment_pax p ON p.segment_id = ds.id INNER JOIN walkinn_dossier_segment_pax_rooming r ON r.id = p.rooming_id INNER JOIN walkinn_pax_rooming pr ON pr.id = r.pax_rooming_id WHERE 1 = 1 AND ds.dossier_id = :dossierId AND ds.actif = 1 AND ds.is_prestation_seche = 0
Parameters:
[ ":dossierId" => "4097" ] |
|
59.19 ms (0.00%) |
721 |
SELECT ROUND(kp.montant,2) AS 'montant', kp.mode_paiement AS 'mode_paiement', IFNULL(kp.code_reduction, '') AS 'code_reduction', IFNULL(kp.emetteur, '') AS 'emetteur' -- kp.created_at AS 'date' FROM kernix_reservation kr INNER JOIN kernix_reservation_paiement kp ON kp.reservation_id = kr.id WHERE 1 = 1 AND kr.dossier_id = :dossierId
Parameters:
[ ":dossierId" => "4097" ] |
|
46.95 ms (0.00%) |
721 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.montant AS montant_3, t0.quantite AS quantite_4, t0.code AS code_5, t0.type_ligne AS type_ligne_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.reservation_id AS reservation_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM kernix_reservation_ligne t0 WHERE t0.reservation_id = ?
Parameters:
[
69
]
|
|
31.48 ms (0.00%) |
1 |
SELECT walkinn_dossier.id, walkinn_dossier.libelle, kr.code AS code_kernix, kr.client AS email, kr.voyage_id AS voyage_id, kr.formule_id AS formule_id, IFNULL(df.paye, 0) AS paye, IFNULL(df.fk_statut, 2) AS statut_paiement, IFNULL(df.multicurrency_total_ttc, kr.montant_total) AS montant, walkinn_dossier_type.libelle AS `type`, walkinn_dossier_etat.id AS statut, ( SELECT DATE_FORMAT(MIN(date_depart), "%Y-%m-%d") FROM walkinn_dossier_segment WHERE walkinn_dossier_segment.dossier_id = walkinn_dossier.id AND walkinn_dossier_segment.is_prestation_seche = 0) AS date_depart, ( SELECT MAX(DATE_ADD(date_depart, INTERVAL nb_jours-1 DAY)) FROM walkinn_dossier_segment WHERE walkinn_dossier_segment.dossier_id = walkinn_dossier.id AND walkinn_dossier_segment.is_prestation_seche = 0) AS date_retour, walkinn_dossier.envoi_docs AS envoi_docs, walkinn_dossier.docs AS docs, walkinn_dossier.created_at, walkinn_dossier.updated_at, walkinn_dossier.docs, walkinn_dossier.envoi_docs, kr.facture_id, kr.propal_id AS devis_id, kr.pending FROM walkinn_dossier INNER JOIN kernix_reservation kr ON kr.dossier_id = walkinn_dossier.id INNER JOIN walkinn_dossier_type walkinn_dossier_type ON walkinn_dossier_type.id = walkinn_dossier.dossier_type_id INNER JOIN walkinn_dossier_etat walkinn_dossier_etat ON walkinn_dossier_etat.id = walkinn_dossier.dossier_etat_id LEFT JOIN doli_facture df ON df.rowid = kr.facture_id WHERE 1=1 AND kr.actif = 1 AND IFNULL( walkinn_dossier.is_valide, 0) > 0 AND walkinn_dossier.dossier_etat_id <> 4 AND (SELECT YEAR(MAX(DATE_ADD(date_depart, INTERVAL nb_jours-1 DAY))) FROM walkinn_dossier_segment WHERE walkinn_dossier_segment.dossier_id = walkinn_dossier.id AND walkinn_dossier_segment.is_prestation_seche = 0) > 2024 GROUP BY walkinn_dossier.id
Parameters:
[] |
|
0.25 ms (0.00%) |
1 |
SELECT param FROM doli_extrafields WHERE name = "sous_destination" AND elementtype = "societe"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\DossierSegmentServiceGroupement | No errors. |
| App\Entity\VoyageServiceGroupement | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Dossier | No errors. |
| App\Entity\DossierType | No errors. |
| App\Entity\DossierEtat | No errors. |
| App\Entity\Destination | No errors. |
| App\Entity\DossierGuide | No errors. |
| App\Entity\VoyageTheme | No errors. |
| App\Entity\VoyageCategorie | No errors. |
| App\Entity\KernixReservation | No errors. |
| App\Entity\KernixTypeReservation | No errors. |
| App\Entity\KernixStatutReservation | No errors. |
| App\Entity\Voyage | No errors. |
| App\Entity\DossierSegment | No errors. |
| App\Entity\PlanDeTransport | No errors. |
| App\Entity\DossierFactureExtra | No errors. |
| App\Entity\KernixReservationParticipant | No errors. |
| App\Entity\KernixReservationLigne | No errors. |
| App\Entity\KernixFacturation | No errors. |
| App\Entity\KernixLivraison | No errors. |
| App\Entity\KernixReservationAjustement | No errors. |
| App\Entity\KernixPaiement | No errors. |