Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.31 ms
(86.34%)
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
  475162
  541825
  544660
  549003
  549051
  551358
  552171
  553889
  556342
  557524
  558356
  563249
  566260
  568350
  568559
  569840
  573824
  574125
  574207
  574211
  574225
  575308
  578487
  587052
  588471
  591838
  593983
  594613
  596660
  596662
  598662
  598894
  600454
  603136
  603508
  604002
  613806
  616550
  621915
  622579
  624703
  627835
  628795
  639210
  639942
  641787
  648722
  650113
  650167
  651588
  651691
  651883
  653371
  654151
  661607
  663176
  665922
  671090
  671810
  672800
  676196
  676215
  676474
  676530
  676953
  676969
  676995
  678185
  679305
  682954
  686054
  687093
  687374
  693881
  703697
  704942
  705102
  709535
  714460
  717812
  718587
  718848
  719375
  720208
  720299
  720807
  729738
  732090
  732426
  736927
  740145
  741640
  742195
  742900
  744728
  746381
  748399
  749829
  752180
  754027
  761384
  772688
  773534
  778456
  779800
  779894
  781631
  783798
  786232
  788309
  789089
  791563
  795247
  801719
  802043
  805652
  808097
  811210
  812559
  813284
]
14.30 ms
(7.80%)
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
  475162
  541825
  544660
  553889
  558356
  563249
  568350
  573824
  574125
  549051
  566260
  568559
  574207
  552171
  556342
  557524
  574225
  575308
  648722
  650167
  651588
  654151
  663176
  665922
  678185
  679305
  686054
  687093
  703697
  705102
  709535
  718587
  650113
  651691
  651883
  661607
  671090
  671810
  672800
  676530
  676969
  682954
  687374
  693881
  704942
  718848
  719375
  720208
  720807
  653371
  676196
  676215
  676474
  676953
  676995
  714460
  717812
  720299
  549003
  551358
  569840
  574211
  578487
  591838
  596662
  628795
  603508
  613806
  621915
  639942
  587052
  593983
  594613
  596660
  598662
  598894
  616550
  639210
  588471
  600454
  603136
  604002
  622579
  624703
  627835
  641787
  778456
  779894
  783798
  795247
  802043
  805652
  779800
  781631
  788309
  789089
  813284
  729738
  742195
  742900
  754027
  773534
  786232
  791563
  801719
  808097
  811210
  812559
  732090
  740145
  744728
  748399
  749829
  761384
  736927
  741640
  746381
  752180
  772688
  732426
]
2.87 ms
(1.57%)
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
  475162
  541825
  544660
  549003
  549051
  551358
  552171
  553889
  556342
  557524
  558356
  563249
  566260
  568350
  568559
  569840
  573824
  574125
  574207
  574211
  574225
  575308
  578487
  587052
  588471
  591838
  593983
  594613
  596660
  596662
  598662
  598894
  600454
  603136
  603508
  604002
  613806
  616550
  621915
  622579
  624703
  627835
  628795
  639210
  639942
  641787
  648722
  650113
  650167
  651588
  651691
  651883
  653371
  654151
  661607
  663176
  665922
  671090
  671810
  672800
  676196
  676215
  676474
  676530
  676953
  676969
  676995
  678185
  679305
  682954
  686054
  687093
  687374
  693881
  703697
  704942
  705102
  709535
  714460
  717812
  718587
  718848
  719375
  720208
  720299
  720807
  729738
  732090
  732426
  736927
  740145
  741640
  742195
  742900
  744728
  746381
  748399
  749829
  752180
  754027
  761384
  772688
  773534
  778456
  779800
  779894
  781631
  783798
  786232
  788309
  789089
  791563
  795247
  801719
  802043
  805652
  808097
  811210
  812559
  813284
]
2.02 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лето"
]
2.01 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лет"
]
1.95 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.