Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.36 ms
(87.10%)
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
  13646
  389700
  394648
  421166
  426399
  429900
  429958
  438316
  446373
  446446
  451337
  452253
  454180
  454568
  458391
  460804
  464815
  465429
  468241
  474847
  478215
  486126
  487342
  489210
  500292
  501557
  508778
  510948
  513214
  514240
  514927
  515464
  522797
  523196
  525302
  526228
  530142
  534548
  537091
  539326
  545294
  553277
  554490
  555988
  556899
  559289
  562418
  567321
  568261
  569575
  572535
  574023
  581873
  584029
  585358
  589680
  592993
  593540
  594110
  596235
  596796
  596927
  598189
  598899
  603772
  604631
  607716
  610039
  614829
  615741
  618410
  619703
  620260
  623284
  623684
  632121
  642481
  658784
  660400
  663353
  663987
  669057
  670367
  670372
  671043
  671049
  685843
  695691
  697628
  702352
  705451
  715420
  716201
  716543
  721992
  727455
  729696
  735998
  741688
  741739
  741749
  757492
  758792
  760079
  765657
  770200
  770610
  772714
  772717
  780653
  781309
  786873
  795420
  796816
  796999
  800473
  802742
  803543
  819410
  825751
]
15.68 ms
(7.66%)
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
  632121
  446373
  508778
  594110
  760079
  474847
  537091
  523196
  623284
  596927
  465429
  501557
  695691
  780653
  796816
  770200
  741688
  741739
  741749
  464815
  438316
  581873
  553277
  802742
  614829
  513214
  562418
  394648
  596796
  795420
  598189
  574023
  615741
  452253
  13646
  522797
  526228
  569575
  592993
  478215
  454568
  702352
  593540
  607716
  454180
  554490
  796999
  446446
  642481
  781309
  735998
  572535
  596235
  421166
  468241
  555988
  584029
  598899
  604631
  429958
  460804
  500292
  525302
  486126
  515464
  514927
  487342
  451337
  716201
  567321
  458391
  514240
  619703
  426399
  429900
  618410
  623684
  585358
  610039
  819410
  539326
  530142
  534548
  545294
  559289
  556899
  658784
  671049
  705451
  660400
  663353
  715420
  663987
  685843
  568261
  603772
  620260
  786873
  727455
  772714
  800473
  803543
  729696
  770610
  772717
  757492
  765657
  697628
  389700
  825751
  489210
  510948
  670367
  671043
  716543
  670372
  721992
  669057
  589680
  758792
]
2.78 ms
(1.36%)
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
  13646
  389700
  394648
  421166
  426399
  429900
  429958
  438316
  446373
  446446
  451337
  452253
  454180
  454568
  458391
  460804
  464815
  465429
  468241
  474847
  478215
  486126
  487342
  489210
  500292
  501557
  508778
  510948
  513214
  514240
  514927
  515464
  522797
  523196
  525302
  526228
  530142
  534548
  537091
  539326
  545294
  553277
  554490
  555988
  556899
  559289
  562418
  567321
  568261
  569575
  572535
  574023
  581873
  584029
  585358
  589680
  592993
  593540
  594110
  596235
  596796
  596927
  598189
  598899
  603772
  604631
  607716
  610039
  614829
  615741
  618410
  619703
  620260
  623284
  623684
  632121
  642481
  658784
  660400
  663353
  663987
  669057
  670367
  670372
  671043
  671049
  685843
  695691
  697628
  702352
  705451
  715420
  716201
  716543
  721992
  727455
  729696
  735998
  741688
  741739
  741749
  757492
  758792
  760079
  765657
  770200
  770610
  772714
  772717
  780653
  781309
  786873
  795420
  796816
  796999
  800473
  802742
  803543
  819410
  825751
]
2.23 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мастурбация зрелой в чулках"
]
2.12 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац зрелая женщин чулк нижн бел"
]
1.79 ms
(0.87%)
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.