Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
395.43 ms
(94.82%)
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
  385426
  387556
  406652
  423478
  435647
  497792
  499587
  519601
  526863
  530980
  540099
  541018
  541819
  553696
  589661
  591803
  599522
  645913
  652881
  658939
  663937
  664759
  676573
  680778
  683698
  687427
  687957
  689171
  695495
  696414
  700034
  700815
  701474
  702146
  702401
  703689
  706758
  707840
  708543
  714958
  716640
  717473
  718908
  720283
  724320
  724736
  725922
  729253
  734364
  734432
  735187
  736960
  743640
  748495
  753732
  764453
  765812
  769059
  770693
  773509
  775220
  778169
  780371
  781004
  781967
  782739
  783652
  784141
  784305
  785380
  786320
  786545
  788640
  789513
  790116
  790580
  791308
  793563
  793576
  794628
  794718
  794888
  795502
  796459
  796971
  797500
  800095
  800843
  803567
  810045
  811162
  811807
  812001
  813737
  815844
  816511
  817181
  817703
  817752
  817864
  818028
  818031
  819112
  819423
  819527
  819532
  819917
  820026
  820101
  821819
  823633
  823725
  823774
  824041
  825295
  825582
  826630
  826631
  827591
  827784
]
12.35 ms
(2.96%)
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
  680778
  435647
  780371
  706758
  599522
  823725
  819112
  702401
  786545
  734364
  826630
  819527
  687427
  702146
  718908
  796971
  735187
  796459
  743640
  387556
  769059
  786320
  790116
  803567
  793576
  820026
  791308
  781004
  725922
  823774
  818028
  823633
  497792
  530980
  541018
  703689
  687957
  591803
  794628
  775220
  793563
  695495
  676573
  800095
  764453
  795502
  812001
  423478
  826631
  817703
  819917
  813737
  664759
  782739
  794888
  734432
  753732
  770693
  773509
  729253
  784305
  778169
  824041
  827784
  541819
  553696
  663937
  689171
  696414
  701474
  797500
  765812
  784141
  794718
  817181
  817864
  811162
  811807
  783652
  790580
  825295
  526863
  708543
  717473
  800843
  810045
  748495
  736960
  720283
  788640
  645913
  589661
  827591
  817752
  519601
  652881
  700815
  785380
  781967
  499587
  385426
  816511
  819532
  714958
  789513
  724320
  716640
  724736
  406652
  815844
  818031
  819423
  825582
  821819
  820101
  540099
  658939
  707840
  683698
  700034
]
2.52 ms
(0.61%)
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
  385426
  387556
  406652
  423478
  435647
  497792
  499587
  519601
  526863
  530980
  540099
  541018
  541819
  553696
  589661
  591803
  599522
  645913
  652881
  658939
  663937
  664759
  676573
  680778
  683698
  687427
  687957
  689171
  695495
  696414
  700034
  700815
  701474
  702146
  702401
  703689
  706758
  707840
  708543
  714958
  716640
  717473
  718908
  720283
  724320
  724736
  725922
  729253
  734364
  734432
  735187
  736960
  743640
  748495
  753732
  764453
  765812
  769059
  770693
  773509
  775220
  778169
  780371
  781004
  781967
  782739
  783652
  784141
  784305
  785380
  786320
  786545
  788640
  789513
  790116
  790580
  791308
  793563
  793576
  794628
  794718
  794888
  795502
  796459
  796971
  797500
  800095
  800843
  803567
  810045
  811162
  811807
  812001
  813737
  815844
  816511
  817181
  817703
  817752
  817864
  818028
  818031
  819112
  819423
  819527
  819532
  819917
  820026
  820101
  821819
  823633
  823725
  823774
  824041
  825295
  825582
  826630
  826631
  827591
  827784
]
2.25 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shower fuck"
]
1.66 ms
(0.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shower секс"
]
1.64 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.17 ms
(0.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shower секс"
]

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.