Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.invoice_number AS invoice_number_2,
  t0.created_at AS created_at_3,
  t0.update_at AS update_at_4,
  t0.due_date AS due_date_5,
  t0.amount AS amount_6,
  t0.status AS status_7,
  t0.path AS path_8,
  t0.reference AS reference_9,
  t0.purchase_order_path AS purchase_order_path_10,
  t0.type AS type_11,
  t0.quotation_id AS quotation_id_12,
  t0.client_id AS client_id_13,
  t0.created_by_id AS created_by_id_14
FROM
  invoice t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.invoice_number AS invoice_number_2, t0.created_at AS created_at_3, t0.update_at AS update_at_4, t0.due_date AS due_date_5, t0.amount AS amount_6, t0.status AS status_7, t0.path AS path_8, t0.reference AS reference_9, t0.purchase_order_path AS purchase_order_path_10, t0.type AS type_11, t0.quotation_id AS quotation_id_12, t0.client_id AS client_id_13, t0.created_by_id AS created_by_id_14 FROM invoice t0 WHERE t0.id = '9';

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.created_at AS created_at_3,
  t0.notes AS notes_4,
  t0.motif AS motif_5,
  t0.quote_file AS quote_file_6,
  t0.purchase_order_path AS purchase_order_path_7,
  t0.total_amount AS total_amount_8,
  t0.subtotal AS subtotal_9,
  t0.discount_amount AS discount_amount_10,
  t0.vat_amount AS vat_amount_11,
  t0.global_discount_type AS global_discount_type_12,
  t0.global_discount_value AS global_discount_value_13,
  t0.global_discount_amount AS global_discount_amount_14,
  t0.vat_rate AS vat_rate_15,
  t0.is_vat_applicable AS is_vat_applicable_16,
  t0.is_accepted AS is_accepted_17,
  t0.labor_cost AS labor_cost_18,
  t0.token AS token_19,
  t0.status AS status_20,
  t0.version AS version_21,
  t0.sent_at AS sent_at_22,
  t0.validated_at AS validated_at_23,
  t0.converted_at AS converted_at_24,
  t0.declaration_failure_id AS declaration_failure_id_25,
  t0.client_id AS client_id_26,
  t0.car_id AS car_id_27,
  t0.structure_id AS structure_id_28,
  t0.intervention_type_id AS intervention_type_id_29,
  t0.parent_quotation_id AS parent_quotation_id_30,
  t0.superseded_by_id AS superseded_by_id_31,
  t0.created_by_id AS created_by_id_32,
  t0.validated_by_id AS validated_by_id_33,
  t0.converted_by_id AS converted_by_id_34
FROM
  quotation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.created_at AS created_at_3, t0.notes AS notes_4, t0.motif AS motif_5, t0.quote_file AS quote_file_6, t0.purchase_order_path AS purchase_order_path_7, t0.total_amount AS total_amount_8, t0.subtotal AS subtotal_9, t0.discount_amount AS discount_amount_10, t0.vat_amount AS vat_amount_11, t0.global_discount_type AS global_discount_type_12, t0.global_discount_value AS global_discount_value_13, t0.global_discount_amount AS global_discount_amount_14, t0.vat_rate AS vat_rate_15, t0.is_vat_applicable AS is_vat_applicable_16, t0.is_accepted AS is_accepted_17, t0.labor_cost AS labor_cost_18, t0.token AS token_19, t0.status AS status_20, t0.version AS version_21, t0.sent_at AS sent_at_22, t0.validated_at AS validated_at_23, t0.converted_at AS converted_at_24, t0.declaration_failure_id AS declaration_failure_id_25, t0.client_id AS client_id_26, t0.car_id AS car_id_27, t0.structure_id AS structure_id_28, t0.intervention_type_id AS intervention_type_id_29, t0.parent_quotation_id AS parent_quotation_id_30, t0.superseded_by_id AS superseded_by_id_31, t0.created_by_id AS created_by_id_32, t0.validated_by_id AS validated_by_id_33, t0.converted_by_id AS converted_by_id_34 FROM quotation t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.cree_le AS cree_le_2,
  t0.modifie_le AS modifie_le_3,
  t0.description AS description_4,
  t0.kilometrage AS kilometrage_5,
  t0.registration_document AS registration_document_6,
  t0.medias AS medias_7,
  t0.number AS number_8,
  t0.status AS status_9,
  t0.token AS token_10,
  t0.vehicule_id AS vehicule_id_11,
  t12.id AS id_13,
  t12.kilometrage AS kilometrage_14,
  t12.niveau_huile AS niveau_huile_15,
  t12.niveau_liquide_refroidissement AS niveau_liquide_refroidissement_16,
  t12.pression_pneus AS pression_pneus_17,
  t12.etat_batterie AS etat_batterie_18,
  t12.etat_freinage AS etat_freinage_19,
  t12.lecture_codes_defauts AS lecture_codes_defauts_20,
  t12.etat_moteur AS etat_moteur_21,
  t12.niveau_huile_moteur AS niveau_huile_moteur_22,
  t12.test_emissions AS test_emissions_23,
  t12.etat_systeme_direction AS etat_systeme_direction_24,
  t12.etat_suspension AS etat_suspension_25,
  t12.usure_pneus AS usure_pneus_26,
  t12.systeme_echappement AS systeme_echappement_27,
  t12.pieces_a_remplacer AS pieces_a_remplacer_28,
  t12.temps_reparation_estime AS temps_reparation_estime_29,
  t12.cout_reparation_estime AS cout_reparation_estime_30,
  t12.observations AS observations_31,
  t12.technicien_responsable AS technicien_responsable_32,
  t12.niveau_liquide_frein AS niveau_liquide_frein_33,
  t12.etat_plaquettes_frein AS etat_plaquettes_frein_34,
  t12.etat_disques_frein AS etat_disques_frein_35,
  t12.epaisseur_plaquettes_avant AS epaisseur_plaquettes_avant_36,
  t12.epaisseur_plaquettes_arriere AS epaisseur_plaquettes_arriere_37,
  t12.phares_avant_codes AS phares_avant_codes_38,
  t12.phares_avant_routes AS phares_avant_routes_39,
  t12.phares_arriere AS phares_arriere_40,
  t12.feux_stop AS feux_stop_41,
  t12.clignotants AS clignotants_42,
  t12.feux_recul AS feux_recul_43,
  t12.feux_antibrouillard AS feux_antibrouillard_44,
  t12.etat_filtre_air AS etat_filtre_air_45,
  t12.etat_filtre_huile AS etat_filtre_huile_46,
  t12.etat_filtre_carburant AS etat_filtre_carburant_47,
  t12.niveau_lave_glace AS niveau_lave_glace_48,
  t12.niveau_carburant AS niveau_carburant_49,
  t12.temperature_moteur AS temperature_moteur_50,
  t12.pression_huile_moteur AS pression_huile_moteur_51,
  t12.regime_ralenti AS regime_ralenti_52,
  t12.test_demarrage AS test_demarrage_53,
  t12.etat_courroies AS etat_courroies_54,
  t12.etat_durites AS etat_durites_55,
  t12.tension_batterie AS tension_batterie_56,
  t12.etat_alternateur AS etat_alternateur_57,
  t12.etat_demarreur AS etat_demarreur_58,
  t12.charge_alternateur AS charge_alternateur_59,
  t12.pression_pneu_avant_gauche AS pression_pneu_avant_gauche_60,
  t12.pression_pneu_avant_droit AS pression_pneu_avant_droit_61,
  t12.pression_pneu_arriere_gauche AS pression_pneu_arriere_gauche_62,
  t12.pression_pneu_arriere_droit AS pression_pneu_arriere_droit_63,
  t12.alignement_roues AS alignement_roues_64,
  t12.equilibrage_roues AS equilibrage_roues_65,
  t12.profondeur_sculpture_pneus AS profondeur_sculpture_pneus_66,
  t12.fonctionnement_climatisation AS fonctionnement_climatisation_67,
  t12.niveau_gaz_climatisation AS niveau_gaz_climatisation_68,
  t12.temperature_climatisation AS temperature_climatisation_69,
  t12.etat_carrosserie AS etat_carrosserie_70,
  t12.etat_interieur AS etat_interieur_71,
  t12.etat_essuie_glaces AS etat_essuie_glaces_72,
  t12.etat_retroviseurs AS etat_retroviseurs_73,
  t12.etat_pare_brise AS etat_pare_brise_74,
  t12.vibrations_anormales AS vibrations_anormales_75,
  t12.bruits_anormaux AS bruits_anormaux_76,
  t12.description_bruits AS description_bruits_77,
  t12.fumee_echappement AS fumee_echappement_78,
  t12.consommation_carburant AS consommation_carburant_79,
  t12.date_derniere_vidange AS date_derniere_vidange_80,
  t12.km_derniere_vidange AS km_derniere_vidange_81,
  t12.prochaine_vidange_km AS prochaine_vidange_km_82,
  t12.prochaine_revision_km AS prochaine_revision_km_83,
  t12.date_prochain_controle_technique AS date_prochain_controle_technique_84,
  t12.vehicule_roule AS vehicule_roule_85,
  t12.note_etat_general AS note_etat_general_86,
  t12.recommandations AS recommandations_87,
  t12.cree_le AS cree_le_88,
  t12.modifie_le AS modifie_le_89,
  t12.token AS token_90,
  t12.medias AS medias_91,
  t12.declaration_failure_id AS declaration_failure_id_92,
  t12.diagnostician_id AS diagnostician_id_93,
  t12.structure_id AS structure_id_94,
  t0.appointment_id AS appointment_id_95,
  t0.client_id AS client_id_96,
  t97.id AS id_98,
  t97.status AS status_99,
  t97.step AS step_100,
  t97.declaration_failure_id AS declaration_failure_id_101,
  t0.structure_id AS structure_id_102
FROM
  declaration_pannes t0
  LEFT JOIN diagnostics t12 ON t12.declaration_failure_id = t0.id
  LEFT JOIN validation t97 ON t97.declaration_failure_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.description AS description_4, t0.kilometrage AS kilometrage_5, t0.registration_document AS registration_document_6, t0.medias AS medias_7, t0.number AS number_8, t0.status AS status_9, t0.token AS token_10, t0.vehicule_id AS vehicule_id_11, t12.id AS id_13, t12.kilometrage AS kilometrage_14, t12.niveau_huile AS niveau_huile_15, t12.niveau_liquide_refroidissement AS niveau_liquide_refroidissement_16, t12.pression_pneus AS pression_pneus_17, t12.etat_batterie AS etat_batterie_18, t12.etat_freinage AS etat_freinage_19, t12.lecture_codes_defauts AS lecture_codes_defauts_20, t12.etat_moteur AS etat_moteur_21, t12.niveau_huile_moteur AS niveau_huile_moteur_22, t12.test_emissions AS test_emissions_23, t12.etat_systeme_direction AS etat_systeme_direction_24, t12.etat_suspension AS etat_suspension_25, t12.usure_pneus AS usure_pneus_26, t12.systeme_echappement AS systeme_echappement_27, t12.pieces_a_remplacer AS pieces_a_remplacer_28, t12.temps_reparation_estime AS temps_reparation_estime_29, t12.cout_reparation_estime AS cout_reparation_estime_30, t12.observations AS observations_31, t12.technicien_responsable AS technicien_responsable_32, t12.niveau_liquide_frein AS niveau_liquide_frein_33, t12.etat_plaquettes_frein AS etat_plaquettes_frein_34, t12.etat_disques_frein AS etat_disques_frein_35, t12.epaisseur_plaquettes_avant AS epaisseur_plaquettes_avant_36, t12.epaisseur_plaquettes_arriere AS epaisseur_plaquettes_arriere_37, t12.phares_avant_codes AS phares_avant_codes_38, t12.phares_avant_routes AS phares_avant_routes_39, t12.phares_arriere AS phares_arriere_40, t12.feux_stop AS feux_stop_41, t12.clignotants AS clignotants_42, t12.feux_recul AS feux_recul_43, t12.feux_antibrouillard AS feux_antibrouillard_44, t12.etat_filtre_air AS etat_filtre_air_45, t12.etat_filtre_huile AS etat_filtre_huile_46, t12.etat_filtre_carburant AS etat_filtre_carburant_47, t12.niveau_lave_glace AS niveau_lave_glace_48, t12.niveau_carburant AS niveau_carburant_49, t12.temperature_moteur AS temperature_moteur_50, t12.pression_huile_moteur AS pression_huile_moteur_51, t12.regime_ralenti AS regime_ralenti_52, t12.test_demarrage AS test_demarrage_53, t12.etat_courroies AS etat_courroies_54, t12.etat_durites AS etat_durites_55, t12.tension_batterie AS tension_batterie_56, t12.etat_alternateur AS etat_alternateur_57, t12.etat_demarreur AS etat_demarreur_58, t12.charge_alternateur AS charge_alternateur_59, t12.pression_pneu_avant_gauche AS pression_pneu_avant_gauche_60, t12.pression_pneu_avant_droit AS pression_pneu_avant_droit_61, t12.pression_pneu_arriere_gauche AS pression_pneu_arriere_gauche_62, t12.pression_pneu_arriere_droit AS pression_pneu_arriere_droit_63, t12.alignement_roues AS alignement_roues_64, t12.equilibrage_roues AS equilibrage_roues_65, t12.profondeur_sculpture_pneus AS profondeur_sculpture_pneus_66, t12.fonctionnement_climatisation AS fonctionnement_climatisation_67, t12.niveau_gaz_climatisation AS niveau_gaz_climatisation_68, t12.temperature_climatisation AS temperature_climatisation_69, t12.etat_carrosserie AS etat_carrosserie_70, t12.etat_interieur AS etat_interieur_71, t12.etat_essuie_glaces AS etat_essuie_glaces_72, t12.etat_retroviseurs AS etat_retroviseurs_73, t12.etat_pare_brise AS etat_pare_brise_74, t12.vibrations_anormales AS vibrations_anormales_75, t12.bruits_anormaux AS bruits_anormaux_76, t12.description_bruits AS description_bruits_77, t12.fumee_echappement AS fumee_echappement_78, t12.consommation_carburant AS consommation_carburant_79, t12.date_derniere_vidange AS date_derniere_vidange_80, t12.km_derniere_vidange AS km_derniere_vidange_81, t12.prochaine_vidange_km AS prochaine_vidange_km_82, t12.prochaine_revision_km AS prochaine_revision_km_83, t12.date_prochain_controle_technique AS date_prochain_controle_technique_84, t12.vehicule_roule AS vehicule_roule_85, t12.note_etat_general AS note_etat_general_86, t12.recommandations AS recommandations_87, t12.cree_le AS cree_le_88, t12.modifie_le AS modifie_le_89, t12.token AS token_90, t12.medias AS medias_91, t12.declaration_failure_id AS declaration_failure_id_92, t12.diagnostician_id AS diagnostician_id_93, t12.structure_id AS structure_id_94, t0.appointment_id AS appointment_id_95, t0.client_id AS client_id_96, t97.id AS id_98, t97.status AS status_99, t97.step AS step_100, t97.declaration_failure_id AS declaration_failure_id_101, t0.structure_id AS structure_id_102 FROM declaration_pannes t0 LEFT JOIN diagnostics t12 ON t12.declaration_failure_id = t0.id LEFT JOIN validation t97 ON t97.declaration_failure_id = t0.id WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.line_type AS line_type_2,
  t0.quantity AS quantity_3,
  t0.unit_price AS unit_price_4,
  t0.description AS description_5,
  t0.reference AS reference_6,
  t0.discount_rate AS discount_rate_7,
  t0.quotation_id AS quotation_id_8,
  t0.piece_id AS piece_id_9,
  t0.stock_id AS stock_id_10
FROM
  quotation_item t0
WHERE
  t0.quotation_id = ?

SELECT t0.id AS id_1, t0.line_type AS line_type_2, t0.quantity AS quantity_3, t0.unit_price AS unit_price_4, t0.description AS description_5, t0.reference AS reference_6, t0.discount_rate AS discount_rate_7, t0.quotation_id AS quotation_id_8, t0.piece_id AS piece_id_9, t0.stock_id AS stock_id_10 FROM quotation_item t0 WHERE t0.quotation_id = 12;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.method AS method_3,
  t0.reference AS reference_4,
  t0.status AS status_5,
  t0.path AS path_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8
FROM
  payment t0
WHERE
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.method AS method_3, t0.reference AS reference_4, t0.status AS status_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8 FROM payment t0 WHERE t0.invoice_id = 9;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.city AS city_3,
  t0.rccm AS rccm_4,
  t0.address AS address_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  structure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.city AS city_3, t0.rccm AS rccm_4, t0.address AS address_5, t0.phone AS phone_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM structure t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.cree_le AS cree_le_2,
  t0.modifie_le AS modifie_le_3,
  t0.nom_complet AS nom_complet_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.adresse AS adresse_7,
  t0.rccm AS rccm_8,
  t0.type AS type_9,
  t0.token AS token_10,
  t0.company_name AS company_name_11,
  t0.contact_name AS contact_name_12,
  t0.contact_email AS contact_email_13,
  t0.contact_phone AS contact_phone_14,
  t0.linked_user_id AS linked_user_id_15,
  t0.structure_id AS structure_id_16
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.nom_complet AS nom_complet_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.adresse AS adresse_7, t0.rccm AS rccm_8, t0.type AS type_9, t0.token AS token_10, t0.company_name AS company_name_11, t0.contact_name AS contact_name_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.linked_user_id AS linked_user_id_15, t0.structure_id AS structure_id_16 FROM clients t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.cree_le AS cree_le_2,
  t0.modifie_le AS modifie_le_3,
  t0.immatriculation AS immatriculation_4,
  t0.couleure AS couleure_5,
  t0.mise_en_circulation AS mise_en_circulation_6,
  t0.images AS images_7,
  t0.carburant AS carburant_8,
  t0.type_boite AS type_boite_9,
  t0.model AS model_10,
  t0.token AS token_11,
  t0.client_id AS client_id_12,
  t0.mark_id AS mark_id_13,
  t0.structure_id AS structure_id_14
FROM
  vehicules t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.immatriculation AS immatriculation_4, t0.couleure AS couleure_5, t0.mise_en_circulation AS mise_en_circulation_6, t0.images AS images_7, t0.carburant AS carburant_8, t0.type_boite AS type_boite_9, t0.model AS model_10, t0.token AS token_11, t0.client_id AS client_id_12, t0.mark_id AS mark_id_13, t0.structure_id AS structure_id_14 FROM vehicules t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.cree_le AS cree_le_2,
  t0.modifie_le AS modifie_le_3,
  t0.nom AS nom_4,
  t0.token AS token_5
FROM
  marques t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cree_le AS cree_le_2, t0.modifie_le AS modifie_le_3, t0.nom AS nom_4, t0.token AS token_5 FROM marques t0 WHERE t0.id = 88;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.price AS price_4,
  t0.quantity AS quantity_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.supplier_id AS supplier_id_8,
  t0.structure_id AS structure_id_9,
  t0.stock_category_id AS stock_category_id_10
FROM
  stock t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.structure_id AS structure_id_9, t0.stock_category_id AS stock_category_id_10 FROM stock t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.price AS price_4,
  t0.quantity AS quantity_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.supplier_id AS supplier_id_8,
  t0.structure_id AS structure_id_9,
  t0.stock_category_id AS stock_category_id_10
FROM
  stock t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.structure_id AS structure_id_9, t0.stock_category_id AS stock_category_id_10 FROM stock t0 WHERE t0.id = 2;