Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.88 ms
(85.81%)
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
  162863
  248770
  384525
  384562
  385121
  385788
  398921
  401641
  402080
  403259
  403346
  405481
  405500
  411207
  413208
  413254
  419281
  420062
  428170
  430508
  431182
  432265
  432327
  437260
  443431
  458541
  458558
  465794
  466646
  467664
  473071
  473959
  476388
  478851
  479871
  483466
  488080
  491533
  496644
  500234
  500861
  506344
  509500
  511329
  511781
  515823
  519609
  523759
  530721
  531626
  536662
  537386
  538345
  544299
  544339
  548693
  551166
  551497
  553275
  554978
  555947
  557507
  565289
  566077
  566247
  567666
  567770
  569160
  570196
  570461
  573653
  573656
  584250
  584434
  586885
  591226
  596579
  598267
  599629
  600468
  601820
  604928
  604956
  607497
  617590
  623051
  631598
  642377
  659623
  662978
  664491
  677534
  693944
  694438
  700301
  701687
  703604
  709093
  709685
  710689
  711225
  715478
  721336
  741051
  741298
  742651
  745634
  747312
  762766
  769189
  772063
  774728
  776270
  779946
  794504
  794968
  796380
  801520
  808585
  812162
]
15.76 ms
(8.67%)
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
  488080
  544299
  553275
  555947
  557507
  584250
  573653
  573656
  599629
  596579
  808585
  413254
  419281
  248770
  405500
  411207
  420062
  465794
  428170
  437260
  536662
  515823
  538345
  483466
  693944
  478851
  385121
  473071
  566247
  566077
  432265
  430508
  432327
  443431
  491533
  523759
  500861
  398921
  401641
  402080
  403346
  467664
  479871
  458541
  500234
  530721
  506344
  511781
  537386
  554978
  544339
  548693
  551497
  569160
  570461
  709685
  710689
  711225
  664491
  677534
  694438
  703604
  715478
  721336
  659623
  662978
  565289
  604928
  591226
  600468
  601820
  623051
  631598
  642377
  598267
  604956
  607497
  586885
  617590
  774728
  794968
  796380
  812162
  779946
  741051
  741298
  747312
  794504
  745634
  769189
  742651
  762766
  772063
  700301
  701687
  709093
  776270
  801520
  162863
  384525
  385788
  476388
  384562
  403259
  405481
  511329
  509500
  431182
  413208
  458558
  466646
  473959
  519609
  496644
  531626
  551166
  567666
  567770
  570196
  584434
]
2.52 ms
(1.39%)
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
  162863
  248770
  384525
  384562
  385121
  385788
  398921
  401641
  402080
  403259
  403346
  405481
  405500
  411207
  413208
  413254
  419281
  420062
  428170
  430508
  431182
  432265
  432327
  437260
  443431
  458541
  458558
  465794
  466646
  467664
  473071
  473959
  476388
  478851
  479871
  483466
  488080
  491533
  496644
  500234
  500861
  506344
  509500
  511329
  511781
  515823
  519609
  523759
  530721
  531626
  536662
  537386
  538345
  544299
  544339
  548693
  551166
  551497
  553275
  554978
  555947
  557507
  565289
  566077
  566247
  567666
  567770
  569160
  570196
  570461
  573653
  573656
  584250
  584434
  586885
  591226
  596579
  598267
  599629
  600468
  601820
  604928
  604956
  607497
  617590
  623051
  631598
  642377
  659623
  662978
  664491
  677534
  693944
  694438
  700301
  701687
  703604
  709093
  709685
  710689
  711225
  715478
  721336
  741051
  741298
  742651
  745634
  747312
  762766
  769189
  772063
  774728
  776270
  779946
  794504
  794968
  796380
  801520
  808585
  812162
]
2.18 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural beautiful"
]
2.03 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные красивая"
]
1.68 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.89%)
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.