Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.tag_class AS tag_class_3,
  t0.value AS value_4,
  t0.title_slug_fr AS title_slug_fr_5,
  t0.enabled AS enabled_6,
  t0.php_condition AS php_condition_7,
  t0.product_php_condition AS product_php_condition_8
FROM
  tags t0
  INNER JOIN product_tags ON t0.id = product_tags.tags_id
WHERE
  product_tags.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.tag_class AS tag_class_3, t0.value AS value_4, t0.title_slug_fr AS title_slug_fr_5, t0.enabled AS enabled_6, t0.php_condition AS php_condition_7, t0.product_php_condition AS product_php_condition_8 FROM tags t0 INNER JOIN product_tags ON t0.id = product_tags.tags_id WHERE product_tags.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.title_fr AS title_fr_3,
  t0.description AS description_4,
  t0.is_adult AS is_adult_5,
  t0.date AS date_6,
  t0.live_stats AS live_stats_7,
  t0.title_slug_fr AS title_slug_fr_8,
  t0.is_enabled AS is_enabled_9,
  t0.keywords AS keywords_10,
  t0.price_is_active AS price_is_active_11,
  t0.availability_is_active AS availability_is_active_12,
  t0.condition_is_active AS condition_is_active_13,
  t0.long_description AS long_description_14,
  t0.long_description_html AS long_description_html_15,
  t0.filter_price AS filter_price_16,
  t0.category_id AS category_id_17,
  t0.price_id AS price_id_18,
  t0.product_availability_id AS product_availability_id_19,
  t0.product_condition_id AS product_condition_id_20,
  t0.supplier_id AS supplier_id_21
FROM
  Product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0 WHERE t0.id = '2';

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.parent_category_id AS parent_category_id_14
FROM
  categories t0
WHERE
  t0.is_pin = ?
  AND t0.file_created = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.parent_category_id AS parent_category_id_14 FROM categories t0 WHERE t0.is_pin = 1 AND t0.file_created = 1;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.title_fr AS title_fr_3,
  t0.description AS description_4,
  t0.is_adult AS is_adult_5,
  t0.date AS date_6,
  t0.live_stats AS live_stats_7,
  t0.title_slug_fr AS title_slug_fr_8,
  t0.is_enabled AS is_enabled_9,
  t0.keywords AS keywords_10,
  t0.price_is_active AS price_is_active_11,
  t0.availability_is_active AS availability_is_active_12,
  t0.condition_is_active AS condition_is_active_13,
  t0.long_description AS long_description_14,
  t0.long_description_html AS long_description_html_15,
  t0.filter_price AS filter_price_16,
  t0.category_id AS category_id_17,
  t0.price_id AS price_id_18,
  t0.product_availability_id AS product_availability_id_19,
  t0.product_condition_id AS product_condition_id_20,
  t0.supplier_id AS supplier_id_21
FROM
  Product t0
  INNER JOIN product_product ON t0.id = product_product.product_source
WHERE
  product_product.product_target = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0 INNER JOIN product_product ON t0.id = product_product.product_source WHERE product_product.product_target = 2;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.product_id AS product_id_3
FROM
  product_additional_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.product_id AS product_id_3 FROM product_additional_image t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.rating_number AS rating_number_2,
  t0.full_name AS full_name_3,
  t0.comment AS comment_4,
  t0.is_visible AS is_visible_5,
  t0.user_logged_in AS user_logged_in_6,
  t0.verified_purchase AS verified_purchase_7,
  t0.created_at AS created_at_8,
  t0.customer_email AS customer_email_9,
  t0.product_id AS product_id_10
FROM
  product_review t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.rating_number AS rating_number_2, t0.full_name AS full_name_3, t0.comment AS comment_4, t0.is_visible AS is_visible_5, t0.user_logged_in AS user_logged_in_6, t0.verified_purchase AS verified_purchase_7, t0.created_at AS created_at_8, t0.customer_email AS customer_email_9, t0.product_id AS product_id_10 FROM product_review t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.title_fr AS title_fr_3,
  t0.description AS description_4,
  t0.is_adult AS is_adult_5,
  t0.date AS date_6,
  t0.live_stats AS live_stats_7,
  t0.title_slug_fr AS title_slug_fr_8,
  t0.is_enabled AS is_enabled_9,
  t0.keywords AS keywords_10,
  t0.price_is_active AS price_is_active_11,
  t0.availability_is_active AS availability_is_active_12,
  t0.condition_is_active AS condition_is_active_13,
  t0.long_description AS long_description_14,
  t0.long_description_html AS long_description_html_15,
  t0.filter_price AS filter_price_16,
  t0.category_id AS category_id_17,
  t0.price_id AS price_id_18,
  t0.product_availability_id AS product_availability_id_19,
  t0.product_condition_id AS product_condition_id_20,
  t0.supplier_id AS supplier_id_21
FROM
  Product t0
  INNER JOIN product_product ON t0.id = product_product.product_target
WHERE
  product_product.product_source = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = 2;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.description_fr AS description_fr_3,
  t0.attribute_id AS attribute_id_4,
  t0.product_id AS product_id_5,
  t0.product_option_id AS product_option_id_6
FROM
  product_attribute_value t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.description_fr AS description_fr_3, t0.attribute_id AS attribute_id_4, t0.product_id AS product_id_5, t0.product_option_id AS product_option_id_6 FROM product_attribute_value t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.platform_data_id AS platform_data_id_3
FROM
  platform_logo t0
WHERE
  t0.platform_data_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_logo t0 WHERE t0.platform_data_id = 1;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.value AS value_3,
  t0.title_fr_slug AS title_fr_slug_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.description_fr AS description_fr_7
FROM
  product_availability_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.value AS value_3, t0.title_fr_slug AS title_fr_slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.description_fr AS description_fr_7 FROM product_availability_value t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_slug_fr AS title_slug_fr_3,
  t0.description AS description_4,
  t0.is_enabled AS is_enabled_5,
  t0.product_id AS product_id_6
FROM
  product_additional_details t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.description AS description_4, t0.is_enabled AS is_enabled_5, t0.product_id AS product_id_6 FROM product_additional_details t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.parent_category_id AS parent_category_id_14
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.parent_category_id AS parent_category_id_14 FROM categories t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.platform_title AS platform_title_2,
  t0.is_active AS is_active_3,
  t0.description AS description_4,
  t0.start_at AS start_at_5,
  t0.end_at AS end_at_6
FROM
  platform_data t0
WHERE
  t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.platform_title AS platform_title_2, t0.is_active AS is_active_3, t0.description AS description_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6 FROM platform_data t0 WHERE t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.product_id AS product_id_3
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.product_id AS product_id_3 FROM product_image t0 WHERE t0.product_id = 2;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.value AS value_3,
  t0.title_fr_slug AS title_fr_slug_4,
  t0.description_fr AS description_fr_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  product_condition_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.value AS value_3, t0.title_fr_slug AS title_fr_slug_4, t0.description_fr AS description_fr_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM product_condition_value t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.sale_price AS sale_price_3,
  t0.is_sale_price AS is_sale_price_4,
  t0.sale_price_effective_date_start AS sale_price_effective_date_start_5,
  t0.sale_price_effective_date_end AS sale_price_effective_date_end_6,
  t0.is_sale_effective_date AS is_sale_effective_date_7
FROM
  product_price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.is_sale_price AS is_sale_price_4, t0.sale_price_effective_date_start AS sale_price_effective_date_start_5, t0.sale_price_effective_date_end AS sale_price_effective_date_end_6, t0.is_sale_effective_date AS is_sale_effective_date_7 FROM product_price t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.stock_value AS stock_value_2,
  t0.is_availability_date AS is_availability_date_3,
  t0.availability_date AS availability_date_4,
  t0.availability_id AS availability_id_5
FROM
  product_availability t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.stock_value AS stock_value_2, t0.is_availability_date AS is_availability_date_3, t0.availability_date AS availability_date_4, t0.availability_id AS availability_id_5 FROM product_availability t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.product_condition_id AS product_condition_id_2
FROM
  product_condition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.product_condition_id AS product_condition_id_2 FROM product_condition t0 WHERE t0.id = 2;