Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.50 ms
(85.00%)
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
  385148
  388805
  397997
  403087
  410331
  413641
  426470
  431639
  445785
  446892
  469305
  470105
  487013
  492427
  492440
  502205
  503757
  506882
  510594
  517693
  522178
  528871
  530742
  533185
  536528
  537872
  538076
  538603
  542880
  544801
  546556
  547028
  555529
  561483
  565031
  565111
  565137
  567083
  567729
  574318
  574706
  576572
  577562
  578433
  580890
  582076
  582465
  587344
  591569
  598338
  602426
  604087
  605184
  607685
  609045
  609696
  618998
  620755
  622459
  622733
  626253
  629387
  631740
  631750
  641982
  642045
  644876
  663263
  668809
  687206
  692963
  700042
  707483
  715688
  715865
  720235
  724401
  724426
  725004
  727326
  730756
  732161
  733708
  736437
  738280
  738371
  745294
  745473
  750078
  750483
  750623
  752147
  757221
  759117
  759139
  760568
  774908
  776084
  781895
  782007
  785023
  788255
  790326
  791961
  792625
  792697
  793592
  797308
  798273
  799409
  802274
  804260
  804314
  804445
  804654
  805952
  805992
  808154
  808740
  811275
]
13.42 ms
(8.88%)
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
  506882
  510594
  530742
  555529
  561483
  604087
  804260
  724401
  804314
  622459
  808154
  598338
  385148
  641982
  792625
  785023
  738280
  760568
  469305
  492427
  567729
  605184
  757221
  759117
  793592
  733708
  752147
  470105
  413641
  644876
  668809
  397997
  602426
  732161
  750623
  542880
  574706
  445785
  538076
  544801
  618998
  781895
  802274
  517693
  582465
  574318
  546556
  797308
  582076
  692963
  776084
  725004
  687206
  745294
  577562
  626253
  609045
  774908
  804445
  782007
  707483
  426470
  431639
  522178
  567083
  576572
  591569
  790326
  745473
  492440
  609696
  805992
  538603
  578433
  587344
  804654
  736437
  759139
  388805
  503757
  727326
  730756
  631750
  533185
  547028
  565137
  798273
  403087
  410331
  663263
  537872
  502205
  565111
  580890
  631740
  607685
  750483
  750078
  620755
  487013
  536528
  700042
  642045
  791961
  738371
  724426
  805952
  528871
  622733
  565031
  720235
  808740
  715688
  792697
  799409
  811275
  788255
  446892
  715865
  629387
]
2.32 ms
(1.54%)
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
  385148
  388805
  397997
  403087
  410331
  413641
  426470
  431639
  445785
  446892
  469305
  470105
  487013
  492427
  492440
  502205
  503757
  506882
  510594
  517693
  522178
  528871
  530742
  533185
  536528
  537872
  538076
  538603
  542880
  544801
  546556
  547028
  555529
  561483
  565031
  565111
  565137
  567083
  567729
  574318
  574706
  576572
  577562
  578433
  580890
  582076
  582465
  587344
  591569
  598338
  602426
  604087
  605184
  607685
  609045
  609696
  618998
  620755
  622459
  622733
  626253
  629387
  631740
  631750
  641982
  642045
  644876
  663263
  668809
  687206
  692963
  700042
  707483
  715688
  715865
  720235
  724401
  724426
  725004
  727326
  730756
  732161
  733708
  736437
  738280
  738371
  745294
  745473
  750078
  750483
  750623
  752147
  757221
  759117
  759139
  760568
  774908
  776084
  781895
  782007
  785023
  788255
  790326
  791961
  792625
  792697
  793592
  797308
  798273
  799409
  802274
  804260
  804314
  804445
  804654
  805952
  805992
  808154
  808740
  811275
]
2.04 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge tits amateur"
]
1.75 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные сиськ любительск"
]
1.62 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные сиськ любительск"
]
1.52 ms
(1.01%)
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.