Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.17 ms
(86.94%)
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
  69876
  69940
  147173
  385166
  396335
  396909
  398399
  399952
  401570
  401630
  407550
  426211
  437486
  443359
  447813
  447940
  462899
  466654
  469189
  482995
  497749
  500533
  500943
  500945
  505291
  508268
  508279
  523946
  528307
  529394
  529834
  532571
  538746
  567037
  568513
  580354
  580624
  580652
  583077
  587087
  594469
  615897
  619602
  621509
  622649
  629828
  633480
  641533
  647721
  652964
  682929
  689898
  695782
  700853
  701447
  709340
  710795
  714949
  717120
  718685
  718856
  723454
  725025
  726454
  729928
  732027
  735982
  738911
  739920
  746432
  746612
  749538
  750276
  751357
  755445
  755959
  756620
  757006
  757117
  762339
  763393
  767798
  769643
  771311
  771909
  772863
  773019
  773639
  775484
  776057
  777033
  777046
  778810
  779014
  783355
  783928
  783937
  783945
  786456
  788091
  788259
  792024
  792166
  797286
  797287
  800026
  801300
  802227
  802231
  803448
  804301
  805261
  805336
  806097
  807472
  809640
  812082
  812434
  813984
  824800
]
13.65 ms
(7.70%)
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
  778810
  786456
  800026
  805336
  812434
  399952
  443359
  385166
  532571
  523946
  615897
  776057
  802227
  802231
  807472
  783945
  755445
  622649
  812082
  824800
  647721
  147173
  401630
  508279
  528307
  729928
  633480
  69940
  437486
  447813
  462899
  500943
  505291
  529394
  500945
  508268
  580624
  580652
  482995
  396335
  396909
  813984
  652964
  682929
  700853
  710795
  580354
  594469
  621509
  805261
  797287
  732027
  757117
  783928
  773019
  756620
  769643
  771311
  762339
  735982
  751357
  771909
  641533
  709340
  718685
  792024
  806097
  447940
  466654
  69876
  398399
  469189
  529834
  538746
  568513
  567037
  583077
  689898
  718856
  701447
  714949
  717120
  695782
  723454
  587087
  619602
  629828
  775484
  777046
  792166
  777033
  779014
  788259
  804301
  757006
  763393
  772863
  773639
  783355
  788091
  809640
  725025
  726454
  739920
  746612
  755959
  738911
  746432
  749538
  750276
  767798
  783937
  797286
  801300
  803448
  426211
  401570
  497749
  407550
  500533
]
2.40 ms
(1.35%)
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
  69876
  69940
  147173
  385166
  396335
  396909
  398399
  399952
  401570
  401630
  407550
  426211
  437486
  443359
  447813
  447940
  462899
  466654
  469189
  482995
  497749
  500533
  500943
  500945
  505291
  508268
  508279
  523946
  528307
  529394
  529834
  532571
  538746
  567037
  568513
  580354
  580624
  580652
  583077
  587087
  594469
  615897
  619602
  621509
  622649
  629828
  633480
  641533
  647721
  652964
  682929
  689898
  695782
  700853
  701447
  709340
  710795
  714949
  717120
  718685
  718856
  723454
  725025
  726454
  729928
  732027
  735982
  738911
  739920
  746432
  746612
  749538
  750276
  751357
  755445
  755959
  756620
  757006
  757117
  762339
  763393
  767798
  769643
  771311
  771909
  772863
  773019
  773639
  775484
  776057
  777033
  777046
  778810
  779014
  783355
  783928
  783937
  783945
  786456
  788091
  788259
  792024
  792166
  797286
  797287
  800026
  801300
  802227
  802231
  803448
  804301
  805261
  805336
  806097
  807472
  809640
  812082
  812434
  813984
  824800
]
1.97 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation girl"
]
1.76 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк девушк"
]
1.70 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.95%)
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.