Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.44 ms
(79.61%)
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
  475335
  497693
  505137
  514941
  519722
  522639
  528034
  533618
  534114
  535438
  536242
  541322
  542142
  543866
  545411
  545459
  546202
  548854
  550919
  550922
  558398
  559294
  568068
  574377
  579281
  580188
  580189
  590101
  593079
  593116
  594053
  594143
  594409
  595145
  595434
  595860
  596610
  598310
  600144
  601367
  602808
  604412
  609888
  609920
  612779
  614967
  615983
  618364
  623154
  628111
  632311
  633755
  634106
  634314
  636183
  637544
  641951
  642042
  643233
  647839
  648701
  656942
  660367
  673257
  674043
  674936
  679194
  679677
  691242
  695387
  696594
  696596
  696607
  708202
  711615
  711899
  713027
  713185
  720739
  722527
  725038
  726292
  729337
  735703
  737552
  738483
  740409
  740934
  741252
  741527
  744033
  745088
  745106
  750426
  752105
  752610
  752634
  752648
  752670
  754902
  756078
  761572
  762222
  767208
  770210
  770814
  771355
  782854
  785589
  785606
  786049
  786879
  787515
  791296
  792799
  800538
  806541
  808746
]
21.59 ms
(13.38%)
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
  519722
  528034
  533618
  534114
  535438
  497693
  505137
  514941
  522639
  536242
  475335
  545411
  550922
  574377
  580189
  541322
  545459
  548854
  550919
  558398
  559294
  568068
  580188
  542142
  543866
  579281
  647839
  648701
  656942
  660367
  679194
  695387
  711899
  713185
  674936
  696594
  696607
  708202
  673257
  674043
  679677
  691242
  696596
  711615
  713027
  720739
  722527
  546202
  593079
  594409
  595860
  634106
  636183
  641951
  642042
  594053
  594372
  595434
  604412
  612779
  615983
  634314
  643233
  593116
  598310
  601367
  609920
  614967
  618364
  623154
  632311
  633755
  637544
  590101
  594143
  595145
  596610
  600144
  602808
  609888
  628111
  785589
  786049
  786879
  791296
  782849
  782854
  800538
  725038
  726292
  740934
  741527
  744033
  752610
  756078
  761572
  762222
  767208
  770814
  785606
  787515
  792799
  806541
  808746
  729337
  740409
  750426
  738483
  741252
  745088
  745106
  735703
  737552
  752105
  770210
  771355
  752634
  752648
  752670
  754902
]
4.28 ms
(2.65%)
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
  475335
  497693
  505137
  514941
  519722
  522639
  528034
  533618
  534114
  535438
  536242
  541322
  542142
  543866
  545411
  545459
  546202
  548854
  550919
  550922
  558398
  559294
  568068
  574377
  579281
  580188
  580189
  590101
  593079
  593116
  594053
  594143
  594409
  595145
  595434
  595860
  596610
  598310
  600144
  601367
  602808
  604412
  609888
  609920
  612779
  614967
  615983
  618364
  623154
  628111
  632311
  633755
  634106
  634314
  636183
  637544
  641951
  642042
  643233
  647839
  648701
  656942
  660367
  673257
  674043
  674936
  679194
  679677
  691242
  695387
  696594
  696596
  696607
  708202
  711615
  711899
  713027
  713185
  720739
  722527
  725038
  726292
  729337
  735703
  737552
  738483
  740409
  740934
  741252
  741527
  744033
  745088
  745106
  750426
  752105
  752610
  752634
  752648
  752670
  754902
  756078
  761572
  762222
  767208
  770210
  770814
  771355
  782854
  785589
  785606
  786049
  786879
  787515
  791296
  792799
  800538
  806541
  808746
]
2.06 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen huge"
]
1.78 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen огромные"
]
1.51 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen огромные"
]

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.