Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
111.49 ms
(83.12%)
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
  411703
  428328
  439587
  446562
  450990
  452644
  452953
  454304
  459401
  464550
  470064
  473392
  475227
  482499
  488957
  489603
  490268
  491212
  491508
  491535
  491732
  493033
  496595
  501007
  503220
  503287
  505819
  506252
  508786
  508830
  508835
  508836
  508839
  508846
  508860
  509440
  511752
  512274
  517797
  518599
  518608
  518609
  518818
  519426
  523679
  523862
  525211
  525957
  527180
  542748
  544494
  545721
  548903
  551165
  567848
  568835
  572164
  573175
  574566
  575057
  575472
  575806
  576095
  576352
  576380
  576401
  576413
  577427
  581483
  584631
  584907
  587297
  589683
  595756
  596168
  597028
  597112
  597149
  597182
  597480
  598092
  598431
  598614
  599326
  599529
  599938
  600078
  600302
  600438
  600973
  601985
  605349
  605746
  608560
  608787
  619007
  620124
  621222
  621735
  621980
  625439
  630609
  693338
  746126
  760451
  796831
  803039
]
13.78 ms
(10.28%)
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
  576401
  576352
  587297
  600438
  598431
  597182
  600302
  598614
  796831
  803039
  760451
  746126
  446562
  459401
  464550
  518609
  490268
  491732
  506252
  508846
  511752
  519426
  525957
  512274
  489603
  505819
  508830
  508836
  523679
  450990
  439587
  525211
  568835
  576413
  542748
  544494
  575057
  576380
  693338
  545721
  581483
  630609
  599529
  597149
  428328
  473392
  411703
  508835
  493033
  508786
  518608
  491212
  508839
  488957
  491535
  501007
  503287
  527180
  503220
  496595
  452644
  482499
  574566
  573175
  575806
  575472
  577427
  621222
  600078
  491508
  518818
  523862
  509440
  517797
  470064
  619007
  475227
  567848
  600973
  608787
  598092
  584631
  584907
  599938
  548903
  454304
  595756
  576095
  589683
  608560
  625439
  551165
  572164
  597480
  621980
  508860
  596168
  599326
  620124
  597112
  605746
  518599
  597028
  621735
  605349
  452953
  601985
]
2.16 ms
(1.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
  411703
  428328
  439587
  446562
  450990
  452644
  452953
  454304
  459401
  464550
  470064
  473392
  475227
  482499
  488957
  489603
  490268
  491212
  491508
  491535
  491732
  493033
  496595
  501007
  503220
  503287
  505819
  506252
  508786
  508830
  508835
  508836
  508839
  508846
  508860
  509440
  511752
  512274
  517797
  518599
  518608
  518609
  518818
  519426
  523679
  523862
  525211
  525957
  527180
  542748
  544494
  545721
  548903
  551165
  567848
  568835
  572164
  573175
  574566
  575057
  575472
  575806
  576095
  576352
  576380
  576401
  576413
  577427
  581483
  584631
  584907
  587297
  589683
  595756
  596168
  597028
  597112
  597149
  597182
  597480
  598092
  598431
  598614
  599326
  599529
  599938
  600078
  600302
  600438
  600973
  601985
  605349
  605746
  608560
  608787
  619007
  620124
  621222
  621735
  621980
  625439
  630609
  693338
  746126
  760451
  796831
  803039
]
2.08 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty russian"
]
1.60 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty русск"
]
1.55 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty русск"
]
1.47 ms
(1.10%)
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.