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
  count(DISTINCT t0_.id) AS sclr_0
FROM
  tickets t0_
WHERE
  t0_.status = ?

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM tickets t0_ WHERE t0_.status = 2;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.id AS id_1
FROM
  tickets t0_
WHERE
  t0_.status = ?
ORDER BY
  t0_.id DESC
LIMIT
  10

SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM tickets t0_ WHERE t0_.status = 2 ORDER BY t0_.id DESC LIMIT 10;

SELECT
  t0_.id AS id_0,
  t0_.serie AS serie_1,
  t0_.reference AS reference_2,
  t0_.designation AS designation_3,
  t0_.type_ticket AS type_ticket_4,
  t0_.email AS email_5,
  t0_.adresse AS adresse_6,
  t0_.phone AS phone_7,
  t0_.comment AS comment_8,
  t0_.ref_ticket AS ref_ticket_9,
  t0_.is_referenced AS is_referenced_10,
  t0_.closed_at AS closed_at_11,
  t0_.created_at AS created_at_12,
  t0_.updated_at AS updated_at_13,
  t0_.status AS status_14,
  t0_.compteur_mono_a4 AS compteur_mono_a4_15,
  t0_.compteur_mono_a3 AS compteur_mono_a3_16,
  t0_.compteur_mono_gf AS compteur_mono_gf_17,
  t0_.compteur_color_a4 AS compteur_color_a4_18,
  t0_.compteur_color_a3 AS compteur_color_a3_19,
  t0_.compteur_color_gf AS compteur_color_gf_20,
  t0_.description_file AS description_file_21,
  t0_.code_machine AS code_machine_22,
  t0_.ville AS ville_23,
  t0_.contrat_id AS contrat_id_24,
  t0_.product_id AS product_id_25,
  t0_.client_id AS client_id_26,
  t0_.user_id AS user_id_27,
  t0_.ticket_category_id AS ticket_category_id_28
FROM
  tickets t0_
WHERE
  t0_.status = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t0_.id DESC

SELECT t0_.id AS id_0, t0_.serie AS serie_1, t0_.reference AS reference_2, t0_.designation AS designation_3, t0_.type_ticket AS type_ticket_4, t0_.email AS email_5, t0_.adresse AS adresse_6, t0_.phone AS phone_7, t0_.comment AS comment_8, t0_.ref_ticket AS ref_ticket_9, t0_.is_referenced AS is_referenced_10, t0_.closed_at AS closed_at_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t0_.status AS status_14, t0_.compteur_mono_a4 AS compteur_mono_a4_15, t0_.compteur_mono_a3 AS compteur_mono_a3_16, t0_.compteur_mono_gf AS compteur_mono_gf_17, t0_.compteur_color_a4 AS compteur_color_a4_18, t0_.compteur_color_a3 AS compteur_color_a3_19, t0_.compteur_color_gf AS compteur_color_gf_20, t0_.description_file AS description_file_21, t0_.code_machine AS code_machine_22, t0_.ville AS ville_23, t0_.contrat_id AS contrat_id_24, t0_.product_id AS product_id_25, t0_.client_id AS client_id_26, t0_.user_id AS user_id_27, t0_.ticket_category_id AS ticket_category_id_28 FROM tickets t0_ WHERE t0_.status = 2 AND t0_.id IN (2620, 2619, 2618, 2617, 2616, 2615, 2614, 2613, 2612, 2611) ORDER BY t0_.id 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.version AS version_2,
  t0.type_contrat AS type_contrat_3,
  t0.adresse_facturation AS adresse_facturation_4,
  t0.ref_band_commande AS ref_band_commande_5,
  t0.statut AS statut_6,
  t0.periodicite_facturation AS periodicite_facturation_7,
  t0.premiere_mensualite AS premiere_mensualite_8,
  t0.terme_facturation AS terme_facturation_9,
  t0.action_aterme AS action_aterme_10,
  t0.val_decote AS val_decote_11,
  t0.loyers AS loyers_12,
  t0.sepatare_factures AS sepatare_factures_13,
  t0.preventive AS preventive_14,
  t0.ref_contrat AS ref_contrat_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.sla AS sla_18,
  t0.delivery_status AS delivery_status_19,
  t0.sage_sync AS sage_sync_20,
  t0.numero_contrat AS numero_contrat_21,
  t0.date_start_contrat AS date_start_contrat_22,
  t0.client_id AS client_id_23,
  t0.devis_id AS devis_id_24,
  t0.added_by_id AS added_by_id_25
FROM
  contrat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.type_contrat AS type_contrat_3, t0.adresse_facturation AS adresse_facturation_4, t0.ref_band_commande AS ref_band_commande_5, t0.statut AS statut_6, t0.periodicite_facturation AS periodicite_facturation_7, t0.premiere_mensualite AS premiere_mensualite_8, t0.terme_facturation AS terme_facturation_9, t0.action_aterme AS action_aterme_10, t0.val_decote AS val_decote_11, t0.loyers AS loyers_12, t0.sepatare_factures AS sepatare_factures_13, t0.preventive AS preventive_14, t0.ref_contrat AS ref_contrat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sla AS sla_18, t0.delivery_status AS delivery_status_19, t0.sage_sync AS sage_sync_20, t0.numero_contrat AS numero_contrat_21, t0.date_start_contrat AS date_start_contrat_22, t0.client_id AS client_id_23, t0.devis_id AS devis_id_24, t0.added_by_id AS added_by_id_25 FROM contrat t0 WHERE t0.id = 3542;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.mail AS mail_3,
  t0.phone AS phone_4,
  t0.website AS website_5,
  t0.address AS address_6,
  t0.code_postal AS code_postal_7,
  t0.ville AS ville_8,
  t0.ref AS ref_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.ice AS ice_12,
  t0.rc AS rc_13,
  t0.code_client AS code_client_14,
  t0.sage_sync AS sage_sync_15,
  t0.client_type_id AS client_type_id_16,
  t0.user_id AS user_id_17,
  t0.commercial_id AS commercial_id_18
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.mail AS mail_3, t0.phone AS phone_4, t0.website AS website_5, t0.address AS address_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.ref AS ref_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.code_client AS code_client_14, t0.sage_sync AS sage_sync_15, t0.client_type_id AS client_type_id_16, t0.user_id AS user_id_17, t0.commercial_id AS commercial_id_18 FROM client t0 WHERE t0.id = 582;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.etat AS etat_3,
  t0.date_start AS date_start_4,
  t0.comment AS comment_5,
  t0.date_preview_end AS date_preview_end_6,
  t0.date_end AS date_end_7,
  t0.date_preview_start AS date_preview_start_8,
  t0.ticket_id AS ticket_id_9
FROM
  affectation t0
WHERE
  t0.ticket_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.etat AS etat_3, t0.date_start AS date_start_4, t0.comment AS comment_5, t0.date_preview_end AS date_preview_end_6, t0.date_end AS date_end_7, t0.date_preview_start AS date_preview_start_8, t0.ticket_id AS ticket_id_9 FROM affectation t0 WHERE t0.ticket_id = 2620;

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
  INNER JOIN affectation_user ON t0.id = affectation_user.user_id
WHERE
  affectation_user.affectation_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 INNER JOIN affectation_user ON t0.id = affectation_user.user_id WHERE affectation_user.affectation_id = 2388;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.type_contrat AS type_contrat_3,
  t0.adresse_facturation AS adresse_facturation_4,
  t0.ref_band_commande AS ref_band_commande_5,
  t0.statut AS statut_6,
  t0.periodicite_facturation AS periodicite_facturation_7,
  t0.premiere_mensualite AS premiere_mensualite_8,
  t0.terme_facturation AS terme_facturation_9,
  t0.action_aterme AS action_aterme_10,
  t0.val_decote AS val_decote_11,
  t0.loyers AS loyers_12,
  t0.sepatare_factures AS sepatare_factures_13,
  t0.preventive AS preventive_14,
  t0.ref_contrat AS ref_contrat_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.sla AS sla_18,
  t0.delivery_status AS delivery_status_19,
  t0.sage_sync AS sage_sync_20,
  t0.numero_contrat AS numero_contrat_21,
  t0.date_start_contrat AS date_start_contrat_22,
  t0.client_id AS client_id_23,
  t0.devis_id AS devis_id_24,
  t0.added_by_id AS added_by_id_25
FROM
  contrat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.type_contrat AS type_contrat_3, t0.adresse_facturation AS adresse_facturation_4, t0.ref_band_commande AS ref_band_commande_5, t0.statut AS statut_6, t0.periodicite_facturation AS periodicite_facturation_7, t0.premiere_mensualite AS premiere_mensualite_8, t0.terme_facturation AS terme_facturation_9, t0.action_aterme AS action_aterme_10, t0.val_decote AS val_decote_11, t0.loyers AS loyers_12, t0.sepatare_factures AS sepatare_factures_13, t0.preventive AS preventive_14, t0.ref_contrat AS ref_contrat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sla AS sla_18, t0.delivery_status AS delivery_status_19, t0.sage_sync AS sage_sync_20, t0.numero_contrat AS numero_contrat_21, t0.date_start_contrat AS date_start_contrat_22, t0.client_id AS client_id_23, t0.devis_id AS devis_id_24, t0.added_by_id AS added_by_id_25 FROM contrat t0 WHERE t0.id = 3545;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.etat AS etat_3,
  t0.date_start AS date_start_4,
  t0.comment AS comment_5,
  t0.date_preview_end AS date_preview_end_6,
  t0.date_end AS date_end_7,
  t0.date_preview_start AS date_preview_start_8,
  t0.ticket_id AS ticket_id_9
FROM
  affectation t0
WHERE
  t0.ticket_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.etat AS etat_3, t0.date_start AS date_start_4, t0.comment AS comment_5, t0.date_preview_end AS date_preview_end_6, t0.date_end AS date_end_7, t0.date_preview_start AS date_preview_start_8, t0.ticket_id AS ticket_id_9 FROM affectation t0 WHERE t0.ticket_id = 2619;

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
  INNER JOIN affectation_user ON t0.id = affectation_user.user_id
WHERE
  affectation_user.affectation_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 INNER JOIN affectation_user ON t0.id = affectation_user.user_id WHERE affectation_user.affectation_id = 2386;