Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.21 ms
(88.99%)
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
  7161
  79683
  81571
  108029
  116720
  186993
  236359
  281380
  350980
  372443
  385760
  398710
  411956
  415055
  426395
  432897
  455195
  463808
  467524
  467973
  475957
  477439
  479040
  483112
  484695
  487762
  488423
  497935
  497950
  499910
  503466
  503905
  509684
  511686
  512688
  515371
  517603
  518268
  519013
  519034
  523032
  523996
  527414
  529515
  530457
  531481
  537403
  541207
  541638
  541770
  546786
  554349
  554497
  554835
  555953
  559247
  574396
  578937
  580766
  587963
  588172
  590217
  592723
  592834
  593129
  596786
  596823
  597844
  598954
  605988
  608111
  610880
  620995
  621710
  624430
  627654
  642084
  648497
  651746
  659350
  664562
  671492
  671494
  675182
  678641
  683477
  690744
  691690
  694322
  697596
  697605
  705786
  705874
  709593
  715844
  716725
  729441
  733019
  735362
  736154
  736500
  739898
  763733
  765028
  766041
  768151
  769102
  778837
  782680
  785628
  788101
  790729
  791168
  793314
  794090
  796017
  800565
  801268
  813612
  813955
]
14.50 ms
(6.05%)
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
  477439
  523032
  515371
  108029
  554349
  467524
  530457
  499910
  479040
  484695
  610880
  517603
  593129
  488423
  509684
  523996
  467973
  518268
  813955
  592834
  735362
  519013
  624430
  574396
  651746
  411956
  497950
  546786
  578937
  671494
  736154
  415055
  715844
  791168
  463808
  627654
  642084
  236359
  519034
  541207
  605988
  537403
  765028
  281380
  705786
  675182
  736500
  768151
  683477
  455195
  678641
  559247
  580766
  596786
  554835
  487762
  588172
  739898
  350980
  608111
  598954
  620995
  503466
  555953
  596823
  527414
  531481
  729441
  529515
  497935
  541638
  503905
  664562
  691690
  709593
  597844
  793314
  511686
  766041
  690744
  81571
  512688
  733019
  796017
  186993
  782680
  788101
  398710
  483112
  475957
  587963
  79683
  554497
  716725
  648497
  697596
  671492
  705874
  801268
  778837
  790729
  763733
  769102
  697605
  432897
  541770
  7161
  621710
  592723
  659350
  590217
  785628
  794090
  800565
  385760
  116720
  372443
  426395
  813612
  694322
]
4.09 ms
(1.71%)
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
  7161
  79683
  81571
  108029
  116720
  186993
  236359
  281380
  350980
  372443
  385760
  398710
  411956
  415055
  426395
  432897
  455195
  463808
  467524
  467973
  475957
  477439
  479040
  483112
  484695
  487762
  488423
  497935
  497950
  499910
  503466
  503905
  509684
  511686
  512688
  515371
  517603
  518268
  519013
  519034
  523032
  523996
  527414
  529515
  530457
  531481
  537403
  541207
  541638
  541770
  546786
  554349
  554497
  554835
  555953
  559247
  574396
  578937
  580766
  587963
  588172
  590217
  592723
  592834
  593129
  596786
  596823
  597844
  598954
  605988
  608111
  610880
  620995
  621710
  624430
  627654
  642084
  648497
  651746
  659350
  664562
  671492
  671494
  675182
  678641
  683477
  690744
  691690
  694322
  697596
  697605
  705786
  705874
  709593
  715844
  716725
  729441
  733019
  735362
  736154
  736500
  739898
  763733
  765028
  766041
  768151
  769102
  778837
  782680
  785628
  788101
  790729
  791168
  793314
  794090
  796017
  800565
  801268
  813612
  813955
]
2.64 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в рот как в"
]
1.96 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в рот в"
]
1.68 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.63%)
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.