Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.85 ms
(85.66%)
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
  402116
  412941
  461428
  466761
  468707
  469826
  471595
  479220
  479225
  481025
  483418
  489668
  502082
  506492
  514769
  517607
  522033
  528274
  533690
  533954
  538677
  541134
  543384
  544771
  549148
  552102
  556685
  562428
  568228
  578789
  579749
  583531
  586562
  587689
  588124
  592708
  602995
  603435
  605019
  606999
  608170
  608319
  609516
  612683
  614006
  615137
  616634
  618260
  622758
  622930
  631287
  631356
  634333
  636605
  646012
  646486
  647458
  647915
  648693
  650688
  654303
  659334
  662474
  663562
  666987
  669692
  677919
  684430
  687354
  689229
  690752
  693420
  702134
  702995
  703140
  704722
  705322
  708876
  712290
  713708
  714544
  716709
  717445
  717808
  719524
  728980
  730987
  732816
  734124
  734185
  734598
  734664
  736863
  742687
  745593
  748436
  748441
  749756
  755111
  755918
  757470
  759978
  760317
  761504
  768790
  775542
  789113
  791722
  803242
  803711
  805788
  810319
  819028
  819159
  820113
  823285
  824760
  825578
  826998
  827578
]
15.34 ms
(7.97%)
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
  768790
  708876
  402116
  461428
  466761
  412941
  471595
  514769
  489668
  468707
  469826
  481025
  479220
  533690
  502082
  538677
  517607
  479225
  543384
  568228
  522033
  483418
  506492
  528274
  544771
  646012
  659334
  663562
  705322
  684430
  713708
  556685
  622758
  592708
  586562
  608170
  759978
  760317
  761504
  810319
  736863
  748441
  749756
  728980
  742687
  748436
  755918
  618260
  631287
  823285
  824760
  819028
  826998
  827578
  819159
  820113
  825578
  533954
  549148
  552102
  541134
  579749
  583531
  646486
  647458
  648693
  654303
  669692
  690752
  712290
  717808
  719524
  647915
  666987
  689229
  693420
  703140
  716709
  650688
  662474
  677919
  687354
  702134
  702995
  704722
  714544
  717445
  562428
  578789
  587689
  606999
  612683
  614006
  615137
  602995
  616634
  622930
  588124
  603435
  605019
  608319
  609516
  631356
  634333
  636605
  789113
  791722
  775542
  803242
  730987
  732816
  734124
  734185
  734598
  734664
  745593
  755111
  757470
  803711
  805788
]
4.71 ms
(2.45%)
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
  402116
  412941
  461428
  466761
  468707
  469826
  471595
  479220
  479225
  481025
  483418
  489668
  502082
  506492
  514769
  517607
  522033
  528274
  533690
  533954
  538677
  541134
  543384
  544771
  549148
  552102
  556685
  562428
  568228
  578789
  579749
  583531
  586562
  587689
  588124
  592708
  602995
  603435
  605019
  606999
  608170
  608319
  609516
  612683
  614006
  615137
  616634
  618260
  622758
  622930
  631287
  631356
  634333
  636605
  646012
  646486
  647458
  647915
  648693
  650688
  654303
  659334
  662474
  663562
  666987
  669692
  677919
  684430
  687354
  689229
  690752
  693420
  702134
  702995
  703140
  704722
  705322
  708876
  712290
  713708
  714544
  716709
  717445
  717808
  719524
  728980
  730987
  732816
  734124
  734185
  734598
  734664
  736863
  742687
  745593
  748436
  748441
  749756
  755111
  755918
  757470
  759978
  760317
  761504
  768790
  775542
  789113
  791722
  803242
  803711
  805788
  810319
  819028
  819159
  820113
  823285
  824760
  825578
  826998
  827578
]
2.03 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband big dick"
]
1.92 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband большой большие член"
]
1.84 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband большой большие член"
]
1.76 ms
(0.91%)
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.