Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
300.82 ms
(55.95%)
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
  16974
  162863
  168687
  375092
  383926
  384196
  384494
  385039
  389262
  392068
  393333
  395689
  396146
  398497
  399224
  399412
  399806
  401751
  402185
  404391
  405730
  407250
  407335
  407492
  408776
  408795
  409732
  410814
  411443
  413999
  419056
  419066
  420651
  426138
  427513
  429583
  437403
  438911
  439470
  441334
  441424
  445136
  446250
  447834
  447970
  448321
  449990
  451292
  453699
  453897
  455073
  455783
  456536
  456635
  458583
  458711
  459092
  460962
  461180
  461676
  462065
  462960
  463735
  466422
  470334
  472349
  474199
  476313
  477569
  479200
  485425
  492145
  494888
  497466
  503536
  506826
  508035
  510901
  514747
  518177
  519847
  524231
  527279
  528336
  528566
  528762
  531265
  533118
  538951
  539098
  540603
  547629
  551522
  551540
  551599
  552956
  558780
  559928
  561476
  565114
  567595
  580267
  582435
  585319
  585864
  588083
  589678
  604885
  627056
  648958
  653786
  665332
  674369
  674637
  675801
  678926
  757713
  796300
  802333
  813316
]
226.61 ms
(42.15%)
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
  458583
  446250
  447970
  528762
  462065
  407335
  384494
  459092
  506826
  396146
  399412
  401751
  405730
  413999
  419056
  466422
  510901
  533118
  460962
  653786
  398497
  474199
  449990
  407492
  427513
  461676
  476313
  463735
  531265
  518177
  462960
  675801
  561476
  567595
  580267
  588083
  453699
  389262
  458711
  445136
  508035
  485425
  514747
  399224
  410814
  477569
  492145
  453897
  547629
  582435
  559928
  558780
  419066
  408795
  383926
  16974
  409732
  420651
  429583
  456635
  447834
  455073
  494888
  539098
  528336
  524231
  528566
  551522
  551599
  552956
  678926
  565114
  796300
  813316
  426138
  407250
  461180
  470334
  472349
  497466
  451292
  456536
  503536
  479200
  437403
  393333
  402185
  404391
  439470
  441424
  648958
  674637
  665332
  674369
  585319
  757713
  627056
  802333
  162863
  399806
  408776
  168687
  395689
  375092
  441334
  438911
  455783
  519847
  540603
  538951
  527279
  551540
  604885
  585864
  589678
  411443
  448321
  384196
  385039
  392068
]
3.82 ms
(0.71%)
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
  16974
  162863
  168687
  375092
  383926
  384196
  384494
  385039
  389262
  392068
  393333
  395689
  396146
  398497
  399224
  399412
  399806
  401751
  402185
  404391
  405730
  407250
  407335
  407492
  408776
  408795
  409732
  410814
  411443
  413999
  419056
  419066
  420651
  426138
  427513
  429583
  437403
  438911
  439470
  441334
  441424
  445136
  446250
  447834
  447970
  448321
  449990
  451292
  453699
  453897
  455073
  455783
  456536
  456635
  458583
  458711
  459092
  460962
  461180
  461676
  462065
  462960
  463735
  466422
  470334
  472349
  474199
  476313
  477569
  479200
  485425
  492145
  494888
  497466
  503536
  506826
  508035
  510901
  514747
  518177
  519847
  524231
  527279
  528336
  528566
  528762
  531265
  533118
  538951
  539098
  540603
  547629
  551522
  551540
  551599
  552956
  558780
  559928
  561476
  565114
  567595
  580267
  582435
  585319
  585864
  588083
  589678
  604885
  627056
  648958
  653786
  665332
  674369
  674637
  675801
  678926
  757713
  796300
  802333
  813316
]
1.83 ms
(0.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член соск"
]
1.68 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хуй соска"
]
1.47 ms
(0.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.27%)
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.