Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = 'professional_video' LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.summary AS summary_6,
  t0.description AS description_7,
  t0.status AS status_8,
  t0.keywords AS keywords_9,
  t0.general_comments AS general_comments_10,
  t0.published AS published_11,
  t0.featured AS featured_12,
  t0.sku AS sku_13,
  t0.mfr_code AS mfr_code_14,
  t0.blk_code AS blk_code_15,
  t0.ean_code AS ean_code_16,
  t0.supplier_code AS supplier_code_17,
  t0.volumetric_weight AS volumetric_weight_18,
  t0.views AS views_19,
  t0.sales AS sales_20,
  t0.created_at AS created_at_21,
  t0.supplier_url AS supplier_url_22,
  t0.in_the_box_text AS in_the_box_text_23,
  t0.discount_percent AS discount_percent_24,
  t0.available_at AS available_at_25,
  t0.offer AS offer_26,
  t0.cash_back AS cash_back_27,
  t0.ask_for_price AS ask_for_price_28,
  t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29,
  t0.warehouse_stock_quantity AS warehouse_stock_quantity_30,
  t0.warehouse_stock_reserved AS warehouse_stock_reserved_31,
  t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32,
  t0.warehouse_stock_immutable AS warehouse_stock_immutable_33,
  t0.price_gross_amount AS price_gross_amount_34,
  t0.price_gross_currency AS price_gross_currency_35,
  t0.price_with_discount_amount AS price_with_discount_amount_36,
  t0.price_with_discount_currency AS price_with_discount_currency_37,
  t0.price_url AS price_url_38,
  t0.price_comments AS price_comments_39,
  t0.supplier_discount AS supplier_discount_40,
  t0.special_discount AS special_discount_41,
  t0.customs_charges AS customs_charges_42,
  t0.expected_profit AS expected_profit_43,
  t0.accessories AS accessories_44,
  t0.original_price_amount AS original_price_amount_45,
  t0.original_price_currency AS original_price_currency_46,
  t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47,
  t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48,
  t0.dimensions_measurement_unit AS dimensions_measurement_unit_49,
  t0.dimensions_length AS dimensions_length_50,
  t0.dimensions_width AS dimensions_width_51,
  t0.dimensions_height AS dimensions_height_52,
  t0.dimensions_weight_unit AS dimensions_weight_unit_53,
  t0.dimensions_weight AS dimensions_weight_54,
  t0.dimensions_volume AS dimensions_volume_55,
  t0.type_id AS type_id_56,
  t0.main_image_id AS main_image_id_57,
  t0.manufacturer_id AS manufacturer_id_58,
  t0.discr
FROM
  products t0
WHERE
  t0.slug = ?
  AND t0.discr IN ('product')
LIMIT
  1

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.price_url AS price_url_38, t0.price_comments AS price_comments_39, t0.supplier_discount AS supplier_discount_40, t0.special_discount AS special_discount_41, t0.customs_charges AS customs_charges_42, t0.expected_profit AS expected_profit_43, t0.accessories AS accessories_44, t0.original_price_amount AS original_price_amount_45, t0.original_price_currency AS original_price_currency_46, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48, t0.dimensions_measurement_unit AS dimensions_measurement_unit_49, t0.dimensions_length AS dimensions_length_50, t0.dimensions_width AS dimensions_width_51, t0.dimensions_height AS dimensions_height_52, t0.dimensions_weight_unit AS dimensions_weight_unit_53, t0.dimensions_weight AS dimensions_weight_54, t0.dimensions_volume AS dimensions_volume_55, t0.type_id AS type_id_56, t0.main_image_id AS main_image_id_57, t0.manufacturer_id AS manufacturer_id_58, t0.discr FROM products t0 WHERE t0.slug = 'EOS R6 w 24_105mm' AND t0.discr IN ('product') LIMIT 1;

SELECT
  p0_.content AS content_0,
  p0_.field AS field_1
FROM
  product_translations p0_
WHERE
  p0_.foreign_key = ?
  AND p0_.locale = ?
  AND p0_.object_class = ?

SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = '1964' AND p0_.locale = 'en' AND p0_.object_class = 'App\\Entity\\Product\\Object\\BaseProduct';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  products
SET
  views = ?
WHERE
  id = ?

UPDATE products SET views = 34 WHERE id = 1964;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.url AS url_4
FROM
  product_reference t0
  INNER JOIN products_references ON t0.id = products_references.reference_id
WHERE
  products_references.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = 1964;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.summary AS summary_3,
  p0_.price_gross_amount AS price_gross_amount_4,
  p0_.price_gross_currency AS price_gross_currency_5,
  p0_.price_with_discount_amount AS price_with_discount_amount_6,
  p0_.price_with_discount_currency AS price_with_discount_currency_7,
  p0_.mfr_code AS mfr_code_8,
  p0_.blk_code AS blk_code_9,
  p1_.id AS id_10,
  p1_.name AS name_11,
  a2_.name AS name_12,
  a2_.path AS path_13,
  p3_.id AS id_14,
  p3_.name AS name_15,
  p3_.slug AS slug_16,
  a4_.name AS name_17,
  a4_.path AS path_18,
  p5_.slug AS slug_19,
  p6_.slug AS slug_20
FROM
  products p0_
  INNER JOIN products_categories p7_ ON p0_.id = p7_.product_id
  INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id)
  INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id)
  AND a4_.discr IN ('manufacturer_logo')
  INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id)
  INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id)
  INNER JOIN products_categories p9_ ON (
    p0_.id = p9_.product_id
    AND p9_.main = 1
  )
  INNER JOIN product_category p6_ ON (p9_.category_id = p6_.id)
  INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id)
  LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id)
  AND a2_.discr IN (
    'product_image', 'product_category_banner',
    'manufacturer_logo', 'product_reference_pdf',
    'product_reference_image'
  )
WHERE
  (
    p0_.id IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
    AND p0_.published = ?
    AND p0_.status NOT IN (?, ?)
  )
  AND p0_.discr IN ('product', 'product_kit')
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.price_gross_amount AS price_gross_amount_4, p0_.price_gross_currency AS price_gross_currency_5, p0_.price_with_discount_amount AS price_with_discount_amount_6, p0_.price_with_discount_currency AS price_with_discount_currency_7, p0_.mfr_code AS mfr_code_8, p0_.blk_code AS blk_code_9, p1_.id AS id_10, p1_.name AS name_11, a2_.name AS name_12, a2_.path AS path_13, p3_.id AS id_14, p3_.name AS name_15, p3_.slug AS slug_16, a4_.name AS name_17, a4_.path AS path_18, p5_.slug AS slug_19, p6_.slug AS slug_20 FROM products p0_ INNER JOIN products_categories p7_ ON p0_.id = p7_.product_id INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id) INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id) AND a4_.discr IN ('manufacturer_logo') INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id) INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id) INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id AND p9_.main = 1) INNER JOIN product_category p6_ ON (p9_.category_id = p6_.id) INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id) LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id) AND a2_.discr IN ('product_image', 'product_category_banner', 'manufacturer_logo', 'product_reference_pdf', 'product_reference_image') WHERE (p0_.id IN (4269, 4532, 6510, 632, 6352, 6353, 6497, 6508, 9435, 6691, 6699, 6713, 6857, 6865, 6871, 6932, 7049, 7055, 7099, 7102, 5816, 6129, 967, 9364, 1307, 1308, 9366, 1381, 1470, 9369, 1552, 1619, 1632, 1696, 1700, 1806, 1812, 1828, 1860, 1868, 1870, 1871, 1876, 1877, 1885, 1888, 1901, 1935, 1936, 1938, 1940, 1941, 1965, 1995, 1996, 2001, 2049, 2074, 2085, 2089, 2117, 2118, 2144, 2164, 2166, 2172, 2203, 2204, 2230, 2257, 2260, 2314, 2316, 2324, 2333, 2370, 2374, 2382, 2390, 2433, 2444, 2457, 2458, 2497, 2498, 2508, 2513, 2520, 2523, 2526, 2573, 2585, 2594, 2595, 2605, 2644, 2656, 2719, 2763, 2780, 2812, 2832, 2861, 5179, 9498, 9196, 9499, 9501, 9313, 9339, 313, 437, 612, 613, 774, 9362, 2249, 2882, 5023, 5882, 5987, 6546, 6547, 6652, 7190, 7226, 7230, 7267, 7404, 9461, 7641, 7854, 7930, 8943, 8947, 8583, 8611, 1289, 9487, 8800, 8802, 8805, 8870, 8871, 8885, 8886, 8892, 8950, 8952, 8953, 8991, 9007, 9008, 9030, 9035, 9040, 9067, 9068, 9100, 9290, 1313, 1423, 1429, 1527, 2043, 2462, 2772, 3003, 3231, 3350, 4188, 4348, 6234, 7183, 933, 1857, 6408, 7298, 7310, 8160, 3279, 3563, 3614, 3903, 2926, 3282, 3283, 3284, 3565, 3566, 3843, 4125, 9407, 5246, 446, 9495, 9055, 9056, 9057, 9058, 9083, 9088, 9133, 9194, 5122, 6628, 4364, 5071, 6482, 6578, 7466, 7467, 8002, 8057, 8058, 3865, 4169, 2470, 5228, 5563, 6456, 6458, 6608, 6609, 7381, 7382, 9456, 7581, 8100, 9473, 8118, 8273, 8700, 9213, 5579, 5667, 5861, 6178, 7225, 7349, 7350, 7493, 7498, 7502, 9463, 7646, 7650, 7671, 9466, 7799, 7810, 7863, 7871, 7874, 7884, 9467, 7938, 7943, 7059, 9450, 7152, 7195, 7259, 7379, 463, 745, 746, 1913, 2637, 2662, 2663, 3117, 3124, 3125, 3444, 3458, 9401, 4003, 4005, 4253, 4255, 4496, 4508, 4733, 4734, 5050, 5056, 5057, 5058, 5272, 5541, 5619, 6569, 6808, 6818, 9258, 1333, 1338, 2090, 3586, 3588, 3898, 5109, 6612, 8854, 747, 9355, 968, 1914, 1919, 2634, 9385, 4862, 4863, 6483, 8717, 9259, 760, 4841) AND p0_.published = 1 AND p0_.status NOT IN ('view', 'no_view')) AND p0_.discr IN ('product', 'product_kit') GROUP BY p0_.id ORDER BY p0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5
FROM
  cart t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = 'cart_698930ac79ffd9.37404019' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.lvl = ?

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '5' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '7' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '9' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '10' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '11' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '14' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.tree_root = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = 1 LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  p0_.id AS id_0,
  p0_.migration_id AS migration_id_1,
  p0_.softone_id AS softone_id_2,
  p0_.name AS name_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.lft AS lft_6,
  p0_.lvl AS lvl_7,
  p0_.rgt AS rgt_8,
  p0_.published AS published_9,
  p0_.sort_index AS sort_index_10
FROM
  product_category p0_
WHERE
  p0_.rgt < 924
  AND p0_.lft > 1
  AND p0_.tree_root = ?
ORDER BY
  p0_.tree_root ASC,
  p0_.lft ASC

SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = 1 ORDER BY p0_.tree_root ASC, p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.wishlist AS wishlist_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.price_amount AS price_amount_6,
  t0.price_currency AS price_currency_7,
  t0.cart_id AS cart_id_8,
  t0.product_id AS product_id_9
FROM
  cart_item t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = 0x1F10552210B36388A021A156737CE3C3;