Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.29 ms
(88.03%)
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
  129748
  407681
  427361
  435743
  461139
  465289
  488385
  489011
  489266
  489327
  490638
  492968
  499751
  500700
  501408
  504009
  504018
  506711
  507214
  514945
  521598
  523294
  524233
  525187
  526327
  528280
  529467
  529927
  530193
  534974
  538492
  539349
  540396
  540719
  541015
  541127
  541536
  542244
  543931
  544619
  545023
  545738
  548373
  548421
  549572
  555482
  555700
  557836
  558320
  562971
  568021
  571953
  574950
  577568
  577663
  578181
  578521
  579576
  579873
  580652
  581654
  582401
  584110
  584361
  585873
  588416
  591561
  591945
  593389
  595182
  595224
  598349
  598362
  599422
  601038
  605454
  605598
  606276
  609042
  609998
  611418
  616661
  618208
  619358
  625217
  626545
  627326
  628141
  628630
  628901
  630718
  644201
  645132
  645706
  649056
  654465
  662584
  662826
  671936
  674041
  678593
  681797
  684504
  684555
  686079
  706693
  721230
  725227
  733946
  743952
  759694
  761305
  763996
  770965
  773928
  779216
  785299
  790319
  793657
  805341
]
11.19 ms
(6.83%)
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
  580652
  595224
  504009
  555482
  628901
  605454
  645706
  684504
  544619
  558320
  574950
  628630
  562971
  492968
  545023
  585873
  785299
  555700
  662584
  678593
  684555
  706693
  611418
  618208
  779216
  793657
  805341
  725227
  733946
  761305
  763996
  759694
  770965
  407681
  541536
  542244
  630718
  129748
  489266
  523294
  584110
  548373
  568021
  681797
  625217
  488385
  499751
  540396
  530193
  529467
  686079
  601038
  773928
  490638
  541015
  609042
  598362
  595182
  605598
  627326
  514945
  529927
  616661
  524233
  581654
  582401
  649056
  721230
  790319
  557836
  578521
  671936
  743952
  579576
  427361
  465289
  674041
  489327
  528280
  662826
  507214
  598349
  521598
  628141
  501408
  654465
  591945
  500700
  489011
  534974
  571953
  619358
  545738
  435743
  591561
  525187
  539349
  504018
  538492
  577663
  584361
  577568
  579873
  609998
  644201
  593389
  626545
  543931
  506711
  549572
  588416
  526327
  645132
  578181
  599422
  540719
  548421
  606276
  461139
  541127
]
2.44 ms
(1.49%)
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
  129748
  407681
  427361
  435743
  461139
  465289
  488385
  489011
  489266
  489327
  490638
  492968
  499751
  500700
  501408
  504009
  504018
  506711
  507214
  514945
  521598
  523294
  524233
  525187
  526327
  528280
  529467
  529927
  530193
  534974
  538492
  539349
  540396
  540719
  541015
  541127
  541536
  542244
  543931
  544619
  545023
  545738
  548373
  548421
  549572
  555482
  555700
  557836
  558320
  562971
  568021
  571953
  574950
  577568
  577663
  578181
  578521
  579576
  579873
  580652
  581654
  582401
  584110
  584361
  585873
  588416
  591561
  591945
  593389
  595182
  595224
  598349
  598362
  599422
  601038
  605454
  605598
  606276
  609042
  609998
  611418
  616661
  618208
  619358
  625217
  626545
  627326
  628141
  628630
  628901
  630718
  644201
  645132
  645706
  649056
  654465
  662584
  662826
  671936
  674041
  678593
  681797
  684504
  684555
  686079
  706693
  721230
  725227
  733946
  743952
  759694
  761305
  763996
  770965
  773928
  779216
  785299
  790319
  793657
  805341
]
1.67 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в вагин"
]
1.56 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "спермы в киске"
]
1.42 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в вагин"
]
1.35 ms
(0.82%)
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.