Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.23 ms
(88.37%)
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
  72416
  73672
  122488
  125944
  246261
  387315
  401893
  467508
  495884
  531025
  531689
  532081
  533590
  533754
  537728
  538175
  540606
  544314
  548042
  548861
  549430
  549929
  552755
  574252
  595321
  613181
  613832
  614391
  616711
  619488
  642392
  643118
  656032
  657384
  661906
  668826
  670079
  685308
  689119
  692036
  696220
  713172
  714505
  719897
  720214
  722113
  723046
  723100
  724202
  725268
  726901
  730094
  734113
  736852
  737650
  738734
  742477
  746739
  747048
  747341
  748017
  748612
  752503
  755886
  770090
  772875
  773949
  779497
  782781
  784301
  789327
  789370
  792898
  794473
  795166
  800417
  801040
  802214
  804561
  805348
  806090
  809890
  811083
  814023
  814125
  814450
  817088
  817694
  817803
  820530
  821526
  823137
  823597
  823689
  823800
  823810
  823916
  823924
  823933
  824213
  824312
  824408
  824529
  825326
  825900
  826123
  826585
  826586
  826986
  827035
  827246
  827452
  827504
  828145
  828260
  828283
  828370
  828415
  828597
]
9.91 ms
(5.99%)
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
  723100
  789327
  792898
  809890
  401893
  73672
  814125
  814450
  824408
  823924
  823916
  817803
  826123
  817694
  825326
  828260
  828415
  828145
  827452
  533754
  533590
  537728
  549430
  656032
  661906
  668826
  713172
  657384
  685308
  689119
  714505
  670079
  692036
  696220
  548042
  548861
  595321
  613181
  619488
  643118
  614391
  642392
  782781
  804561
  779497
  795166
  801040
  802214
  805348
  724202
  726901
  746739
  748017
  755886
  772875
  811083
  725268
  737650
  747048
  748612
  730094
  734113
  738734
  736852
  747341
  752503
  770090
  773949
  742477
  719897
  720214
  722113
  723046
  784301
  789370
  794473
  800417
  806090
  72416
  616711
  613832
  467508
  246261
  122488
  125944
  387315
  821526
  823597
  823800
  823810
  824213
  824529
  825900
  826586
  823689
  817088
  820530
  826986
  827035
  827504
  814023
  823137
  824264
  824312
  826585
  828370
  828283
  823933
  827246
  828597
  538175
  540606
  495884
  531689
  532081
  531025
  549929
  544314
  552755
  574252
]
1.99 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short short"
]
1.95 ms
(1.18%)
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
  72416
  73672
  122488
  125944
  246261
  387315
  401893
  467508
  495884
  531025
  531689
  532081
  533590
  533754
  537728
  538175
  540606
  544314
  548042
  548861
  549430
  549929
  552755
  574252
  595321
  613181
  613832
  614391
  616711
  619488
  642392
  643118
  656032
  657384
  661906
  668826
  670079
  685308
  689119
  692036
  696220
  713172
  714505
  719897
  720214
  722113
  723046
  723100
  724202
  725268
  726901
  730094
  734113
  736852
  737650
  738734
  742477
  746739
  747048
  747341
  748017
  748612
  752503
  755886
  770090
  772875
  773949
  779497
  782781
  784301
  789327
  789370
  792898
  794473
  795166
  800417
  801040
  802214
  804561
  805348
  806090
  809890
  811083
  814023
  814125
  814450
  817088
  817694
  817803
  820530
  821526
  823137
  823597
  823689
  823800
  823810
  823916
  823924
  823933
  824213
  824312
  824408
  824529
  825326
  825900
  826123
  826585
  826586
  826986
  827035
  827246
  827452
  827504
  828145
  828260
  828283
  828370
  828415
  828597
]
1.81 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short short"
]
1.79 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short short"
]

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.