Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.95 ms
(86.46%)
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
  6666
  382426
  396378
  398425
  400617
  417975
  424746
  428621
  428882
  429685
  443463
  445837
  448042
  454272
  465297
  466963
  469840
  469915
  472334
  474553
  474735
  476023
  476749
  484550
  490649
  492061
  494499
  502290
  504280
  507366
  509358
  510467
  523709
  538415
  538429
  546977
  548628
  548706
  548773
  549982
  551249
  552124
  552681
  552684
  558853
  562237
  562277
  562310
  564461
  565314
  566475
  567411
  569686
  569842
  569846
  570021
  570038
  570043
  570045
  570271
  570460
  570483
  570525
  570531
  570570
  570603
  570669
  571582
  571596
  572503
  573021
  573560
  573563
  573568
  573678
  573712
  573773
  573967
  573987
  574539
  574611
  575106
  575214
  575452
  575485
  577407
  578158
  592493
  594225
  595403
  600472
  601090
  605050
  609140
  619416
  621091
  653821
  656339
  658013
  658278
  659118
  659670
  660560
  665256
  671125
  673455
  675028
  679131
  716035
  740252
  743394
  753300
  768286
  768307
  772105
  789049
  791302
  793607
  803453
  810691
]
15.35 ms
(8.25%)
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
  659118
  659670
  660560
  675028
  653821
  656339
  658013
  658278
  665256
  671125
  673455
  679131
  716035
  549982
  570570
  619416
  592493
  601090
  789049
  793607
  810691
  791302
  753300
  772105
  768286
  768307
  740252
  743394
  803453
  382426
  6666
  396378
  417975
  428621
  465297
  445837
  490649
  502290
  546977
  562277
  562310
  565314
  570043
  570483
  571582
  573021
  573773
  575485
  577407
  578158
  548628
  548706
  552681
  562237
  569842
  569846
  570045
  570271
  570460
  570525
  571596
  573560
  573678
  573712
  573967
  573987
  574539
  575106
  551249
  564461
  566475
  570603
  570669
  573563
  573568
  575214
  575452
  548773
  552124
  552684
  558853
  567411
  570021
  570038
  570531
  572503
  574611
  595403
  600472
  605050
  594225
  398425
  400617
  429685
  454272
  472334
  476023
  476749
  443463
  448042
  469840
  428882
  509358
  494499
  504280
  507366
  484550
  492061
  510467
  538429
  523709
  538415
  424746
  569686
  621091
  466963
  609140
  474553
  474735
  469915
]
3.13 ms
(1.68%)
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
  6666
  382426
  396378
  398425
  400617
  417975
  424746
  428621
  428882
  429685
  443463
  445837
  448042
  454272
  465297
  466963
  469840
  469915
  472334
  474553
  474735
  476023
  476749
  484550
  490649
  492061
  494499
  502290
  504280
  507366
  509358
  510467
  523709
  538415
  538429
  546977
  548628
  548706
  548773
  549982
  551249
  552124
  552681
  552684
  558853
  562237
  562277
  562310
  564461
  565314
  566475
  567411
  569686
  569842
  569846
  570021
  570038
  570043
  570045
  570271
  570460
  570483
  570525
  570531
  570570
  570603
  570669
  571582
  571596
  572503
  573021
  573560
  573563
  573568
  573678
  573712
  573773
  573967
  573987
  574539
  574611
  575106
  575214
  575452
  575485
  577407
  578158
  592493
  594225
  595403
  600472
  601090
  605050
  609140
  619416
  621091
  653821
  656339
  658013
  658278
  659118
  659670
  660560
  665256
  671125
  673455
  675028
  679131
  716035
  740252
  743394
  753300
  768286
  768307
  772105
  789049
  791302
  793607
  803453
  810691
]
1.84 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая взасос"
]
1.71 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая поцел"
]
1.50 ms
(0.81%)
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.