Query Metrics
15
Database Queries
13
Different statements
104.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
50.11 ms (0.00%) |
1 |
DELETE FROM token WHERE name IS NULL AND lifetime IS NOT NULL AND (create_time + lifetime) < ?
Parameters:
[
1758013996
]
|
|
14.36 ms (0.00%) |
3 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.company AS company_4, t0.remarques AS remarques_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.purchase_address_use_address AS purchase_address_use_address_8, t0.prix_m3_defaut AS prix_m3_defaut_9, t0.jour_delai AS jour_delai_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, t0.address_id AS address_id_15, t16.id AS id_17, t16.name AS name_18, t16.address AS address_19, t16.zip_code AS zip_code_20, t16.town AS town_21, t16.created_by AS created_by_22, t16.updated_by AS updated_by_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.country_id AS country_id_26, t0.purchase_address_id AS purchase_address_id_27 FROM tiers t0 LEFT JOIN address t16 ON t0.address_id = t16.id WHERE t0.purchase_address_id = ?
Parameters:
[
1486
]
|
|
8.56 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 IN (?)
Parameters:
[
[
13
]
]
|
|
4.73 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
]
|
|
4.25 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.prix_camion AS prix_camion_5, t0.prix_transport AS prix_transport_6, t0.multicubage AS multicubage_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.chauffeur_id AS chauffeur_id_12, t13.id AS id_14, t13.first_name AS first_name_15, t13.last_name AS last_name_16, t13.email AS email_17, t13.phone1 AS phone1_18, t13.phone2 AS phone2_19, t13.created_by AS created_by_20, t13.updated_by AS updated_by_21, t13.created_at AS created_at_22, t13.updated_at AS updated_at_23, t0.scierie_id AS scierie_id_24, t25.id AS id_26, t25.type AS type_27, t25.name AS name_28, t25.company AS company_29, t25.remarques AS remarques_30, t25.phone1 AS phone1_31, t25.phone2 AS phone2_32, t25.purchase_address_use_address AS purchase_address_use_address_33, t25.prix_m3_defaut AS prix_m3_defaut_34, t25.jour_delai AS jour_delai_35, t25.created_by AS created_by_36, t25.updated_by AS updated_by_37, t25.created_at AS created_at_38, t25.updated_at AS updated_at_39, t25.address_id AS address_id_40, t25.purchase_address_id AS purchase_address_id_41, t0.facture_id AS facture_id_42, t43.id AS id_44, t43.date AS date_45, t43.numfacture AS numfacture_46, t43.montant_ht AS montant_ht_47, t43.montant AS montant_48, t43.payer AS payer_49, t43.created_by AS created_by_50, t43.updated_by AS updated_by_51, t43.created_at AS created_at_52, t43.updated_at AS updated_at_53, t43.scierie_id AS scierie_id_54 FROM livraison t0 LEFT JOIN chauffeur t13 ON t0.chauffeur_id = t13.id LEFT JOIN tiers t25 ON t0.scierie_id = t25.id LEFT JOIN facture t43 ON t0.facture_id = t43.id WHERE t0.id = ?
Parameters:
[
4844
]
|
|
4.06 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.id = ?
Parameters:
[
"5009"
]
|
|
3.38 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.full_name_debardeur AS full_name_debardeur_4, t0.email AS email_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM debardeur t0 WHERE t0.id IN (?)
Parameters:
[
[
6
17
]
]
|
|
3.38 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_bcb3306de9cdb175b9af40cd3f62193459bc5017"
]
|
|
3.38 ms (0.00%) |
1 |
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:
[
[
956
]
]
|
|
2.49 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.full_name_abatteur AS full_name_abatteur_4, t0.email AS email_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM abatteur t0 WHERE t0.id IN (?)
Parameters:
[
[
1
]
]
|
|
2.49 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.cubage_livraison_id AS cubage_livraison_id_19 FROM document_cubage_livraison t0 LEFT JOIN media t7 ON t0.media_id = t7.id WHERE t0.cubage_livraison_id = ?
Parameters:
[
5009
]
|
|
1.94 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.remarques AS remarques_2, t0.gps AS gps_3, t0.cubage_estimatif AS cubage_estimatif_4, t0.localisation AS localisation_5, t0.commune AS commune_6, t0.client AS client_7, t0.price AS price_8, t0.tva AS tva_9, t0.buy_type AS buy_type_10, t0.cvo AS cvo_11, t0.dt_end AS dt_end_12, t0.finish AS finish_13, t0.chantier_bucheron AS chantier_bucheron_14, t0.achat_terrain AS achat_terrain_15, t0.paiement_preparer AS paiement_preparer_16, t0.payer AS payer_17, t0.payment_type AS payment_type_18, t0.montant_regler AS montant_regler_19, t0.traverse_cours_eau AS traverse_cours_eau_20, t0.demande_dtt AS demande_dtt_21, t0.autre_alerte AS autre_alerte_22, t0.texte_alerte AS texte_alerte_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.prestation_type_id AS prestation_type_id_28, t29.id AS id_30, t29.name AS name_31, t29.sale AS sale_32, t0.contrat_id AS contrat_id_33, t34.id AS id_35, t34.numero AS numero_36, t34.attestation_annee AS attestation_annee_37, t34.attestation_montant_string AS attestation_montant_string_38, t34.attestation_montant AS attestation_montant_39, t34.reference AS reference_40, t34.remarques AS remarques_41, t34.dt_command AS dt_command_42, t34.state AS state_43, t34.created_by AS created_by_44, t34.updated_by AS updated_by_45, t34.created_at AS created_at_46, t34.updated_at AS updated_at_47, t34.responsable_id AS responsable_id_48, t34.tiers_id AS tiers_id_49, t0.chantier_id AS chantier_id_50 FROM prestation t0 LEFT JOIN prestation_type t29 ON t0.prestation_type_id = t29.id LEFT JOIN contrat t34 ON t0.contrat_id = t34.id WHERE t0.chantier_id = ?
Parameters:
[
591
]
|
|
1.16 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.company AS company_4, t0.remarques AS remarques_5, t0.phone1 AS phone1_6, t0.phone2 AS phone2_7, t0.purchase_address_use_address AS purchase_address_use_address_8, t0.prix_m3_defaut AS prix_m3_defaut_9, t0.jour_delai AS jour_delai_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, t0.address_id AS address_id_15, t16.id AS id_17, t16.name AS name_18, t16.address AS address_19, t16.zip_code AS zip_code_20, t16.town AS town_21, t16.created_by AS created_by_22, t16.updated_by AS updated_by_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.country_id AS country_id_26, t0.purchase_address_id AS purchase_address_id_27 FROM tiers t0 LEFT JOIN address t16 ON t0.address_id = t16.id WHERE t0.id IN (?)
Parameters:
[
[
795
801
907
]
]
|
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\CubageLivraison | No errors. |
| App\Entity\Chauffeur | No errors. |
| App\Entity\Tiers | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Livraison | No errors. |
| App\Entity\BoisType | No errors. |
| App\Entity\BoisQuality | No errors. |
| App\Entity\BoisSize | No errors. |
| App\Entity\Marquage | No errors. |
| App\Entity\Chantier | No errors. |
| App\Entity\Abatteur | No errors. |
| App\Entity\Debardeur | No errors. |
| App\Entity\CubageLivraisonPlateforme | No errors. |
| App\Entity\Plateforme | No errors. |
| App\Entity\PlateformeCase | No errors. |
| App\Entity\DocumentCubageLivraison | No errors. |
| App\Entity\CubageChantier | No errors. |
| App\Entity\CubagePlateformeRestant | No errors. |
| App\Entity\CubagePlateforme | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\SuiviAutresReglement | No errors. |
| App\Entity\ChantierAutreClient | No errors. |
| App\Entity\Purchase | No errors. |
| App\Entity\Facture | No errors. |
| App\Entity\TiersM3Price | No errors. |
| App\Entity\LivraisonPlateformePourChauffeur | No errors. |
| App\Entity\CubagePrestationEstimed | No errors. |
| App\Entity\CubageFacture | No errors. |
| App\Entity\CubageChantierTest | No errors. |
| App\Entity\CubageChantierAutreClient | No errors. |
| App\Entity\CubageChantierRestant | No errors. |
| App\Entity\PurchasePrice | No errors. |
| App\Entity\FraisChantier | No errors. |
| App\Entity\DocumentChantier | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\Prestation | No errors. |
| App\Entity\PrestationType | No errors. |
| App\Entity\Deposit | 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\Document | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Media | No errors. |