Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
343.78 ms
(92.70%)
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
  415286
  415863
  419587
  419625
  422805
  426944
  427457
  429086
  429124
  441536
  443004
  443107
  444041
  444399
  445324
  448255
  448993
  451813
  456571
  457045
  457282
  457684
  459896
  462331
  467854
  468049
  472094
  472119
  472792
  474826
  475232
  477395
  477831
  478267
  481725
  485048
  486862
  486875
  486941
  487239
  487749
  495847
  497160
  498765
  500175
  500186
  501033
  502470
  503693
  503702
  503863
  509009
  510881
  511543
  514020
  514744
  515137
  516619
  517790
  518587
  518596
  518975
  520701
  520747
  521971
  525985
  526586
  528884
  529194
  531197
  533807
  534575
  539116
  539147
  539662
  542760
  549699
  555120
  556715
  558204
  562106
  565720
  567425
  571824
  575133
  575441
  577572
  577815
  585300
  591418
  593618
  595011
  595751
  595863
  596069
  600193
  601027
  614065
  615829
  625378
  633818
  643079
  653941
  655590
  665984
  667647
  677020
  679863
  691797
  714927
  716882
  726550
  756585
  785421
  792488
  797437
  806804
  807589
  808044
  813250
]
17.12 ms
(4.62%)
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
  797437
  509009
  495847
  529194
  486862
  667647
  595011
  601027
  514744
  514020
  565720
  472119
  477395
  577815
  808044
  726550
  415286
  429086
  502470
  534575
  467854
  595751
  595863
  443004
  451813
  510881
  517790
  503693
  503863
  567425
  549699
  526586
  486875
  415863
  487239
  498765
  518587
  520747
  539116
  516619
  577572
  665984
  593618
  807589
  474826
  643079
  457045
  716882
  422805
  477831
  485048
  677020
  472792
  456571
  468049
  486941
  500175
  539147
  497160
  575441
  633818
  462331
  518596
  562106
  625378
  478267
  419587
  481725
  443107
  503702
  459896
  448993
  457684
  571824
  575133
  679863
  558204
  614065
  714927
  445324
  531197
  533807
  511543
  539662
  785421
  756585
  419625
  426944
  444041
  444399
  525985
  596069
  427457
  542760
  556715
  691797
  653941
  655590
  585300
  591418
  792488
  806804
  472094
  500186
  501033
  429124
  457282
  518975
  528884
  487749
  813250
  448255
  475232
  520701
  521971
  615829
  555120
  515137
  600193
  441536
]
3.15 ms
(0.85%)
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
  415286
  415863
  419587
  419625
  422805
  426944
  427457
  429086
  429124
  441536
  443004
  443107
  444041
  444399
  445324
  448255
  448993
  451813
  456571
  457045
  457282
  457684
  459896
  462331
  467854
  468049
  472094
  472119
  472792
  474826
  475232
  477395
  477831
  478267
  481725
  485048
  486862
  486875
  486941
  487239
  487749
  495847
  497160
  498765
  500175
  500186
  501033
  502470
  503693
  503702
  503863
  509009
  510881
  511543
  514020
  514744
  515137
  516619
  517790
  518587
  518596
  518975
  520701
  520747
  521971
  525985
  526586
  528884
  529194
  531197
  533807
  534575
  539116
  539147
  539662
  542760
  549699
  555120
  556715
  558204
  562106
  565720
  567425
  571824
  575133
  575441
  577572
  577815
  585300
  591418
  593618
  595011
  595751
  595863
  596069
  600193
  601027
  614065
  615829
  625378
  633818
  643079
  653941
  655590
  665984
  667647
  677020
  679863
  691797
  714927
  716882
  726550
  756585
  785421
  792488
  797437
  806804
  807589
  808044
  813250
]
2.15 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sucking big tits"
]
1.72 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sucking большие сиськ"
]
1.63 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sucking большие сиськ"
]

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.