Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.28 ms
(56.90%)
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
  404280
  412548
  414845
  417723
  426660
  426812
  433920
  438738
  440257
  441943
  443913
  446737
  450646
  450650
  455377
  458469
  461005
  463200
  464598
  467365
  468129
  468863
  469044
  470176
  470480
  472055
  474783
  475693
  475873
  482774
  482906
  484944
  485452
  488297
  488745
  488858
  490019
  490515
  490841
  491367
  492318
  502194
  503156
  505545
  507608
  515511
  516804
  517458
  517619
  518156
  519014
  520669
  523429
  523902
  524888
  526382
  527403
  532940
  534826
  537425
  538484
  552234
  552928
  556961
  563834
  565757
  566051
  566616
  567599
  580675
  584365
  590556
  592701
  593790
  601741
  610309
  610522
  612029
  620389
  621172
  628828
  629833
  639845
  645696
  646052
  648033
  658216
  667752
  668072
  669347
  670623
  670715
  672396
  675930
  681490
  685931
  693227
  693273
  693778
  696100
  701917
  709452
  713335
  719294
  721978
  723189
  733330
  734383
  736146
  764518
  769585
  809592
  815475
  815478
  816951
  819902
  821406
  821586
  822154
  822201
]
141.57 ms
(37.95%)
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
  404280
  412548
  414845
  417723
  426660
  426812
  433920
  438738
  440257
  441943
  443913
  446737
  450646
  450650
  455377
  458469
  461005
  463200
  464598
  467365
  468129
  468863
  469044
  470176
  470480
  472055
  474783
  475693
  475873
  482774
  482906
  484944
  485452
  488297
  488745
  488858
  490019
  490515
  490841
  491367
  492318
  502194
  503156
  505545
  507608
  515511
  516804
  517458
  517619
  518156
  519014
  520669
  523429
  523902
  524888
  526382
  527403
  532940
  534826
  537425
  538484
  552234
  552928
  556961
  563834
  565757
  566051
  566616
  567599
  580675
  584365
  590556
  592701
  593790
  601741
  610309
  610522
  612029
  620389
  621172
  628828
  629833
  639845
  645696
  646052
  648033
  658216
  667752
  668072
  669347
  670623
  670715
  672396
  675930
  681490
  685931
  693227
  693273
  693778
  696100
  701917
  709452
  713335
  719294
  721978
  723189
  733330
  734383
  736146
  764518
  769585
  809592
  815475
  815478
  816951
  819902
  821406
  821586
  822154
  822201
]
11.89 ms
(3.19%)
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
  490019
  450650
  475873
  484944
  470480
  520669
  505545
  526382
  518156
  467365
  468863
  464598
  426812
  455377
  488858
  527403
  490841
  491367
  566051
  567599
  612029
  593790
  621172
  433920
  821406
  821586
  822201
  565757
  645696
  658216
  668072
  693227
  701917
  670715
  693778
  719294
  610522
  620389
  629833
  592701
  610309
  590556
  628828
  809592
  733330
  736146
  734383
  769585
  764518
  417723
  441943
  482774
  446737
  474783
  490515
  472055
  475693
  492318
  517458
  532940
  537425
  502194
  507608
  515511
  524888
  538484
  469044
  485452
  552234
  556961
  580675
  414845
  426660
  438738
  440257
  443913
  468129
  470176
  458469
  463200
  412548
  450646
  404280
  461005
  517619
  519014
  523429
  488297
  523902
  482906
  488745
  503156
  516804
  584365
  639845
  709452
  601741
  815478
  815475
  816951
  819902
  822154
  534826
  552928
  566616
  563834
  646052
  667752
  669347
  670623
  672396
  681490
  693273
  696100
  713335
  721978
  723189
  648033
  675930
  685931
]
2.03 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член real"
]
1.83 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dick real"
]
1.77 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член real"
]
1.68 ms
(0.45%)
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.