Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.33 ms
(88.82%)
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
  38068
  142773
  238809
  383902
  385751
  391247
  391689
  393338
  397122
  405272
  408998
  414004
  416123
  425711
  426406
  438877
  446344
  447004
  449809
  451890
  453327
  454925
  454944
  465629
  467163
  468705
  469351
  471836
  473037
  474984
  515096
  520003
  520809
  522927
  528825
  529105
  535540
  544345
  548091
  549129
  561351
  575197
  576393
  579521
  591708
  603516
  604064
  610643
  613643
  620779
  626308
  628358
  643415
  646776
  648118
  649919
  650993
  661312
  663550
  671729
  674891
  676759
  696168
  699670
  709406
  710989
  713945
  720405
  724185
  727414
  735682
  737357
  739482
  742142
  743327
  744135
  752196
  752966
  752974
  758033
  760529
  760733
  768338
  771506
  774736
  779382
  781934
  783259
  786812
  789195
  789424
  791308
  793507
  797613
  798719
  804283
  805019
  805140
  806980
  807794
  808508
  815059
  816036
  817780
  819122
  819152
  819465
  819515
  819637
  819646
  821009
  821489
  821546
  822136
  822229
  822421
  822768
  823383
  824887
  825537
]
11.74 ms
(5.98%)
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
  579521
  650993
  709406
  628358
  781934
  789195
  743327
  760529
  797613
  807794
  742142
  752966
  735682
  774736
  793507
  676759
  591708
  752974
  786812
  393338
  426406
  643415
  391247
  405272
  819637
  825537
  822768
  515096
  549129
  671729
  674891
  661312
  663550
  804283
  744135
  710989
  528825
  620779
  238809
  425711
  819515
  469351
  474984
  453327
  451890
  438877
  383902
  414004
  416123
  454944
  522927
  535540
  473037
  467163
  561351
  576393
  520003
  789424
  575197
  446344
  447004
  454925
  449809
  529105
  408998
  471836
  468705
  391689
  397122
  142773
  385751
  38068
  819646
  815059
  819122
  821489
  822229
  823383
  544345
  699670
  648118
  720405
  603516
  604064
  610643
  613643
  779382
  760733
  783259
  737357
  724185
  739482
  752196
  771506
  626308
  806980
  520809
  548091
  758033
  646776
  817780
  822136
  819465
  822421
  824887
  816036
  819152
  821009
  821546
  465629
  696168
  713945
  649919
  791308
  805140
  798719
  805019
  768338
  808508
  727414
]
2.59 ms
(1.32%)
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
  38068
  142773
  238809
  383902
  385751
  391247
  391689
  393338
  397122
  405272
  408998
  414004
  416123
  425711
  426406
  438877
  446344
  447004
  449809
  451890
  453327
  454925
  454944
  465629
  467163
  468705
  469351
  471836
  473037
  474984
  515096
  520003
  520809
  522927
  528825
  529105
  535540
  544345
  548091
  549129
  561351
  575197
  576393
  579521
  591708
  603516
  604064
  610643
  613643
  620779
  626308
  628358
  643415
  646776
  648118
  649919
  650993
  661312
  663550
  671729
  674891
  676759
  696168
  699670
  709406
  710989
  713945
  720405
  724185
  727414
  735682
  737357
  739482
  742142
  743327
  744135
  752196
  752966
  752974
  758033
  760529
  760733
  768338
  771506
  774736
  779382
  781934
  783259
  786812
  789195
  789424
  791308
  793507
  797613
  798719
  804283
  805019
  805140
  806980
  807794
  808508
  815059
  816036
  817780
  819122
  819152
  819465
  819515
  819637
  819646
  821009
  821489
  821546
  822136
  822229
  822421
  822768
  823383
  824887
  825537
]
2.31 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девушки в бассейн порно"
]
1.92 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк бассейн порн"
]
1.52 ms
(0.77%)
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.