Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
225.58 ms
(88.27%)
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
  392404
  400571
  401229
  401919
  406371
  413033
  420351
  425490
  428476
  428499
  428761
  435131
  444717
  445187
  448781
  448797
  458251
  461714
  463689
  469749
  470154
  472321
  478651
  489661
  492020
  492109
  495670
  496776
  504738
  506093
  509736
  511721
  512902
  513664
  514402
  522096
  524089
  524324
  525385
  531165
  532172
  533773
  536616
  536781
  536819
  544770
  545831
  546957
  555065
  556911
  560442
  562830
  564001
  565266
  570978
  573732
  574727
  579580
  582393
  583448
  584351
  594491
  596583
  600219
  600317
  601046
  606587
  606801
  607713
  630234
  632646
  632663
  632669
  632703
  632974
  633766
  634512
  634545
  634773
  637134
  637432
  638298
  639782
  642022
  642677
  645858
  646904
  656499
  666541
  666892
  669012
  674984
  680115
  680248
  681126
  692767
  704248
  704269
  713564
  715145
  718675
  719001
  721551
  726658
  730011
  748354
  757342
  766831
  778941
  784242
  784481
  784755
  785498
  788789
  811037
  814049
  814783
  815019
  815748
  820682
]
19.17 ms
(7.50%)
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
  600317
  413033
  401229
  420351
  428499
  546957
  570978
  582393
  584351
  719001
  606587
  637432
  594491
  634545
  715145
  718675
  470154
  445187
  458251
  461714
  392404
  536819
  511721
  504738
  400571
  536781
  634512
  448781
  514402
  492020
  814783
  512902
  656499
  692767
  555065
  630234
  639782
  766831
  726658
  730011
  748354
  811037
  669012
  600219
  506093
  496776
  492109
  562830
  495670
  532172
  406371
  757342
  533773
  666892
  632663
  815019
  556911
  574727
  564001
  579580
  704269
  721551
  642022
  632974
  435131
  463689
  472321
  513664
  524324
  820682
  814049
  666541
  680115
  680248
  642677
  778941
  784242
  784481
  785498
  788789
  444717
  536616
  583448
  525385
  448797
  704248
  713564
  601046
  632646
  681126
  560442
  573732
  565266
  545831
  596583
  607713
  522096
  509736
  428761
  784755
  524089
  646904
  637134
  606801
  634773
  489661
  425490
  645858
  478651
  638298
  401919
  531165
  428476
  815748
  674984
  544770
  632703
  632669
  633766
  469749
]
4.36 ms
(1.71%)
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
  392404
  400571
  401229
  401919
  406371
  413033
  420351
  425490
  428476
  428499
  428761
  435131
  444717
  445187
  448781
  448797
  458251
  461714
  463689
  469749
  470154
  472321
  478651
  489661
  492020
  492109
  495670
  496776
  504738
  506093
  509736
  511721
  512902
  513664
  514402
  522096
  524089
  524324
  525385
  531165
  532172
  533773
  536616
  536781
  536819
  544770
  545831
  546957
  555065
  556911
  560442
  562830
  564001
  565266
  570978
  573732
  574727
  579580
  582393
  583448
  584351
  594491
  596583
  600219
  600317
  601046
  606587
  606801
  607713
  630234
  632646
  632663
  632669
  632703
  632974
  633766
  634512
  634545
  634773
  637134
  637432
  638298
  639782
  642022
  642677
  645858
  646904
  656499
  666541
  666892
  669012
  674984
  680115
  680248
  681126
  692767
  704248
  704269
  713564
  715145
  718675
  719001
  721551
  726658
  730011
  748354
  757342
  766831
  778941
  784242
  784481
  784755
  785498
  788789
  811037
  814049
  814783
  815019
  815748
  820682
]
1.83 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pantyhose beauty anal"
]
1.59 ms
(0.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pantyhose beauty анал"
]
1.56 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pantyhose beauty анал"
]

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.