Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.01 ms
(83.26%)
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
  382432
  395235
  395249
  396586
  396816
  401199
  403589
  420023
  422434
  438839
  447111
  501245
  502236
  530824
  542437
  544350
  546434
  549341
  550750
  552613
  552957
  557157
  563964
  564071
  568030
  570444
  571451
  574487
  574829
  586388
  591190
  591520
  603126
  603371
  612230
  622585
  622658
  624371
  629072
  629858
  634819
  651875
  654473
  654499
  654601
  654619
  654670
  655344
  655976
  657050
  657346
  657411
  657705
  658359
  658670
  659314
  659565
  660525
  661249
  662777
  663508
  663899
  664304
  665404
  666614
  670038
  684248
  684326
  696331
  700798
  704865
  714815
  716715
  724105
  727382
  732887
  734239
  742215
  742227
  743335
  745520
  751762
  758304
  764515
  764617
  787949
  789299
  789313
  789543
  793458
  793729
  793732
  797573
  798566
  804169
  804706
  806044
  809174
  810234
  810730
  817145
  817464
  817622
  817883
  819122
  819993
  821468
  821552
  821572
  821817
  822137
  822305
  822406
  823246
  823421
  825462
  825552
]
17.26 ms
(10.19%)
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
  727382
  401199
  591190
  549341
  403589
  557157
  793729
  758304
  822406
  816024
  823421
  764515
  724105
  422434
  651875
  825462
  447111
  396816
  654837
  564071
  716715
  819993
  657705
  570444
  502236
  574487
  438839
  663899
  825552
  823246
  822137
  544350
  655344
  659314
  603126
  788760
  396586
  654473
  742215
  742227
  700798
  821817
  821552
  817145
  659565
  661249
  670038
  654601
  797573
  743335
  793732
  806044
  395235
  789313
  530824
  574829
  657050
  658359
  660525
  654499
  654670
  655976
  657346
  657411
  662777
  664304
  658670
  603371
  789543
  810234
  787949
  810730
  654619
  591520
  684326
  382432
  704865
  764617
  622658
  821572
  501245
  793458
  714815
  817622
  789299
  821468
  666614
  586388
  734239
  629072
  420023
  817883
  552613
  665404
  696331
  550750
  804706
  809174
  634819
  395249
  822305
  817464
  819122
  568030
  571451
  546434
  552957
  563964
  684248
  663508
  612230
  622585
  624371
  629858
  798566
  804169
  732887
  745520
  751762
  542437
]
3.38 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
  382432
  395235
  395249
  396586
  396816
  401199
  403589
  420023
  422434
  438839
  447111
  501245
  502236
  530824
  542437
  544350
  546434
  549341
  550750
  552613
  552957
  557157
  563964
  564071
  568030
  570444
  571451
  574487
  574829
  586388
  591190
  591520
  603126
  603371
  612230
  622585
  622658
  624371
  629072
  629858
  634819
  651875
  654473
  654499
  654601
  654619
  654670
  655344
  655976
  657050
  657346
  657411
  657705
  658359
  658670
  659314
  659565
  660525
  661249
  662777
  663508
  663899
  664304
  665404
  666614
  670038
  684248
  684326
  696331
  700798
  704865
  714815
  716715
  724105
  727382
  732887
  734239
  742215
  742227
  743335
  745520
  751762
  758304
  764515
  764617
  787949
  789299
  789313
  789543
  793458
  793729
  793732
  797573
  798566
  804169
  804706
  806044
  809174
  810234
  810730
  817145
  817464
  817622
  817883
  819122
  819993
  821468
  821552
  821572
  821817
  822137
  822305
  822406
  823246
  823421
  825462
  825552
]
2.18 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебут худую сучку"
]
1.93 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс худая девушк"
]
1.63 ms
(0.96%)
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.