Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.84 ms
(87.63%)
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
  395101
  469775
  474588
  476891
  503764
  518230
  522700
  531875
  532899
  534031
  540685
  543755
  547656
  550378
  552689
  552875
  563987
  564322
  565272
  567642
  569853
  574225
  575688
  583229
  583405
  592999
  596584
  597229
  604144
  605677
  606358
  606548
  609808
  618549
  629784
  630388
  631605
  633615
  634562
  636609
  639293
  645007
  645176
  649276
  649585
  650663
  656286
  663408
  664235
  667159
  669279
  675856
  677347
  681208
  682494
  682918
  684669
  686589
  687784
  693184
  698012
  699216
  701526
  702633
  703395
  705200
  707662
  709833
  710620
  714126
  714845
  718700
  720549
  720758
  722563
  722597
  722646
  723411
  733387
  734472
  737334
  744797
  750314
  755403
  760461
  773973
  775348
  777566
  778185
  779476
  781564
  782349
  783104
  783381
  783967
  784597
  785141
  786656
  786658
  787069
  787947
  788128
  789120
  789395
  793919
  795551
  796196
  796886
  796916
  798969
  800410
  801733
  801928
  803342
  804819
  807484
  811276
  811759
  812163
]
12.98 ms
(7.20%)
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
  755403
  395101
  645007
  469775
  476891
  503764
  531875
  532899
  540685
  534031
  518230
  522700
  474588
  550378
  563987
  567642
  543755
  547656
  552689
  565272
  569853
  575688
  574225
  583405
  650663
  664235
  675856
  677347
  682494
  682918
  693184
  702633
  703395
  705200
  718700
  720549
  722563
  722597
  722646
  645176
  649276
  649585
  663408
  680196
  681208
  686589
  701526
  707662
  709833
  710620
  714126
  656286
  667159
  669279
  684669
  687784
  698012
  699216
  714845
  720758
  723411
  552875
  564322
  583229
  592999
  609808
  629784
  630388
  596584
  605677
  606358
  606548
  636609
  639293
  604144
  631605
  633615
  597229
  618549
  634562
  775348
  779476
  781564
  783104
  784597
  785141
  786658
  793919
  796196
  796916
  800410
  801928
  807484
  777566
  778185
  782349
  783967
  787947
  789120
  796886
  803342
  804819
  733387
  734472
  737334
  744797
  750314
  760461
  773973
  783381
  786656
  787069
  788128
  789395
  795551
  798969
  801733
  811276
  811759
  812163
]
2.71 ms
(1.51%)
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
  395101
  469775
  474588
  476891
  503764
  518230
  522700
  531875
  532899
  534031
  540685
  543755
  547656
  550378
  552689
  552875
  563987
  564322
  565272
  567642
  569853
  574225
  575688
  583229
  583405
  592999
  596584
  597229
  604144
  605677
  606358
  606548
  609808
  618549
  629784
  630388
  631605
  633615
  634562
  636609
  639293
  645007
  645176
  649276
  649585
  650663
  656286
  663408
  664235
  667159
  669279
  675856
  677347
  681208
  682494
  682918
  684669
  686589
  687784
  693184
  698012
  699216
  701526
  702633
  703395
  705200
  707662
  709833
  710620
  714126
  714845
  718700
  720549
  720758
  722563
  722597
  722646
  723411
  733387
  734472
  737334
  744797
  750314
  755403
  760461
  773973
  775348
  777566
  778185
  779476
  781564
  782349
  783104
  783381
  783967
  784597
  785141
  786656
  786658
  787069
  787947
  788128
  789120
  789395
  793919
  795551
  796196
  796886
  796916
  798969
  800410
  801733
  801928
  803342
  804819
  807484
  811276
  811759
  812163
]
2.26 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "перв порн"
]
1.64 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "первое порно"
]
1.50 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.19 ms
(0.66%)
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.