GET http://owa.nikos-archive.org/svarochnyy-apparat/argonovaya-svarka-tig

Query Metrics

58 Database Queries
18 Different statements
52.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.41 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/argonovaya-svarka-tig"
]
2 0.28 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
  "home"
]
3 0.17 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:
[
  20
]
4 0.22 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
]
5 0.16 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
]
6 0.19 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = ?
Parameters:
[
  8
]
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:
[
  8
]
8 1.82 ms
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23, s0_.type_id AS type_id_24, s0_.body_id AS body_id_25 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = ? AND s0_.is_deleted = ? AND s0_.type_id IN (?) AND s1_.parent_id = ? ORDER BY s1_.position ASC, s0_.title DESC
Parameters:
[
  1
  0
  "catalogGroup"
  20
]
9 0.30 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s1_.id AS id_2, s1_.widget_type AS widget_type_3, s1_.field_type AS field_type_4, s1_.field_name AS field_name_5, s1_.name AS name_6, s1_.title AS title_7, s1_.description AS description_8, s0_.page_id AS page_id_9, s0_.filter_item_id AS filter_item_id_10, s1_.property_id AS property_id_11 FROM submarine_filter_manager_type_relations s0_ INNER JOIN submarine_filter_manager_types s1_ ON s0_.filter_item_id = s1_.id WHERE s0_.page_id = ? ORDER BY s0_.position ASC
Parameters:
[
  20
]
10 1.05 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"
  20
]
11 0.66 ms
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
Parameters:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  1
]
12 2.41 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:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  "manufacturer"
]
13 0.25 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"
  "4419"
  "4458"
  "55"
  "5571"
  "6065"
]
14 0.48 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"
  20
]
15 0.57 ms
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
Parameters:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  1
]
16 1.25 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:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  "property_539"
]
17 0.44 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"
  20
]
18 0.51 ms
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
Parameters:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  1
]
19 1.06 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:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  "property_578"
]
20 0.43 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"
  20
]
21 0.52 ms
SELECT s0_.id AS id_0 FROM submarine_pages s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.is_enabled = ?
Parameters:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  1
]
22 1.22 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:
[
  2360
  2919
  2924
  2925
  2926
  2931
  2933
  3531
  3578
  3782
  3783
  3784
  3801
  3802
  4459
  4460
  4467
  4473
  4560
  4659
  4660
  4662
  5071
  5326
  5327
  5328
  5329
  5330
  5331
  5332
  5333
  5335
  5336
  5337
  5362
  5363
  5364
  5365
  5366
  5367
  5597
  5598
  5599
  5600
  5601
  5602
  5603
  5604
  5605
  5606
  5677
  5678
  5679
  5738
  5739
  5740
  5741
  5742
  5883
  5884
  5885
  5886
  5887
  5888
  5889
  5890
  5891
  5892
  5893
  5894
  5895
  5896
  6056
  6113
  6117
  6118
  6119
  6120
  6121
  6122
  6123
  6139
  6157
  6158
  6159
  6160
  6223
  6224
  6225
  6226
  6227
  6228
  6229
  6230
  6231
  6232
  6233
  6234
  6235
  6236
  6237
  6239
  6240
  6241
  6242
  6243
  6876
  6877
  6878
  6884
  "property_585"
]
23 1.18 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"
  20
  "price"
]
24 1.21 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"
  20
  "property_543"
]
25 4.26 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = ? AND s0_.is_deleted = ? AND s0_.type_id IN (?) AND s1_.parent_id = ? ORDER BY s1_.position ASC, s0_.title DESC) dctrn_result) dctrn_table
Parameters:
[
  1
  0
  "product"
  20
]
26 2.79 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_25, title_4 FROM (SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23, s1_.id AS id_24, s1_.position AS position_25 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = ? AND s0_.is_deleted = ? AND s0_.type_id IN (?) AND s1_.parent_id = ?) dctrn_result_inner ORDER BY position_25 ASC, title_4 DESC) dctrn_result LIMIT 18
Parameters:
[
  1
  0
  "product"
  20
]
27 1.18 ms
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23, s0_.type_id AS type_id_24, s0_.body_id AS body_id_25 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = ? AND s0_.is_deleted = ? AND s0_.type_id IN (?) AND s1_.parent_id = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s1_.position ASC, s0_.title DESC
Parameters:
[
  1
  0
  "product"
  20
  5365
  3784
  4459
  5895
  4660
  3531
  5597
  6229
  6121
  6227
  6157
  6119
  5740
  6224
  2931
  5336
  5885
  4560
]
28 0.87 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  5365
]
29 0.24 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = ?
Parameters:
[
  4458
]
30 0.95 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"
  3784
]
31 0.19 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = ?
Parameters:
[
  55
]
32 0.85 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"
  4459
]
33 1.11 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"
  5895
]
34 0.22 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:
[
  2512
]
35 0.85 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"
  4660
]
36 0.90 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  3531
]
37 0.19 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = ?
Parameters:
[
  19
]
38 0.77 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  5597
]
39 0.19 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.id = ?
Parameters:
[
  5571
]
40 0.91 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"
  6229
]
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:
[
  2955
]
42 0.79 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  6121
]
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.id = ?
Parameters:
[
  6065
]
44 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"
  6227
]
45 0.90 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  6157
]
46 0.81 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"
  6119
]
47 0.95 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"
  5740
]
48 1.12 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:
[
  3047
]
49 0.85 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"
  6224
]
50 0.91 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"
  2931
]
51 0.73 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  5336
]
52 0.90 ms
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  5885
]
53 0.78 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"
  4560
]
54 1.28 ms
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.tag AS tag_2, s0_.is_directory AS is_directory_3, s0_.title AS title_4, s0_.description AS description_5, s0_.is_deleted AS is_deleted_6, s0_.is_enabled AS is_enabled_7, s0_.html_title AS html_title_8, s0_.html_meta_description AS html_meta_description_9, s0_.html_meta_keywords AS html_meta_keywords_10, s0_.cached_values AS cached_values_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.published_at AS published_at_14, s0_.image_path AS image_path_15, s0_.countComments AS countComments_16, s0_.allowedComments AS allowedComments_17, s0_.moderatedComments AS moderatedComments_18, s0_.moy_sklad_update_errors AS moy_sklad_update_errors_19, s0_.price AS price_20, s0_.product_id AS product_id_21, s0_.is_available AS is_available_22, s0_.is_discount AS is_discount_23, s0_.type_id AS type_id_24, s0_.body_id AS body_id_25 FROM submarine_pages s0_ INNER JOIN submarine_pages_relations s1_ ON s0_.id = s1_.page_id LEFT JOIN submarine_pages_body s2_ ON s0_.body_id = s2_.id WHERE s0_.is_enabled = ? AND s0_.is_deleted = ? AND s0_.type_id IN (?) AND s1_.parent_id = ? ORDER BY s1_.position ASC, s0_.title DESC
Parameters:
[
  1
  0
  "catalogSeoGroup"
  20
]
55 3.42 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"
]
56 0.28 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.countComments AS countComments_17, t0.allowedComments AS allowedComments_18, t0.moderatedComments AS moderatedComments_19, t0.moy_sklad_update_errors AS moy_sklad_update_errors_20, t0.price AS price_21, t0.product_id AS product_id_22, t0.is_available AS is_available_23, t0.is_discount AS is_discount_24, t0.type_id AS type_id_25, t0.body_id AS body_id_26 FROM submarine_pages t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
  "catalog"
]
57 0.42 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:
[
  20
]
58 3.19 ms
SELECT t0.id AS id_1, t0.body AS body_2 FROM submarine_pages_body t0 WHERE t0.id = ?
Parameters:
[
  20
]

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.