Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.71 ms
(86.88%)
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
  385057
  416472
  417497
  426549
  426944
  445473
  447445
  448250
  449208
  453329
  458222
  461461
  461620
  461795
  463910
  466415
  473472
  473748
  479798
  480434
  483555
  484051
  487168
  487975
  498423
  503617
  507688
  507965
  508189
  510704
  511465
  515333
  517229
  520739
  521537
  524504
  524639
  525243
  526033
  526589
  527626
  527867
  533686
  552160
  557422
  557888
  558856
  560107
  560587
  561664
  565189
  565191
  569147
  570054
  573296
  575505
  576689
  577897
  586688
  591073
  593729
  598150
  598246
  599467
  601454
  604715
  607385
  610317
  615440
  617030
  622371
  623086
  623450
  630802
  653519
  656358
  659418
  661691
  663448
  675156
  680200
  688450
  710891
  714816
  716628
  716710
  729440
  730607
  731475
  736850
  746318
  747177
  751229
  759002
  765154
  765393
  769088
  776377
  777628
  777940
  779328
  781569
  783052
  783641
  784381
  785287
  786145
  786319
  788480
  789726
  790129
  790701
  793446
  800026
  807339
  808255
  816146
  819452
  821582
  822886
]
14.73 ms
(7.63%)
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
  716710
  463910
  515333
  524639
  586688
  416472
  507965
  716628
  731475
  473472
  557422
  448250
  458222
  788480
  557888
  617030
  466415
  630802
  807339
  746318
  576689
  776377
  786145
  808255
  525243
  751229
  623450
  822886
  819452
  816146
  821582
  533686
  656358
  661691
  688450
  790129
  779328
  765154
  784381
  747177
  765393
  800026
  385057
  445473
  461620
  498423
  524504
  560107
  565189
  570054
  577897
  560587
  569147
  598246
  622371
  623086
  447445
  461795
  487168
  527626
  714816
  527867
  680200
  659418
  604715
  785287
  736850
  675156
  517229
  793446
  729440
  710891
  786319
  789726
  790701
  783052
  783641
  759002
  769088
  781569
  730607
  599467
  453329
  777628
  503617
  552160
  484051
  598150
  520739
  565191
  593729
  479798
  663448
  417497
  521537
  601454
  483555
  653519
  607385
  449208
  508189
  610317
  615440
  777940
  507688
  461461
  426549
  473748
  526589
  526033
  487975
  575505
  558856
  573296
  561664
  591073
  426944
  480434
  511465
  510704
]
3.66 ms
(1.90%)
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
  385057
  416472
  417497
  426549
  426944
  445473
  447445
  448250
  449208
  453329
  458222
  461461
  461620
  461795
  463910
  466415
  473472
  473748
  479798
  480434
  483555
  484051
  487168
  487975
  498423
  503617
  507688
  507965
  508189
  510704
  511465
  515333
  517229
  520739
  521537
  524504
  524639
  525243
  526033
  526589
  527626
  527867
  533686
  552160
  557422
  557888
  558856
  560107
  560587
  561664
  565189
  565191
  569147
  570054
  573296
  575505
  576689
  577897
  586688
  591073
  593729
  598150
  598246
  599467
  601454
  604715
  607385
  610317
  615440
  617030
  622371
  623086
  623450
  630802
  653519
  656358
  659418
  661691
  663448
  675156
  680200
  688450
  710891
  714816
  716628
  716710
  729440
  730607
  731475
  736850
  746318
  747177
  751229
  759002
  765154
  765393
  769088
  776377
  777628
  777940
  779328
  781569
  783052
  783641
  784381
  785287
  786145
  786319
  788480
  789726
  790129
  790701
  793446
  800026
  807339
  808255
  816146
  819452
  821582
  822886
]
1.89 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс сперм косичк"
]
1.85 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет сперма с косичками"
]
1.68 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.78%)
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.