Symfony Profiler

Query Metrics

45 Database Queries

21 Different statements

41.61 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 t0.id AS id_1, t0.value AS value_2, t0.page_id AS page_id_3, t0.field_id AS field_id_4, t0.type_id AS type_id_5 FROM submarine_pages_values t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = ? AND t0.type_id = ?
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 ORDER BY s0_.value ASC
SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ?) AND s0_.name = ?
SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ?) AND s0_.name = ?
SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ?) AND s0_.name = ?
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_.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_.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 t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = ? AND t0.type_id = ?
SELECT COUNT(s0_.page_id) AS sclr_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) INNER JOIN submarine_filter_manager_index s2_ ON (s0_.page_id = s2_.page_id) INNER JOIN submarine_filter_manager_index s3_ ON (s0_.page_id = s3_.page_id) INNER JOIN submarine_filter_manager_index s4_ ON (s0_.page_id = s4_.page_id) INNER JOIN submarine_filter_manager_index s5_ ON (s0_.page_id = s5_.page_id) WHERE (s0_.name = ? AND s0_.value_number = ?) AND (s1_.name = ? AND (s1_.value IN (?) OR s1_.value_number IN (?))) AND (s2_.name = ? AND s2_.value_number <= ?) AND (s3_.name = ? AND s3_.value_number >= ? AND s3_.value_number <= ?) AND (s4_.name = ? AND s4_.value_number >= ? AND s4_.value_number <= ?) AND (s5_.name = ? AND (s5_.value IN (?) OR s5_.value_number IN (?)))
SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) WHERE (s0_.name = ? AND s0_.value_number = ?) AND (s1_.name = ? AND (s1_.value IN (?) OR s1_.value_number IN (?)))
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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (?) AND s2_.id = ? ORDER BY s0_.price ASC) dctrn_result) dctrn_table
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_20 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_.title AS title_25, s1_.description AS description_26, s1_.value_type AS value_type_27, s1_.value_default AS value_default_28, s1_.values_choices AS values_choices_29, s1_.item_group_id AS item_group_id_30, s1_.position AS position_31, s1_.type_id AS type_id_32 FROM submarine_pages s0_ INNER JOIN submarine_pages_values s2_ ON s0_.id = s2_.page_id INNER JOIN submarine_pages_type_fields s1_ ON s2_.field_id = s1_.id AND s2_.type_id = s1_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (?) AND s1_.id = ?) dctrn_result_inner ORDER BY price_20 ASC) 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (?) AND s2_.id = ? AND s0_.id IN (?) ORDER BY s0_.price 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 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_.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.48 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: [`"/svarochnyy-apparat/svarochnyy-invertor/ewm"`] 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 = '/svarochnyy-apparat/svarochnyy-invertor/ewm' LIMIT 1;
2	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.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: [`4075`] 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 = 4075;
4	0.20 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: [`11`] 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 = 11;
5	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: [`11`] 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 = 11;
6	0.17 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: [`9`] 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 = 9;
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: [`9`] 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 = 9;
8	0.15 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.13 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	0.59 ms	SELECT t0.id AS id_1, t0.value AS value_2, t0.page_id AS page_id_3, t0.field_id AS field_id_4, t0.type_id AS type_id_5 FROM submarine_pages_values t0 WHERE t0.page_id = ? Parameters: [`4075`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.page_id AS page_id_3, t0.field_id AS field_id_4, t0.type_id AS type_id_5 FROM submarine_pages_values t0 WHERE t0.page_id = ? SELECT t0.id AS id_1, t0.value AS value_2, t0.page_id AS page_id_3, t0.field_id AS field_id_4, t0.type_id AS type_id_5 FROM submarine_pages_values t0 WHERE t0.page_id = 4075;
11	0.22 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = ? AND t0.type_id = ? Parameters: [`"filtered_field_name" "catalogSeoGroup"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = ? AND t0.type_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = 'filtered_field_name' AND t0.type_id = 'catalogSeoGroup';
12	0.43 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: [`11`] 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 = 11 ORDER BY s0_.position ASC;
13	1.73 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" 11`] 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 = 11;
14	1.79 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.is_enabled = 1;
15	3.59 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: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 "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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.name = 'manufacturer' GROUP BY s0_.value ORDER BY s0_.value ASC;
16	0.28 ms	SELECT s0_.id AS id_0, s0_.title AS title_1 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"19" "2470" "2512" "2955" "3047" "3099" "3115" "4419" "4458" "55" "5571" "6065"`] 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 ('19', '2470', '2512', '2955', '3047', '3099', '3115', '4419', '4458', '55', '5571', '6065');
17	0.60 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" 11`] 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 = 11;
18	0.80 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.is_enabled = 1;
19	3.01 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: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 "property_539"] 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.name = 'property_539' GROUP BY s0_.value ORDER BY s0_.value ASC;
20	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" 11`] 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 = 11;
21	0.72 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.is_enabled = 1;
22	0.88 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: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 "property_555"] 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.name = 'property_555' GROUP BY s0_.value ORDER BY s0_.value ASC;
23	2.05 ms	SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ?) AND s0_.name = ? Parameters: [`"category_id" 11 "price"`] View formatted query View runnable query Explain query SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN ( SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ? ) AND s0_.name = ? SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = 'category_id' AND s1_.value_number = 11) AND s0_.name = 'price';
24	1.71 ms	SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ?) AND s0_.name = ? Parameters: [`"category_id" 11 "property_543"`] View formatted query View runnable query Explain query SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN ( SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ? ) AND s0_.name = ? SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = 'category_id' AND s1_.value_number = 11) AND s0_.name = 'property_543';
25	1.58 ms	SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ?) AND s0_.name = ? Parameters: [`"category_id" 11 "property_542"`] View formatted query View runnable query Explain query SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN ( SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = ? AND s1_.value_number = ? ) AND s0_.name = ? SELECT MIN(s0_.value_number) AS sclr_0, MAX(s0_.value_number) AS sclr_1 FROM submarine_filter_manager_index s0_ WHERE s0_.page_id IN (SELECT s1_.page_id FROM submarine_filter_manager_index s1_ WHERE s1_.name = 'category_id' AND s1_.value_number = 11) AND s0_.name = 'property_542';
26	0.26 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: [`11`] 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 = 11 ORDER BY s0_.position ASC;
27	0.71 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" 11`] 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 = 11;
28	0.75 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.is_enabled = 1;
29	0.21 ms	SELECT s0_.id AS id_0, s0_.title AS title_1 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"19" "2470" "2512" "2955" "3047" "3099" "3115" "4419" "4458" "55" "5571" "6065"`] 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 ('19', '2470', '2512', '2955', '3047', '3099', '3115', '4419', '4458', '55', '5571', '6065');
30	0.50 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" 11`] 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 = 11;
31	0.76 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.is_enabled = 1;
32	0.50 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" 11`] 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 = 11;
33	0.69 ms	SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ? Parameters: [2344 2345 2350 2494 2495 2496 3077 3079 3083 3091 3092 3093 3094 3095 3096 3097 3098 3119 3253 3540 3541 3542 3543 3559 3569 3718 3719 3720 3721 3722 3723 3726 3727 3728 3808 3809 3816 3845 4450 4451 4452 4456 4469 4470 4476 4477 4478 4479 4480 4481 4482 4483 4485 5070 5199 5281 5282 5283 5284 5285 5286 5287 5288 5289 5290 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5526 5561 5562 5563 5564 5565 5566 5645 5646 5647 5648 5649 5650 5651 5652 5708 5709 5710 5711 5712 5713 5714 5715 5716 5717 5718 5719 5720 5721 5722 5723 5820 5821 5822 5823 5824 5825 5826 5827 5828 5829 5830 5831 5832 5833 5834 5835 5836 5837 5838 5839 5840 5841 5842 5843 5844 5845 5846 5847 5848 6074 6075 6076 6077 6078 6079 6080 6081 6082 6083 6084 6085 6145 6146 6147 6148 6149 6150 6151 6152 6167 6168 6169 6170 6171 6172 6173 6174 6175 6176 6177 6178 6179 6180 6181 6182 6183 6184 6185 6186 6187 6188 6189 6824 6863 6864 6866 6867 6874 6875 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 (2344, 2345, 2350, 2494, 2495, 2496, 3077, 3079, 3083, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3098, 3119, 3253, 3540, 3541, 3542, 3543, 3559, 3569, 3718, 3719, 3720, 3721, 3722, 3723, 3726, 3727, 3728, 3808, 3809, 3816, 3845, 4450, 4451, 4452, 4456, 4469, 4470, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4485, 5070, 5199, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5288, 5289, 5290, 5338, 5339, 5340, 5341, 5342, 5343, 5344, 5345, 5346, 5347, 5348, 5526, 5561, 5562, 5563, 5564, 5565, 5566, 5645, 5646, 5647, 5648, 5649, 5650, 5651, 5652, 5708, 5709, 5710, 5711, 5712, 5713, 5714, 5715, 5716, 5717, 5718, 5719, 5720, 5721, 5722, 5723, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5831, 5832, 5833, 5834, 5835, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6824, 6863, 6864, 6866, 6867, 6874, 6875) AND s0_.is_enabled = 1;
34	0.21 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = ? AND t0.type_id = ? Parameters: [`"filtered_field_value" "catalogSeoGroup"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = ? AND t0.type_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.value_type AS value_type_4, t0.value_default AS value_default_5, t0.values_choices AS values_choices_6, t0.item_group_id AS item_group_id_7, t0.position AS position_8, t0.type_id AS type_id_9, t0.page_type_id AS page_type_id_10 FROM submarine_pages_type_fields t0 WHERE t0.id = 'filtered_field_value' AND t0.type_id = 'catalogSeoGroup';
35	1.76 ms	SELECT COUNT(s0_.page_id) AS sclr_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) INNER JOIN submarine_filter_manager_index s2_ ON (s0_.page_id = s2_.page_id) INNER JOIN submarine_filter_manager_index s3_ ON (s0_.page_id = s3_.page_id) INNER JOIN submarine_filter_manager_index s4_ ON (s0_.page_id = s4_.page_id) INNER JOIN submarine_filter_manager_index s5_ ON (s0_.page_id = s5_.page_id) WHERE (s0_.name = ? AND s0_.value_number = ?) AND (s1_.name = ? AND (s1_.value IN (?) OR s1_.value_number IN (?))) AND (s2_.name = ? AND s2_.value_number <= ?) AND (s3_.name = ? AND s3_.value_number >= ? AND s3_.value_number <= ?) AND (s4_.name = ? AND s4_.value_number >= ? AND s4_.value_number <= ?) AND (s5_.name = ? AND (s5_.value IN (?) OR s5_.value_number IN (?))) Parameters: [`"category_id" 11 "manufacturer" "3099" "3099" "price" 305118.0 "property_543" 140.0 1000.0 "property_542" 3.2 13.0 "property_555" "есть" "есть"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.page_id) AS sclr_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) INNER JOIN submarine_filter_manager_index s2_ ON (s0_.page_id = s2_.page_id) INNER JOIN submarine_filter_manager_index s3_ ON (s0_.page_id = s3_.page_id) INNER JOIN submarine_filter_manager_index s4_ ON (s0_.page_id = s4_.page_id) INNER JOIN submarine_filter_manager_index s5_ ON (s0_.page_id = s5_.page_id) WHERE ( s0_.name = ? AND s0_.value_number = ? ) AND ( s1_.name = ? AND ( s1_.value IN (?) OR s1_.value_number IN (?) ) ) AND ( s2_.name = ? AND s2_.value_number <= ? ) AND ( s3_.name = ? AND s3_.value_number >= ? AND s3_.value_number <= ? ) AND ( s4_.name = ? AND s4_.value_number >= ? AND s4_.value_number <= ? ) AND ( s5_.name = ? AND ( s5_.value IN (?) OR s5_.value_number IN (?) ) ) SELECT COUNT(s0_.page_id) AS sclr_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) INNER JOIN submarine_filter_manager_index s2_ ON (s0_.page_id = s2_.page_id) INNER JOIN submarine_filter_manager_index s3_ ON (s0_.page_id = s3_.page_id) INNER JOIN submarine_filter_manager_index s4_ ON (s0_.page_id = s4_.page_id) INNER JOIN submarine_filter_manager_index s5_ ON (s0_.page_id = s5_.page_id) WHERE (s0_.name = 'category_id' AND s0_.value_number = 11) AND (s1_.name = 'manufacturer' AND (s1_.value IN ('3099') OR s1_.value_number IN ('3099'))) AND (s2_.name = 'price' AND s2_.value_number <= 305118) AND (s3_.name = 'property_543' AND s3_.value_number >= 140 AND s3_.value_number <= 1000) AND (s4_.name = 'property_542' AND s4_.value_number >= 3.2 AND s4_.value_number <= 13) AND (s5_.name = 'property_555' AND (s5_.value IN ('есть') OR s5_.value_number IN ('есть')));
36	1.66 ms	SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) WHERE (s0_.name = ? AND s0_.value_number = ?) AND (s1_.name = ? AND (s1_.value IN (?) OR s1_.value_number IN (?))) Parameters: [`"category_id" 11 "manufacturer" "3099" "3099"`] View formatted query View runnable query Explain query SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) WHERE ( s0_.name = ? AND s0_.value_number = ? ) AND ( s1_.name = ? AND ( s1_.value IN (?) OR s1_.value_number IN (?) ) ) SELECT s0_.page_id AS page_id_0 FROM submarine_filter_manager_index s0_ INNER JOIN submarine_filter_manager_index s1_ ON (s0_.page_id = s1_.page_id) WHERE (s0_.name = 'category_id' AND s0_.value_number = 11) AND (s1_.name = 'manufacturer' AND (s1_.value IN ('3099') OR s1_.value_number IN ('3099')));
37	4.66 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (?) AND s2_.id = ? ORDER BY s0_.price ASC) dctrn_result) dctrn_table Parameters: [`3845 "product_availability"`] 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE ( s0_.is_enabled = 1 AND s0_.is_deleted = 0 ) AND s0_.id IN (?) AND s2_.id = ? ORDER BY s0_.price ASC ) 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (3845) AND s2_.id = 'product_availability' ORDER BY s0_.price ASC) dctrn_result) dctrn_table;
38	0.87 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_20 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_.title AS title_25, s1_.description AS description_26, s1_.value_type AS value_type_27, s1_.value_default AS value_default_28, s1_.values_choices AS values_choices_29, s1_.item_group_id AS item_group_id_30, s1_.position AS position_31, s1_.type_id AS type_id_32 FROM submarine_pages s0_ INNER JOIN submarine_pages_values s2_ ON s0_.id = s2_.page_id INNER JOIN submarine_pages_type_fields s1_ ON s2_.field_id = s1_.id AND s2_.type_id = s1_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (?) AND s1_.id = ?) dctrn_result_inner ORDER BY price_20 ASC) dctrn_result LIMIT 18 Parameters: [`3845 "product_availability"`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, price_20 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_.title AS title_25, s1_.description AS description_26, s1_.value_type AS value_type_27, s1_.value_default AS value_default_28, s1_.values_choices AS values_choices_29, s1_.item_group_id AS item_group_id_30, s1_.position AS position_31, s1_.type_id AS type_id_32 FROM submarine_pages s0_ INNER JOIN submarine_pages_values s2_ ON s0_.id = s2_.page_id INNER JOIN submarine_pages_type_fields s1_ ON s2_.field_id = s1_.id AND s2_.type_id = s1_.type_id WHERE ( s0_.is_enabled = 1 AND s0_.is_deleted = 0 ) AND s0_.id IN (?) AND s1_.id = ? ) dctrn_result_inner ORDER BY price_20 ASC ) dctrn_result LIMIT 18 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_20 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_.title AS title_25, s1_.description AS description_26, s1_.value_type AS value_type_27, s1_.value_default AS value_default_28, s1_.values_choices AS values_choices_29, s1_.item_group_id AS item_group_id_30, s1_.position AS position_31, s1_.type_id AS type_id_32 FROM submarine_pages s0_ INNER JOIN submarine_pages_values s2_ ON s0_.id = s2_.page_id INNER JOIN submarine_pages_type_fields s1_ ON s2_.field_id = s1_.id AND s2_.type_id = s1_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (3845) AND s1_.id = 'product_availability') dctrn_result_inner ORDER BY price_20 ASC) dctrn_result LIMIT 18;
39	0.41 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (?) AND s2_.id = ? AND s0_.id IN (?) ORDER BY s0_.price ASC Parameters: [`3845 "product_availability" 3845`] 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE ( s0_.is_enabled = 1 AND s0_.is_deleted = 0 ) AND s0_.id IN (?) AND s2_.id = ? AND s0_.id IN (?) ORDER BY s0_.price 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_values s1_ ON s0_.id = s1_.page_id INNER JOIN submarine_pages_type_fields s2_ ON s1_.field_id = s2_.id AND s1_.type_id = s2_.type_id WHERE (s0_.is_enabled = 1 AND s0_.is_deleted = 0) AND s0_.id IN (3845) AND s2_.id = 'product_availability' AND s0_.id IN (3845) ORDER BY s0_.price ASC;
40	0.92 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" 3845`] 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 = 3845 ORDER BY s2_.position ASC, s1_.position ASC;
41	0.20 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: [`3099`] 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 = 3099;
42	3.40 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;
43	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.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;
44	0.34 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: [`4075`] 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 = 4075 ORDER BY t0.position ASC;
45	0.22 ms	SELECT t0.id AS id_1, t0.body AS body_2 FROM submarine_pages_body t0 WHERE t0.id = ? Parameters: [`4075`] 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 = 4075;

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\PagesBundle\Entity\Type\PageTypeField	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.

Symfony Profiler

GET http://nikos-archive.org/svarochnyy-apparat/svarochnyy-invertor/ewm

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping