Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.27 ms
(81.36%)
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
  391916
  391944
  391945
  391980
  391992
  391994
  400480
  418126
  422144
  424198
  429736
  429737
  429879
  429905
  434286
  434309
  434313
  434371
  435530
  435535
  438316
  439078
  439292
  439522
  444548
  444913
  444918
  445103
  446786
  447040
  452942
  458684
  460754
  460804
  461944
  464264
  464500
  465481
  466379
  466384
  466388
  466398
  466510
  467878
  467885
  468255
  469120
  469128
  469146
  471009
  471607
  471664
  472811
  473391
  476041
  476715
  477143
  479107
  479351
  479364
  480869
  481961
  482751
  484152
  485797
  487944
  489087
  491101
  491107
  491108
  491431
  492695
  493258
  495562
  496063
  499383
  499391
  499865
  504794
  505281
  506458
  508740
  508778
  509098
  512065
  513630
  513637
  513643
  513649
  513650
  514702
  517808
  517813
  519309
  519363
  519371
  520646
  525884
  527624
  530707
  535368
  535390
  535462
  547805
  550179
  554998
  555000
  583615
  602793
  620330
  714459
  714562
  740919
  742318
  742415
  751609
  761608
  790575
  791930
  807326
]
18.84 ms
(11.77%)
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
  742318
  751609
  761608
  740919
  742415
  714459
  714562
  790575
  791930
  391994
  466379
  466398
  468255
  480869
  467885
  469146
  471664
  472811
  391980
  429879
  458684
  466388
  471607
  391916
  424198
  452942
  465481
  479351
  464264
  469128
  481961
  506458
  509098
  512065
  514702
  517808
  535368
  492695
  504794
  508740
  513643
  513649
  513650
  517813
  535390
  484152
  491101
  499865
  519363
  487944
  491107
  491108
  505281
  513630
  513637
  519371
  520646
  530707
  535462
  519309
  444548
  527624
  495562
  499383
  525884
  583615
  435530
  439078
  464500
  485797
  550179
  547805
  555000
  554998
  602793
  444913
  444918
  469120
  479107
  391945
  429736
  429737
  429905
  434309
  434313
  438316
  460754
  391992
  434286
  446786
  418126
  434371
  461944
  445103
  460804
  489087
  493258
  496063
  508778
  499391
  471009
  807326
  491431
  620330
  467878
  473391
  391944
  400480
  422144
  439292
  435535
  439522
  482751
  447040
  476041
  477143
  466510
  476715
  479364
  466384
]
4.08 ms
(2.55%)
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
  391916
  391944
  391945
  391980
  391992
  391994
  400480
  418126
  422144
  424198
  429736
  429737
  429879
  429905
  434286
  434309
  434313
  434371
  435530
  435535
  438316
  439078
  439292
  439522
  444548
  444913
  444918
  445103
  446786
  447040
  452942
  458684
  460754
  460804
  461944
  464264
  464500
  465481
  466379
  466384
  466388
  466398
  466510
  467878
  467885
  468255
  469120
  469128
  469146
  471009
  471607
  471664
  472811
  473391
  476041
  476715
  477143
  479107
  479351
  479364
  480869
  481961
  482751
  484152
  485797
  487944
  489087
  491101
  491107
  491108
  491431
  492695
  493258
  495562
  496063
  499383
  499391
  499865
  504794
  505281
  506458
  508740
  508778
  509098
  512065
  513630
  513637
  513643
  513649
  513650
  514702
  517808
  517813
  519309
  519363
  519371
  520646
  525884
  527624
  530707
  535368
  535390
  535462
  547805
  550179
  554998
  555000
  583615
  602793
  620330
  714459
  714562
  740919
  742318
  742415
  751609
  761608
  790575
  791930
  807326
]
2.06 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian solo mature"
]
1.79 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск соло mature"
]
1.43 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск соло mature"
]

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.