Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.75 ms
(86.13%)
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
  209373
  383823
  388635
  395394
  404412
  415948
  418720
  421187
  422075
  425006
  425130
  428392
  428930
  430785
  431762
  431965
  433097
  433239
  438588
  438762
  439203
  442204
  449760
  450508
  455039
  455503
  455515
  455836
  456544
  457595
  458686
  459085
  460969
  461337
  464204
  466782
  469599
  469655
  470817
  472336
  475000
  475918
  477437
  479099
  479616
  480918
  481641
  481995
  483014
  483350
  484893
  485569
  487578
  489140
  491390
  492656
  492716
  493310
  496107
  496976
  498431
  500367
  501030
  504919
  505984
  506499
  506824
  507200
  507893
  508391
  510117
  510583
  511299
  512194
  514296
  517001
  517860
  519959
  520626
  521530
  521685
  522608
  522903
  523954
  524202
  524624
  525440
  526877
  526900
  528507
  529543
  531238
  543344
  549169
  549794
  550076
  551213
  552220
  556241
  556662
  557491
  557958
  561236
  563220
  564078
  565373
  568307
  569826
  576264
  576267
  597638
  599664
  600965
  603704
  613851
  688024
  728103
  804491
  811090
  814949
]
19.21 ms
(9.20%)
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
  457595
  483350
  491390
  492716
  507893
  512194
  531238
  519959
  525440
  526900
  505984
  517860
  529543
  461337
  549794
  569826
  551213
  549169
  563220
  576264
  576267
  688024
  550076
  599664
  613851
  383823
  481641
  209373
  425130
  459085
  388635
  418720
  481995
  404412
  422075
  455039
  458686
  480918
  425006
  428930
  430785
  449760
  456544
  514296
  521530
  522608
  523954
  526877
  489140
  511299
  524202
  524624
  485569
  506499
  483014
  492656
  506824
  507200
  510583
  520626
  395394
  433239
  439203
  431762
  438588
  442204
  814949
  469599
  498431
  504919
  543344
  557958
  557491
  561236
  552220
  556241
  564078
  565373
  568307
  556662
  597638
  603704
  600965
  811090
  728103
  804491
  455515
  475000
  475918
  477437
  479099
  438762
  455503
  428392
  470817
  415948
  421187
  455836
  460969
  469655
  472336
  517001
  521685
  487578
  496107
  522903
  484893
  501030
  496976
  508391
  510117
  528507
  433097
  431965
  464204
  493310
  450508
  466782
  479616
  500367
]
2.94 ms
(1.41%)
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
  209373
  383823
  388635
  395394
  404412
  415948
  418720
  421187
  422075
  425006
  425130
  428392
  428930
  430785
  431762
  431965
  433097
  433239
  438588
  438762
  439203
  442204
  449760
  450508
  455039
  455503
  455515
  455836
  456544
  457595
  458686
  459085
  460969
  461337
  464204
  466782
  469599
  469655
  470817
  472336
  475000
  475918
  477437
  479099
  479616
  480918
  481641
  481995
  483014
  483350
  484893
  485569
  487578
  489140
  491390
  492656
  492716
  493310
  496107
  496976
  498431
  500367
  501030
  504919
  505984
  506499
  506824
  507200
  507893
  508391
  510117
  510583
  511299
  512194
  514296
  517001
  517860
  519959
  520626
  521530
  521685
  522608
  522903
  523954
  524202
  524624
  525440
  526877
  526900
  528507
  529543
  531238
  543344
  549169
  549794
  550076
  551213
  552220
  556241
  556662
  557491
  557958
  561236
  563220
  564078
  565373
  568307
  569826
  576264
  576267
  597638
  599664
  600965
  603704
  613851
  688024
  728103
  804491
  811090
  814949
]
1.82 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "место"
]
1.76 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мест"
]
1.66 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.