Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.23 ms
(85.38%)
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
  400434
  416181
  421137
  428092
  435104
  442898
  446234
  447828
  448921
  450473
  455352
  462479
  465815
  465997
  466713
  469804
  470068
  470135
  472448
  473266
  477968
  480375
  481576
  481908
  482087
  486828
  488199
  491750
  491873
  494089
  495015
  497062
  497406
  500390
  503933
  506603
  507167
  512857
  515453
  516042
  518308
  518980
  522124
  522507
  522753
  524976
  525775
  525843
  526121
  526398
  526653
  527565
  528464
  529527
  533570
  533818
  533971
  535353
  542226
  543255
  543428
  543821
  544280
  544414
  545739
  546226
  551042
  551617
  553655
  553725
  554655
  557970
  558022
  558032
  559674
  560017
  560879
  565680
  566109
  567493
  571824
  572603
  573276
  573638
  574724
  574739
  574783
  577359
  578912
  582597
  588290
  588971
  590595
  592736
  592821
  595239
  595404
  595712
  602962
  606896
  610054
  618972
  622061
  625116
  626366
  629760
  631875
  637306
  654347
  663789
  664612
  667919
  669640
  672753
  683008
  689133
  689136
  693926
  695828
  780046
]
15.23 ms
(9.27%)
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
  516042
  533818
  535353
  542226
  551042
  553655
  558032
  572603
  544280
  577359
  543428
  544414
  557970
  559674
  566109
  573276
  573638
  574724
  574783
  578912
  654347
  669640
  664612
  672753
  683008
  689133
  689136
  693926
  695828
  553725
  560017
  582597
  592736
  595404
  595712
  622061
  626366
  629760
  631875
  637306
  588290
  595239
  590595
  592821
  625116
  602962
  606896
  610054
  780046
  465815
  400434
  469804
  442898
  465997
  477968
  481576
  421137
  450473
  470068
  486828
  522124
  526398
  525775
  526653
  500390
  503933
  663789
  565680
  482087
  529527
  470135
  560879
  667919
  546226
  588971
  447828
  428092
  473266
  524976
  618972
  551617
  416181
  435104
  446234
  481908
  448921
  455352
  472448
  480375
  495015
  506603
  507167
  518980
  533971
  497406
  512857
  522507
  522753
  526121
  528464
  497062
  515453
  525843
  494089
  518308
  527565
  533570
  462479
  466713
  488199
  491750
  491873
  543255
  558022
  571824
  543821
  545739
  554655
  567493
  574739
]
2.75 ms
(1.67%)
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
  400434
  416181
  421137
  428092
  435104
  442898
  446234
  447828
  448921
  450473
  455352
  462479
  465815
  465997
  466713
  469804
  470068
  470135
  472448
  473266
  477968
  480375
  481576
  481908
  482087
  486828
  488199
  491750
  491873
  494089
  495015
  497062
  497406
  500390
  503933
  506603
  507167
  512857
  515453
  516042
  518308
  518980
  522124
  522507
  522753
  524976
  525775
  525843
  526121
  526398
  526653
  527565
  528464
  529527
  533570
  533818
  533971
  535353
  542226
  543255
  543428
  543821
  544280
  544414
  545739
  546226
  551042
  551617
  553655
  553725
  554655
  557970
  558022
  558032
  559674
  560017
  560879
  565680
  566109
  567493
  571824
  572603
  573276
  573638
  574724
  574739
  574783
  577359
  578912
  582597
  588290
  588971
  590595
  592736
  592821
  595239
  595404
  595712
  602962
  606896
  610054
  618972
  622061
  625116
  626366
  629760
  631875
  637306
  654347
  663789
  664612
  667919
  669640
  672753
  683008
  689133
  689136
  693926
  695828
  780046
]
1.68 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в голов"
]
1.60 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в голову"
]
1.44 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.80%)
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.