Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.44 ms
(82.93%)
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
  395452
  427012
  428609
  433749
  433761
  441077
  446049
  450166
  455745
  456529
  461194
  464512
  469644
  478529
  482064
  482566
  482833
  487636
  505764
  517908
  518317
  521380
  521699
  535037
  544426
  544531
  547657
  549691
  550517
  558539
  562558
  563551
  565672
  565784
  567485
  569320
  571708
  573533
  575017
  575854
  576441
  584045
  587296
  588372
  594246
  594442
  594555
  597634
  599072
  603085
  605369
  606503
  607161
  607481
  612858
  614805
  618768
  623692
  625922
  638000
  643614
  648683
  648776
  662836
  686917
  689804
  692658
  709747
  710308
  712765
  712803
  714484
  718049
  725696
  727087
  727673
  732016
  732169
  732911
  734140
  737995
  740512
  742358
  744061
  747597
  747819
  748337
  748464
  749398
  749520
  751260
  751968
  754137
  756601
  757885
  759554
  760058
  760608
  760626
  761705
  767106
  768812
  776703
  777750
  779769
  780715
  784746
  785849
  787826
  790865
  793070
  793534
  797036
  797954
  798015
  799081
  804448
  805066
  805970
  813177
]
15.52 ms
(10.18%)
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
  804448
  395452
  455745
  482064
  433749
  482833
  450166
  544531
  563551
  712765
  567485
  597634
  607161
  725696
  744061
  751260
  784746
  464512
  478529
  612858
  805066
  732016
  790865
  623692
  594555
  427012
  433761
  518317
  648683
  441077
  428609
  482566
  461194
  469644
  487636
  446049
  456529
  517908
  505764
  521380
  521699
  535037
  544426
  550517
  565672
  565784
  571708
  576441
  549691
  575017
  562558
  569320
  575854
  689804
  692658
  712803
  648776
  710308
  662836
  686917
  714484
  547657
  558539
  573533
  584045
  588372
  594442
  606503
  599072
  607481
  605369
  643614
  587296
  594246
  603085
  614805
  625922
  777750
  779769
  787826
  797036
  798015
  799081
  813177
  727087
  727673
  732169
  734140
  754137
  759554
  761705
  793534
  797954
  805970
  740512
  747819
  748337
  749520
  751968
  760058
  767106
  742358
  747597
  756601
  757885
  768812
  732911
  737995
  748464
  749398
  760608
  760626
  618768
  638000
  709747
  718049
  776703
  780715
  785849
  793070
]
3.03 ms
(1.99%)
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
  395452
  427012
  428609
  433749
  433761
  441077
  446049
  450166
  455745
  456529
  461194
  464512
  469644
  478529
  482064
  482566
  482833
  487636
  505764
  517908
  518317
  521380
  521699
  535037
  544426
  544531
  547657
  549691
  550517
  558539
  562558
  563551
  565672
  565784
  567485
  569320
  571708
  573533
  575017
  575854
  576441
  584045
  587296
  588372
  594246
  594442
  594555
  597634
  599072
  603085
  605369
  606503
  607161
  607481
  612858
  614805
  618768
  623692
  625922
  638000
  643614
  648683
  648776
  662836
  686917
  689804
  692658
  709747
  710308
  712765
  712803
  714484
  718049
  725696
  727087
  727673
  732016
  732169
  732911
  734140
  737995
  740512
  742358
  744061
  747597
  747819
  748337
  748464
  749398
  749520
  751260
  751968
  754137
  756601
  757885
  759554
  760058
  760608
  760626
  761705
  767106
  768812
  776703
  777750
  779769
  780715
  784746
  785849
  787826
  790865
  793070
  793534
  797036
  797954
  798015
  799081
  804448
  805066
  805970
  813177
]
2.14 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "так хочет жена"
]
1.83 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хочет жен"
]
1.77 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.14%)
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.