Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.74 ms
(85.24%)
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
  69816
  389239
  396075
  425366
  455535
  469297
  485219
  500413
  513836
  516497
  518630
  520999
  523216
  524352
  525311
  525771
  526172
  530161
  530221
  531273
  533390
  534589
  536130
  537757
  546226
  546516
  554797
  554968
  556794
  556867
  563383
  575595
  578588
  579223
  580049
  580126
  582835
  585257
  588132
  588335
  588479
  597829
  599405
  600730
  603032
  604322
  606605
  607328
  608415
  608609
  608613
  614900
  616002
  617038
  623131
  629193
  629760
  630686
  632177
  638567
  645169
  650063
  651646
  651821
  651926
  653330
  665740
  666450
  666674
  671679
  680094
  687717
  690784
  694666
  700724
  707401
  709134
  709430
  712526
  717229
  718232
  720345
  723116
  723998
  724894
  725617
  726408
  728457
  730159
  731024
  732756
  733778
  734296
  737466
  738364
  742821
  746840
  748000
  748121
  749641
  752382
  755364
  755549
  760265
  760990
  761079
  761258
  769429
  772035
  773711
  781571
  781608
  783875
  788660
  797067
  803458
  804781
  809778
  810544
  825347
]
13.75 ms
(8.57%)
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
  608609
  588479
  638567
  804781
  810544
  783875
  809778
  723998
  724894
  734296
  742821
  749641
  781571
  781608
  748000
  760990
  769429
  726408
  737466
  732756
  752382
  755364
  755549
  728457
  761079
  773711
  614900
  617038
  629193
  717229
  718232
  723116
  455535
  520999
  500413
  523216
  534589
  469297
  650063
  645169
  651926
  709430
  630686
  599405
  730159
  772035
  738364
  746840
  632177
  425366
  518630
  580049
  694666
  733778
  797067
  803458
  69816
  563383
  526172
  707401
  651821
  623131
  533390
  546226
  608613
  687717
  731024
  825347
  530221
  666450
  531273
  709134
  597829
  761258
  720345
  788660
  725617
  748121
  760265
  389239
  396075
  485219
  524352
  525311
  530161
  516497
  525771
  537757
  536130
  513836
  546516
  554968
  556867
  578588
  580126
  554797
  556794
  575595
  579223
  651646
  680094
  666674
  671679
  700724
  653330
  665740
  690784
  712526
  582835
  585257
  588132
  588335
  606605
  607328
  629760
  616002
  600730
  603032
  604322
  608415
]
2.98 ms
(1.86%)
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
  69816
  389239
  396075
  425366
  455535
  469297
  485219
  500413
  513836
  516497
  518630
  520999
  523216
  524352
  525311
  525771
  526172
  530161
  530221
  531273
  533390
  534589
  536130
  537757
  546226
  546516
  554797
  554968
  556794
  556867
  563383
  575595
  578588
  579223
  580049
  580126
  582835
  585257
  588132
  588335
  588479
  597829
  599405
  600730
  603032
  604322
  606605
  607328
  608415
  608609
  608613
  614900
  616002
  617038
  623131
  629193
  629760
  630686
  632177
  638567
  645169
  650063
  651646
  651821
  651926
  653330
  665740
  666450
  666674
  671679
  680094
  687717
  690784
  694666
  700724
  707401
  709134
  709430
  712526
  717229
  718232
  720345
  723116
  723998
  724894
  725617
  726408
  728457
  730159
  731024
  732756
  733778
  734296
  737466
  738364
  742821
  746840
  748000
  748121
  749641
  752382
  755364
  755549
  760265
  760990
  761079
  761258
  769429
  772035
  773711
  781571
  781608
  783875
  788660
  797067
  803458
  804781
  809778
  810544
  825347
]
1.92 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock sperm"
]
1.86 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock сперм"
]
1.70 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock сперм"
]
1.48 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.