Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.23 ms
(87.34%)
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
  24087
  124519
  150820
  391155
  392391
  414720
  427197
  448656
  468363
  478732
  493170
  522021
  533655
  538899
  543668
  543768
  544809
  545808
  564549
  568013
  578884
  586121
  617430
  618365
  618928
  619203
  626403
  626685
  639037
  643612
  656117
  664585
  668100
  671854
  680245
  683316
  685789
  686721
  697456
  707569
  709239
  709542
  714429
  715037
  715652
  715919
  720282
  723269
  725009
  726129
  726242
  728247
  729074
  732594
  734189
  736231
  737525
  741514
  743944
  744098
  746492
  750101
  750251
  752124
  754065
  755147
  760264
  760906
  761596
  762397
  762758
  762774
  764850
  764963
  765058
  765072
  765073
  765429
  765437
  765718
  766260
  766437
  766673
  766710
  766905
  767790
  772448
  776028
  776029
  776046
  776999
  777575
  778890
  781562
  781568
  782294
  783067
  787318
  788435
  791239
  791482
  791594
  791607
  791794
  792667
  792806
  793867
  794882
  794896
  796884
  798804
  800326
  804810
  809797
  810434
  813747
  813828
]
11.29 ms
(6.79%)
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
  24087
  720282
  743671
  744936
  766260
  781562
  766437
  741514
  752124
  754065
  783067
  568013
  697456
  668100
  683316
  639037
  643612
  725009
  765106
  813747
  792667
  791594
  762758
  794896
  478732
  392391
  656117
  626685
  776029
  762774
  765429
  810434
  626403
  788435
  736231
  764963
  746492
  791607
  533655
  680245
  545808
  776028
  760264
  764850
  737525
  715652
  776999
  781568
  414720
  723269
  765718
  124519
  709542
  813828
  468363
  715037
  778890
  793867
  794882
  776046
  777575
  791239
  791794
  792806
  796884
  804810
  744098
  765058
  765072
  791482
  726242
  750101
  765437
  767790
  729074
  765073
  766710
  743944
  762397
  766905
  772448
  766673
  782294
  787318
  798804
  800326
  809797
  448656
  586121
  707569
  150820
  618365
  493170
  619203
  760906
  714429
  578884
  543668
  686721
  671854
  715919
  685789
  726129
  755147
  522021
  564549
  391155
  538899
  544809
  709239
  732594
  750251
  618928
  734189
  664585
  761596
  617430
  427197
  728247
  543768
]
3.58 ms
(2.15%)
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
  24087
  124519
  150820
  391155
  392391
  414720
  427197
  448656
  468363
  478732
  493170
  522021
  533655
  538899
  543668
  543768
  544809
  545808
  564549
  568013
  578884
  586121
  617430
  618365
  618928
  619203
  626403
  626685
  639037
  643612
  656117
  664585
  668100
  671854
  680245
  683316
  685789
  686721
  697456
  707569
  709239
  709542
  714429
  715037
  715652
  715919
  720282
  723269
  725009
  726129
  726242
  728247
  729074
  732594
  734189
  736231
  737525
  741514
  743944
  744098
  746492
  750101
  750251
  752124
  754065
  755147
  760264
  760906
  761596
  762397
  762758
  762774
  764850
  764963
  765058
  765072
  765073
  765429
  765437
  765718
  766260
  766437
  766673
  766710
  766905
  767790
  772448
  776028
  776029
  776046
  776999
  777575
  778890
  781562
  781568
  782294
  783067
  787318
  788435
  791239
  791482
  791594
  791607
  791794
  792667
  792806
  793867
  794882
  794896
  796884
  798804
  800326
  804810
  809797
  810434
  813747
  813828
]
1.68 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал жен домашн любительск"
]
1.64 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal wife homemade"
]
1.57 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал жен домашн любительск"
]
1.29 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.