Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.80 ms
(88.29%)
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
  33707
  34146
  326207
  373884
  386082
  386357
  390292
  393759
  411443
  413186
  413429
  413569
  420022
  421033
  421138
  421734
  423455
  423876
  426069
  430920
  434783
  436840
  437437
  438020
  441758
  442995
  443002
  443004
  443027
  443055
  448647
  449598
  451634
  452370
  452423
  452704
  452709
  452725
  455522
  455598
  456071
  456583
  458217
  461231
  461811
  463496
  463725
  465796
  467755
  469814
  473048
  473068
  477232
  478131
  478139
  490705
  493276
  501916
  502630
  504623
  505263
  509522
  518058
  518061
  522578
  522897
  525216
  525720
  526940
  526941
  529255
  530518
  531429
  551604
  552241
  552609
  558618
  569231
  569308
  578342
  579357
  581833
  585011
  586700
  591295
  593421
  594594
  594607
  594619
  594638
  610082
  614658
  616699
  622264
  631717
  637747
  659379
  660307
  668471
  669398
  700299
  701495
  705737
  713699
  718529
  720955
  721791
  728067
  728557
  730662
  734154
  744313
  749437
  751128
  753259
  753993
  787033
  795385
  809179
  817298
]
12.24 ms
(6.72%)
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
  421734
  529255
  434783
  452704
  469814
  413569
  502630
  465796
  795385
  728067
  809179
  441758
  436840
  443002
  458217
  817298
  421033
  718529
  753259
  730662
  569231
  622264
  721791
  442995
  386357
  463725
  501916
  579357
  660307
  614658
  720955
  509522
  430920
  616699
  787033
  728557
  525720
  669398
  421138
  452725
  552609
  578342
  594638
  734154
  610082
  33707
  438020
  478131
  505263
  518058
  552241
  423455
  386082
  326207
  637747
  393759
  443055
  373884
  34146
  504623
  668471
  586700
  531429
  749437
  581833
  413186
  461811
  744313
  420022
  448647
  713699
  705737
  443004
  456583
  751128
  526941
  522897
  452423
  593421
  452370
  522578
  461231
  530518
  558618
  700299
  659379
  591295
  753993
  437437
  455598
  411443
  426069
  525216
  455522
  449598
  467755
  594607
  423876
  473068
  490705
  390292
  456071
  473048
  594619
  413429
  452709
  443027
  477232
  493276
  463496
  518061
  585011
  594594
  551604
  451634
  478139
  701495
  569308
  631717
  526940
]
2.40 ms
(1.32%)
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
  33707
  34146
  326207
  373884
  386082
  386357
  390292
  393759
  411443
  413186
  413429
  413569
  420022
  421033
  421138
  421734
  423455
  423876
  426069
  430920
  434783
  436840
  437437
  438020
  441758
  442995
  443002
  443004
  443027
  443055
  448647
  449598
  451634
  452370
  452423
  452704
  452709
  452725
  455522
  455598
  456071
  456583
  458217
  461231
  461811
  463496
  463725
  465796
  467755
  469814
  473048
  473068
  477232
  478131
  478139
  490705
  493276
  501916
  502630
  504623
  505263
  509522
  518058
  518061
  522578
  522897
  525216
  525720
  526940
  526941
  529255
  530518
  531429
  551604
  552241
  552609
  558618
  569231
  569308
  578342
  579357
  581833
  585011
  586700
  591295
  593421
  594594
  594607
  594619
  594638
  610082
  614658
  616699
  622264
  631717
  637747
  659379
  660307
  668471
  669398
  700299
  701495
  705737
  713699
  718529
  720955
  721791
  728067
  728557
  730662
  734154
  744313
  749437
  751128
  753259
  753993
  787033
  795385
  809179
  817298
]
1.86 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс sensual"
]
1.79 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob sensual"
]
1.30 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс sensual"
]

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.