Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.27 ms
(84.70%)
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
  385220
  389711
  393585
  395867
  396885
  396994
  408354
  414866
  415568
  420240
  432149
  434055
  443513
  443780
  445889
  453159
  466212
  467036
  468788
  480742
  482335
  491402
  496114
  500467
  504055
  508718
  514470
  518286
  518823
  529524
  533575
  537520
  543242
  544523
  559861
  559880
  560087
  560958
  565747
  566761
  568051
  581482
  606487
  607845
  611339
  612796
  617493
  619449
  623555
  623859
  624238
  628020
  637740
  671335
  682166
  682467
  682571
  685612
  686024
  690771
  699540
  699708
  703834
  706668
  707479
  710054
  712188
  716487
  719342
  722053
  726448
  726725
  726862
  727392
  732236
  733160
  733271
  734117
  737581
  739957
  755312
  772163
  775028
  776632
  781967
  784703
  794698
  795180
  797049
  798764
  800622
  801343
  801531
  801935
  803171
  804162
  804177
  807431
  814336
  814611
  815372
  815468
  815845
  815872
  815888
  816213
  816394
  816618
  817100
  817851
  817883
  818511
  819185
  819773
  820686
  822181
  823502
  826834
  826873
]
13.10 ms
(7.48%)
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
  800622
  803171
  737581
  703834
  414866
  468788
  395867
  445889
  504055
  560958
  544523
  733271
  732236
  518286
  434055
  415568
  443513
  500467
  566761
  432149
  508718
  453159
  467036
  611339
  443780
  480742
  393585
  466212
  529524
  385220
  389711
  396885
  396994
  408354
  420240
  817851
  820686
  822181
  817100
  817883
  818511
  819773
  823502
  826834
  814611
  815372
  815468
  816394
  819185
  814336
  815845
  815872
  815888
  816213
  816618
  826873
  482335
  518823
  533575
  514470
  537520
  496114
  491402
  543242
  559861
  560087
  581482
  568051
  671335
  685612
  716487
  682166
  682571
  690771
  699540
  707479
  719342
  682467
  686024
  706668
  710054
  712188
  559880
  565747
  612796
  619449
  624238
  637740
  607845
  628020
  606487
  623859
  798764
  807431
  794698
  797049
  801935
  804177
  726725
  727392
  733160
  734117
  772851
  795180
  801531
  804162
  726862
  739957
  755312
  726448
  772163
  617493
  623555
  699708
  722053
  775028
  776632
  781967
  784703
  801343
]
4.86 ms
(2.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy licking hairy"
]
3.87 ms
(2.21%)
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
  385220
  389711
  393585
  395867
  396885
  396994
  408354
  414866
  415568
  420240
  432149
  434055
  443513
  443780
  445889
  453159
  466212
  467036
  468788
  480742
  482335
  491402
  496114
  500467
  504055
  508718
  514470
  518286
  518823
  529524
  533575
  537520
  543242
  544523
  559861
  559880
  560087
  560958
  565747
  566761
  568051
  581482
  606487
  607845
  611339
  612796
  617493
  619449
  623555
  623859
  624238
  628020
  637740
  671335
  682166
  682467
  682571
  685612
  686024
  690771
  699540
  699708
  703834
  706668
  707479
  710054
  712188
  716487
  719342
  722053
  726448
  726725
  726862
  727392
  732236
  733160
  733271
  734117
  737581
  739957
  755312
  772163
  775028
  776632
  781967
  784703
  794698
  795180
  797049
  798764
  800622
  801343
  801531
  801935
  803171
  804162
  804177
  807431
  814336
  814611
  815372
  815468
  815845
  815872
  815888
  816213
  816394
  816618
  817100
  817851
  817883
  818511
  819185
  819773
  820686
  822181
  823502
  826834
  826873
]
1.75 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая лиза волосатая"
]
1.45 ms
(0.83%)
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.