Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.24 ms
(84.16%)
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
  3522
  87363
  185247
  282649
  359096
  387501
  387655
  389806
  390426
  390917
  393157
  394509
  395770
  395940
  397062
  398402
  398628
  403393
  412875
  417950
  419926
  452399
  507020
  526144
  527553
  533183
  538792
  542850
  549288
  557792
  563694
  582457
  593606
  593635
  594829
  601683
  607109
  614321
  619847
  620211
  626311
  627910
  628819
  632892
  633009
  643715
  664201
  673337
  675585
  686854
  692150
  700026
  701458
  709357
  712602
  715666
  716600
  716831
  717211
  718459
  723127
  723485
  724403
  726343
  728869
  731407
  746053
  746295
  747150
  750014
  751708
  752446
  752933
  759376
  763274
  764544
  767521
  768241
  768338
  769859
  771512
  775661
  777616
  779318
  780026
  781595
  783066
  786714
  786815
  787468
  787589
  789897
  789905
  790177
  792001
  792338
  793729
  793766
  793964
  797543
  802684
  803447
  805250
  805623
  808837
  810189
  810530
  811190
  811353
  817384
  818013
  818183
  824081
  824919
  824941
  825219
  825455
  825523
  825588
  827094
]
16.76 ms
(9.65%)
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
  716600
  792001
  793729
  787468
  752933
  752446
  633009
  397062
  759376
  389806
  626311
  594829
  810189
  185247
  395770
  3522
  398402
  824941
  825219
  827094
  817384
  818183
  824081
  825588
  818013
  824919
  825455
  825523
  533183
  538792
  527553
  542850
  563694
  673337
  716831
  712602
  718459
  700026
  627910
  614321
  628819
  593635
  780026
  786714
  789905
  793964
  803447
  777616
  797543
  731407
  746295
  767521
  768338
  771512
  787589
  789897
  792338
  810530
  811353
  726343
  747150
  751708
  763274
  746053
  750014
  764544
  768241
  632892
  643715
  701458
  709357
  717211
  781595
  783066
  790177
  802684
  805250
  805623
  87363
  387501
  390426
  395940
  387655
  394509
  723485
  607109
  728869
  715666
  786815
  549288
  620211
  769859
  390917
  359096
  582457
  686854
  692150
  775661
  793766
  811190
  724403
  601683
  619847
  779318
  808837
  398628
  403393
  417950
  412875
  452399
  393157
  282649
  419926
  507020
  526144
  557792
  664201
  675585
  723127
  593606
]
2.52 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "она сосет член"
]
2.45 ms
(1.41%)
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
  3522
  87363
  185247
  282649
  359096
  387501
  387655
  389806
  390426
  390917
  393157
  394509
  395770
  395940
  397062
  398402
  398628
  403393
  412875
  417950
  419926
  452399
  507020
  526144
  527553
  533183
  538792
  542850
  549288
  557792
  563694
  582457
  593606
  593635
  594829
  601683
  607109
  614321
  619847
  620211
  626311
  627910
  628819
  632892
  633009
  643715
  664201
  673337
  675585
  686854
  692150
  700026
  701458
  709357
  712602
  715666
  716600
  716831
  717211
  718459
  723127
  723485
  724403
  726343
  728869
  731407
  746053
  746295
  747150
  750014
  751708
  752446
  752933
  759376
  763274
  764544
  767521
  768241
  768338
  769859
  771512
  775661
  777616
  779318
  780026
  781595
  783066
  786714
  786815
  787468
  787589
  789897
  789905
  790177
  792001
  792338
  793729
  793766
  793964
  797543
  802684
  803447
  805250
  805623
  808837
  810189
  810530
  811190
  811353
  817384
  818013
  818183
  824081
  824919
  824941
  825219
  825455
  825523
  825588
  827094
]
2.35 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс"
]
1.72 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.98%)
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.