Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.66 ms
(84.40%)
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
  390663
  422413
  424024
  434846
  436452
  436692
  443004
  443462
  445524
  450678
  452181
  456146
  458026
  458992
  460386
  473388
  478182
  479879
  482035
  489180
  490439
  493846
  494671
  494816
  495991
  497193
  526629
  531971
  538407
  540830
  548436
  558881
  561247
  561912
  563555
  564076
  567028
  568372
  573276
  581431
  584903
  585782
  588060
  588158
  591178
  599488
  600279
  603800
  607154
  608066
  616293
  617534
  625189
  626193
  631693
  635356
  636928
  642442
  650098
  659206
  661608
  661976
  662373
  669316
  670184
  674208
  675122
  679537
  688996
  691481
  693018
  695164
  722925
  733022
  737065
  741878
  754457
  761947
  762989
  763327
  764284
  764321
  764396
  766057
  768190
  769426
  772586
  772591
  772759
  779912
  779957
  780777
  781578
  781633
  782930
  782973
  784747
  785166
  786352
  787898
  790702
  791219
  792491
  793689
  793724
  797349
  798327
  798609
  801650
  802570
  802729
  805000
  805107
  805832
  809647
  809984
  810192
  811440
  813610
  814980
]
14.17 ms
(9.44%)
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
  785166
  786352
  793689
  733022
  754457
  762989
  769426
  772591
  781578
  782930
  761947
  772586
  766057
  737065
  763327
  779912
  781633
  787898
  802570
  424024
  473388
  661976
  688996
  458992
  445524
  811440
  482035
  458026
  479879
  497193
  493846
  607154
  531971
  495991
  538407
  625189
  591178
  792491
  443004
  548436
  585782
  631693
  642442
  588060
  805000
  772759
  779957
  768190
  456146
  617534
  443462
  561912
  563555
  805832
  460386
  561247
  802729
  805107
  764396
  798327
  626193
  600279
  584903
  741878
  422413
  526629
  659206
  661608
  693018
  599488
  603800
  722925
  782973
  436692
  764321
  489180
  588158
  636928
  813610
  814980
  669316
  784747
  780777
  791219
  764284
  390663
  436452
  478182
  793724
  650098
  608066
  810192
  568372
  670184
  674208
  675122
  662373
  691481
  635356
  616293
  450678
  573276
  809647
  679537
  790702
  798609
  494671
  564076
  558881
  434846
  452181
  695164
  540830
  490439
  494816
  567028
  581431
  797349
  801650
  809984
]
2.96 ms
(1.97%)
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
  390663
  422413
  424024
  434846
  436452
  436692
  443004
  443462
  445524
  450678
  452181
  456146
  458026
  458992
  460386
  473388
  478182
  479879
  482035
  489180
  490439
  493846
  494671
  494816
  495991
  497193
  526629
  531971
  538407
  540830
  548436
  558881
  561247
  561912
  563555
  564076
  567028
  568372
  573276
  581431
  584903
  585782
  588060
  588158
  591178
  599488
  600279
  603800
  607154
  608066
  616293
  617534
  625189
  626193
  631693
  635356
  636928
  642442
  650098
  659206
  661608
  661976
  662373
  669316
  670184
  674208
  675122
  679537
  688996
  691481
  693018
  695164
  722925
  733022
  737065
  741878
  754457
  761947
  762989
  763327
  764284
  764321
  764396
  766057
  768190
  769426
  772586
  772591
  772759
  779912
  779957
  780777
  781578
  781633
  782930
  782973
  784747
  785166
  786352
  787898
  790702
  791219
  792491
  793689
  793724
  797349
  798327
  798609
  801650
  802570
  802729
  805000
  805107
  805832
  809647
  809984
  810192
  811440
  813610
  814980
]
1.65 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov homemade deepthroat"
]
1.59 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов домашн любительск глубокийминет минет оральн секс"
]
1.56 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов домашн любительск глубокийминет минет оральн секс"
]
1.49 ms
(0.99%)
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.