Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.99 ms
(88.10%)
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
  390192
  398712
  401820
  402015
  417564
  422286
  424916
  443565
  443619
  446086
  451033
  459580
  459965
  460387
  461693
  462895
  466555
  467599
  468217
  469675
  469689
  470529
  470678
  475945
  476853
  479507
  483403
  483437
  500084
  502136
  504295
  508423
  508854
  510759
  510762
  511597
  512227
  514280
  516662
  520754
  522003
  522640
  523788
  524888
  533678
  533690
  539412
  543412
  543923
  544196
  544766
  545139
  546802
  548757
  549783
  550280
  552005
  552251
  557473
  557937
  557954
  558790
  559629
  560335
  564145
  564390
  565749
  571134
  571373
  572315
  575298
  577690
  579635
  585694
  587661
  588165
  591907
  593853
  595757
  600725
  601507
  602504
  603870
  605525
  606908
  614829
  614830
  619885
  620055
  625089
  625682
  627706
  639219
  642521
  647951
  653601
  669700
  694166
  712631
  714193
  715116
  715518
  730372
  745257
  745906
  748454
  749063
  762468
  765221
  765841
  773965
  784186
  784511
  785394
  790679
  793448
  797871
  798099
  811770
  812564
]
14.04 ms
(7.11%)
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
  605525
  784186
  798099
  784511
  785394
  745906
  749063
  765221
  773965
  614829
  715518
  790679
  462895
  424916
  468217
  469689
  508423
  533690
  500084
  483437
  558790
  575298
  714193
  564145
  593853
  600725
  745257
  762468
  466555
  390192
  398712
  401820
  512227
  564390
  571373
  544766
  647951
  653601
  669700
  588165
  585694
  601507
  602504
  625089
  625682
  627706
  504295
  552005
  524888
  479507
  557954
  587661
  591907
  620055
  470678
  443619
  459965
  446086
  460387
  502136
  510762
  523788
  543923
  545139
  543412
  550280
  571134
  579635
  712631
  546802
  557473
  577690
  642521
  606908
  748454
  639219
  461693
  470529
  508854
  510759
  522640
  422286
  476853
  475945
  516662
  520754
  467599
  560335
  565749
  715116
  603870
  793448
  811770
  797871
  812564
  765841
  730372
  417564
  451033
  511597
  483403
  402015
  522003
  559629
  614830
  619885
  552251
  459580
  694166
  469675
  443565
  533678
  514280
  539412
  544196
  557937
  572315
  549783
  548757
  595757
]
2.75 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
  390192
  398712
  401820
  402015
  417564
  422286
  424916
  443565
  443619
  446086
  451033
  459580
  459965
  460387
  461693
  462895
  466555
  467599
  468217
  469675
  469689
  470529
  470678
  475945
  476853
  479507
  483403
  483437
  500084
  502136
  504295
  508423
  508854
  510759
  510762
  511597
  512227
  514280
  516662
  520754
  522003
  522640
  523788
  524888
  533678
  533690
  539412
  543412
  543923
  544196
  544766
  545139
  546802
  548757
  549783
  550280
  552005
  552251
  557473
  557937
  557954
  558790
  559629
  560335
  564145
  564390
  565749
  571134
  571373
  572315
  575298
  577690
  579635
  585694
  587661
  588165
  591907
  593853
  595757
  600725
  601507
  602504
  603870
  605525
  606908
  614829
  614830
  619885
  620055
  625089
  625682
  627706
  639219
  642521
  647951
  653601
  669700
  694166
  712631
  714193
  715116
  715518
  730372
  745257
  745906
  748454
  749063
  762468
  765221
  765841
  773965
  784186
  784511
  785394
  790679
  793448
  797871
  798099
  811770
  812564
]
1.83 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur friends"
]
1.76 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск friends"
]
1.65 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск friends"
]

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.