Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.42 ms
(82.84%)
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
  418125
  419088
  420576
  422438
  422469
  428382
  431500
  437217
  437222
  437607
  443029
  443068
  448213
  448763
  450339
  451605
  453508
  455612
  456607
  457841
  463678
  469648
  469655
  470218
  471517
  472370
  474279
  475010
  476013
  476460
  478847
  479555
  480011
  481419
  482997
  483560
  485542
  486116
  487303
  487313
  487802
  488709
  489187
  490328
  490867
  491309
  491716
  491719
  491746
  492458
  493919
  494802
  497052
  502639
  503679
  505431
  506433
  507433
  509036
  510077
  513325
  513346
  513620
  516039
  516389
  517248
  520587
  521571
  521685
  522584
  525600
  537282
  537310
  541080
  546374
  549814
  551820
  552781
  552941
  553654
  555510
  556241
  556474
  558210
  558522
  559236
  560802
  561236
  564902
  565400
  565426
  567648
  568837
  568961
  570695
  571832
  574000
  574043
  588252
  588261
  598511
  598839
  601941
  609103
  609419
  614434
  617431
  618806
  620846
  623471
  644904
  650228
  663347
  698878
  717796
  758380
  758691
  765055
  769077
  781397
]
18.59 ms
(10.89%)
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
  650228
  558210
  717796
  758380
  574000
  644904
  490328
  503679
  537310
  551820
  564902
  574043
  556474
  598511
  609419
  698878
  443029
  469648
  475010
  476460
  422438
  472370
  418125
  455612
  419088
  420576
  437222
  476013
  502639
  516389
  488709
  491719
  494802
  522584
  487802
  525600
  487313
  491309
  509036
  520587
  485542
  571832
  457841
  552941
  451605
  552781
  568961
  479555
  506433
  492458
  487303
  618806
  617431
  758691
  765055
  781397
  470218
  437607
  481419
  450339
  456607
  663347
  559236
  570695
  565426
  588261
  431500
  463678
  471517
  422469
  428382
  443068
  513325
  513620
  483560
  491716
  497052
  489187
  507433
  541080
  482997
  490867
  769077
  558522
  588252
  561236
  556241
  598839
  448213
  469655
  521571
  521685
  510077
  513346
  517248
  491746
  516039
  486116
  493919
  480011
  623471
  609103
  614434
  601941
  537282
  553654
  567648
  546374
  555510
  568837
  549814
  560802
  565400
  620846
  437217
  453508
  474279
  448763
  478847
  505431
]
3.42 ms
(2.00%)
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
  418125
  419088
  420576
  422438
  422469
  428382
  431500
  437217
  437222
  437607
  443029
  443068
  448213
  448763
  450339
  451605
  453508
  455612
  456607
  457841
  463678
  469648
  469655
  470218
  471517
  472370
  474279
  475010
  476013
  476460
  478847
  479555
  480011
  481419
  482997
  483560
  485542
  486116
  487303
  487313
  487802
  488709
  489187
  490328
  490867
  491309
  491716
  491719
  491746
  492458
  493919
  494802
  497052
  502639
  503679
  505431
  506433
  507433
  509036
  510077
  513325
  513346
  513620
  516039
  516389
  517248
  520587
  521571
  521685
  522584
  525600
  537282
  537310
  541080
  546374
  549814
  551820
  552781
  552941
  553654
  555510
  556241
  556474
  558210
  558522
  559236
  560802
  561236
  564902
  565400
  565426
  567648
  568837
  568961
  570695
  571832
  574000
  574043
  588252
  588261
  598511
  598839
  601941
  609103
  609419
  614434
  617431
  618806
  620846
  623471
  644904
  650228
  663347
  698878
  717796
  758380
  758691
  765055
  769077
  781397
]
2.17 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian pov public"
]
1.94 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск пов на улиц"
]
1.69 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.88%)
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.