Symfony Profiler

Query Metrics

60 Database Queries

18 Different statements

46.33 ms Query time

0 Invalid entities

Queries


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.tag = ? 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.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.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.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.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.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.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 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_.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_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ?
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
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_.title AS title_1 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?)
SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ?
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
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_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ?
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
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_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ?
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
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_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ?
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
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_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ?
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
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 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 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
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_.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 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 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 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 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 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 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 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 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position 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, 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 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.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.body AS body_2 FROM submarine_pages_body t0 WHERE t0.id = ?

#▲	Time	Info
1	0.42 ms	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 Parameters: [`"/svarochnye-materialy/svarochnaya-provoloka/alyuminievaya-svarochnaya-provoloka"`] View formatted query View runnable query Explain query 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/alyuminievaya-svarochnaya-provoloka' LIMIT 1;
2	0.28 ms	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 Parameters: [`"home"`] View formatted query View runnable query Explain query 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;
3	0.18 ms	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 = ? Parameters: [`2273`] View formatted query View runnable query Explain query 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 = 2273;
4	0.23 ms	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 = ? Parameters: [`2270`] View formatted query View runnable query Explain query 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;
5	0.18 ms	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 = ? Parameters: [`2270`] View formatted query View runnable query Explain query 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 = 2270;
6	0.18 ms	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 = ? Parameters: [`26`] View formatted query View runnable query Explain query 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 = 26;
7	0.15 ms	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 = ? Parameters: [`26`] View formatted query View runnable query Explain query 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 = 26;
8	0.18 ms	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 = ? Parameters: [`8`] View formatted query View runnable query Explain query 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;
9	0.18 ms	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 = ? Parameters: [`8`] View formatted query View runnable query Explain query 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;
10	1.57 ms	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 Parameters: [`1 0 "catalogGroup" 2273`] View formatted query View runnable query Explain query 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 = 2273 ORDER BY s1_.position ASC, s0_.title DESC;
11	0.30 ms	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 Parameters: [`2273`] View formatted query View runnable query Explain query 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 = 2273 ORDER BY s0_.position ASC;
12	0.84 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ? Parameters: [`"category_id" 2273`] View formatted query View runnable query Explain query 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 = 2273;
13	0.62 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 1] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.is_enabled = 1;
14	2.30 ms	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 Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 "manufacturer"] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.name = 'manufacturer' GROUP BY s0_.value ORDER BY s0_.value ASC;
15	0.25 ms	SELECT s0_.id AS id_0, s0_.title AS title_1 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?) Parameters: [`"2470" "2955" "3538" "55" "6019" "6799" "6822"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.title AS title_1 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?) SELECT s0_.id AS id_0, s0_.title AS title_1 FROM submarine_pages s0_ WHERE s0_.id IN ('2470', '2955', '3538', '55', '6019', '6799', '6822');
16	0.53 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ? Parameters: [`"category_id" 2273`] View formatted query View runnable query Explain query 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 = 2273;
17	0.54 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 1] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.is_enabled = 1;
18	1.82 ms	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 Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 "property_176"] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.name = 'property_176' GROUP BY s0_.value ORDER BY s0_.value ASC;
19	0.42 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ? Parameters: [`"category_id" 2273`] View formatted query View runnable query Explain query 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 = 2273;
20	0.55 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 1] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.is_enabled = 1;
21	1.31 ms	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 Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 "property_176"] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.name = 'property_176' GROUP BY s0_.value_number ORDER BY s0_.value_number ASC;
22	0.40 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ? Parameters: [`"category_id" 2273`] View formatted query View runnable query Explain query 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 = 2273;
23	0.48 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 1] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.is_enabled = 1;
24	0.98 ms	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 Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 "property_509"] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.name = 'property_509' GROUP BY s0_.value ORDER BY s0_.value ASC;
25	0.39 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ? Parameters: [`"category_id" 2273`] View formatted query View runnable query Explain query 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 = 2273;
26	0.53 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 1] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.is_enabled = 1;
27	1.12 ms	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 Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 "property_178"] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.name = 'property_178' GROUP BY s0_.value ORDER BY s0_.value ASC;
28	0.40 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ WHERE s0_.name = ? AND s0_.value_number = ? Parameters: [`"category_id" 2273`] View formatted query View runnable query Explain query 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 = 2273;
29	0.53 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 1] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.is_enabled = 1;
30	1.03 ms	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 Parameters: [2586 2587 2588 2589 2590 2591 2592 2593 2594 3665 3666 3667 3668 3669 3670 3671 6604 6605 6606 6607 6642 6643 6644 6646 6647 6648 6649 6650 6651 6652 6653 6654 6655 6656 6657 6658 6659 6660 6661 6662 6663 6664 6665 6666 6667 6668 6669 6671 6672 6675 6676 6677 6678 6679 6680 6681 6682 6683 6685 6686 6688 6690 6691 6692 6694 6695 6696 6697 6699 6700 6703 6704 6705 6707 6709 6710 6711 6712 6713 6715 6718 6719 6722 6723 6724 6725 6726 6741 6742 6743 6744 6745 6746 6747 6748 6750 6751 6752 6754 6756 6760 6761 6764 6765 6766 6767 6768 6769 6770 6771 6772 6773 6776 6777 6778 6784 6786 6787 6788 6790 6897 "property_178"] View formatted query View runnable query Explain query 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 (2586, 2587, 2588, 2589, 2590, 2591, 2592, 2593, 2594, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 6604, 6605, 6606, 6607, 6642, 6643, 6644, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 6663, 6664, 6665, 6666, 6667, 6668, 6669, 6671, 6672, 6675, 6676, 6677, 6678, 6679, 6680, 6681, 6682, 6683, 6685, 6686, 6688, 6690, 6691, 6692, 6694, 6695, 6696, 6697, 6699, 6700, 6703, 6704, 6705, 6707, 6709, 6710, 6711, 6712, 6713, 6715, 6718, 6719, 6722, 6723, 6724, 6725, 6726, 6741, 6742, 6743, 6744, 6745, 6746, 6747, 6748, 6750, 6751, 6752, 6754, 6756, 6760, 6761, 6764, 6765, 6766, 6767, 6768, 6769, 6770, 6771, 6772, 6773, 6776, 6777, 6778, 6784, 6786, 6787, 6788, 6790, 6897) AND s0_.name = 'property_178' GROUP BY s0_.value_number ORDER BY s0_.value_number ASC;
31	4.43 ms	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 Parameters: [`1 0 "product" 2273`] View formatted query View runnable query Explain query 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 = 2273 ORDER BY s1_.position ASC, s0_.title DESC) dctrn_result) dctrn_table;
32	2.51 ms	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 Parameters: [`1 0 "product" 2273`] View formatted query View runnable query Explain query 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 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 = 2273) dctrn_result_inner ORDER BY position_25 ASC, title_4 DESC) dctrn_result LIMIT 18;
33	1.12 ms	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 Parameters: [`1 0 "product" 2273 6756 6722 3668 6650 6683 6723 6696 3670 6672 6667 6695 2594 6677 2593 6776 6713 3669 6718`] View formatted query View runnable query Explain query 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 = 2273 AND s0_.id IN (6756, 6722, 3668, 6650, 6683, 6723, 6696, 3670, 6672, 6667, 6695, 2594, 6677, 2593, 6776, 6713, 3669, 6718) ORDER BY s1_.position ASC, s0_.title DESC;
34	0.90 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6756`] View formatted query View runnable query Explain query 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 = 6756 ORDER BY s2_.position ASC, s1_.position ASC;
35	0.24 ms	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 = ? Parameters: [`6799`] View formatted query View runnable query Explain query 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 = 6799;
36	0.68 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6722`] View formatted query View runnable query Explain query 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 = 6722 ORDER BY s2_.position ASC, s1_.position ASC;
37	0.21 ms	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 = ? Parameters: [`6019`] View formatted query View runnable query Explain query 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 = 6019;
38	0.73 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 3668`] View formatted query View runnable query Explain query 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 = 3668 ORDER BY s2_.position ASC, s1_.position ASC;
39	0.19 ms	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 = ? Parameters: [`2470`] View formatted query View runnable query Explain query 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 = 2470;
40	0.66 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6650`] View formatted query View runnable query Explain query 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 = 6650 ORDER BY s2_.position ASC, s1_.position ASC;
41	0.18 ms	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 = ? Parameters: [`3538`] View formatted query View runnable query Explain query 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 = 3538;
42	0.73 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6683`] View formatted query View runnable query Explain query 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 = 6683 ORDER BY s2_.position ASC, s1_.position ASC;
43	0.63 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6723`] View formatted query View runnable query Explain query 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 = 6723 ORDER BY s2_.position ASC, s1_.position ASC;
44	0.63 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6696`] View formatted query View runnable query Explain query 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 = 6696 ORDER BY s2_.position ASC, s1_.position ASC;
45	0.66 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 3670`] View formatted query View runnable query Explain query 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 = 3670 ORDER BY s2_.position ASC, s1_.position ASC;
46	0.73 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6672`] View formatted query View runnable query Explain query 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 = 6672 ORDER BY s2_.position ASC, s1_.position ASC;
47	0.65 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6667`] View formatted query View runnable query Explain query 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 = 6667 ORDER BY s2_.position ASC, s1_.position ASC;
48	0.82 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6695`] View formatted query View runnable query Explain query 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 = 6695 ORDER BY s2_.position ASC, s1_.position ASC;
49	0.77 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 2594`] View formatted query View runnable query Explain query 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 = 2594 ORDER BY s2_.position ASC, s1_.position ASC;
50	0.66 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6677`] View formatted query View runnable query Explain query 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 = 6677 ORDER BY s2_.position ASC, s1_.position ASC;
51	0.72 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 2593`] View formatted query View runnable query Explain query 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 = 2593 ORDER BY s2_.position ASC, s1_.position ASC;
52	0.87 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6776`] View formatted query View runnable query Explain query 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 = 6776 ORDER BY s2_.position ASC, s1_.position ASC;
53	0.70 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6713`] View formatted query View runnable query Explain query 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 = 6713 ORDER BY s2_.position ASC, s1_.position ASC;
54	0.70 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 3669`] View formatted query View runnable query Explain query 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 = 3669 ORDER BY s2_.position ASC, s1_.position ASC;
55	0.79 ms	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 Parameters: [`"Submarine\PagesBundle\Entity\Page" 6718`] View formatted query View runnable query Explain query 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 = 6718 ORDER BY s2_.position ASC, s1_.position ASC;
56	1.07 ms	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 Parameters: [`1 0 "catalogSeoGroup" 2273`] View formatted query View runnable query Explain query 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 ('catalogSeoGroup') AND s1_.parent_id = 2273 ORDER BY s1_.position ASC, s0_.title DESC;
57	3.47 ms	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 Parameters: [`"catalogGroup" "actions"`] View formatted query View runnable query Explain query 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;
58	0.33 ms	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 Parameters: [`"catalog"`] View formatted query View runnable query Explain query 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 = 'catalog' LIMIT 1;
59	0.39 ms	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 Parameters: [`2273`] View formatted query View runnable query Explain query 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 = 2273 ORDER BY t0.position ASC;
60	0.26 ms	SELECT t0.id AS id_1, t0.body AS body_2 FROM submarine_pages_body t0 WHERE t0.id = ? Parameters: [`2273`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.body AS body_2 FROM submarine_pages_body t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.body AS body_2 FROM submarine_pages_body t0 WHERE t0.id = 2273;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Submarine\RedirectsBundle\Entity\Redirect	No errors.
Submarine\PagesBundle\Entity\Page	No errors.
Submarine\PagesBundle\Entity\Type\PageType	No errors.
Submarine\PagesBundle\Entity\PageBody	No errors.
Submarine\PagesBundle\Entity\Relations	No errors.
Submarine\PagesBundle\Entity\Type\PageValue	No errors.
Submarine\PagesBundle\Entity\Link	No errors.
Submarine\FilterManagerBundle\Entity\FilterTypeRelation	No errors.
Submarine\FilterManagerBundle\Entity\FilterType	No errors.
Submarine\PropertiesBundle\Entity\Property	No errors.
Submarine\FilterManagerBundle\Entity\Index\IndexItem	No errors.
Submarine\PropertiesBundle\Entity\PropertyValue	No errors.
Submarine\PropertiesBundle\Entity\Group	No errors.
Submarine\PagesBundle\Entity\Type\PageTypeField	No errors.

Symfony Profiler

GET http://ssl.nikos-archive.org/svarochnye-materialy/svarochnaya-provoloka/alyuminievaya-svarochnaya-provoloka

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping