Symfony Profiler

SELECT
  p0_.id AS id_0
FROM
  produit_declination_value p0_
  LEFT JOIN produit p1_ ON p0_.produit_id = p1_.id
  INNER JOIN group_declination_value g2_ ON p0_.id = g2_.produit_declination_id
  LEFT JOIN stock s3_ ON p0_.id = s3_.declination_produit_id
  AND (s3_.warehouse_id = ?)
WHERE
  (
    (
      UPPER(p0_.reference) LIKE ?
      OR UPPER(p1_.reference) LIKE ?
    )
  )
  AND g2_.declination_id = ?
  AND g2_.value_id = ?
  AND (s3_.qt_stock - s3_.qt_reserved) >= 1
  AND p1_.deleted_at IS NULL
GROUP BY
  p0_.id

SELECT p0_.id AS id_0 FROM produit_declination_value p0_ LEFT JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN group_declination_value g2_ ON p0_.id = g2_.produit_declination_id LEFT JOIN stock s3_ ON p0_.id = s3_.declination_produit_id AND (s3_.warehouse_id = 1) WHERE ((UPPER(p0_.reference) LIKE '%EN5%' OR UPPER(p1_.reference) LIKE '%EN5%')) AND g2_.declination_id = 1 AND g2_.value_id = 74 AND (s3_.qt_stock - s3_.qt_reserved) >= 1 AND p1_.deleted_at IS NULL GROUP BY p0_.id;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.barcode AS barcode_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.buying_price_ht AS buying_price_ht_5,
  p0_.buying_price_ttc AS buying_price_ttc_6,
  p0_.price_ht AS price_ht_7,
  p0_.created_at AS created_at_8,
  p0_.alert_stock_min AS alert_stock_min_9,
  p0_.uuid AS uuid_10,
  COALESCE(
    SUM(s1_.qt_stock),
    0
  ) AS sclr_11,
  COALESCE(
    SUM(s1_.qt_reserved),
    0
  ) AS sclr_12,
  COALESCE(
    SUM(s1_.qt_stock - s1_.qt_reserved),
    0
  ) AS sclr_13,
  (
    SELECT
      MIN(v2_.name) AS sclr_15
    FROM
      group_declination_value g3_
      INNER JOIN declination d4_ ON g3_.declination_id = d4_.id
      INNER JOIN value_declination v2_ ON g3_.value_id = v2_.id
    WHERE
      g3_.produit_declination_id = p0_.id
      AND d4_.position = 1
  ) AS sclr_14,
  (
    SELECT
      MIN(v5_.name) AS sclr_17
    FROM
      group_declination_value g6_
      INNER JOIN declination d7_ ON g6_.declination_id = d7_.id
      INNER JOIN value_declination v5_ ON g6_.value_id = v5_.id
    WHERE
      g6_.produit_declination_id = p0_.id
      AND d7_.position = 2
  ) AS sclr_16,
  p0_.produit_id AS produit_id_18
FROM
  produit_declination_value p0_
  LEFT JOIN produit p8_ ON p0_.produit_id = p8_.id
  INNER JOIN group_declination_value g9_ ON p0_.id = g9_.produit_declination_id
  LEFT JOIN stock s1_ ON p0_.id = s1_.declination_produit_id
  AND (s1_.warehouse_id = ?)
WHERE
  (
    (
      UPPER(p0_.reference) LIKE ?
      OR UPPER(p8_.reference) LIKE ?
    )
  )
  AND g9_.declination_id = ?
  AND g9_.value_id = ?
  AND (s1_.qt_stock - s1_.qt_reserved) >= 1
  AND p8_.deleted_at IS NULL
GROUP BY
  p0_.id
ORDER BY
  sclr_14 ASC,
  sclr_16 ASC,
  p0_.reference ASC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.barcode AS barcode_2, p0_.name AS name_3, p0_.description AS description_4, p0_.buying_price_ht AS buying_price_ht_5, p0_.buying_price_ttc AS buying_price_ttc_6, p0_.price_ht AS price_ht_7, p0_.created_at AS created_at_8, p0_.alert_stock_min AS alert_stock_min_9, p0_.uuid AS uuid_10, COALESCE(SUM(s1_.qt_stock), 0) AS sclr_11, COALESCE(SUM(s1_.qt_reserved), 0) AS sclr_12, COALESCE(SUM(s1_.qt_stock - s1_.qt_reserved), 0) AS sclr_13, (SELECT MIN(v2_.name) AS sclr_15 FROM group_declination_value g3_ INNER JOIN declination d4_ ON g3_.declination_id = d4_.id INNER JOIN value_declination v2_ ON g3_.value_id = v2_.id WHERE g3_.produit_declination_id = p0_.id AND d4_.position = 1) AS sclr_14, (SELECT MIN(v5_.name) AS sclr_17 FROM group_declination_value g6_ INNER JOIN declination d7_ ON g6_.declination_id = d7_.id INNER JOIN value_declination v5_ ON g6_.value_id = v5_.id WHERE g6_.produit_declination_id = p0_.id AND d7_.position = 2) AS sclr_16, p0_.produit_id AS produit_id_18 FROM produit_declination_value p0_ LEFT JOIN produit p8_ ON p0_.produit_id = p8_.id INNER JOIN group_declination_value g9_ ON p0_.id = g9_.produit_declination_id LEFT JOIN stock s1_ ON p0_.id = s1_.declination_produit_id AND (s1_.warehouse_id = 1) WHERE ((UPPER(p0_.reference) LIKE '%EN5%' OR UPPER(p8_.reference) LIKE '%EN5%')) AND g9_.declination_id = 1 AND g9_.value_id = 74 AND (s1_.qt_stock - s1_.qt_reserved) >= 1 AND p8_.deleted_at IS NULL GROUP BY p0_.id ORDER BY sclr_14 ASC, sclr_16 ASC, p0_.reference ASC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.qt_stock AS qt_stock_2,
  t0.qt_reserved AS qt_reserved_3,
  t0.incoming_quantity AS incoming_quantity_4,
  t0.incoming_date_estimated AS incoming_date_estimated_5,
  t0.exchange_incoming_quantity AS exchange_incoming_quantity_6,
  t0.average_unit_cost AS average_unit_cost_7,
  t0.last_purchase_price AS last_purchase_price_8,
  t0.valuation_updated_at AS valuation_updated_at_9,
  t0.produit_id AS produit_id_10,
  t0.declination_produit_id AS declination_produit_id_11,
  t0.warehouse_id AS warehouse_id_12
FROM
  stock t0
WHERE
  t0.declination_produit_id = ?

SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.incoming_quantity AS incoming_quantity_4, t0.incoming_date_estimated AS incoming_date_estimated_5, t0.exchange_incoming_quantity AS exchange_incoming_quantity_6, t0.average_unit_cost AS average_unit_cost_7, t0.last_purchase_price AS last_purchase_price_8, t0.valuation_updated_at AS valuation_updated_at_9, t0.produit_id AS produit_id_10, t0.declination_produit_id AS declination_produit_id_11, t0.warehouse_id AS warehouse_id_12 FROM stock t0 WHERE t0.declination_produit_id = 18083;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.image_size AS image_size_4,
  t0.is_selected AS is_selected_5
FROM
  file t0
  INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id
WHERE
  produit_declination_value_file.produit_declination_value_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = 18083;

SELECT
  t0.id AS id_1,
  t0.produit_declination_id AS produit_declination_id_2,
  t0.declination_id AS declination_id_3,
  t0.value_id AS value_id_4
FROM
  group_declination_value t0
WHERE
  t0.produit_declination_id = ?

SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = 18083;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.declination_id AS declination_id_4,
  t0.parent_id AS parent_id_5
FROM
  value_declination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.start_at AS start_at_4,
  t0.end_at AS end_at_5,
  t0.created_at AS created_at_6,
  t0.discount_type AS discount_type_7,
  t0.discount_value AS discount_value_8,
  t0.code AS code_9,
  t0.total_quantity AS total_quantity_10,
  t0.quantity_user AS quantity_user_11,
  t0.is_enabled AS is_enabled_12,
  t0.type AS type_13
FROM
  promotion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5, t0.created_at AS created_at_6, t0.discount_type AS discount_type_7, t0.discount_value AS discount_value_8, t0.code AS code_9, t0.total_quantity AS total_quantity_10, t0.quantity_user AS quantity_user_11, t0.is_enabled AS is_enabled_12, t0.type AS type_13 FROM promotion t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.module_code AS module_code_4,
  t0.module_name AS module_name_5,
  t0.description AS description_6,
  t0.module_order AS module_order_7
FROM
  `right` t0
  INNER JOIN right_group_user ON t0.id = right_group_user.right_id
WHERE
  right_group_user.group_user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.module_code AS module_code_4, t0.module_name AS module_name_5, t0.description AS description_6, t0.module_order AS module_order_7 FROM `right` t0 INNER JOIN right_group_user ON t0.id = right_group_user.right_id WHERE right_group_user.group_user_id = 2;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.barcode AS barcode_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.usual_quantity AS usual_quantity_6,
  t0.buying_price_ht AS buying_price_ht_7,
  t0.buying_price_ttc AS buying_price_ttc_8,
  t0.real_unit_value AS real_unit_value_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.reseller_price_ttc AS reseller_price_ttc_12,
  t0.unit AS unit_13,
  t0.is_stock AS is_stock_14,
  t0.is_declination AS is_declination_15,
  t0.created_at AS created_at_16,
  t0.uuid AS uuid_17,
  t0.information AS information_18,
  t0.is_archived AS is_archived_19,
  t0.deleted_at AS deleted_at_20,
  t0.reason_of_delete AS reason_of_delete_21,
  t0.best_selection AS best_selection_22,
  t0.rating_score AS rating_score_23,
  t0.rating_count AS rating_count_24,
  t0.material AS material_25,
  t0.supplier_reference AS supplier_reference_26,
  t0.meta_description AS meta_description_27,
  t0.video_url AS video_url_28,
  t0.show_in_web_site AS show_in_web_site_29,
  t0.show_in_pos_default AS show_in_pos_default_30,
  t0.can_be_restocked AS can_be_restocked_31,
  t0.categories_id AS categories_id_32,
  t0.tva_id AS tva_id_33,
  t0.buy_tva_id AS buy_tva_id_34,
  t0.promotion_id AS promotion_id_35,
  t0.supplier_id AS supplier_id_36
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.barcode AS barcode_3, t0.name AS name_4, t0.description AS description_5, t0.usual_quantity AS usual_quantity_6, t0.buying_price_ht AS buying_price_ht_7, t0.buying_price_ttc AS buying_price_ttc_8, t0.real_unit_value AS real_unit_value_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.reseller_price_ttc AS reseller_price_ttc_12, t0.unit AS unit_13, t0.is_stock AS is_stock_14, t0.is_declination AS is_declination_15, t0.created_at AS created_at_16, t0.uuid AS uuid_17, t0.information AS information_18, t0.is_archived AS is_archived_19, t0.deleted_at AS deleted_at_20, t0.reason_of_delete AS reason_of_delete_21, t0.best_selection AS best_selection_22, t0.rating_score AS rating_score_23, t0.rating_count AS rating_count_24, t0.material AS material_25, t0.supplier_reference AS supplier_reference_26, t0.meta_description AS meta_description_27, t0.video_url AS video_url_28, t0.show_in_web_site AS show_in_web_site_29, t0.show_in_pos_default AS show_in_pos_default_30, t0.can_be_restocked AS can_be_restocked_31, t0.categories_id AS categories_id_32, t0.tva_id AS tva_id_33, t0.buy_tva_id AS buy_tva_id_34, t0.promotion_id AS promotion_id_35, t0.supplier_id AS supplier_id_36 FROM produit t0 WHERE t0.id = 1360;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.type AS type_3,
  t0.value_string AS value_string_4,
  t0.value_int AS value_int_5,
  t0.value_float AS value_float_6,
  t0.value_bool AS value_bool_7,
  t0.value_json AS value_json_8,
  t0.value_text AS value_text_9,
  t0.description AS description_10,
  t0.updated_at AS updated_at_11,
  t0.section AS section_12
FROM
  website_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.type AS type_3, t0.value_string AS value_string_4, t0.value_int AS value_int_5, t0.value_float AS value_float_6, t0.value_bool AS value_bool_7, t0.value_json AS value_json_8, t0.value_text AS value_text_9, t0.description AS description_10, t0.updated_at AS updated_at_11, t0.section AS section_12 FROM website_setting t0 WHERE t0.setting_key = 'site_maintenance' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.display_in_filter AS display_in_filter_4
FROM
  declination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.display_in_filter AS display_in_filter_4 FROM declination t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civility AS civility_5,
  t0.first_name AS first_name_6,
  t0.email AS email_7,
  t0.birth_date AS birth_date_8,
  t0.description AS description_9,
  t0.client_search_note AS client_search_note_10,
  t0.phone AS phone_11,
  t0.second_phone AS second_phone_12,
  t0.adress AS adress_13,
  t0.country AS country_14,
  t0.region AS region_15,
  t0.city AS city_16,
  t0.zip AS zip_17,
  t0.type AS type_18,
  t0.is_verified AS is_verified_19,
  t0.created_at AS created_at_20,
  t0.is_blocked AS is_blocked_21,
  t0.blocked_at AS blocked_at_22,
  t0.unblocked_at AS unblocked_at_23,
  t0.block_reason AS block_reason_24,
  t0.blocked_hours AS blocked_hours_25,
  t0.client_type_locked AS client_type_locked_26,
  t0.internal_messenger_sound_enabled AS internal_messenger_sound_enabled_27,
  t0.internal_messenger_browser_notifications_enabled AS internal_messenger_browser_notifications_enabled_28,
  t0.messenger_code AS messenger_code_29,
  t0.supplier_id AS supplier_id_30,
  t0.promotion_id AS promotion_id_31,
  t0.group_user_id AS group_user_id_32,
  t0.user_post_id AS user_post_id_33,
  t0.client_type_id AS client_type_id_34
FROM
  `users` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.first_name AS first_name_6, t0.email AS email_7, t0.birth_date AS birth_date_8, t0.description AS description_9, t0.client_search_note AS client_search_note_10, t0.phone AS phone_11, t0.second_phone AS second_phone_12, t0.adress AS adress_13, t0.country AS country_14, t0.region AS region_15, t0.city AS city_16, t0.zip AS zip_17, t0.type AS type_18, t0.is_verified AS is_verified_19, t0.created_at AS created_at_20, t0.is_blocked AS is_blocked_21, t0.blocked_at AS blocked_at_22, t0.unblocked_at AS unblocked_at_23, t0.block_reason AS block_reason_24, t0.blocked_hours AS blocked_hours_25, t0.client_type_locked AS client_type_locked_26, t0.internal_messenger_sound_enabled AS internal_messenger_sound_enabled_27, t0.internal_messenger_browser_notifications_enabled AS internal_messenger_browser_notifications_enabled_28, t0.messenger_code AS messenger_code_29, t0.supplier_id AS supplier_id_30, t0.promotion_id AS promotion_id_31, t0.group_user_id AS group_user_id_32, t0.user_post_id AS user_post_id_33, t0.client_type_id AS client_type_id_34 FROM `users` t0 WHERE t0.id = 65007;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  group_user t0
  INNER JOIN user_user_group ON t0.id = user_user_group.group_user_id
WHERE
  user_user_group.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM group_user t0 INNER JOIN user_user_group ON t0.id = user_user_group.group_user_id WHERE user_user_group.user_id = 65007;