Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.19 ms
(84.59%)
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
  10229
  384337
  390525
  403081
  417734
  417735
  432805
  445563
  455841
  456519
  462915
  466209
  474766
  476136
  477253
  484633
  487711
  488298
  491273
  495568
  530496
  534193
  537664
  542209
  545712
  551226
  580592
  585726
  591862
  596198
  598018
  599889
  601922
  602580
  605167
  615561
  615789
  617681
  619857
  625289
  630160
  639825
  642012
  644499
  653559
  654332
  669403
  671350
  671760
  672345
  673969
  674452
  678940
  681523
  681876
  691226
  693356
  694324
  698579
  698859
  704003
  704241
  707738
  713076
  718651
  718687
  718691
  718714
  718719
  719002
  720386
  722267
  722483
  722555
  722583
  722609
  722626
  725113
  725133
  725151
  726608
  727780
  727824
  731874
  733847
  733852
  733887
  735930
  735951
  735968
  737137
  739789
  741306
  743325
  744593
  747457
  748327
  748661
  748706
  748927
  748964
  750187
  752690
  753545
  755334
  755427
  758194
  758959
  758971
  758997
  759960
  761174
  785324
  786768
  790958
  793075
  793673
  811941
  811946
  818291
]
14.97 ms
(8.97%)
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
  718687
  551226
  491273
  818291
  477253
  530496
  673969
  691226
  644499
  785324
  790958
  793673
  725151
  741306
  758194
  758971
  735951
  727824
  748706
  639825
  718691
  718714
  718719
  811941
  384337
  403081
  718651
  693356
  722583
  585726
  602580
  755334
  759960
  733852
  737137
  417734
  534193
  545712
  672345
  704241
  722483
  617681
  733847
  10229
  671350
  719002
  722609
  694324
  698579
  698859
  713076
  596198
  630160
  735968
  811946
  739789
  748327
  753545
  758997
  726608
  748661
  761174
  445563
  653559
  599889
  601922
  417735
  432805
  455841
  456519
  462915
  474766
  476136
  466209
  487711
  495568
  484633
  390525
  537664
  488298
  542209
  669403
  674452
  681876
  707738
  704003
  720386
  722267
  654332
  671760
  678940
  681523
  722555
  722626
  580592
  598018
  625289
  605167
  642012
  591862
  615561
  615789
  619857
  793075
  786768
  725113
  725133
  735930
  748927
  748964
  752690
  755427
  758959
  727780
  733887
  743325
  744593
  747457
  750187
  731874
]
3.34 ms
(2.00%)
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
  10229
  384337
  390525
  403081
  417734
  417735
  432805
  445563
  455841
  456519
  462915
  466209
  474766
  476136
  477253
  484633
  487711
  488298
  491273
  495568
  530496
  534193
  537664
  542209
  545712
  551226
  580592
  585726
  591862
  596198
  598018
  599889
  601922
  602580
  605167
  615561
  615789
  617681
  619857
  625289
  630160
  639825
  642012
  644499
  653559
  654332
  669403
  671350
  671760
  672345
  673969
  674452
  678940
  681523
  681876
  691226
  693356
  694324
  698579
  698859
  704003
  704241
  707738
  713076
  718651
  718687
  718691
  718714
  718719
  719002
  720386
  722267
  722483
  722555
  722583
  722609
  722626
  725113
  725133
  725151
  726608
  727780
  727824
  731874
  733847
  733852
  733887
  735930
  735951
  735968
  737137
  739789
  741306
  743325
  744593
  747457
  748327
  748661
  748706
  748927
  748964
  750187
  752690
  753545
  755334
  755427
  758194
  758959
  758971
  758997
  759960
  761174
  785324
  786768
  790958
  793075
  793673
  811941
  811946
  818291
]
2.00 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting xxx anal"
]
1.96 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг xxx анал"
]
1.72 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг xxx анал"
]

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.