Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.entity_name AS entity_name_1,
  s0_.entity_id AS entity_id_2,
  s0_.value AS value_3,
  s0_.value_number AS value_number_4,
  s1_.id AS id_5,
  s1_.title AS title_6,
  s1_.description AS description_7,
  s1_.value_type AS value_type_8,
  s1_.value_postfix AS value_postfix_9,
  s1_.values_choice AS values_choice_10,
  s1_.value_default AS value_default_11,
  s1_.position AS position_12,
  s2_.id AS id_13,
  s2_.title AS title_14,
  s2_.position AS position_15
FROM
  submarine_properties_values s0_
  INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id
  INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id
WHERE
  s0_.entity_name = ?
  AND s0_.entity_id = ?
ORDER BY
  s2_.position ASC,
  s1_.position ASC

SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = 'Submarine\\PagesBundle\\Entity\\Page' AND s0_.entity_id = 3381 ORDER BY s2_.position ASC, s1_.position 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 = 2271 ORDER BY s1_.position ASC, s0_.title DESC) dctrn_result) dctrn_table;

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,
  s1_.id AS id_24,
  s1_.position AS position_25,
  s0_.type_id AS type_id_26,
  s0_.body_id AS body_id_27,
  s1_.parent_id AS parent_id_28,
  s1_.page_id AS page_id_29
FROM
  submarine_pages s0_
  INNER JOIN submarine_pages_types s2_ ON s0_.type_id = s2_.id
  INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id
WHERE
  s2_.id IN (?, ?)
  AND s0_.is_enabled = 1
  AND s0_.is_deleted = 0
ORDER BY
  s1_.position ASC,
  s0_.title ASC

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, s1_.id AS id_24, s1_.position AS position_25, s0_.type_id AS type_id_26, s0_.body_id AS body_id_27, s1_.parent_id AS parent_id_28, s1_.page_id AS page_id_29 FROM submarine_pages s0_ INNER JOIN submarine_pages_types s2_ ON s0_.type_id = s2_.id INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id WHERE s2_.id IN ('catalogGroup', 'actions') AND s0_.is_enabled = 1 AND s0_.is_deleted = 0 ORDER BY s1_.position ASC, s0_.title 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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )
  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 (2531, 2534, 2535, 2537, 2538, 2539, 3380, 3381, 3505, 3506, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 4291, 4292, 4293, 4295, 4296, 4297, 4298, 4299, 4345, 4346, 4347, 4348, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6027, 6590, 6591, 6592, 6618, 6619, 6620, 6621, 6622, 6623, 6624, 6806) AND s0_.name = 'property_186' GROUP BY s0_.value ORDER BY s0_.value ASC;

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 = 2271 ORDER BY s1_.position ASC, s0_.title DESC;

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

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 (2531, 2534, 2535, 2537, 2538, 2539, 3380, 3381, 3505, 3506, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 4291, 4292, 4293, 4295, 4296, 4297, 4298, 4299, 4345, 4346, 4347, 4348, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6027, 6590, 6591, 6592, 6618, 6619, 6620, 6621, 6622, 6623, 6624, 6806) AND s0_.is_enabled = 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.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 = 2270;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      position_25,
      title_4
    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,
          s1_.id AS id_24,
          s1_.position AS position_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 = ?
      ) dctrn_result_inner
    ORDER BY
      position_25 ASC,
      title_4 DESC
  ) dctrn_result
LIMIT
  18
OFFSET
  18

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_25, title_4 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, s1_.id AS id_24, s1_.position AS position_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 ('product') AND s1_.parent_id = 2271) dctrn_result_inner ORDER BY position_25 ASC, title_4 DESC) dctrn_result LIMIT 18 OFFSET 18;

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 (2531, 2534, 2535, 2537, 2538, 2539, 3380, 3381, 3505, 3506, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 4291, 4292, 4293, 4295, 4296, 4297, 4298, 4299, 4345, 4346, 4347, 4348, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6027, 6590, 6591, 6592, 6618, 6619, 6620, 6621, 6622, 6623, 6624, 6806) AND s0_.name = 'property_176' GROUP BY s0_.value_number ORDER BY s0_.value_number ASC;

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 = ?
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
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 ('product') AND s1_.parent_id = 2271 AND s0_.id IN (3381, 3380, 6806, 6020, 6021, 6025, 6026, 6027, 6619, 6622, 6624, 3505, 3616, 3615, 3610, 3617, 3613, 4298) ORDER BY s1_.position ASC, s0_.title DESC;

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

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.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 = '/svarochnye-materialy/svarochnaya-provoloka/provoloka-svarochnaya-omednennaya-sv08g2s' 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_links t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

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_links t0 WHERE t0.parent_id = 2271 ORDER BY t0.position ASC;