Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.54 ms
(85.46%)
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
  326300
  420108
  422953
  426611
  429934
  445804
  446238
  456555
  461155
  466745
  468111
  486171
  486841
  490089
  492112
  510061
  511256
  511267
  514392
  526951
  530934
  536249
  545755
  546202
  548701
  550916
  558903
  558912
  566736
  566889
  575719
  581582
  591612
  592380
  594554
  605699
  607453
  609052
  610961
  612247
  620855
  622991
  625553
  626241
  626535
  626734
  628105
  634527
  634563
  641609
  643008
  666886
  667052
  675809
  683183
  686138
  690510
  695939
  698407
  700293
  700666
  703088
  711615
  712261
  716572
  716871
  718889
  720163
  720707
  721118
  722050
  724483
  730371
  741104
  742931
  744357
  744981
  745001
  747026
  751405
  751424
  752105
  754147
  758196
  761146
  761922
  763443
  763515
  766750
  766884
  769312
  769797
  769835
  770420
  770986
  771137
  776234
  778069
  780718
  784567
  790365
  790391
  791351
  792645
  795525
  799319
  800451
  800497
  800581
  800625
  805013
  805637
  806938
  814640
  817150
  819566
  821044
  821512
  824668
]
15.01 ms
(8.20%)
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
  536249
  461155
  566736
  446238
  429934
  511267
  666886
  581582
  634527
  634563
  780718
  700293
  492112
  545755
  819566
  814640
  821512
  824668
  548701
  550916
  558912
  686138
  700666
  703088
  718889
  720163
  675809
  716871
  695939
  622991
  641609
  607453
  620855
  626241
  626734
  776234
  790365
  800581
  800625
  790391
  800451
  805013
  742931
  745001
  747026
  769835
  771137
  730371
  744357
  761146
  770986
  763443
  770420
  751405
  761922
  766750
  643008
  799319
  445804
  594554
  591612
  420108
  751424
  326300
  490089
  510061
  511256
  486171
  558903
  575719
  667052
  690510
  605699
  592380
  617608
  625553
  778069
  724483
  766884
  426611
  486841
  514392
  526951
  422953
  817150
  821044
  530934
  466745
  720707
  721118
  683183
  698407
  711615
  546202
  566889
  610961
  612247
  628105
  626535
  609052
  784567
  800497
  791351
  795525
  806938
  744981
  754147
  769312
  769797
  741104
  752105
  758196
  763515
  712261
  716572
  722050
  792645
  805637
  468111
  456555
]
3.95 ms
(2.16%)
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
  326300
  420108
  422953
  426611
  429934
  445804
  446238
  456555
  461155
  466745
  468111
  486171
  486841
  490089
  492112
  510061
  511256
  511267
  514392
  526951
  530934
  536249
  545755
  546202
  548701
  550916
  558903
  558912
  566736
  566889
  575719
  581582
  591612
  592380
  594554
  605699
  607453
  609052
  610961
  612247
  620855
  622991
  625553
  626241
  626535
  626734
  628105
  634527
  634563
  641609
  643008
  666886
  667052
  675809
  683183
  686138
  690510
  695939
  698407
  700293
  700666
  703088
  711615
  712261
  716572
  716871
  718889
  720163
  720707
  721118
  722050
  724483
  730371
  741104
  742931
  744357
  744981
  745001
  747026
  751405
  751424
  752105
  754147
  758196
  761146
  761922
  763443
  763515
  766750
  766884
  769312
  769797
  769835
  770420
  770986
  771137
  776234
  778069
  780718
  784567
  790365
  790391
  791351
  792645
  795525
  799319
  800451
  800497
  800581
  800625
  805013
  805637
  806938
  814640
  817150
  819566
  821044
  821512
  824668
]
2.08 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy teen anal"
]
1.99 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy teen анал"
]
1.86 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy 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.