Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.43 ms
(78.30%)
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
  319841
  379578
  383224
  384811
  385538
  389442
  390082
  390702
  391968
  395729
  399415
  402564
  407586
  411116
  411336
  411675
  411910
  417018
  420249
  421343
  425195
  426006
  428410
  433823
  445846
  446783
  450821
  450844
  451797
  452130
  452240
  457102
  462567
  464278
  464544
  466918
  467880
  468484
  472216
  477683
  478063
  485955
  487608
  490881
  494222
  500689
  500692
  502062
  502108
  507947
  515074
  521235
  524355
  541373
  542876
  549230
  549240
  549326
  551017
  551946
  556008
  566007
  566537
  568553
  568562
  577553
  583464
  591288
  592555
  592945
  593431
  596409
  604581
  620145
  621682
  632450
  640692
  650957
  650983
  655864
  665187
  675968
  678996
  697229
  713045
  714981
  720050
  720264
  722516
  722521
  723527
  723966
  725613
  730559
  732181
  733266
  740806
  744994
  748478
  757526
  761525
  767560
  770325
  773754
  781971
  810655
  814178
  814374
  814387
  815226
  816068
  816562
  818462
  820346
  820658
  821064
  821598
  826642
  827206
  827648
]
22.83 ms
(15.09%)
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
  723966
  730559
  757526
  761525
  767560
  732181
  740806
  770325
  773754
  632450
  781971
  810655
  391968
  411116
  379578
  385538
  390702
  390082
  411910
  407586
  814374
  452130
  468484
  451797
  462567
  466918
  502062
  500692
  549230
  577553
  549240
  713045
  665187
  697229
  720050
  720264
  591288
  604581
  593431
  592945
  733266
  748478
  725613
  744994
  411336
  457102
  421343
  541373
  383224
  417018
  826642
  827648
  445846
  452240
  464278
  450821
  542876
  583464
  621682
  395729
  402564
  425195
  446783
  500689
  490881
  485955
  384811
  319841
  389442
  399415
  420249
  426006
  411675
  433823
  428410
  814178
  814387
  821064
  821598
  723527
  820658
  827206
  816562
  820346
  815226
  816068
  818462
  450844
  467880
  464544
  472216
  477683
  478063
  487608
  494222
  502108
  507947
  524355
  521235
  515074
  551946
  566007
  566537
  549326
  551017
  556008
  568553
  568562
  678996
  722521
  650957
  650983
  675968
  655864
  714981
  722516
  620145
  592555
  640692
  596409
]
2.75 ms
(1.82%)
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
  319841
  379578
  383224
  384811
  385538
  389442
  390082
  390702
  391968
  395729
  399415
  402564
  407586
  411116
  411336
  411675
  411910
  417018
  420249
  421343
  425195
  426006
  428410
  433823
  445846
  446783
  450821
  450844
  451797
  452130
  452240
  457102
  462567
  464278
  464544
  466918
  467880
  468484
  472216
  477683
  478063
  485955
  487608
  490881
  494222
  500689
  500692
  502062
  502108
  507947
  515074
  521235
  524355
  541373
  542876
  549230
  549240
  549326
  551017
  551946
  556008
  566007
  566537
  568553
  568562
  577553
  583464
  591288
  592555
  592945
  593431
  596409
  604581
  620145
  621682
  632450
  640692
  650957
  650983
  655864
  665187
  675968
  678996
  697229
  713045
  714981
  720050
  720264
  722516
  722521
  723527
  723966
  725613
  730559
  732181
  733266
  740806
  744994
  748478
  757526
  761525
  767560
  770325
  773754
  781971
  810655
  814178
  814374
  814387
  815226
  816068
  816562
  818462
  820346
  820658
  821064
  821598
  826642
  827206
  827648
]
2.07 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy licking"
]
1.89 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая лиза"
]
1.68 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.07%)
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.