Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.85 ms
(83.94%)
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
  391923
  391959
  391994
  392025
  398979
  418521
  418714
  419619
  427100
  429860
  429879
  429886
  434325
  435355
  435874
  455373
  456045
  459472
  461944
  464053
  465841
  466402
  466405
  466630
  467876
  467905
  467923
  470024
  470143
  474214
  474323
  479148
  488887
  489087
  493961
  494598
  496506
  499836
  501476
  502497
  505326
  506092
  509430
  513528
  517881
  519309
  519753
  525355
  525468
  525884
  527258
  528544
  533156
  533719
  537237
  543640
  544527
  544874
  550125
  560692
  560828
  571360
  571707
  577433
  578169
  578323
  579510
  592573
  592985
  596792
  599239
  599354
  601566
  602215
  609071
  609623
  632683
  632849
  641807
  661539
  678716
  680791
  680801
  680806
  680809
  685758
  686494
  686549
  711749
  714468
  714476
  714487
  730795
  732165
  735958
  740384
  742336
  745335
  754656
  766349
  768805
  783352
  788753
  793011
  793023
  800657
  802241
  803404
  803479
  806730
  806986
  807884
  813963
  824530
  824733
  824837
  825560
  825771
  826706
]
15.22 ms
(9.84%)
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
  571707
  714487
  685758
  560828
  641807
  599239
  596792
  732165
  609623
  459472
  466405
  398979
  525355
  527258
  601566
  544527
  579510
  435874
  506092
  513528
  543640
  577433
  429860
  429886
  435355
  479148
  592573
  826706
  537237
  544874
  686494
  680801
  686549
  788753
  800657
  802241
  803479
  742336
  735958
  745335
  560692
  578169
  391994
  466630
  429879
  466402
  502497
  505326
  494598
  550125
  533719
  632849
  602215
  519753
  678716
  714476
  592985
  599354
  796642
  509430
  525468
  470143
  474323
  470024
  813963
  824530
  824733
  680806
  680809
  661539
  632683
  803404
  754656
  730795
  766349
  711749
  807884
  391923
  467923
  391959
  467876
  496506
  456045
  418714
  461944
  489087
  517881
  519309
  493961
  525884
  474214
  501476
  825560
  825771
  824837
  571360
  680791
  806986
  783352
  740384
  768805
  793011
  793023
  806730
  392025
  465841
  533156
  609071
  418521
  419619
  467905
  434325
  455373
  464053
  427100
  499836
  528544
  714468
  578323
  488887
]
2.62 ms
(1.69%)
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
  391923
  391959
  391994
  392025
  398979
  418521
  418714
  419619
  427100
  429860
  429879
  429886
  434325
  435355
  435874
  455373
  456045
  459472
  461944
  464053
  465841
  466402
  466405
  466630
  467876
  467905
  467923
  470024
  470143
  474214
  474323
  479148
  488887
  489087
  493961
  494598
  496506
  499836
  501476
  502497
  505326
  506092
  509430
  513528
  517881
  519309
  519753
  525355
  525468
  525884
  527258
  528544
  533156
  533719
  537237
  543640
  544527
  544874
  550125
  560692
  560828
  571360
  571707
  577433
  578169
  578323
  579510
  592573
  592985
  596792
  599239
  599354
  601566
  602215
  609071
  609623
  632683
  632849
  641807
  661539
  678716
  680791
  680801
  680806
  680809
  685758
  686494
  686549
  711749
  714468
  714476
  714487
  730795
  732165
  735958
  740384
  742336
  745335
  754656
  766349
  768805
  783352
  788753
  793011
  793023
  800657
  802241
  803404
  803479
  806730
  806986
  807884
  813963
  824530
  824733
  824837
  825560
  825771
  826706
]
2.08 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian hairy solo"
]
1.74 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск волосатая соло"
]
1.58 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.