Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.71 ms
(82.33%)
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
  391926
  397656
  398354
  400023
  400689
  428177
  428305
  432735
  435386
  437999
  439475
  441113
  443170
  445711
  447789
  454535
  464705
  464837
  465172
  465252
  465923
  466591
  468348
  468393
  468438
  469760
  472324
  473784
  474737
  477597
  478073
  489014
  493610
  494438
  497507
  498751
  513219
  513394
  523541
  528315
  528380
  528489
  534432
  541727
  544976
  545366
  555170
  561008
  573270
  577912
  578298
  580595
  583597
  588014
  589472
  590802
  591259
  595459
  596738
  603313
  604338
  604421
  605437
  618908
  620259
  623303
  624484
  624578
  630289
  648393
  649516
  652683
  656498
  659387
  666374
  678909
  693897
  706359
  710418
  710510
  712553
  712770
  720099
  720126
  720174
  720417
  720664
  723131
  723153
  724614
  729090
  729299
  729962
  732262
  734324
  750317
  751424
  751433
  761189
  763515
  777003
  782602
  786178
  788079
  788852
  788911
  789075
  790126
  790542
  791885
  792171
  796132
  800896
  802049
  804309
  813861
  814457
  817273
  825876
  826934
]
19.31 ms
(11.06%)
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
  466591
  497507
  814457
  555170
  712770
  790542
  800896
  469760
  817273
  710510
  723153
  561008
  734324
  763515
  782602
  428305
  624484
  583597
  652683
  603313
  618908
  623303
  720664
  534432
  590802
  604338
  591259
  630289
  541727
  706359
  596738
  777003
  447789
  580595
  624578
  826934
  825876
  498751
  710418
  720126
  595459
  790126
  791885
  729962
  729299
  724614
  729090
  751433
  712553
  788079
  398354
  588014
  464837
  573270
  656498
  545366
  788852
  391926
  472324
  513394
  397656
  751424
  465172
  528315
  464705
  489014
  589472
  620259
  796132
  732262
  804309
  720174
  437999
  474737
  443170
  468438
  478073
  493610
  513219
  578298
  648393
  659387
  544976
  432735
  428177
  441113
  454535
  468348
  465923
  494438
  577912
  720099
  720417
  723131
  649516
  605437
  788911
  750317
  792171
  400023
  400689
  445711
  435386
  473784
  468393
  528489
  666374
  693897
  523541
  604421
  761189
  439475
  465252
  477597
  802049
  786178
  528380
  813861
  789075
  678909
]
4.17 ms
(2.39%)
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
  391926
  397656
  398354
  400023
  400689
  428177
  428305
  432735
  435386
  437999
  439475
  441113
  443170
  445711
  447789
  454535
  464705
  464837
  465172
  465252
  465923
  466591
  468348
  468393
  468438
  469760
  472324
  473784
  474737
  477597
  478073
  489014
  493610
  494438
  497507
  498751
  513219
  513394
  523541
  528315
  528380
  528489
  534432
  541727
  544976
  545366
  555170
  561008
  573270
  577912
  578298
  580595
  583597
  588014
  589472
  590802
  591259
  595459
  596738
  603313
  604338
  604421
  605437
  618908
  620259
  623303
  624484
  624578
  630289
  648393
  649516
  652683
  656498
  659387
  666374
  678909
  693897
  706359
  710418
  710510
  712553
  712770
  720099
  720126
  720174
  720417
  720664
  723131
  723153
  724614
  729090
  729299
  729962
  732262
  734324
  750317
  751424
  751433
  761189
  763515
  777003
  782602
  786178
  788079
  788852
  788911
  789075
  790126
  790542
  791885
  792171
  796132
  800896
  802049
  804309
  813861
  814457
  817273
  825876
  826934
]
2.24 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard amateur anal"
]
2.03 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard любительск анал"
]
1.58 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard любительск анал"
]
1.51 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.