Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.67 ms
(78.60%)
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
  558013
  563137
  577735
  577997
  585261
  587725
  588313
  590264
  594912
  596896
  599229
  601952
  602942
  603587
  603836
  606725
  606775
  609263
  609942
  613465
  614193
  614585
  614614
  615147
  615712
  618916
  620901
  624420
  625380
  631740
  631778
  631975
  631976
  631980
  632440
  635633
  637701
  639934
  642697
  698550
  711297
  721369
  725369
  725390
  726744
  727818
  728874
  728961
  729421
  730444
  731803
  733554
  738758
  743380
  744665
  745257
  746158
  746201
  748138
  748151
  748999
  749889
  751094
  753150
  753465
  754948
  759567
  760064
  761086
  761866
  764806
  765156
  769819
  770141
  771874
  772632
  772959
  773609
  775733
  776426
  776468
  776845
  776971
  778243
  778471
  779039
  781999
  782194
  783486
  784117
  784837
  786255
  788879
  789854
  790356
  790493
  791355
  792661
  795497
  796545
  799456
  800568
  802580
  802657
  802750
  802782
  803091
  803398
  804380
  804455
  804748
  807303
  807902
  812510
  812575
  812599
  812604
  812779
  813039
  813061
]
22.97 ms
(14.37%)
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
  558013
  563137
  577735
  577997
  587725
  588313
  590264
  596896
  603836
  606775
  614614
  625380
  631976
  635633
  599229
  601952
  602942
  603587
  606725
  613465
  618916
  624420
  631740
  631975
  631980
  639934
  585261
  594912
  620901
  637701
  609263
  609942
  631778
  776426
  776468
  778243
  778471
  783486
  784117
  786255
  788879
  790356
  791355
  795497
  800568
  802782
  803398
  807303
  812604
  813061
  775733
  776845
  782194
  784837
  789854
  790493
  796545
  799456
  802750
  803091
  804380
  804748
  813039
  725369
  727818
  729421
  748999
  753150
  759567
  761086
  792661
  802580
  802657
  804455
  807902
  812510
  812575
  812599
  812779
  725390
  743380
  745257
  748138
  748151
  753465
  754948
  761866
  764806
  765156
  730444
  746201
  760064
  769819
  773609
  726744
  728874
  728961
  731803
  770141
  771874
  772632
  772959
  733554
  738758
  744665
  746158
  749889
  751094
  614193
  614585
  615147
  615712
  632440
  642697
  698550
  711297
  721369
  776971
  779039
  781999
]
3.77 ms
(2.36%)
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
  558013
  563137
  577735
  577997
  585261
  587725
  588313
  590264
  594912
  596896
  599229
  601952
  602942
  603587
  603836
  606725
  606775
  609263
  609942
  613465
  614193
  614585
  614614
  615147
  615712
  618916
  620901
  624420
  625380
  631740
  631778
  631975
  631976
  631980
  632440
  635633
  637701
  639934
  642697
  698550
  711297
  721369
  725369
  725390
  726744
  727818
  728874
  728961
  729421
  730444
  731803
  733554
  738758
  743380
  744665
  745257
  746158
  746201
  748138
  748151
  748999
  749889
  751094
  753150
  753465
  754948
  759567
  760064
  761086
  761866
  764806
  765156
  769819
  770141
  771874
  772632
  772959
  773609
  775733
  776426
  776468
  776845
  776971
  778243
  778471
  779039
  781999
  782194
  783486
  784117
  784837
  786255
  788879
  789854
  790356
  790493
  791355
  792661
  795497
  796545
  799456
  800568
  802580
  802657
  802750
  802782
  803091
  803398
  804380
  804455
  804748
  807303
  807902
  812510
  812575
  812599
  812604
  812779
  813039
  813061
]
2.26 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red pussy"
]
1.89 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red pussy"
]
1.88 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red pussy"
]

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.