Query Metrics
25
Database Queries
18
Different statements
26.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.83 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.town AS town_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.country_id AS country_id_10, t11.id AS id_12, t11.name AS name_13, t14.id AS id_15, t14.type AS type_16, t14.name AS name_17, t14.company AS company_18, t14.remarques AS remarques_19, t14.phone1 AS phone1_20, t14.phone2 AS phone2_21, t14.purchase_address_use_address AS purchase_address_use_address_22, t14.prix_m3_defaut AS prix_m3_defaut_23, t14.jour_delai AS jour_delai_24, t14.created_by AS created_by_25, t14.updated_by AS updated_by_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.address_id AS address_id_29, t14.purchase_address_id AS purchase_address_id_30, t31.id AS id_32, t31.type AS type_33, t31.name AS name_34, t31.company AS company_35, t31.remarques AS remarques_36, t31.phone1 AS phone1_37, t31.phone2 AS phone2_38, t31.purchase_address_use_address AS purchase_address_use_address_39, t31.prix_m3_defaut AS prix_m3_defaut_40, t31.jour_delai AS jour_delai_41, t31.created_by AS created_by_42, t31.updated_by AS updated_by_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.address_id AS address_id_46, t31.purchase_address_id AS purchase_address_id_47 FROM address t0 LEFT JOIN country t11 ON t0.country_id = t11.id LEFT JOIN tiers t14 ON t14.address_id = t0.id LEFT JOIN tiers t31 ON t31.purchase_address_id = t0.id WHERE t0.id IN (?)
Parameters:
[
[
714
]
]
|
|
2.80 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.bl AS bl_3, t0.numfacture AS numfacture_4, t0.estimer AS estimer_5, t0.bois_fini AS bois_fini_6, t0.volume_inner AS volume_inner_7, t0.volume_approximatif AS volume_approximatif_8, t0.volume_outter AS volume_outter_9, t0.coef AS coef_10, t0.volume_stere AS volume_stere_11, t0.coef_stere AS coef_stere_12, t0.volume_tonne AS volume_tonne_13, t0.coef_tonne AS coef_tonne_14, t0.prix_m3 AS prix_m3_15, t0.prix_stere AS prix_stere_16, t0.prix_tonne AS prix_tonne_17, t0.prix_camion AS prix_camion_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.chauffeur_id AS chauffeur_id_23, t24.id AS id_25, t24.first_name AS first_name_26, t24.last_name AS last_name_27, t24.email AS email_28, t24.phone1 AS phone1_29, t24.phone2 AS phone2_30, t24.created_by AS created_by_31, t24.updated_by AS updated_by_32, t24.created_at AS created_at_33, t24.updated_at AS updated_at_34, t0.scierie_id AS scierie_id_35, t36.id AS id_37, t36.type AS type_38, t36.name AS name_39, t36.company AS company_40, t36.remarques AS remarques_41, t36.phone1 AS phone1_42, t36.phone2 AS phone2_43, t36.purchase_address_use_address AS purchase_address_use_address_44, t36.prix_m3_defaut AS prix_m3_defaut_45, t36.jour_delai AS jour_delai_46, t36.created_by AS created_by_47, t36.updated_by AS updated_by_48, t36.created_at AS created_at_49, t36.updated_at AS updated_at_50, t36.address_id AS address_id_51, t36.purchase_address_id AS purchase_address_id_52, t0.livraison_id AS livraison_id_53, t0.bois_type_id AS bois_type_id_54, t55.id AS id_56, t55.name AS name_57, t0.bois_quality_id AS bois_quality_id_58, t59.id AS id_60, t59.name AS name_61, t0.bois_size_id AS bois_size_id_62, t63.id AS id_64, t63.name AS name_65, t63.grume AS grume_66, t0.marquage_id AS marquage_id_67, t0.chantier_id AS chantier_id_68, t69.id AS id_70, t69.name AS name_71, t69.commune AS commune_72, t69.gps AS gps_73, t69.lieudit AS lieudit_74, t69.message_pour_chauffeur AS message_pour_chauffeur_75, t69.message_operateur AS message_operateur_76, t69.client AS client_77, t69.payer AS payer_78, t69.paiement_preparer AS paiement_preparer_79, t69.bilan AS bilan_80, t69.avec_grumes AS avec_grumes_81, t69.avec_billons AS avec_billons_82, t69.intervenants AS intervenants_83, t69.consigne AS consigne_84, t69.dt_start AS dt_start_85, t69.dt_end AS dt_end_86, t69.dt_end_coupe AS dt_end_coupe_87, t69.expected_dt_start AS expected_dt_start_88, t69.expected_dt_end AS expected_dt_end_89, t69.lien1 AS lien1_90, t69.lien12 AS lien12_91, t69.lien13 AS lien13_92, t69.lien2 AS lien2_93, t69.lien_vers_drive AS lien_vers_drive_94, t69.donneur_ordre AS donneur_ordre_95, t69.adresse_donneur_ordre AS adresse_donneur_ordre_96, t69.cpdonneur_ordre AS cpdonneur_ordre_97, t69.ville_donneur_ordre AS ville_donneur_ordre_98, t69.telephone_donneur_ordre AS telephone_donneur_ordre_99, t69.email_donneur_ordre AS email_donneur_ordre_100, t69.societe_abattage AS societe_abattage_101, t69.contact_abattage AS contact_abattage_102, t69.adresse_abattage AS adresse_abattage_103, t69.cpabattage AS cpabattage_104, t69.ville_abattage AS ville_abattage_105, t69.telephone_abattage AS telephone_abattage_106, t69.periode_abattage AS periode_abattage_107, t69.societe_debardage AS societe_debardage_108, t69.contact_debardage AS contact_debardage_109, t69.adresse_debardage AS adresse_debardage_110, t69.cpdebardage AS cpdebardage_111, t69.ville_debardage AS ville_debardage_112, t69.telephone_debardage AS telephone_debardage_113, t69.periode_debardage AS periode_debardage_114, t69.consignessecuriteintervenants AS consignessecuriteintervenants_115, t69.latitude AS latitude_116, t69.longitude AS longitude_117, t69.surface AS surface_118, t69.volume200 AS volume200_119, t69.fin_de_coupe AS fin_de_coupe_120, t69.bois_fini AS bois_fini_121, t69.billons_fini AS billons_fini_122, t69.grumes_debarde AS grumes_debarde_123, t69.dt_end_grumes AS dt_end_grumes_124, t69.billons_debarde AS billons_debarde_125, t69.dt_end_billons AS dt_end_billons_126, t69.infospe1 AS infospe1_127, t69.infospe2 AS infospe2_128, t69.infospe3 AS infospe3_129, t69.infospe4 AS infospe4_130, t69.infospe5 AS infospe5_131, t69.infospe6 AS infospe6_132, t69.infospe7 AS infospe7_133, t69.infospe8 AS infospe8_134, t69.infospe9 AS infospe9_135, t69.infospe10 AS infospe10_136, t69.infospe11 AS infospe11_137, t69.infospe12 AS infospe12_138, t69.infospe13 AS infospe13_139, t69.infospe14 AS infospe14_140, t69.infospe15 AS infospe15_141, t69.infospe16 AS infospe16_142, t69.infospe17 AS infospe17_143, t69.infospe18 AS infospe18_144, t69.infospe19 AS infospe19_145, t69.infospe20 AS infospe20_146, t69.infospe21 AS infospe21_147, t69.infospe22 AS infospe22_148, t69.infospe23 AS infospe23_149, t69.infospe24 AS infospe24_150, t69.infospe25 AS infospe25_151, t69.infospe26 AS infospe26_152, t69.infospe27 AS infospe27_153, t69.infospe28 AS infospe28_154, t69.valueinfospe28 AS valueinfospe28_155, t69.infospe29 AS infospe29_156, t69.infospe30 AS infospe30_157, t69.infospe31 AS infospe31_158, t69.infospe32 AS infospe32_159, t69.infospe33 AS infospe33_160, t69.couverturetelbonne AS couverturetelbonne_161, t69.zonecouverte AS zonecouverte_162, t69.ficheobservations AS ficheobservations_163, t69.cout_m3_defaut AS cout_m3_defaut_164, t69.total_achats_bois AS total_achats_bois_165, t69.total_couts_exploitation AS total_couts_exploitation_166, t69.total_ventes AS total_ventes_167, t69.benefices AS benefices_168, t69.financial_close AS financial_close_169, t69.chauffeur_par_defaut_id AS chauffeur_par_defaut_id_170, t69.abatteur_id AS abatteur_id_171, t69.debardeur_id AS debardeur_id_172, t69.debardeurdeux_id AS debardeurdeux_id_173, t0.cubage_livraison_plateforme_id AS cubage_livraison_plateforme_id_174, t175.id AS id_176, t175.date AS date_177, t175.bl AS bl_178, t175.numfacture AS numfacture_179, t175.volume_inner AS volume_inner_180, t175.volume_approximatif AS volume_approximatif_181, t175.volume_outter AS volume_outter_182, t175.coef AS coef_183, t175.volume_stere AS volume_stere_184, t175.coef_stere AS coef_stere_185, t175.volume_tonne AS volume_tonne_186, t175.coef_tonne AS coef_tonne_187, t175.prix_m3 AS prix_m3_188, t175.prix_stere AS prix_stere_189, t175.prix_tonne AS prix_tonne_190, t175.prix_camion AS prix_camion_191, t175.distributed AS distributed_192, t175.created_by AS created_by_193, t175.updated_by AS updated_by_194, t175.created_at AS created_at_195, t175.updated_at AS updated_at_196, t175.plateforme_id AS plateforme_id_197, t175.case_id AS case_id_198, t175.chauffeur_id AS chauffeur_id_199, t175.scierie_id AS scierie_id_200, t175.livraison_id AS livraison_id_201, t175.bois_type_id AS bois_type_id_202, t175.bois_quality_id AS bois_quality_id_203, t175.bois_size_id AS bois_size_id_204 FROM cubage_livraison t0 LEFT JOIN chauffeur t24 ON t0.chauffeur_id = t24.id LEFT JOIN tiers t36 ON t0.scierie_id = t36.id LEFT JOIN bois_type t55 ON t0.bois_type_id = t55.id LEFT JOIN bois_quality t59 ON t0.bois_quality_id = t59.id LEFT JOIN bois_size t63 ON t0.bois_size_id = t63.id LEFT JOIN chantier t69 ON t0.chantier_id = t69.id LEFT JOIN cubage_livraison_plateforme t175 ON t0.cubage_livraison_plateforme_id = t175.id WHERE t0.chantier_id = ?
Parameters:
[
562
]
|
|
2.73 ms (0.00%) |
4 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.cubage_chantier_id AS cubage_chantier_id_19 FROM document_cubage t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.cubage_chantier_id = ?
Parameters:
[
1983
]
|
|
2.18 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.attestation_annee AS attestation_annee_3, t0.attestation_montant_string AS attestation_montant_string_4, t0.attestation_montant AS attestation_montant_5, t0.reference AS reference_6, t0.remarques AS remarques_7, t0.dt_command AS dt_command_8, t0.state AS state_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.responsable_id AS responsable_id_14, t15.id AS id_16, t15.username AS username_17, t15.email AS email_18, t15.password AS password_19, t15.enable AS enable_20, t15.salt AS salt_21, t15.roles AS roles_22, t15.first_name AS first_name_23, t15.last_name AS last_name_24, t15.phone AS phone_25, t15.created_by AS created_by_26, t15.updated_by AS updated_by_27, t15.created_at AS created_at_28, t15.updated_at AS updated_at_29, t0.tiers_id AS tiers_id_30, t31.id AS id_32, t31.type AS type_33, t31.name AS name_34, t31.company AS company_35, t31.remarques AS remarques_36, t31.phone1 AS phone1_37, t31.phone2 AS phone2_38, t31.purchase_address_use_address AS purchase_address_use_address_39, t31.prix_m3_defaut AS prix_m3_defaut_40, t31.jour_delai AS jour_delai_41, t31.created_by AS created_by_42, t31.updated_by AS updated_by_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.address_id AS address_id_46, t31.purchase_address_id AS purchase_address_id_47 FROM contrat t0 LEFT JOIN user t15 ON t0.responsable_id = t15.id LEFT JOIN tiers t31 ON t0.tiers_id = t31.id WHERE t0.id IN (?)
Parameters:
[
[
891
]
]
|
|
1.98 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.commune AS commune_3, t0.gps AS gps_4, t0.lieudit AS lieudit_5, t0.message_pour_chauffeur AS message_pour_chauffeur_6, t0.message_operateur AS message_operateur_7, t0.client AS client_8, t0.payer AS payer_9, t0.paiement_preparer AS paiement_preparer_10, t0.bilan AS bilan_11, t0.avec_grumes AS avec_grumes_12, t0.avec_billons AS avec_billons_13, t0.intervenants AS intervenants_14, t0.consigne AS consigne_15, t0.dt_start AS dt_start_16, t0.dt_end AS dt_end_17, t0.dt_end_coupe AS dt_end_coupe_18, t0.expected_dt_start AS expected_dt_start_19, t0.expected_dt_end AS expected_dt_end_20, t0.lien1 AS lien1_21, t0.lien12 AS lien12_22, t0.lien13 AS lien13_23, t0.lien2 AS lien2_24, t0.lien_vers_drive AS lien_vers_drive_25, t0.donneur_ordre AS donneur_ordre_26, t0.adresse_donneur_ordre AS adresse_donneur_ordre_27, t0.cpdonneur_ordre AS cpdonneur_ordre_28, t0.ville_donneur_ordre AS ville_donneur_ordre_29, t0.telephone_donneur_ordre AS telephone_donneur_ordre_30, t0.email_donneur_ordre AS email_donneur_ordre_31, t0.societe_abattage AS societe_abattage_32, t0.contact_abattage AS contact_abattage_33, t0.adresse_abattage AS adresse_abattage_34, t0.cpabattage AS cpabattage_35, t0.ville_abattage AS ville_abattage_36, t0.telephone_abattage AS telephone_abattage_37, t0.periode_abattage AS periode_abattage_38, t0.societe_debardage AS societe_debardage_39, t0.contact_debardage AS contact_debardage_40, t0.adresse_debardage AS adresse_debardage_41, t0.cpdebardage AS cpdebardage_42, t0.ville_debardage AS ville_debardage_43, t0.telephone_debardage AS telephone_debardage_44, t0.periode_debardage AS periode_debardage_45, t0.consignessecuriteintervenants AS consignessecuriteintervenants_46, t0.latitude AS latitude_47, t0.longitude AS longitude_48, t0.surface AS surface_49, t0.volume200 AS volume200_50, t0.fin_de_coupe AS fin_de_coupe_51, t0.bois_fini AS bois_fini_52, t0.billons_fini AS billons_fini_53, t0.grumes_debarde AS grumes_debarde_54, t0.dt_end_grumes AS dt_end_grumes_55, t0.billons_debarde AS billons_debarde_56, t0.dt_end_billons AS dt_end_billons_57, t0.infospe1 AS infospe1_58, t0.infospe2 AS infospe2_59, t0.infospe3 AS infospe3_60, t0.infospe4 AS infospe4_61, t0.infospe5 AS infospe5_62, t0.infospe6 AS infospe6_63, t0.infospe7 AS infospe7_64, t0.infospe8 AS infospe8_65, t0.infospe9 AS infospe9_66, t0.infospe10 AS infospe10_67, t0.infospe11 AS infospe11_68, t0.infospe12 AS infospe12_69, t0.infospe13 AS infospe13_70, t0.infospe14 AS infospe14_71, t0.infospe15 AS infospe15_72, t0.infospe16 AS infospe16_73, t0.infospe17 AS infospe17_74, t0.infospe18 AS infospe18_75, t0.infospe19 AS infospe19_76, t0.infospe20 AS infospe20_77, t0.infospe21 AS infospe21_78, t0.infospe22 AS infospe22_79, t0.infospe23 AS infospe23_80, t0.infospe24 AS infospe24_81, t0.infospe25 AS infospe25_82, t0.infospe26 AS infospe26_83, t0.infospe27 AS infospe27_84, t0.infospe28 AS infospe28_85, t0.valueinfospe28 AS valueinfospe28_86, t0.infospe29 AS infospe29_87, t0.infospe30 AS infospe30_88, t0.infospe31 AS infospe31_89, t0.infospe32 AS infospe32_90, t0.infospe33 AS infospe33_91, t0.couverturetelbonne AS couverturetelbonne_92, t0.zonecouverte AS zonecouverte_93, t0.ficheobservations AS ficheobservations_94, t0.cout_m3_defaut AS cout_m3_defaut_95, t0.total_achats_bois AS total_achats_bois_96, t0.total_couts_exploitation AS total_couts_exploitation_97, t0.total_ventes AS total_ventes_98, t0.benefices AS benefices_99, t0.financial_close AS financial_close_100, t0.chauffeur_par_defaut_id AS chauffeur_par_defaut_id_101, t102.id AS id_103, t102.first_name AS first_name_104, t102.last_name AS last_name_105, t102.email AS email_106, t102.phone1 AS phone1_107, t102.phone2 AS phone2_108, t102.created_by AS created_by_109, t102.updated_by AS updated_by_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t0.abatteur_id AS abatteur_id_113, t114.id AS id_115, t114.first_name AS first_name_116, t114.last_name AS last_name_117, t114.full_name_abatteur AS full_name_abatteur_118, t114.email AS email_119, t114.phone1 AS phone1_120, t114.phone2 AS phone2_121, t114.created_by AS created_by_122, t114.updated_by AS updated_by_123, t114.created_at AS created_at_124, t114.updated_at AS updated_at_125, t0.debardeur_id AS debardeur_id_126, t127.id AS id_128, t127.first_name AS first_name_129, t127.last_name AS last_name_130, t127.full_name_debardeur AS full_name_debardeur_131, t127.email AS email_132, t127.phone1 AS phone1_133, t127.phone2 AS phone2_134, t127.created_by AS created_by_135, t127.updated_by AS updated_by_136, t127.created_at AS created_at_137, t127.updated_at AS updated_at_138, t0.debardeurdeux_id AS debardeurdeux_id_139, t140.id AS id_141, t140.first_name AS first_name_142, t140.last_name AS last_name_143, t140.full_name_debardeur AS full_name_debardeur_144, t140.email AS email_145, t140.phone1 AS phone1_146, t140.phone2 AS phone2_147, t140.created_by AS created_by_148, t140.updated_by AS updated_by_149, t140.created_at AS created_at_150, t140.updated_at AS updated_at_151, t152.id AS id_153, t152.remarques AS remarques_154, t152.gps AS gps_155, t152.cubage_estimatif AS cubage_estimatif_156, t152.localisation AS localisation_157, t152.commune AS commune_158, t152.client AS client_159, t152.price AS price_160, t152.tva AS tva_161, t152.buy_type AS buy_type_162, t152.cvo AS cvo_163, t152.dt_end AS dt_end_164, t152.finish AS finish_165, t152.chantier_bucheron AS chantier_bucheron_166, t152.achat_terrain AS achat_terrain_167, t152.paiement_preparer AS paiement_preparer_168, t152.payer AS payer_169, t152.payment_type AS payment_type_170, t152.montant_regler AS montant_regler_171, t152.traverse_cours_eau AS traverse_cours_eau_172, t152.demande_dtt AS demande_dtt_173, t152.autre_alerte AS autre_alerte_174, t152.texte_alerte AS texte_alerte_175, t152.created_by AS created_by_176, t152.updated_by AS updated_by_177, t152.created_at AS created_at_178, t152.updated_at AS updated_at_179, t152.prestation_type_id AS prestation_type_id_180, t152.contrat_id AS contrat_id_181, t152.chantier_id AS chantier_id_182 FROM chantier t0 LEFT JOIN chauffeur t102 ON t0.chauffeur_par_defaut_id = t102.id LEFT JOIN abatteur t114 ON t0.abatteur_id = t114.id LEFT JOIN debardeur t127 ON t0.debardeur_id = t127.id LEFT JOIN debardeur t140 ON t0.debardeurdeux_id = t140.id LEFT JOIN prestation t152 ON t152.chantier_id = t0.id WHERE t0.id = ?
Parameters:
[
"562"
]
|
|
1.52 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.enable AS enable_5, t0.salt AS salt_6, t0.roles AS roles_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM user t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
1.51 ms (0.00%) |
4 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.cubage_chantier_id AS cubage_chantier_id_19 FROM document_cubage_pour_chauffeur t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.cubage_chantier_id = ?
Parameters:
[
1983
]
|
|
1.43 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.message_chauffeur AS message_chauffeur_2, t0.tous_chauffeur AS tous_chauffeur_3, t0.livraison_urgente AS livraison_urgente_4, t0.creer_par_livraison AS creer_par_livraison_5, t0.volume_inner AS volume_inner_6, t0.volume_from_livraison AS volume_from_livraison_7, t0.volume_outter AS volume_outter_8, t0.coef AS coef_9, t0.volume_stere AS volume_stere_10, t0.coef_stere AS coef_stere_11, t0.cout_m3 AS cout_m3_12, t0.reste_adebarder AS reste_adebarder_13, t0.volume_inner_avant_debardage AS volume_inner_avant_debardage_14, t0.bois_vendu AS bois_vendu_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.scierie_id AS scierie_id_20, t21.id AS id_22, t21.type AS type_23, t21.name AS name_24, t21.company AS company_25, t21.remarques AS remarques_26, t21.phone1 AS phone1_27, t21.phone2 AS phone2_28, t21.purchase_address_use_address AS purchase_address_use_address_29, t21.prix_m3_defaut AS prix_m3_defaut_30, t21.jour_delai AS jour_delai_31, t21.created_by AS created_by_32, t21.updated_by AS updated_by_33, t21.created_at AS created_at_34, t21.updated_at AS updated_at_35, t21.address_id AS address_id_36, t21.purchase_address_id AS purchase_address_id_37, t0.chauffeur_par_defaut_id AS chauffeur_par_defaut_id_38, t39.id AS id_40, t39.first_name AS first_name_41, t39.last_name AS last_name_42, t39.email AS email_43, t39.phone1 AS phone1_44, t39.phone2 AS phone2_45, t39.created_by AS created_by_46, t39.updated_by AS updated_by_47, t39.created_at AS created_at_48, t39.updated_at AS updated_at_49, t0.chantier_id AS chantier_id_50, t0.bois_type_id AS bois_type_id_51, t52.id AS id_53, t52.name AS name_54, t0.bois_quality_id AS bois_quality_id_55, t56.id AS id_57, t56.name AS name_58, t0.bois_size_id AS bois_size_id_59, t60.id AS id_61, t60.name AS name_62, t60.grume AS grume_63, t0.marquage_id AS marquage_id_64 FROM cubage_chantier t0 LEFT JOIN tiers t21 ON t0.scierie_id = t21.id LEFT JOIN chauffeur t39 ON t0.chauffeur_par_defaut_id = t39.id LEFT JOIN bois_type t52 ON t0.bois_type_id = t52.id LEFT JOIN bois_quality t56 ON t0.bois_quality_id = t56.id LEFT JOIN bois_size t60 ON t0.bois_size_id = t60.id WHERE t0.chantier_id = ?
Parameters:
[
562
]
|
|
0.92 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.chantier_id AS chantier_id_19, t0.chantier2_id AS chantier2_id_20, t0.chantier3_id AS chantier3_id_21 FROM document_chantier t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.chantier_id = ?
Parameters:
[
562
]
|
|
0.90 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.client_id AS client_id_6, t7.id AS id_8, t7.type AS type_9, t7.name AS name_10, t7.company AS company_11, t7.remarques AS remarques_12, t7.phone1 AS phone1_13, t7.phone2 AS phone2_14, t7.purchase_address_use_address AS purchase_address_use_address_15, t7.prix_m3_defaut AS prix_m3_defaut_16, t7.jour_delai AS jour_delai_17, t7.created_by AS created_by_18, t7.updated_by AS updated_by_19, t7.created_at AS created_at_20, t7.updated_at AS updated_at_21, t7.address_id AS address_id_22, t7.purchase_address_id AS purchase_address_id_23, t0.chantier_id AS chantier_id_24 FROM chantier_autre_client t0 LEFT JOIN tiers t7 ON t0.client_id = t7.id WHERE t0.chantier_id = ?
Parameters:
[
562
]
|
|
0.86 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.prestation_id AS prestation_id_19 FROM document_prestation_cubage t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.prestation_id = ?
Parameters:
[
946
]
|
|
0.82 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sale AS sale_3 FROM prestation_type t0 WHERE t0.id IN (?)
Parameters:
[
[
2
]
]
|
|
0.82 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.prestation_id AS prestation_id_19 FROM document_prestation t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.prestation_id = ?
Parameters:
[
946
]
|
|
0.81 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.chantier_id AS chantier_id_19, t0.chantier2_id AS chantier2_id_20, t0.chantier3_id AS chantier3_id_21 FROM document_chantier t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.chantier3_id = ?
Parameters:
[
562
]
|
|
0.79 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.lifetime AS lifetime_3, t0.rights AS rights_4, t0.name AS name_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM token t0 WHERE t0.id = ?
Parameters:
[
"TOKEN_e5ba0a179118188b3728c5fe56c40e04222a33ed"
]
|
|
0.65 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.reference AS reference_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.chantier_id AS chantier_id_8 FROM frais_chantier t0 WHERE t0.chantier_id = ?
Parameters:
[
562
]
|
|
0.63 ms (0.00%) |
1 |
DELETE FROM token WHERE name IS NULL AND lifetime IS NOT NULL AND (create_time + lifetime) < ?
Parameters:
[
1752553294
]
|
|
0.42 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6, t7.id AS id_8, t7.file_name AS file_name_9, t7.type AS type_10, t7.size AS size_11, t7.path AS path_12, t7.public AS public_13, t7.versions AS versions_14, t7.created_by AS created_by_15, t7.updated_by AS updated_by_16, t7.created_at AS created_at_17, t7.updated_at AS updated_at_18, t0.chantier_id AS chantier_id_19, t0.chantier2_id AS chantier2_id_20, t0.chantier3_id AS chantier3_id_21 FROM document_chantier t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.chantier2_id = ?
Parameters:
[
562
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Token | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Contrat | No errors. |
| App\Entity\Chantier | No errors. |
| App\Entity\Chauffeur | No errors. |
| App\Entity\Abatteur | No errors. |
| App\Entity\Debardeur | No errors. |
| App\Entity\Prestation | No errors. |
| App\Entity\PrestationType | No errors. |
| App\Entity\ChantierAutreClient | No errors. |
| App\Entity\CubageChantierRestant | No errors. |
| App\Entity\FraisChantier | No errors. |
| App\Entity\DocumentChantier | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\CubageLivraison | No errors. |
| App\Entity\CubageChantier | No errors. |
| App\Entity\CubageChantierTest | No errors. |
| App\Entity\CubagePlateforme | No errors. |
| App\Entity\Deposit | No errors. |
| App\Entity\CubagePrestationEstimed | No errors. |
| App\Entity\M3Price | No errors. |
| App\Entity\SuiviReglement | No errors. |
| App\Entity\Parcelle | No errors. |
| App\Entity\DocumentPrestation | No errors. |
| App\Entity\DocumentPrestationCubage | No errors. |
| App\Entity\Tiers | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\SuiviAutresReglement | No errors. |
| App\Entity\Purchase | No errors. |
| App\Entity\Facture | No errors. |
| App\Entity\Livraison | No errors. |
| App\Entity\CubageLivraisonPlateforme | No errors. |
| App\Entity\CubagePlateformeRestant | No errors. |
| App\Entity\TiersM3Price | No errors. |
| App\Entity\LivraisonPlateformePourChauffeur | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\BoisType | No errors. |
| App\Entity\BoisQuality | No errors. |
| App\Entity\BoisSize | No errors. |
| App\Entity\Marquage | No errors. |
| App\Entity\DocumentCubage | No errors. |
| App\Entity\DocumentCubagePourChauffeur | No errors. |
| App\Entity\CubageFacture | No errors. |
| App\Entity\CubageChantierAutreClient | No errors. |
| App\Entity\PurchasePrice | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Plateforme | No errors. |
| App\Entity\PlateformeCase | No errors. |
| App\Entity\DocumentCubageLivraison | No errors. |