Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.85 ms
(87.21%)
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
  82307
  388112
  388826
  394235
  401858
  403272
  403736
  404180
  404343
  404388
  411958
  414226
  416446
  417745
  417900
  418166
  418852
  419197
  420249
  421759
  422429
  427232
  428109
  434014
  440629
  447304
  448630
  450398
  453346
  454741
  455192
  456817
  456930
  459829
  461480
  462900
  463988
  464115
  464310
  465205
  468527
  468530
  468757
  470379
  472918
  473259
  473761
  473847
  474001
  477245
  478464
  478482
  478873
  478973
  479754
  480945
  484404
  484483
  489566
  491581
  491704
  491877
  492822
  493469
  495982
  497545
  510392
  510647
  513313
  513724
  515102
  519252
  521588
  522821
  523155
  523985
  525959
  527795
  530478
  531016
  537993
  539210
  542990
  552169
  557343
  558061
  562317
  570334
  573015
  574789
  574905
  575771
  591819
  592418
  593171
  594208
  594215
  594225
  595419
  595515
  598688
  598712
  598759
  598806
  600123
  652982
  665714
  667026
  680167
  682827
  715652
  722913
  737594
  740373
  741249
  747402
  753302
  754197
  760975
  765278
]
14.68 ms
(7.91%)
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
  741249
  754197
  82307
  665714
  595515
  598712
  740373
  753302
  765278
  747402
  401858
  574789
  575771
  542990
  715652
  419197
  468527
  472918
  531016
  652982
  562317
  594215
  598688
  593171
  737594
  459829
  388112
  404388
  414226
  417900
  418852
  456817
  473847
  404180
  465205
  527795
  497545
  522821
  598806
  479754
  594208
  491877
  667026
  722913
  558061
  464310
  428109
  491581
  682827
  453346
  600123
  492822
  510392
  513313
  521588
  530478
  539210
  680167
  427232
  480945
  478973
  484483
  523985
  388826
  434014
  462900
  450398
  552169
  574905
  592418
  598759
  760975
  473761
  464115
  468757
  394235
  455192
  403736
  422429
  417745
  484404
  491704
  495982
  489566
  493469
  525959
  473259
  537993
  513724
  519252
  523155
  404343
  421759
  440629
  420249
  411958
  418166
  470379
  515102
  478873
  557343
  570334
  573015
  594225
  595419
  591819
  448630
  454741
  468530
  478464
  416446
  456930
  477245
  447304
  474001
  403272
  463988
  461480
  478482
  510647
]
2.95 ms
(1.59%)
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
  82307
  388112
  388826
  394235
  401858
  403272
  403736
  404180
  404343
  404388
  411958
  414226
  416446
  417745
  417900
  418166
  418852
  419197
  420249
  421759
  422429
  427232
  428109
  434014
  440629
  447304
  448630
  450398
  453346
  454741
  455192
  456817
  456930
  459829
  461480
  462900
  463988
  464115
  464310
  465205
  468527
  468530
  468757
  470379
  472918
  473259
  473761
  473847
  474001
  477245
  478464
  478482
  478873
  478973
  479754
  480945
  484404
  484483
  489566
  491581
  491704
  491877
  492822
  493469
  495982
  497545
  510392
  510647
  513313
  513724
  515102
  519252
  521588
  522821
  523155
  523985
  525959
  527795
  530478
  531016
  537993
  539210
  542990
  552169
  557343
  558061
  562317
  570334
  573015
  574789
  574905
  575771
  591819
  592418
  593171
  594208
  594215
  594225
  595419
  595515
  598688
  598712
  598759
  598806
  600123
  652982
  665714
  667026
  680167
  682827
  715652
  722913
  737594
  740373
  741249
  747402
  753302
  754197
  760975
  765278
]
1.97 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая teen сиськ"
]
1.62 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful teen tits"
]
1.26 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая teen сиськ"
]

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.