Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.12 ms
(81.50%)
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
  341041
  362615
  385759
  387610
  394160
  417097
  417240
  417370
  418514
  422274
  426778
  427759
  428516
  432975
  433619
  437836
  441785
  441978
  442069
  442429
  443493
  444208
  445289
  445798
  447001
  454371
  455649
  457198
  458250
  459730
  466871
  468859
  483969
  493755
  494548
  496465
  502934
  508535
  513589
  516160
  523540
  524993
  528526
  528750
  538044
  539145
  539930
  542117
  545131
  548039
  548991
  553975
  559237
  560555
  561282
  562093
  562471
  565833
  568163
  571941
  577625
  578916
  580600
  585330
  585586
  588791
  597786
  605763
  620676
  627619
  628240
  628779
  636713
  639648
  639666
  639669
  643810
  645736
  647809
  655473
  660770
  663721
  667150
  680298
  680453
  704594
  723537
  725779
  729482
  730361
  732500
  746358
  759913
  760301
  764282
  764908
  765341
  765717
  766659
  769102
  773370
  780494
  789435
  790185
  795722
  796935
  797059
  797355
  805179
  805256
  809365
  809826
  809851
  809874
  810107
  812835
  812935
  819178
  825049
]
17.69 ms
(12.01%)
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
  562093
  578916
  565833
  663721
  445798
  362615
  483969
  528526
  493755
  553975
  639648
  639666
  639669
  729482
  645736
  769102
  760301
  387610
  468859
  513589
  568163
  559237
  524993
  680453
  812935
  765341
  796935
  508535
  437836
  454371
  442069
  580600
  627619
  809851
  809826
  764282
  766659
  797355
  466871
  418514
  443493
  455649
  723537
  680298
  417097
  442429
  539145
  502934
  542117
  660770
  667150
  560555
  628240
  730361
  732500
  704594
  428516
  562471
  588791
  620676
  805256
  746358
  457198
  444208
  445289
  545131
  819178
  655473
  561282
  628779
  636713
  643810
  789435
  780494
  795722
  763828
  773370
  790185
  809365
  422274
  427759
  577625
  810107
  528750
  585330
  523540
  516160
  548991
  496465
  605763
  585586
  597786
  812835
  797059
  385759
  394160
  341041
  764908
  805179
  441978
  417240
  432975
  447001
  458250
  459730
  538044
  725779
  426778
  548039
  441785
  433619
  494548
  539930
  571941
  647809
  809874
  759913
  765717
  417370
  825049
]
2.31 ms
(1.57%)
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
  341041
  362615
  385759
  387610
  394160
  417097
  417240
  417370
  418514
  422274
  426778
  427759
  428516
  432975
  433619
  437836
  441785
  441978
  442069
  442429
  443493
  444208
  445289
  445798
  447001
  454371
  455649
  457198
  458250
  459730
  466871
  468859
  483969
  493755
  494548
  496465
  502934
  508535
  513589
  516160
  523540
  524993
  528526
  528750
  538044
  539145
  539930
  542117
  545131
  548039
  548991
  553975
  559237
  560555
  561282
  562093
  562471
  565833
  568163
  571941
  577625
  578916
  580600
  585330
  585586
  588791
  597786
  605763
  620676
  627619
  628240
  628779
  636713
  639648
  639666
  639669
  643810
  645736
  647809
  655473
  660770
  663721
  667150
  680298
  680453
  704594
  723537
  725779
  729482
  730361
  732500
  746358
  759913
  760301
  764282
  764908
  765341
  765717
  766659
  769102
  773370
  780494
  789435
  790185
  795722
  796935
  797059
  797355
  805179
  805256
  809365
  809826
  809851
  809874
  810107
  812835
  812935
  819178
  825049
]
2.22 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov ass doggy"
]
1.78 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов жоп рак"
]
1.73 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.04%)
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.