Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.tag AS tag_3,
  t0.is_directory AS is_directory_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.is_deleted AS is_deleted_7,
  t0.is_enabled AS is_enabled_8,
  t0.html_title AS html_title_9,
  t0.html_meta_description AS html_meta_description_10,
  t0.html_meta_keywords AS html_meta_keywords_11,
  t0.cached_values AS cached_values_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.published_at AS published_at_15,
  t0.image_path AS image_path_16,
  t0.countComments AS countComments_17,
  t0.allowedComments AS allowedComments_18,
  t0.moderatedComments AS moderatedComments_19,
  t0.moy_sklad_update_errors AS moy_sklad_update_errors_20,
  t0.price AS price_21,
  t0.product_id AS product_id_22,
  t0.is_available AS is_available_23,
  t0.is_discount AS is_discount_24,
  t0.type_id AS type_id_25,
  t0.body_id AS body_id_26
FROM
  submarine_pages t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.url = '/zapasanye-chasti-dlya-svarki-gorelki/svarochnye-gorelki-i-zapasanye-chasti-k-poluavtomatam-mig/napravlyayushchie-kanaly-k-gorelkam' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.tag AS tag_3,
  t0.is_directory AS is_directory_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.is_deleted AS is_deleted_7,
  t0.is_enabled AS is_enabled_8,
  t0.html_title AS html_title_9,
  t0.html_meta_description AS html_meta_description_10,
  t0.html_meta_keywords AS html_meta_keywords_11,
  t0.cached_values AS cached_values_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.published_at AS published_at_15,
  t0.image_path AS image_path_16,
  t0.countComments AS countComments_17,
  t0.allowedComments AS allowedComments_18,
  t0.moderatedComments AS moderatedComments_19,
  t0.moy_sklad_update_errors AS moy_sklad_update_errors_20,
  t0.price AS price_21,
  t0.product_id AS product_id_22,
  t0.is_available AS is_available_23,
  t0.is_discount AS is_discount_24,
  t0.type_id AS type_id_25,
  t0.body_id AS body_id_26
FROM
  submarine_pages t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.tag = 'home' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.parent_id AS parent_id_3,
  t0.page_id AS page_id_4
FROM
  submarine_pages_relations t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.parent_id AS parent_id_3, t0.page_id AS page_id_4 FROM submarine_pages_relations t0 WHERE t0.page_id = 2290;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.tag AS tag_3,
  t0.is_directory AS is_directory_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.is_deleted AS is_deleted_7,
  t0.is_enabled AS is_enabled_8,
  t0.html_title AS html_title_9,
  t0.html_meta_description AS html_meta_description_10,
  t0.html_meta_keywords AS html_meta_keywords_11,
  t0.cached_values AS cached_values_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.published_at AS published_at_15,
  t0.image_path AS image_path_16,
  t0.countComments AS countComments_17,
  t0.allowedComments AS allowedComments_18,
  t0.moderatedComments AS moderatedComments_19,
  t0.moy_sklad_update_errors AS moy_sklad_update_errors_20,
  t0.price AS price_21,
  t0.product_id AS product_id_22,
  t0.is_available AS is_available_23,
  t0.is_discount AS is_discount_24,
  t0.type_id AS type_id_25,
  t0.body_id AS body_id_26
FROM
  submarine_pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = 3195;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.parent_id AS parent_id_3,
  t0.page_id AS page_id_4
FROM
  submarine_pages_relations t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.parent_id AS parent_id_3, t0.page_id AS page_id_4 FROM submarine_pages_relations t0 WHERE t0.page_id = 3195;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.tag AS tag_3,
  t0.is_directory AS is_directory_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.is_deleted AS is_deleted_7,
  t0.is_enabled AS is_enabled_8,
  t0.html_title AS html_title_9,
  t0.html_meta_description AS html_meta_description_10,
  t0.html_meta_keywords AS html_meta_keywords_11,
  t0.cached_values AS cached_values_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.published_at AS published_at_15,
  t0.image_path AS image_path_16,
  t0.countComments AS countComments_17,
  t0.allowedComments AS allowedComments_18,
  t0.moderatedComments AS moderatedComments_19,
  t0.moy_sklad_update_errors AS moy_sklad_update_errors_20,
  t0.price AS price_21,
  t0.product_id AS product_id_22,
  t0.is_available AS is_available_23,
  t0.is_discount AS is_discount_24,
  t0.type_id AS type_id_25,
  t0.body_id AS body_id_26
FROM
  submarine_pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.parent_id AS parent_id_3,
  t0.page_id AS page_id_4
FROM
  submarine_pages_relations t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.parent_id AS parent_id_3, t0.page_id AS page_id_4 FROM submarine_pages_relations t0 WHERE t0.page_id = 8;

SELECT
  s0_.id AS id_0,
  s0_.url AS url_1,
  s0_.tag AS tag_2,
  s0_.is_directory AS is_directory_3,
  s0_.title AS title_4,
  s0_.description AS description_5,
  s0_.is_deleted AS is_deleted_6,
  s0_.is_enabled AS is_enabled_7,
  s0_.html_title AS html_title_8,
  s0_.html_meta_description AS html_meta_description_9,
  s0_.html_meta_keywords AS html_meta_keywords_10,
  s0_.cached_values AS cached_values_11,
  s0_.created_at AS created_at_12,
  s0_.updated_at AS updated_at_13,
  s0_.published_at AS published_at_14,
  s0_.image_path AS image_path_15,
  s0_.countComments AS countComments_16,
  s0_.allowedComments AS allowedComments_17,
  s0_.moderatedComments AS moderatedComments_18,
  s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19,
  s0_.price AS price_20,
  s0_.product_id AS product_id_21,
  s0_.is_available AS is_available_22,
  s0_.is_discount AS is_discount_23,
  s0_.type_id AS type_id_24,
  s0_.body_id AS body_id_25
FROM
  submarine_pages s0_
  INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id
  LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id
WHERE
  s0_.is_enabled = ?
  AND s0_.is_deleted = ?
  AND s0_.type_id IN (?)
  AND s1_.parent_id = ?
ORDER BY
  s1_.position ASC,
  s0_.title DESC

SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23, s0_.type_id AS type_id_24, s0_.body_id AS body_id_25 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = 1 AND s0_.is_deleted = 0 AND s0_.type_id IN ('catalogGroup') AND s1_.parent_id = 2290 ORDER BY s1_.position ASC, s0_.title DESC;

SELECT
  s0_.id AS id_0,
  s0_.position AS position_1,
  s1_.id AS id_2,
  s1_.widget_type AS widget_type_3,
  s1_.field_type AS field_type_4,
  s1_.field_name AS field_name_5,
  s1_.name AS name_6,
  s1_.title AS title_7,
  s1_.description AS description_8,
  s0_.page_id AS page_id_9,
  s0_.filter_item_id AS filter_item_id_10,
  s1_.property_id AS property_id_11
FROM
  submarine_filter_manager_type_relations s0_
  INNER JOIN submarine_filter_manager_types s1_ ON s0_.filter_item_id = s1_.id
WHERE
  s0_.page_id = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.position AS position_1, s1_.id AS id_2, s1_.widget_type AS widget_type_3, s1_.field_type AS field_type_4, s1_.field_name AS field_name_5, s1_.name AS name_6, s1_.title AS title_7, s1_.description AS description_8, s0_.page_id AS page_id_9, s0_.filter_item_id AS filter_item_id_10, s1_.property_id AS property_id_11 FROM submarine_filter_manager_type_relations s0_ INNER JOIN submarine_filter_manager_types s1_ ON s0_.filter_item_id = s1_.id WHERE s0_.page_id = 2290 ORDER BY s0_.position ASC;

SELECT
  s0_.page_id AS page_id_0
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.name = ?
  AND s0_.value_number = ?

SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = 'category_id' AND s0_.value_number = 2290;

SELECT
  s0_.id AS id_0
FROM
  submarine_pages s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.is_enabled = ?

SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.is_enabled = 1;

SELECT
  s0_.id AS id_0,
  s0_.page_id AS page_id_1,
  s0_.name AS name_2,
  s0_.value AS value_3,
  s0_.value_number AS value_number_4,
  COUNT(s0_.id) AS sclr_5
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.page_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.name = ?
GROUP BY
  s0_.value
ORDER BY
  s0_.value ASC

SELECT s0_.id AS id_0, s0_.page_id AS page_id_1, s0_.name AS name_2, s0_.value AS value_3, s0_.value_number AS value_number_4, COUNT(s0_.id) AS sclr_5 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.name = 'property_202' GROUP BY s0_.value ORDER BY s0_.value ASC;

SELECT
  s0_.page_id AS page_id_0
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.name = ?
  AND s0_.value_number = ?

SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = 'category_id' AND s0_.value_number = 2290;

SELECT
  s0_.id AS id_0
FROM
  submarine_pages s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.is_enabled = ?

SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.is_enabled = 1;

SELECT
  s0_.id AS id_0,
  s0_.page_id AS page_id_1,
  s0_.name AS name_2,
  s0_.value AS value_3,
  s0_.value_number AS value_number_4,
  COUNT(s0_.id) AS sclr_5
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.page_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.name = ?
GROUP BY
  s0_.value
ORDER BY
  s0_.value ASC

SELECT s0_.id AS id_0, s0_.page_id AS page_id_1, s0_.name AS name_2, s0_.value AS value_3, s0_.value_number AS value_number_4, COUNT(s0_.id) AS sclr_5 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.name = 'property_207' GROUP BY s0_.value ORDER BY s0_.value ASC;

SELECT
  s0_.page_id AS page_id_0
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.name = ?
  AND s0_.value_number = ?

SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = 'category_id' AND s0_.value_number = 2290;

SELECT
  s0_.id AS id_0
FROM
  submarine_pages s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.is_enabled = ?

SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.is_enabled = 1;

SELECT
  s0_.id AS id_0,
  s0_.page_id AS page_id_1,
  s0_.name AS name_2,
  s0_.value AS value_3,
  s0_.value_number AS value_number_4,
  COUNT(s0_.id) AS sclr_5
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.page_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.name = ?
GROUP BY
  s0_.value_number
ORDER BY
  s0_.value_number ASC

SELECT s0_.id AS id_0, s0_.page_id AS page_id_1, s0_.name AS name_2, s0_.value AS value_3, s0_.value_number AS value_number_4, COUNT(s0_.id) AS sclr_5 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.name = 'property_207' GROUP BY s0_.value_number ORDER BY s0_.value_number ASC;

SELECT
  s0_.page_id AS page_id_0
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.name = ?
  AND s0_.value_number = ?

SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = 'category_id' AND s0_.value_number = 2290;

SELECT
  s0_.id AS id_0
FROM
  submarine_pages s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.is_enabled = ?

SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.is_enabled = 1;

SELECT
  s0_.id AS id_0,
  s0_.page_id AS page_id_1,
  s0_.name AS name_2,
  s0_.value AS value_3,
  s0_.value_number AS value_number_4,
  COUNT(s0_.id) AS sclr_5
FROM
  submarine_filter_manager_index s0_
WHERE
  s0_.page_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND s0_.name = ?
GROUP BY
  s0_.value
ORDER BY
  s0_.value ASC

SELECT s0_.id AS id_0, s0_.page_id AS page_id_1, s0_.name AS name_2, s0_.value AS value_3, s0_.value_number AS value_number_4, COUNT(s0_.id) AS sclr_5 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (2656, 2657, 2658, 2659, 2660, 2661, 2662, 2663, 2664, 3442, 3444, 3445, 3447, 3448, 3449, 3450, 3451, 3452, 4862, 4863, 4864, 4865, 4866, 4867, 4868, 4869, 4870, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4878) AND s0_.name = 'property_834' GROUP BY s0_.value ORDER BY s0_.value ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.url AS url_1,
          s0_.tag AS tag_2,
          s0_.is_directory AS is_directory_3,
          s0_.title AS title_4,
          s0_.description AS description_5,
          s0_.is_deleted AS is_deleted_6,
          s0_.is_enabled AS is_enabled_7,
          s0_.html_title AS html_title_8,
          s0_.html_meta_description AS html_meta_description_9,
          s0_.html_meta_keywords AS html_meta_keywords_10,
          s0_.cached_values AS cached_values_11,
          s0_.created_at AS created_at_12,
          s0_.updated_at AS updated_at_13,
          s0_.published_at AS published_at_14,
          s0_.image_path AS image_path_15,
          s0_.countComments AS countComments_16,
          s0_.allowedComments AS allowedComments_17,
          s0_.moderatedComments AS moderatedComments_18,
          s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19,
          s0_.price AS price_20,
          s0_.product_id AS product_id_21,
          s0_.is_available AS is_available_22,
          s0_.is_discount AS is_discount_23
        FROM
          submarine_pages s0_
          INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id
          LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id
        WHERE
          s0_.is_enabled = ?
          AND s0_.is_deleted = ?
          AND s0_.type_id IN (?)
          AND s1_.parent_id = ?
        ORDER BY
          s1_.position ASC,
          s0_.title DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = 1 AND s0_.is_deleted = 0 AND s0_.type_id IN ('product') AND s1_.parent_id = 2290 ORDER BY s1_.position ASC, s0_.title DESC) dctrn_result) dctrn_table;