Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.reset_token AS reset_token_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.civility AS civility_11,
  t0.telephone AS telephone_12,
  t0.company_id AS company_id_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.date_of_birth AS date_of_birth_17,
  t14.created_at AS created_at_18,
  t14.salary AS salary_19,
  t14.last_name AS last_name_20,
  t14.first_name AS first_name_21,
  t14.civility AS civility_22,
  t14.telephone AS telephone_23,
  t14.department_id AS department_id_24,
  t14.fonction_id AS fonction_id_25,
  t14.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN employee t14 ON t14.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.rc AS rc_3,
  t0.ice AS ice_4,
  t0.address AS address_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays AS pays_8,
  t0.email AS email_9,
  t0.id_fiscal AS id_fiscal_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.currency AS currency_13,
  t0.exchange_rates AS exchange_rates_14,
  t0.cost AS cost_15,
  t0.ca AS ca_16,
  t0.week_work_hours AS week_work_hours_17,
  t0.day_work_hours AS day_work_hours_18,
  t0.workload_breakdown AS workload_breakdown_19,
  t0.cost_per_hour AS cost_per_hour_20,
  t0.dig_price AS dig_price_21,
  t0.ca_breakdown AS ca_breakdown_22,
  t0.marge AS marge_23,
  t0.marge_attribute AS marge_attribute_24,
  t0.marge_min AS marge_min_25,
  t0.marge_min_attribute AS marge_min_attribute_26,
  t0.contrat_title AS contrat_title_27,
  t0.contrat_service_titre AS contrat_service_titre_28,
  t0.interfacing AS interfacing_29,
  t0.limit_depasement AS limit_depasement_30,
  t0.notification_signature_contrat AS notification_signature_contrat_31,
  t0.notification_fin_contrat AS notification_fin_contrat_32,
  t0.envoi_automatique_factures AS envoi_automatique_factures_33,
  t0.volume_mensel_recommande AS volume_mensel_recommande_34,
  t0.show_all_pieces AS show_all_pieces_35,
  t0.show_all_consommable AS show_all_consommable_36,
  t0.permissions_version AS permissions_version_37,
  t0.company_id AS company_id_38,
  t0.contrat_emplacement_id AS contrat_emplacement_id_39
FROM
  setting t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.rc AS rc_3, t0.ice AS ice_4, t0.address AS address_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.id_fiscal AS id_fiscal_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.currency AS currency_13, t0.exchange_rates AS exchange_rates_14, t0.cost AS cost_15, t0.ca AS ca_16, t0.week_work_hours AS week_work_hours_17, t0.day_work_hours AS day_work_hours_18, t0.workload_breakdown AS workload_breakdown_19, t0.cost_per_hour AS cost_per_hour_20, t0.dig_price AS dig_price_21, t0.ca_breakdown AS ca_breakdown_22, t0.marge AS marge_23, t0.marge_attribute AS marge_attribute_24, t0.marge_min AS marge_min_25, t0.marge_min_attribute AS marge_min_attribute_26, t0.contrat_title AS contrat_title_27, t0.contrat_service_titre AS contrat_service_titre_28, t0.interfacing AS interfacing_29, t0.limit_depasement AS limit_depasement_30, t0.notification_signature_contrat AS notification_signature_contrat_31, t0.notification_fin_contrat AS notification_fin_contrat_32, t0.envoi_automatique_factures AS envoi_automatique_factures_33, t0.volume_mensel_recommande AS volume_mensel_recommande_34, t0.show_all_pieces AS show_all_pieces_35, t0.show_all_consommable AS show_all_consommable_36, t0.permissions_version AS permissions_version_37, t0.company_id AS company_id_38, t0.contrat_emplacement_id AS contrat_emplacement_id_39 FROM setting t0 WHERE t0.company_id = 2;

SELECT
  DISTINCT count(DISTINCT d0_.id) AS sclr_0
FROM
  devis d0_
  LEFT JOIN client c1_ ON d0_.client_id = c1_.id
WHERE
  d0_.status <> ?

SELECT DISTINCT count(DISTINCT d0_.id) AS sclr_0 FROM devis d0_ LEFT JOIN client c1_ ON d0_.client_id = c1_.id WHERE d0_.status <> 9;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.created_at AS created_at_1
FROM
  devis d0_
  LEFT JOIN client c1_ ON d0_.client_id = c1_.id
WHERE
  d0_.status <> ?
ORDER BY
  d0_.created_at DESC
LIMIT
  10

SELECT DISTINCT d0_.id AS id_0, d0_.created_at AS created_at_1 FROM devis d0_ LEFT JOIN client c1_ ON d0_.client_id = c1_.id WHERE d0_.status <> 9 ORDER BY d0_.created_at DESC LIMIT 10;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.status AS status_1,
  d0_.created_at AS created_at_2,
  d0_.updated_at AS updated_at_3,
  d0_.version AS version_4,
  d0_.type AS type_5,
  d0_.validated_at AS validated_at_6,
  d0_.validation_note AS validation_note_7,
  d0_.demande_validation_note AS demande_validation_note_8,
  c1_.id AS id_9,
  c1_.name AS name_10,
  c1_.mail AS mail_11,
  c1_.phone AS phone_12,
  c1_.website AS website_13,
  c1_.address AS address_14,
  c1_.code_postal AS code_postal_15,
  c1_.ville AS ville_16,
  c1_.ref AS ref_17,
  c1_.created_at AS created_at_18,
  c1_.updated_at AS updated_at_19,
  c1_.ice AS ice_20,
  c1_.rc AS rc_21,
  c1_.code_client AS code_client_22,
  c1_.sage_sync AS sage_sync_23,
  d0_.saller_id AS saller_id_24,
  d0_.client_id AS client_id_25,
  d0_.validated_by_id AS validated_by_id_26,
  c1_.client_type_id AS client_type_id_27,
  c1_.user_id AS user_id_28,
  c1_.commercial_id AS commercial_id_29
FROM
  devis d0_
  LEFT JOIN client c1_ ON d0_.client_id = c1_.id
WHERE
  d0_.status <> ?
  AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  d0_.created_at DESC

SELECT DISTINCT d0_.id AS id_0, d0_.status AS status_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.version AS version_4, d0_.type AS type_5, d0_.validated_at AS validated_at_6, d0_.validation_note AS validation_note_7, d0_.demande_validation_note AS demande_validation_note_8, c1_.id AS id_9, c1_.name AS name_10, c1_.mail AS mail_11, c1_.phone AS phone_12, c1_.website AS website_13, c1_.address AS address_14, c1_.code_postal AS code_postal_15, c1_.ville AS ville_16, c1_.ref AS ref_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.ice AS ice_20, c1_.rc AS rc_21, c1_.code_client AS code_client_22, c1_.sage_sync AS sage_sync_23, d0_.saller_id AS saller_id_24, d0_.client_id AS client_id_25, d0_.validated_by_id AS validated_by_id_26, c1_.client_type_id AS client_type_id_27, c1_.user_id AS user_id_28, c1_.commercial_id AS commercial_id_29 FROM devis d0_ LEFT JOIN client c1_ ON d0_.client_id = c1_.id WHERE d0_.status <> 9 AND d0_.id IN (3310, 3309, 3308, 3307, 3306, 3305, 3304, 3062, 3058, 3057) ORDER BY d0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  type_attribute t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM type_attribute t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  type_attribute t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM type_attribute t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  roles t0
  INNER JOIN user_roles ON t0.id = user_roles.roles_id
WHERE
  user_roles.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN user_roles ON t0.id = user_roles.roles_id WHERE user_roles.user_id = 3;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.exchange_rates AS exchange_rates_3,
  t0.purchase_price AS purchase_price_4,
  t0.cost AS cost_5,
  t0.cost_price AS cost_price_6,
  t0.version AS version_7,
  t0.quntity AS quntity_8,
  t0.duree AS duree_9,
  t0.taux AS taux_10,
  t0.taux_mo AS taux_mo_11,
  t0.cout_mo AS cout_mo_12,
  t0.cout_pieces AS cout_pieces_13,
  t0.cout_mensuel_service AS cout_mensuel_service_14,
  t0.taux_pieces AS taux_pieces_15,
  t0.loyer_mensuel AS loyer_mensuel_16,
  t0.cout_unit_loyer AS cout_unit_loyer_17,
  t0.marge_loyer AS marge_loyer_18,
  t0.mode_fac AS mode_fac_19,
  t0.cout_mensuel_equip AS cout_mensuel_equip_20,
  t0.status AS status_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.volume_mensuel AS volume_mensuel_24,
  t0.volume_mono AS volume_mono_25,
  t0.volume_color AS volume_color_26,
  t0.prix_requip AS prix_requip_27,
  t0.amortissement_equip AS amortissement_equip_28,
  t0.amortissement_color AS amortissement_color_29,
  t0.consommable_mono_page AS consommable_mono_page_30,
  t0.consommable_color_page AS consommable_color_page_31,
  t0.amortissement_color_e AS amortissement_color_e_32,
  t0.amortissement_mono_s AS amortissement_mono_s_33,
  t0.amortissement_service AS amortissement_service_34,
  t0.amortissement_color_s AS amortissement_color_s_35,
  t0.amortissement_service_c AS amortissement_service_c_36,
  t0.cout_theory_mono AS cout_theory_mono_37,
  t0.cout_theory_color AS cout_theory_color_38,
  t0.coeff_color AS coeff_color_39,
  t0.amortissement_mono AS amortissement_mono_40,
  t0.prix_revient_vente AS prix_revient_vente_41,
  t0.prix_vente AS prix_vente_42,
  t0.marge_vente AS marge_vente_43,
  t0.total_provision_service_vente AS total_provision_service_vente_44,
  t0.prix_vente_service AS prix_vente_service_45,
  t0.marge_vente_service AS marge_vente_service_46,
  t0.contrat_service AS contrat_service_47,
  t0.date_souhaite AS date_souhaite_48,
  t0.qte_reservee AS qte_reservee_49,
  t0.devis_id AS devis_id_50,
  t0.product_id AS product_id_51
FROM
  devis_machine t0
WHERE
  t0.devis_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.exchange_rates AS exchange_rates_3, t0.purchase_price AS purchase_price_4, t0.cost AS cost_5, t0.cost_price AS cost_price_6, t0.version AS version_7, t0.quntity AS quntity_8, t0.duree AS duree_9, t0.taux AS taux_10, t0.taux_mo AS taux_mo_11, t0.cout_mo AS cout_mo_12, t0.cout_pieces AS cout_pieces_13, t0.cout_mensuel_service AS cout_mensuel_service_14, t0.taux_pieces AS taux_pieces_15, t0.loyer_mensuel AS loyer_mensuel_16, t0.cout_unit_loyer AS cout_unit_loyer_17, t0.marge_loyer AS marge_loyer_18, t0.mode_fac AS mode_fac_19, t0.cout_mensuel_equip AS cout_mensuel_equip_20, t0.status AS status_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.volume_mensuel AS volume_mensuel_24, t0.volume_mono AS volume_mono_25, t0.volume_color AS volume_color_26, t0.prix_requip AS prix_requip_27, t0.amortissement_equip AS amortissement_equip_28, t0.amortissement_color AS amortissement_color_29, t0.consommable_mono_page AS consommable_mono_page_30, t0.consommable_color_page AS consommable_color_page_31, t0.amortissement_color_e AS amortissement_color_e_32, t0.amortissement_mono_s AS amortissement_mono_s_33, t0.amortissement_service AS amortissement_service_34, t0.amortissement_color_s AS amortissement_color_s_35, t0.amortissement_service_c AS amortissement_service_c_36, t0.cout_theory_mono AS cout_theory_mono_37, t0.cout_theory_color AS cout_theory_color_38, t0.coeff_color AS coeff_color_39, t0.amortissement_mono AS amortissement_mono_40, t0.prix_revient_vente AS prix_revient_vente_41, t0.prix_vente AS prix_vente_42, t0.marge_vente AS marge_vente_43, t0.total_provision_service_vente AS total_provision_service_vente_44, t0.prix_vente_service AS prix_vente_service_45, t0.marge_vente_service AS marge_vente_service_46, t0.contrat_service AS contrat_service_47, t0.date_souhaite AS date_souhaite_48, t0.qte_reservee AS qte_reservee_49, t0.devis_id AS devis_id_50, t0.product_id AS product_id_51 FROM devis_machine t0 WHERE t0.devis_id = 3310;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.reference AS reference_4,
  t0.created_at AS created_at_5,
  t0.description AS description_6,
  t0.type AS type_7,
  t0.number_users AS number_users_8,
  t0.number_pages AS number_pages_9,
  t0.is_exist AS is_exist_10,
  t0.sage_sync AS sage_sync_11,
  t0.volume_mensel_recommande AS volume_mensel_recommande_12,
  t0.limite_depassement AS limite_depassement_13,
  t0.marque AS marque_14,
  t0.category_id AS category_id_15
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.description AS description_6, t0.type AS type_7, t0.number_users AS number_users_8, t0.number_pages AS number_pages_9, t0.is_exist AS is_exist_10, t0.sage_sync AS sage_sync_11, t0.volume_mensel_recommande AS volume_mensel_recommande_12, t0.limite_depassement AS limite_depassement_13, t0.marque AS marque_14, t0.category_id AS category_id_15 FROM product t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.prixachat AS prixachat_3,
  t0.loyer_mensuel_att AS loyer_mensuel_att_4,
  t0.marge_attribute AS marge_attribute_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.devis_id AS devis_id_8,
  t0.attribute_id AS attribute_id_9
FROM
  devis_attribute t0
WHERE
  t0.devis_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.prixachat AS prixachat_3, t0.loyer_mensuel_att AS loyer_mensuel_att_4, t0.marge_attribute AS marge_attribute_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.devis_id AS devis_id_8, t0.attribute_id AS attribute_id_9 FROM devis_attribute t0 WHERE t0.devis_id = 3032;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.reset_token AS reset_token_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.civility AS civility_11,
  t0.telephone AS telephone_12,
  t0.company_id AS company_id_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.date_of_birth AS date_of_birth_17,
  t14.created_at AS created_at_18,
  t14.salary AS salary_19,
  t14.last_name AS last_name_20,
  t14.first_name AS first_name_21,
  t14.civility AS civility_22,
  t14.telephone AS telephone_23,
  t14.department_id AS department_id_24,
  t14.fonction_id AS fonction_id_25,
  t14.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN employee t14 ON t14.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id WHERE t0.id = 42;

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.rc AS rc_3,
  t0.ice AS ice_4,
  t0.address AS address_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays AS pays_8,
  t0.email AS email_9,
  t0.id_fiscal AS id_fiscal_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.currency AS currency_13,
  t0.exchange_rates AS exchange_rates_14,
  t0.cost AS cost_15,
  t0.ca AS ca_16,
  t0.week_work_hours AS week_work_hours_17,
  t0.day_work_hours AS day_work_hours_18,
  t0.workload_breakdown AS workload_breakdown_19,
  t0.cost_per_hour AS cost_per_hour_20,
  t0.dig_price AS dig_price_21,
  t0.ca_breakdown AS ca_breakdown_22,
  t0.marge AS marge_23,
  t0.marge_attribute AS marge_attribute_24,
  t0.marge_min AS marge_min_25,
  t0.marge_min_attribute AS marge_min_attribute_26,
  t0.contrat_title AS contrat_title_27,
  t0.contrat_service_titre AS contrat_service_titre_28,
  t0.interfacing AS interfacing_29,
  t0.limit_depasement AS limit_depasement_30,
  t0.notification_signature_contrat AS notification_signature_contrat_31,
  t0.notification_fin_contrat AS notification_fin_contrat_32,
  t0.envoi_automatique_factures AS envoi_automatique_factures_33,
  t0.volume_mensel_recommande AS volume_mensel_recommande_34,
  t0.show_all_pieces AS show_all_pieces_35,
  t0.show_all_consommable AS show_all_consommable_36,
  t0.permissions_version AS permissions_version_37,
  t0.company_id AS company_id_38,
  t0.contrat_emplacement_id AS contrat_emplacement_id_39
FROM
  setting t0

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.rc AS rc_3, t0.ice AS ice_4, t0.address AS address_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.id_fiscal AS id_fiscal_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.currency AS currency_13, t0.exchange_rates AS exchange_rates_14, t0.cost AS cost_15, t0.ca AS ca_16, t0.week_work_hours AS week_work_hours_17, t0.day_work_hours AS day_work_hours_18, t0.workload_breakdown AS workload_breakdown_19, t0.cost_per_hour AS cost_per_hour_20, t0.dig_price AS dig_price_21, t0.ca_breakdown AS ca_breakdown_22, t0.marge AS marge_23, t0.marge_attribute AS marge_attribute_24, t0.marge_min AS marge_min_25, t0.marge_min_attribute AS marge_min_attribute_26, t0.contrat_title AS contrat_title_27, t0.contrat_service_titre AS contrat_service_titre_28, t0.interfacing AS interfacing_29, t0.limit_depasement AS limit_depasement_30, t0.notification_signature_contrat AS notification_signature_contrat_31, t0.notification_fin_contrat AS notification_fin_contrat_32, t0.envoi_automatique_factures AS envoi_automatique_factures_33, t0.volume_mensel_recommande AS volume_mensel_recommande_34, t0.show_all_pieces AS show_all_pieces_35, t0.show_all_consommable AS show_all_consommable_36, t0.permissions_version AS permissions_version_37, t0.company_id AS company_id_38, t0.contrat_emplacement_id AS contrat_emplacement_id_39 FROM setting t0;