Query Metrics

7 Database Queries
7 Different statements
361.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
212.34 ms
(58.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижет под платьем"
]
122.43 ms
(33.85%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  7389
  181420
  233365
  387175
  388101
  388769
  395812
  400410
  403425
  409048
  410352
  411372
  411389
  420416
  426000
  426125
  429135
  429255
  440581
  443661
  443997
  447259
  450577
  455758
  455852
  456327
  458199
  459593
  461451
  461505
  462307
  465513
  466155
  466196
  466380
  467311
  467350
  468109
  469288
  469906
  470949
  470965
  470968
  473169
  474736
  477996
  479181
  479923
  483242
  483708
  484026
  484103
  484603
  485362
  486893
  487077
  487082
  488588
  489330
  490407
  490793
  490903
  491960
  491971
  491998
  493043
  496971
  497553
  498918
  498940
  502002
  503431
  504567
  508838
  510103
  511704
  511746
  513477
  515763
  519231
  521473
  522619
  522859
  523700
  524454
  524694
  527755
  529175
  540294
  547814
  553129
  556664
  559184
  561114
  568053
  569960
  570736
  570743
  573733
  575756
  581656
  581852
  582804
  590526
  591792
  598122
  600985
  603168
  603259
  603736
  606791
  613839
  615525
  621314
  624155
  627744
  675435
  676162
  678764
  679387
]
19.51 ms
(5.39%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  466155
  467350
  468109
  479181
  7389
  181420
  388101
  400410
  411372
  411389
  426000
  461505
  465513
  477996
  479923
  233365
  387175
  388769
  409048
  426125
  429135
  447259
  456327
  461451
  470965
  474736
  443997
  455758
  459593
  466196
  466380
  467311
  469906
  502002
  511746
  521473
  523700
  483708
  484103
  484603
  486893
  490903
  491960
  493043
  496971
  511704
  524454
  485362
  498918
  498940
  524694
  483242
  484026
  487077
  487082
  488588
  490793
  491971
  491998
  504567
  420416
  429255
  443661
  410352
  470949
  469288
  473169
  510103
  515763
  497553
  519231
  527755
  529175
  489330
  547814
  569960
  570743
  581656
  581852
  575756
  679387
  676162
  678764
  561114
  570736
  573733
  600985
  615525
  603168
  624155
  606791
  627744
  621314
  395812
  462307
  403425
  440581
  458199
  450577
  455852
  522859
  490407
  513477
  522619
  508838
  503431
  540294
  556664
  568053
  559184
  582804
  675435
  553129
  591792
  598122
  603259
  603736
  590526
  613839
  470968
]
2.90 ms
(0.80%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  7389
  181420
  233365
  387175
  388101
  388769
  395812
  400410
  403425
  409048
  410352
  411372
  411389
  420416
  426000
  426125
  429135
  429255
  440581
  443661
  443997
  447259
  450577
  455758
  455852
  456327
  458199
  459593
  461451
  461505
  462307
  465513
  466155
  466196
  466380
  467311
  467350
  468109
  469288
  469906
  470949
  470965
  470968
  473169
  474736
  477996
  479181
  479923
  483242
  483708
  484026
  484103
  484603
  485362
  486893
  487077
  487082
  488588
  489330
  490407
  490793
  490903
  491960
  491971
  491998
  493043
  496971
  497553
  498918
  498940
  502002
  503431
  504567
  508838
  510103
  511704
  511746
  513477
  515763
  519231
  521473
  522619
  522859
  523700
  524454
  524694
  527755
  529175
  540294
  547814
  553129
  556664
  559184
  561114
  568053
  569960
  570736
  570743
  573733
  575756
  581656
  581852
  582804
  590526
  591792
  598122
  600985
  603168
  603259
  603736
  606791
  613839
  615525
  621314
  624155
  627744
  675435
  676162
  678764
  679387
]
1.68 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза плат"
]
1.61 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.20 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза плат"
]

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

No loaded entities.