Symfony Profiler

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.title_fr AS title_fr_2,
  t0.title_fr_slug AS title_fr_slug_3,
  t0.code AS code_4,
  t0.exchange_rate AS exchange_rate_5,
  t0.is_enabled AS is_enabled_6,
  t0.is_default_currency AS is_default_currency_7
FROM
  currency t0
  INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id
WHERE
  platform_data_currency.platform_data_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_fr_slug AS title_fr_slug_3, t0.code AS code_4, t0.exchange_rate AS exchange_rate_5, t0.is_enabled AS is_enabled_6, t0.is_default_currency AS is_default_currency_7 FROM currency t0 INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id WHERE platform_data_currency.platform_data_id = 1;

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 = ?

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;

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.is_enabled = ?

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.is_enabled = 1;

SELECT
  p0_.id AS id_0,
  p0_.unique_id AS unique_id_1,
  p0_.title_fr AS title_fr_2,
  p0_.description AS description_3,
  p0_.is_adult AS is_adult_4,
  p0_.date AS date_5,
  p0_.live_stats AS live_stats_6,
  p0_.title_slug_fr AS title_slug_fr_7,
  p0_.is_enabled AS is_enabled_8,
  p0_.keywords AS keywords_9,
  p0_.price_is_active AS price_is_active_10,
  p0_.availability_is_active AS availability_is_active_11,
  p0_.condition_is_active AS condition_is_active_12,
  p0_.long_description AS long_description_13,
  p0_.long_description_html AS long_description_html_14,
  p0_.filter_price AS filter_price_15,
  p0_.category_id AS category_id_16,
  p0_.price_id AS price_id_17,
  p0_.product_availability_id AS product_availability_id_18,
  p0_.product_condition_id AS product_condition_id_19,
  p0_.supplier_id AS supplier_id_20
FROM
  Product p0_
WHERE
  p0_.is_enabled = 1
  AND p0_.price_is_active = 1
ORDER BY
  p0_.live_stats ASC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.unique_id AS unique_id_1, p0_.title_fr AS title_fr_2, p0_.description AS description_3, p0_.is_adult AS is_adult_4, p0_.date AS date_5, p0_.live_stats AS live_stats_6, p0_.title_slug_fr AS title_slug_fr_7, p0_.is_enabled AS is_enabled_8, p0_.keywords AS keywords_9, p0_.price_is_active AS price_is_active_10, p0_.availability_is_active AS availability_is_active_11, p0_.condition_is_active AS condition_is_active_12, p0_.long_description AS long_description_13, p0_.long_description_html AS long_description_html_14, p0_.filter_price AS filter_price_15, p0_.category_id AS category_id_16, p0_.price_id AS price_id_17, p0_.product_availability_id AS product_availability_id_18, p0_.product_condition_id AS product_condition_id_19, p0_.supplier_id AS supplier_id_20 FROM Product p0_ WHERE p0_.is_enabled = 1 AND p0_.price_is_active = 1 ORDER BY p0_.live_stats ASC LIMIT 20;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  Product p0_
WHERE
  p0_.is_enabled = 1

SELECT COUNT(p0_.id) AS sclr_0 FROM Product p0_ WHERE p0_.is_enabled = 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

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;

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
  c0_.id AS id_0,
  c0_.title_fr AS title_fr_1,
  c0_.identifier_value AS identifier_value_2,
  c0_.live_stats AS live_stats_3,
  c0_.description AS description_4,
  c0_.title_slug_fr AS title_slug_fr_5,
  c0_.keywords AS keywords_6,
  c0_.is_enabled AS is_enabled_7,
  c0_.is_pin AS is_pin_8,
  c0_.date AS date_9,
  c0_.icon_library_value AS icon_library_value_10,
  c0_.parent_identifier_value AS parent_identifier_value_11,
  c0_.file_created AS file_created_12,
  c0_.parent_category_id AS parent_category_id_13
FROM
  categories c0_

SELECT c0_.id AS id_0, c0_.title_fr AS title_fr_1, c0_.identifier_value AS identifier_value_2, c0_.live_stats AS live_stats_3, c0_.description AS description_4, c0_.title_slug_fr AS title_slug_fr_5, c0_.keywords AS keywords_6, c0_.is_enabled AS is_enabled_7, c0_.is_pin AS is_pin_8, c0_.date AS date_9, c0_.icon_library_value AS icon_library_value_10, c0_.parent_identifier_value AS parent_identifier_value_11, c0_.file_created AS file_created_12, c0_.parent_category_id AS parent_category_id_13 FROM categories c0_;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_slug_fr AS title_slug_fr_3,
  t0.content AS content_4,
  t0.content_html AS content_html_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.enforcement_at AS enforcement_at_8,
  t0.is_enabled AS is_enabled_9,
  t0.random_number AS random_number_10,
  t0.indice AS indice_11
FROM
  legal_pages t0
WHERE
  t0.is_enabled = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.content AS content_4, t0.content_html AS content_html_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enforcement_at AS enforcement_at_8, t0.is_enabled AS is_enabled_9, t0.random_number AS random_number_10, t0.indice AS indice_11 FROM legal_pages t0 WHERE t0.is_enabled = 1;

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

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;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.platform_data_id AS platform_data_id_3
FROM
  platform_favicon 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_favicon t0 WHERE t0.platform_data_id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.is_enabled AS is_enabled_3,
  t0.title_fr AS title_fr_4,
  t0.title_fr_slug AS title_fr_slug_5
FROM
  locale t0
  INNER JOIN platform_data_locale ON t0.id = platform_data_locale.locale_id
WHERE
  platform_data_locale.platform_data_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.is_enabled AS is_enabled_3, t0.title_fr AS title_fr_4, t0.title_fr_slug AS title_fr_slug_5 FROM locale t0 INNER JOIN platform_data_locale ON t0.id = platform_data_locale.locale_id WHERE platform_data_locale.platform_data_id = 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.locale_id AS locale_id_3
FROM
  locale_mobile_img t0
WHERE
  t0.locale_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.locale_id AS locale_id_3 FROM locale_mobile_img t0 WHERE t0.locale_id = 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.locale_id AS locale_id_3
FROM
  locale_mobile_img t0
WHERE
  t0.locale_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.locale_id AS locale_id_3 FROM locale_mobile_img t0 WHERE t0.locale_id = 2;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.locale_id AS locale_id_3
FROM
  locale_mobile_img t0
WHERE
  t0.locale_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.locale_id AS locale_id_3 FROM locale_mobile_img t0 WHERE t0.locale_id = 3;

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.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 = 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 = 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.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.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 = 3;

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 = 3;