Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.60 ms
(85.83%)
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
  16946
  384411
  396194
  396832
  397065
  398882
  413418
  417986
  418871
  447659
  461742
  478357
  480854
  483611
  491701
  491716
  491720
  508221
  533303
  534097
  537959
  538740
  543127
  544805
  569633
  575484
  584287
  585809
  589017
  591164
  592283
  592425
  597132
  597562
  598010
  598360
  598584
  603432
  606365
  606828
  610468
  626501
  626853
  635527
  637254
  638423
  642401
  646076
  648521
  649571
  654086
  654899
  661411
  666562
  668995
  671607
  673696
  683357
  691405
  691738
  693588
  693618
  696227
  702699
  708909
  710863
  715827
  717258
  718191
  718658
  724837
  727293
  727486
  728252
  735085
  740243
  740538
  742715
  743986
  747161
  747447
  751435
  752625
  753809
  761040
  761767
  762792
  764124
  764843
  765424
  767315
  769052
  772960
  777342
  777874
  779695
  779730
  781362
  783047
  784956
  786757
  787323
  789284
  789896
  790586
  793297
  793858
  796309
  799790
  800554
  800761
  800797
  803247
  805523
  811843
  814529
  819111
  825636
  828589
]
14.83 ms
(8.51%)
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
  735085
  747447
  575484
  491701
  751435
  491716
  491720
  543127
  584287
  696227
  606365
  598010
  800554
  767315
  16946
  418871
  819111
  828589
  544805
  691738
  673696
  693588
  715827
  569633
  592283
  592425
  597562
  642401
  597132
  638423
  591164
  606828
  784956
  789896
  790586
  793858
  796309
  787323
  762792
  772960
  781362
  786757
  728252
  740243
  727486
  743986
  761767
  769052
  717258
  721975
  779695
  508221
  398882
  413418
  461742
  447659
  654086
  649571
  708909
  666562
  603432
  598584
  747161
  761040
  718658
  480854
  396194
  397065
  417986
  483611
  384411
  396832
  814529
  825636
  478357
  533303
  534097
  538740
  537959
  654899
  671607
  683357
  702699
  646076
  661411
  691405
  710863
  648521
  668995
  693618
  718191
  585809
  635527
  610468
  589017
  598360
  626501
  626853
  637254
  777342
  777874
  779730
  783047
  793297
  799790
  803247
  789284
  800797
  740538
  752625
  753809
  765424
  800761
  805523
  811843
  724837
  727293
  764843
  742715
  764124
]
2.42 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
  16946
  384411
  396194
  396832
  397065
  398882
  413418
  417986
  418871
  447659
  461742
  478357
  480854
  483611
  491701
  491716
  491720
  508221
  533303
  534097
  537959
  538740
  543127
  544805
  569633
  575484
  584287
  585809
  589017
  591164
  592283
  592425
  597132
  597562
  598010
  598360
  598584
  603432
  606365
  606828
  610468
  626501
  626853
  635527
  637254
  638423
  642401
  646076
  648521
  649571
  654086
  654899
  661411
  666562
  668995
  671607
  673696
  683357
  691405
  691738
  693588
  693618
  696227
  702699
  708909
  710863
  715827
  717258
  718191
  718658
  724837
  727293
  727486
  728252
  735085
  740243
  740538
  742715
  743986
  747161
  747447
  751435
  752625
  753809
  761040
  761767
  762792
  764124
  764843
  765424
  767315
  769052
  772960
  777342
  777874
  779695
  779730
  781362
  783047
  784956
  786757
  787323
  789284
  789896
  790586
  793297
  793858
  796309
  799790
  800554
  800761
  800797
  803247
  805523
  811843
  814529
  819111
  825636
  828589
]
2.08 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen fucking"
]
1.75 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen fucking"
]
1.66 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen fucking"
]

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.