Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.favorite_apps AS favorite_apps_8
FROM
  user t0
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.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 16;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.created_at AS created_at_1
FROM
  material_entry m0_
ORDER BY
  m0_.created_at DESC
LIMIT
  20

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM material_entry m0_ ORDER BY m0_.created_at DESC LIMIT 20;

SELECT
  m0_.id AS id_0,
  m0_.truck_plate AS truck_plate_1,
  m0_.status AS status_2,
  m0_.comment AS comment_3,
  m0_.scheduled_date AS scheduled_date_4,
  m0_.arrival_time AS arrival_time_5,
  m0_.departure_time AS departure_time_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.validated_at AS validated_at_9,
  m0_.estimated_box_count AS estimated_box_count_10,
  m0_.estimated_weight AS estimated_weight_11,
  m0_.loaded_weight AS loaded_weight_12,
  m0_.empty_weight AS empty_weight_13,
  m0_.stock_movement AS stock_movement_14,
  m0_.is_delivered AS is_delivered_15,
  m0_.transport_cost AS transport_cost_16,
  m0_.supplier_id AS supplier_id_17,
  m0_.carrier_id AS carrier_id_18,
  m0_.forklift_operator_id AS forklift_operator_id_19
FROM
  material_entry m0_
WHERE
  m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.truck_plate AS truck_plate_1, m0_.status AS status_2, m0_.comment AS comment_3, m0_.scheduled_date AS scheduled_date_4, m0_.arrival_time AS arrival_time_5, m0_.departure_time AS departure_time_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.validated_at AS validated_at_9, m0_.estimated_box_count AS estimated_box_count_10, m0_.estimated_weight AS estimated_weight_11, m0_.loaded_weight AS loaded_weight_12, m0_.empty_weight AS empty_weight_13, m0_.stock_movement AS stock_movement_14, m0_.is_delivered AS is_delivered_15, m0_.transport_cost AS transport_cost_16, m0_.supplier_id AS supplier_id_17, m0_.carrier_id AS carrier_id_18, m0_.forklift_operator_id AS forklift_operator_id_19 FROM material_entry m0_ WHERE m0_.id IN (102, 101, 100, 99, 98, 97, 95, 94, 93, 92, 89, 88, 87, 86, 85, 83, 82, 81, 80, 79) ORDER BY m0_.created_at DESC;

SELECT
  count(*) AS sclr_0
FROM
  material_entry m0_

SELECT count(*) AS sclr_0 FROM material_entry m0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 4949;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 102;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 4290;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 101;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 5384;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 100;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 1842;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 99;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 98;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 6370;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.quantity AS quantity_3,
  t0.material_category AS material_category_4,
  t0.legacy_material_type AS legacy_material_type_5,
  t0.packaging_type AS packaging_type_6,
  t0.material_entry_id AS material_entry_id_7,
  t0.material_type_id AS material_type_id_8,
  t0.box_id AS box_id_9,
  t0.box_category_id AS box_category_id_10
FROM
  material_entry_line t0
WHERE
  t0.material_entry_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = 97;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = 6245;