Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.24 ms
(84.94%)
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
  410694
  411984
  419949
  420599
  427082
  428024
  432706
  442542
  443978
  447755
  450228
  454341
  454540
  456287
  456572
  458106
  458794
  461594
  465406
  466286
  469568
  469695
  470088
  472691
  472990
  473973
  474433
  474942
  476902
  477044
  477296
  477395
  479258
  479549
  479572
  482713
  484621
  486506
  487716
  487796
  488877
  490768
  491749
  493268
  497005
  497619
  500362
  500643
  504358
  504574
  507811
  508072
  511684
  512165
  513342
  513435
  513705
  516389
  517180
  519819
  520071
  520885
  522791
  524173
  524399
  524565
  525351
  525600
  527314
  528568
  528855
  533024
  541417
  542946
  545645
  546697
  546901
  547936
  548224
  556920
  558656
  559087
  562951
  563055
  564805
  565511
  565580
  566226
  566284
  567371
  568174
  569408
  573587
  575189
  578388
  582205
  582335
  582352
  589288
  589304
  592730
  597452
  603175
  612066
  615819
  618565
  620059
  630576
  635687
  659181
  661409
  668380
  673957
  703494
  714840
  715520
  716072
  758969
  794956
  795000
]
15.30 ms
(8.71%)
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
  411984
  428024
  461594
  466286
  487796
  517180
  497005
  504574
  508072
  524565
  528855
  504358
  542946
  556920
  582205
  589304
  597452
  589288
  592730
  630576
  635687
  470088
  469695
  458106
  490768
  487716
  512165
  527314
  447755
  458794
  497619
  558656
  567371
  564805
  703494
  546901
  565580
  618565
  620059
  795000
  716072
  794956
  420599
  443978
  472691
  419949
  500643
  491749
  524399
  758969
  500362
  524173
  473973
  476902
  432706
  410694
  525351
  582335
  479549
  472990
  547936
  575189
  578388
  673957
  612066
  427082
  520885
  533024
  488877
  573587
  668380
  582352
  603175
  456287
  477044
  516389
  522791
  482713
  454341
  477296
  519819
  565511
  659181
  559087
  615819
  479572
  456572
  486506
  442542
  493268
  513342
  511684
  520071
  513435
  528568
  563055
  566284
  545645
  568174
  715520
  474942
  474433
  479258
  546697
  569408
  548224
  661409
  714840
  566226
  469568
  450228
  465406
  507811
  513705
  525600
  484621
  454540
  477395
  541417
  562951
]
3.22 ms
(1.84%)
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
  410694
  411984
  419949
  420599
  427082
  428024
  432706
  442542
  443978
  447755
  450228
  454341
  454540
  456287
  456572
  458106
  458794
  461594
  465406
  466286
  469568
  469695
  470088
  472691
  472990
  473973
  474433
  474942
  476902
  477044
  477296
  477395
  479258
  479549
  479572
  482713
  484621
  486506
  487716
  487796
  488877
  490768
  491749
  493268
  497005
  497619
  500362
  500643
  504358
  504574
  507811
  508072
  511684
  512165
  513342
  513435
  513705
  516389
  517180
  519819
  520071
  520885
  522791
  524173
  524399
  524565
  525351
  525600
  527314
  528568
  528855
  533024
  541417
  542946
  545645
  546697
  546901
  547936
  548224
  556920
  558656
  559087
  562951
  563055
  564805
  565511
  565580
  566226
  566284
  567371
  568174
  569408
  573587
  575189
  578388
  582205
  582335
  582352
  589288
  589304
  592730
  597452
  603175
  612066
  615819
  618565
  620059
  630576
  635687
  659181
  661409
  668380
  673957
  703494
  714840
  715520
  716072
  758969
  794956
  795000
]
2.04 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс ноч"
]
2.01 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахнула ночью"
]
1.95 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс ноч"
]
1.95 ms
(1.11%)
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.