Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.21 ms
(82.73%)
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
  154374
  394590
  394639
  400638
  403319
  404028
  408885
  408928
  409035
  410686
  411201
  412852
  414132
  414259
  415961
  416580
  416616
  416683
  421993
  422676
  423592
  423662
  424574
  427289
  430262
  431421
  431439
  441095
  441849
  443244
  444538
  445275
  445323
  445530
  448464
  449377
  452800
  453409
  453582
  455080
  471764
  472706
  473213
  473750
  474596
  475335
  475724
  477757
  478542
  480206
  480260
  483742
  486643
  486742
  490232
  493687
  493825
  493839
  497693
  501708
  504085
  505143
  506133
  513972
  515588
  519698
  521431
  523885
  524324
  527915
  527920
  530482
  530497
  530636
  530765
  530805
  531088
  531844
  532897
  540573
  540575
  540680
  544829
  545395
  547486
  547502
  550890
  550922
  553646
  554851
  564293
  569656
  573188
  576916
  583593
  585251
  600249
  609889
  630081
  632927
  633767
  636958
  637060
  640813
  642060
  666016
  666968
  668141
  676636
  677142
  717514
  740874
  745092
  745111
  749255
  752630
  761632
  801275
  809371
  827737
]
16.56 ms
(11.21%)
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
  745092
  745111
  761632
  749255
  752630
  609889
  809371
  154374
  412852
  431439
  490232
  449377
  473213
  531844
  505143
  497693
  475335
  544829
  550922
  564293
  545395
  547502
  553646
  422676
  480260
  632927
  527915
  478542
  409035
  523885
  477757
  642060
  486643
  414132
  416580
  471764
  573188
  414259
  404028
  416616
  403319
  415961
  445275
  493687
  483742
  394590
  827737
  676636
  400638
  441095
  408885
  423592
  423662
  452800
  453582
  455080
  472706
  530497
  530636
  515588
  527920
  532897
  583593
  633767
  585251
  636958
  630081
  408928
  431421
  486742
  740874
  640813
  448464
  637060
  668141
  475724
  540573
  504085
  530482
  394639
  540680
  531088
  474596
  480206
  547486
  554851
  666016
  801275
  717514
  441849
  421993
  430262
  445530
  521431
  530765
  501708
  513972
  540575
  519698
  666968
  576916
  424574
  444538
  473750
  445323
  493825
  493839
  410686
  443244
  427289
  506133
  453409
  411201
  416683
  677142
  530805
  600249
  550890
  524324
  569656
]
2.25 ms
(1.53%)
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
  154374
  394590
  394639
  400638
  403319
  404028
  408885
  408928
  409035
  410686
  411201
  412852
  414132
  414259
  415961
  416580
  416616
  416683
  421993
  422676
  423592
  423662
  424574
  427289
  430262
  431421
  431439
  441095
  441849
  443244
  444538
  445275
  445323
  445530
  448464
  449377
  452800
  453409
  453582
  455080
  471764
  472706
  473213
  473750
  474596
  475335
  475724
  477757
  478542
  480206
  480260
  483742
  486643
  486742
  490232
  493687
  493825
  493839
  497693
  501708
  504085
  505143
  506133
  513972
  515588
  519698
  521431
  523885
  524324
  527915
  527920
  530482
  530497
  530636
  530765
  530805
  531088
  531844
  532897
  540573
  540575
  540680
  544829
  545395
  547486
  547502
  550890
  550922
  553646
  554851
  564293
  569656
  573188
  576916
  583593
  585251
  600249
  609889
  630081
  632927
  633767
  636958
  637060
  640813
  642060
  666016
  666968
  668141
  676636
  677142
  717514
  740874
  745092
  745111
  749255
  752630
  761632
  801275
  809371
  827737
]
1.99 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "biggest anal gape"
]
1.65 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные анал большая большие дырк"
]
1.42 ms
(0.96%)
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.