Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO statistic (
  ip, date, user_agent, request_uri,
  referer, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO statistic (ip, date, user_agent, request_uri, referer, user_id) VALUES ('66.249.77.225', '2025-06-07 04:33:19', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.7103.113 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', '/', NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.common_name AS common_name_1,
  p0_.slug AS slug_2,
  p0_.latin_name AS latin_name_3,
  p0_.visibility AS visibility_4,
  p0_.average_purchase_price AS average_purchase_price_5,
  p0_.selling_price_ht AS selling_price_ht_6,
  p0_.selling_price_ttc AS selling_price_ttc_7,
  p0_.margin_rate AS margin_rate_8,
  p0_.is_active AS is_active_9,
  p0_.description AS description_10,
  p0_.short_description AS short_description_11,
  p0_.composed AS composed_12,
  p0_.created_at AS created_at_13,
  p0_.image AS image_14,
  p0_.reference AS reference_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.position AS position_19,
  c1_.visible AS visible_20,
  c1_.margin_rate AS margin_rate_21,
  c1_.description AS description_22,
  p0_.vat_id AS vat_id_23,
  p0_.category_id AS category_id_24,
  p0_.product_variation_origin_id AS product_variation_origin_id_25,
  c1_.parent_id AS parent_id_26
FROM
  product p0_
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.is_active = ?
  AND p0_.visibility = ?
  AND p0_.category_id IS NOT NULL
ORDER BY
  p0_.created_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.is_active = 1 AND p0_.visibility = 1 AND p0_.category_id IS NOT NULL ORDER BY p0_.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 256;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 256;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 5;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 5;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 9;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 9;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 11;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 11;

SELECT
  p0_.id AS id_0,
  p0_.common_name AS common_name_1,
  p0_.slug AS slug_2,
  p0_.latin_name AS latin_name_3,
  p0_.visibility AS visibility_4,
  p0_.average_purchase_price AS average_purchase_price_5,
  p0_.selling_price_ht AS selling_price_ht_6,
  p0_.selling_price_ttc AS selling_price_ttc_7,
  p0_.margin_rate AS margin_rate_8,
  p0_.is_active AS is_active_9,
  p0_.description AS description_10,
  p0_.short_description AS short_description_11,
  p0_.composed AS composed_12,
  p0_.created_at AS created_at_13,
  p0_.image AS image_14,
  p0_.reference AS reference_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.position AS position_19,
  c1_.visible AS visible_20,
  c1_.margin_rate AS margin_rate_21,
  c1_.description AS description_22,
  p0_.vat_id AS vat_id_23,
  p0_.category_id AS category_id_24,
  p0_.product_variation_origin_id AS product_variation_origin_id_25,
  c1_.parent_id AS parent_id_26
FROM
  product p0_
  LEFT JOIN cart_line c2_ ON (c2_.product_id = p0_.id)
  LEFT JOIN `cart` c3_ ON c2_.cart_id = c3_.id
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  c3_.status = ?
  AND p0_.visibility = ?
  AND p0_.category_id IS NOT NULL
GROUP BY
  p0_.id
ORDER BY
  COUNT(c2_.id) DESC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN cart_line c2_ ON (c2_.product_id = p0_.id) LEFT JOIN `cart` c3_ ON c2_.cart_id = c3_.id LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c3_.status = 'STATUS_VALIDE' AND p0_.visibility = 1 AND p0_.category_id IS NOT NULL GROUP BY p0_.id ORDER BY COUNT(c2_.id) DESC LIMIT 8;

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.visibility = ?
  AND p0_.category_id IS NOT NULL

SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visibility = 1 AND p0_.category_id IS NOT NULL;

SELECT
  p0_.id AS id_0,
  p0_.common_name AS common_name_1,
  p0_.slug AS slug_2,
  p0_.latin_name AS latin_name_3,
  p0_.visibility AS visibility_4,
  p0_.average_purchase_price AS average_purchase_price_5,
  p0_.selling_price_ht AS selling_price_ht_6,
  p0_.selling_price_ttc AS selling_price_ttc_7,
  p0_.margin_rate AS margin_rate_8,
  p0_.is_active AS is_active_9,
  p0_.description AS description_10,
  p0_.short_description AS short_description_11,
  p0_.composed AS composed_12,
  p0_.created_at AS created_at_13,
  p0_.image AS image_14,
  p0_.reference AS reference_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.position AS position_19,
  c1_.visible AS visible_20,
  c1_.margin_rate AS margin_rate_21,
  c1_.description AS description_22,
  p0_.vat_id AS vat_id_23,
  p0_.category_id AS category_id_24,
  p0_.product_variation_origin_id AS product_variation_origin_id_25,
  c1_.parent_id AS parent_id_26
FROM
  product p0_
  LEFT JOIN category c1_ ON p0_.category_id = c1_.id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.common_name AS common_name_1, p0_.slug AS slug_2, p0_.latin_name AS latin_name_3, p0_.visibility AS visibility_4, p0_.average_purchase_price AS average_purchase_price_5, p0_.selling_price_ht AS selling_price_ht_6, p0_.selling_price_ttc AS selling_price_ttc_7, p0_.margin_rate AS margin_rate_8, p0_.is_active AS is_active_9, p0_.description AS description_10, p0_.short_description AS short_description_11, p0_.composed AS composed_12, p0_.created_at AS created_at_13, p0_.image AS image_14, p0_.reference AS reference_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.position AS position_19, c1_.visible AS visible_20, c1_.margin_rate AS margin_rate_21, c1_.description AS description_22, p0_.vat_id AS vat_id_23, p0_.category_id AS category_id_24, p0_.product_variation_origin_id AS product_variation_origin_id_25, c1_.parent_id AS parent_id_26 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.id IN (18, 123, 26, 238, 19, 85, 127, 136);

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 18;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 18;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 19;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 19;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 26;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 26;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 85;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 85;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2
FROM
  product_feature t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM product_feature t0 WHERE t0.product_id = 123;

SELECT
  t0.id AS id_1,
  t0.threshold AS threshold_2,
  t0.quantity AS quantity_3,
  t0.product_id AS product_id_4
FROM
  stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.threshold AS threshold_2, t0.quantity AS quantity_3, t0.product_id AS product_id_4 FROM stock t0 WHERE t0.product_id = 123;