Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.79 ms
(86.27%)
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
  266633
  398527
  400800
  405966
  417612
  417854
  420078
  423867
  428373
  437575
  456062
  459618
  459993
  462311
  464512
  467942
  470697
  480251
  480697
  482003
  489254
  496586
  502852
  506460
  512449
  512619
  514205
  517375
  517835
  520109
  525571
  526724
  530161
  539634
  545233
  546560
  546570
  546990
  551886
  553677
  555089
  556551
  558778
  562061
  563778
  566911
  571795
  574151
  575525
  577243
  578020
  579198
  585257
  588830
  592062
  593014
  593249
  596343
  599820
  600851
  610134
  620692
  626449
  627710
  630821
  634614
  641463
  642237
  642249
  653440
  667928
  670212
  672846
  682363
  691306
  704361
  705339
  715001
  715779
  717962
  718758
  718867
  719211
  725760
  727034
  727608
  728912
  731117
  731225
  736576
  739642
  739898
  741006
  742758
  743422
  743774
  749566
  749602
  762541
  764266
  764603
  765022
  769257
  778740
  779316
  779387
  779686
  781075
  781516
  786742
  788883
  789149
  790650
  791819
  792300
  793467
  795954
  795978
  805361
  809787
]
16.10 ms
(8.33%)
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
  667928
  462311
  502852
  551886
  578020
  546990
  423867
  546570
  705339
  718758
  670212
  715001
  545233
  630821
  778740
  779316
  779686
  781075
  789149
  790650
  795954
  795978
  741006
  762541
  769257
  786742
  791819
  793467
  731117
  736576
  739642
  765022
  731225
  743774
  749566
  728912
  626449
  715779
  718867
  788883
  809787
  610134
  555089
  566911
  588830
  417612
  470697
  489254
  563778
  620692
  553677
  717962
  642237
  727034
  764266
  642249
  514205
  428373
  562061
  459618
  512619
  496586
  556551
  574151
  558778
  682363
  691306
  653440
  627710
  641463
  634614
  417854
  420078
  456062
  530161
  506460
  517835
  579198
  585257
  593249
  593014
  596343
  599820
  672846
  539634
  577243
  805361
  779387
  727608
  520109
  749602
  405966
  517375
  464512
  512449
  575525
  792300
  742758
  398527
  725760
  739898
  764603
  482003
  743422
  600851
  592062
  459993
  480697
  400800
  467942
  526724
  525571
  571795
  437575
  266633
  480251
  546560
  704361
  719211
  781516
]
2.38 ms
(1.23%)
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
  266633
  398527
  400800
  405966
  417612
  417854
  420078
  423867
  428373
  437575
  456062
  459618
  459993
  462311
  464512
  467942
  470697
  480251
  480697
  482003
  489254
  496586
  502852
  506460
  512449
  512619
  514205
  517375
  517835
  520109
  525571
  526724
  530161
  539634
  545233
  546560
  546570
  546990
  551886
  553677
  555089
  556551
  558778
  562061
  563778
  566911
  571795
  574151
  575525
  577243
  578020
  579198
  585257
  588830
  592062
  593014
  593249
  596343
  599820
  600851
  610134
  620692
  626449
  627710
  630821
  634614
  641463
  642237
  642249
  653440
  667928
  670212
  672846
  682363
  691306
  704361
  705339
  715001
  715779
  717962
  718758
  718867
  719211
  725760
  727034
  727608
  728912
  731117
  731225
  736576
  739642
  739898
  741006
  742758
  743422
  743774
  749566
  749602
  762541
  764266
  764603
  765022
  769257
  778740
  779316
  779387
  779686
  781075
  781516
  786742
  788883
  789149
  790650
  791819
  792300
  793467
  795954
  795978
  805361
  809787
]
2.21 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "измена кончи в рот"
]
1.96 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен сперм в рот"
]
1.86 ms
(0.96%)
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.