Symfony Profiler

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 5;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  last_activity = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2025-07-07 12:43:04' WHERE id = 5;

"COMMIT"

"COMMIT";

SELECT
  t0.term AS term_1,
  t0.datas AS datas_2,
  t0.infos AS infos_3,
  t0.is_spirit AS is_spirit_4,
  t0.possible_lwin AS possible_lwin_5,
  t0.possible_product AS possible_product_6,
  t0.valid_match AS valid_match_7,
  t0.id AS id_8,
  t0.uuid AS uuid_9,
  t0.name AS name_10,
  t0.status AS status_11,
  t0.entity_id AS entity_id_12
FROM
  product_waitlist t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.term AS term_1, t0.datas AS datas_2, t0.infos AS infos_3, t0.is_spirit AS is_spirit_4, t0.possible_lwin AS possible_lwin_5, t0.possible_product AS possible_product_6, t0.valid_match AS valid_match_7, t0.id AS id_8, t0.uuid AS uuid_9, t0.name AS name_10, t0.status AS status_11, t0.entity_id AS entity_id_12 FROM product_waitlist t0 WHERE t0.uuid = '58ec196c-9944-4d06-9108-c40ad949f63c' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product_waitlist
SET
  valid_match = ?
WHERE
  id = ?

UPDATE product_waitlist SET valid_match = 'lwin' WHERE id = 17789;

"COMMIT"

"COMMIT";

SELECT
  p0_.term AS term_0,
  p0_.datas AS datas_1,
  p0_.infos AS infos_2,
  p0_.is_spirit AS is_spirit_3,
  p0_.possible_lwin AS possible_lwin_4,
  p0_.possible_product AS possible_product_5,
  p0_.valid_match AS valid_match_6,
  p0_.id AS id_7,
  p0_.uuid AS uuid_8,
  p0_.name AS name_9,
  p0_.status AS status_10,
  l1_.id AS id_11,
  l1_.display_name AS display_name_12,
  l1_.country AS country_13,
  l1_.region AS region_14,
  l1_.sub_region AS sub_region_15,
  l1_.color AS color_16,
  l1_.classification AS classification_17,
  p2_.name AS name_18,
  p2_.display_name AS display_name_19,
  p2_.code AS code_20,
  p2_.lwin AS lwin_21,
  l3_.display_name AS display_name_22,
  l3_.country AS country_23,
  l3_.region AS region_24,
  l3_.sub_region AS sub_region_25,
  l3_.color AS color_26,
  l3_.classification AS classification_27,
  p0_.entity_id AS entity_id_28
FROM
  product_waitlist p0_
  LEFT JOIN entity e4_ ON p0_.entity_id = e4_.id
  LEFT JOIN lwin l1_ ON (l1_.id = p0_.possible_lwin)
  LEFT JOIN product p2_ ON (p2_.id = p0_.possible_product)
  LEFT JOIN lwin l3_ ON (l3_.id = p2_.lwin)
WHERE
  p0_.valid_match IS NULL
  AND e4_.status = ?
  AND p0_.status = ?
  AND (
    (
      p0_.possible_lwin <> 0
      AND p0_.possible_lwin IS NOT NULL
    )
    OR (
      p0_.possible_product <> 0
      AND p0_.possible_product IS NOT NULL
    )
  )
  AND (
    p0_.name LIKE ?
    OR l1_.display_name LIKE ?
    OR l1_.region LIKE ?
    OR l1_.sub_region LIKE ?
    OR JSON_SEARCH(p0_.infos, 'all', ?) IS NOT NULL
  )
  AND p0_.is_spirit = 0
  AND p0_.name NOT LIKE ?
  AND p0_.term NOT LIKE ?
  AND p0_.name NOT LIKE ?
  AND p0_.term NOT LIKE ?
  AND p0_.name NOT LIKE ?
  AND p0_.term NOT LIKE ?
  AND JSON_SEARCH(p0_.infos, 'all', ?) IS NULL
  AND JSON_SEARCH(p0_.infos, 'all', ?) IS NULL
  AND JSON_SEARCH(p0_.infos, 'all', ?) IS NULL
  AND e4_.id = ?
GROUP BY
  p0_.term,
  p0_.name
ORDER BY
  p0_.name ASC

SELECT p0_.term AS term_0, p0_.datas AS datas_1, p0_.infos AS infos_2, p0_.is_spirit AS is_spirit_3, p0_.possible_lwin AS possible_lwin_4, p0_.possible_product AS possible_product_5, p0_.valid_match AS valid_match_6, p0_.id AS id_7, p0_.uuid AS uuid_8, p0_.name AS name_9, p0_.status AS status_10, l1_.id AS id_11, l1_.display_name AS display_name_12, l1_.country AS country_13, l1_.region AS region_14, l1_.sub_region AS sub_region_15, l1_.color AS color_16, l1_.classification AS classification_17, p2_.name AS name_18, p2_.display_name AS display_name_19, p2_.code AS code_20, p2_.lwin AS lwin_21, l3_.display_name AS display_name_22, l3_.country AS country_23, l3_.region AS region_24, l3_.sub_region AS sub_region_25, l3_.color AS color_26, l3_.classification AS classification_27, p0_.entity_id AS entity_id_28 FROM product_waitlist p0_ LEFT JOIN entity e4_ ON p0_.entity_id = e4_.id LEFT JOIN lwin l1_ ON (l1_.id = p0_.possible_lwin) LEFT JOIN product p2_ ON (p2_.id = p0_.possible_product) LEFT JOIN lwin l3_ ON (l3_.id = p2_.lwin) WHERE p0_.valid_match IS NULL AND e4_.status = 1 AND p0_.status = 1 AND ((p0_.possible_lwin <> 0 AND p0_.possible_lwin IS NOT NULL) OR (p0_.possible_product <> 0 AND p0_.possible_product IS NOT NULL)) AND (p0_.name LIKE '%%' OR l1_.display_name LIKE '%%' OR l1_.region LIKE '%%' OR l1_.sub_region LIKE '%%' OR JSON_SEARCH(p0_.infos, 'all', '%%') IS NOT NULL) AND p0_.is_spirit = 0 AND p0_.name NOT LIKE '%champagne%' AND p0_.term NOT LIKE '%champagne%' AND p0_.name NOT LIKE '% brut%' AND p0_.term NOT LIKE '% brut%' AND p0_.name NOT LIKE '%brut %' AND p0_.term NOT LIKE '%brut %' AND JSON_SEARCH(p0_.infos, 'all', '%champagne%') IS NULL AND JSON_SEARCH(p0_.infos, 'all', '% brut%') IS NULL AND JSON_SEARCH(p0_.infos, 'all', '%brut %') IS NULL AND e4_.id = '6218' GROUP BY p0_.term, p0_.name ORDER BY p0_.name ASC;

SELECT
  t0.name AS name_1,
  t0.display_name AS display_name_2,
  t0.phones AS phones_3,
  t0.is_seller AS is_seller_4,
  t0.is_pool AS is_pool_5,
  t0.oenodata AS oenodata_6,
  t0.siret_number AS siret_number_7,
  t0.vat_number AS vat_number_8,
  t0.accise_number AS accise_number_9,
  t0.gacc_number AS gacc_number_10,
  t0.fda_number AS fda_number_11,
  t0.duns_number AS duns_number_12,
  t0.owner AS owner_13,
  t0.is_archived AS is_archived_14,
  t0.approved AS approved_15,
  t0.ignore_import AS ignore_import_16,
  t0.merged_uuids AS merged_uuids_17,
  t0.provisioning AS provisioning_18,
  t0.offer_type AS offer_type_19,
  t0.public_offer AS public_offer_20,
  t0.emails AS emails_21,
  t0.offer_disable_comment AS offer_disable_comment_22,
  t0.default_import_packaging_value AS default_import_packaging_value_23,
  t0.id AS id_24,
  t0.uuid AS uuid_25,
  t0.code AS code_26,
  t0.status AS status_27,
  t0.address AS address_28,
  t0.address2 AS address2_29,
  t0.postcode AS postcode_30,
  t0.city AS city_31,
  t0.url AS url_32,
  t0.parent_id AS parent_id_33,
  t0.type_id AS type_id_34,
  t35.columns AS columns_36,
  t35.type AS type_37,
  t35.id AS id_38,
  t35.uuid AS uuid_39,
  t35.status AS status_40,
  t35.entity_id AS entity_id_41,
  t0.pay_type_id AS pay_type_id_42,
  t0.default_import_packaging_id AS default_import_packaging_id_43,
  t0.country_id AS country_id_44
FROM
  entity t0
  LEFT JOIN import_feeds t35 ON t35.entity_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.display_name AS display_name_2, t0.phones AS phones_3, t0.is_seller AS is_seller_4, t0.is_pool AS is_pool_5, t0.oenodata AS oenodata_6, t0.siret_number AS siret_number_7, t0.vat_number AS vat_number_8, t0.accise_number AS accise_number_9, t0.gacc_number AS gacc_number_10, t0.fda_number AS fda_number_11, t0.duns_number AS duns_number_12, t0.owner AS owner_13, t0.is_archived AS is_archived_14, t0.approved AS approved_15, t0.ignore_import AS ignore_import_16, t0.merged_uuids AS merged_uuids_17, t0.provisioning AS provisioning_18, t0.offer_type AS offer_type_19, t0.public_offer AS public_offer_20, t0.emails AS emails_21, t0.offer_disable_comment AS offer_disable_comment_22, t0.default_import_packaging_value AS default_import_packaging_value_23, t0.id AS id_24, t0.uuid AS uuid_25, t0.code AS code_26, t0.status AS status_27, t0.address AS address_28, t0.address2 AS address2_29, t0.postcode AS postcode_30, t0.city AS city_31, t0.url AS url_32, t0.parent_id AS parent_id_33, t0.type_id AS type_id_34, t35.columns AS columns_36, t35.type AS type_37, t35.id AS id_38, t35.uuid AS uuid_39, t35.status AS status_40, t35.entity_id AS entity_id_41, t0.pay_type_id AS pay_type_id_42, t0.default_import_packaging_id AS default_import_packaging_id_43, t0.country_id AS country_id_44 FROM entity t0 LEFT JOIN import_feeds t35 ON t35.entity_id = t0.id WHERE t0.id = 6218;