Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.93 ms
(83.01%)
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
  339821
  382777
  383051
  384789
  386205
  386314
  393723
  393758
  393765
  393777
  394240
  397208
  398805
  400442
  400453
  400471
  402257
  403496
  408745
  413114
  416965
  418407
  418495
  429342
  430286
  430287
  430289
  432136
  445037
  446886
  447705
  453248
  464277
  464315
  464317
  464322
  466154
  467324
  471518
  480437
  484129
  484956
  488302
  488324
  488330
  488361
  491790
  511018
  515116
  515120
  515179
  515185
  515190
  515195
  515200
  515219
  515245
  515252
  515254
  520716
  520718
  520720
  523008
  525117
  528342
  529117
  548581
  550442
  550612
  551425
  558066
  559044
  566515
  566534
  568600
  569661
  569667
  569684
  569688
  578464
  585997
  587902
  597807
  605467
  610576
  624858
  638482
  644697
  665226
  665502
  669436
  670566
  682539
  693073
  700547
  700654
  701345
  714432
  714480
  722654
  722916
  733172
  743120
  743134
  744298
  744319
  744329
  755219
  759563
  759585
  759600
  759656
  759658
  759662
  778614
  789038
  789300
  823152
  823802
  825184
]
17.14 ms
(11.12%)
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
  569667
  823802
  515254
  789038
  759600
  605467
  550442
  393758
  701345
  408745
  464277
  548581
  669436
  525117
  480437
  429342
  466154
  559044
  515252
  430287
  491790
  568600
  644697
  430286
  418407
  393777
  551425
  515195
  529117
  566534
  569684
  393723
  402257
  418495
  520718
  515116
  488330
  515190
  386205
  382777
  400471
  403496
  430289
  464315
  558066
  578464
  665226
  566515
  585997
  733172
  714432
  400453
  467324
  394240
  471518
  488361
  484956
  825184
  759585
  520720
  515200
  432136
  400442
  416965
  700547
  624858
  744329
  722916
  445037
  488302
  515219
  515179
  714480
  464322
  446886
  464317
  520716
  569661
  693073
  638482
  587902
  610576
  778614
  743120
  743134
  413114
  484129
  823152
  515245
  665502
  722654
  759656
  759662
  744298
  339821
  523008
  528342
  759563
  515185
  453248
  550612
  789300
  386314
  383051
  384789
  700654
  398805
  397208
  488324
  447705
  511018
  515120
  569688
  670566
  682539
  597807
  744319
  755219
  759658
  393765
]
2.58 ms
(1.68%)
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
  339821
  382777
  383051
  384789
  386205
  386314
  393723
  393758
  393765
  393777
  394240
  397208
  398805
  400442
  400453
  400471
  402257
  403496
  408745
  413114
  416965
  418407
  418495
  429342
  430286
  430287
  430289
  432136
  445037
  446886
  447705
  453248
  464277
  464315
  464317
  464322
  466154
  467324
  471518
  480437
  484129
  484956
  488302
  488324
  488330
  488361
  491790
  511018
  515116
  515120
  515179
  515185
  515190
  515195
  515200
  515219
  515245
  515252
  515254
  520716
  520718
  520720
  523008
  525117
  528342
  529117
  548581
  550442
  550612
  551425
  558066
  559044
  566515
  566534
  568600
  569661
  569667
  569684
  569688
  578464
  585997
  587902
  597807
  605467
  610576
  624858
  638482
  644697
  665226
  665502
  669436
  670566
  682539
  693073
  700547
  700654
  701345
  714432
  714480
  722654
  722916
  733172
  743120
  743134
  744298
  744319
  744329
  755219
  759563
  759585
  759600
  759656
  759658
  759662
  778614
  789038
  789300
  823152
  823802
  825184
]
1.82 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дед и молодая порно"
]
1.64 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый молодая девушк порн"
]
1.58 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.92%)
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.