Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
235.61 ms
(91.03%)
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
  233676
  308917
  384566
  385912
  386685
  386735
  388481
  393384
  400000
  427069
  434317
  436049
  443443
  444691
  452732
  456370
  458247
  461151
  462555
  467800
  473118
  481499
  481753
  489421
  497196
  508364
  508772
  509760
  530264
  533437
  539633
  540805
  545250
  549288
  555081
  558751
  563459
  564892
  565876
  567608
  584878
  584949
  597581
  601365
  603775
  616824
  629541
  630111
  634246
  646188
  653306
  655805
  657751
  660606
  663334
  665747
  689107
  690042
  693777
  696708
  709430
  710913
  719103
  719311
  722084
  723293
  725563
  730428
  731517
  734293
  745572
  746208
  746328
  746718
  748721
  748760
  748767
  750795
  755451
  757994
  761872
  764061
  764153
  766263
  767315
  767553
  768125
  768403
  774635
  778105
  781440
  783826
  786346
  788203
  788644
  791617
  793800
  796346
  798259
  798599
  800447
  802021
  805001
  805310
  817447
  817515
  818701
  820951
  821180
  821894
  822055
  822115
  822475
  822505
  825105
  825379
  825585
  826795
  827368
]
11.97 ms
(4.63%)
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
  564892
  657751
  660606
  597581
  616824
  748760
  731517
  436049
  386685
  757994
  764153
  462555
  481753
  489421
  509760
  473118
  443443
  452732
  467800
  821894
  689107
  723293
  778105
  734293
  748721
  788203
  710913
  384566
  719103
  461151
  746718
  481499
  385912
  761872
  781440
  796346
  497196
  458247
  584949
  822475
  601365
  793800
  646188
  549288
  388481
  540805
  539633
  690042
  823752
  825105
  630111
  755451
  693777
  766263
  730428
  629541
  555081
  764061
  584878
  634246
  745572
  767315
  788644
  748767
  774635
  508364
  567608
  805001
  719311
  533437
  800447
  822115
  817515
  822055
  696708
  791617
  725563
  802021
  393384
  818701
  826795
  822505
  655805
  746208
  783826
  444691
  427069
  456370
  709430
  786346
  665747
  798599
  821180
  558751
  750795
  400000
  508772
  545250
  386735
  233676
  825379
  530264
  663334
  563459
  746328
  798259
  768125
  653306
  767553
  768403
  722084
  565876
  817447
  308917
  827368
  603775
  820951
  805310
  434317
  825585
]
3.67 ms
(1.42%)
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
  233676
  308917
  384566
  385912
  386685
  386735
  388481
  393384
  400000
  427069
  434317
  436049
  443443
  444691
  452732
  456370
  458247
  461151
  462555
  467800
  473118
  481499
  481753
  489421
  497196
  508364
  508772
  509760
  530264
  533437
  539633
  540805
  545250
  549288
  555081
  558751
  563459
  564892
  565876
  567608
  584878
  584949
  597581
  601365
  603775
  616824
  629541
  630111
  634246
  646188
  653306
  655805
  657751
  660606
  663334
  665747
  689107
  690042
  693777
  696708
  709430
  710913
  719103
  719311
  722084
  723293
  725563
  730428
  731517
  734293
  745572
  746208
  746328
  746718
  748721
  748760
  748767
  750795
  755451
  757994
  761872
  764061
  764153
  766263
  767315
  767553
  768125
  768403
  774635
  778105
  781440
  783826
  786346
  788203
  788644
  791617
  793800
  796346
  798259
  798599
  800447
  802021
  805001
  805310
  817447
  817515
  818701
  820951
  821180
  821894
  822055
  822115
  822475
  822505
  825105
  825379
  825585
  826795
  827368
]
3.57 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "close up минет оральн секс"
]
1.34 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "close-up blowjob"
]
1.12 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "close up минет оральн секс"
]

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.