Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.86 ms
(82.52%)
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
  383604
  386214
  389457
  391885
  392033
  393350
  402788
  409701
  437265
  438010
  438100
  440257
  440749
  456027
  456220
  457885
  459935
  460507
  460782
  461161
  464530
  477213
  478143
  479457
  479498
  484246
  487604
  488937
  492010
  499418
  500277
  501066
  503020
  506315
  506492
  512757
  513520
  526358
  527845
  537021
  537622
  544636
  545896
  546885
  550963
  554101
  554955
  555549
  555670
  555672
  556154
  557596
  558715
  561242
  567862
  573344
  574124
  576744
  582031
  582448
  588862
  593714
  595848
  599805
  599818
  601351
  602712
  609187
  612482
  617710
  622615
  623731
  626841
  627167
  636487
  643636
  645976
  650275
  659065
  660090
  664514
  667406
  691125
  708681
  709900
  713924
  714755
  718703
  721275
  729357
  729897
  729903
  745685
  748134
  748699
  750298
  756914
  760303
  763886
  769573
  773446
  784410
  786040
  796521
  798735
  798852
  801725
  807289
  817214
  817391
  817409
  817470
  817530
  817672
  818808
  819937
  824002
  824943
  825846
  827406
]
15.94 ms
(10.13%)
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
  506492
  818808
  501066
  546885
  437265
  487604
  558715
  555549
  650275
  659065
  660090
  623731
  599805
  807289
  798735
  748699
  461161
  512757
  748134
  478143
  506315
  561242
  786040
  729903
  438010
  643636
  456220
  817672
  817214
  819937
  825846
  691125
  769573
  557596
  721275
  391885
  544636
  588862
  500277
  503020
  545896
  555672
  555670
  582448
  718703
  554101
  593714
  729357
  784410
  617710
  713924
  456027
  386214
  459935
  576744
  567862
  773446
  756914
  817470
  537622
  556154
  595848
  599818
  622615
  460782
  477213
  492010
  664514
  609187
  745685
  763886
  612482
  438100
  393350
  554955
  667406
  402788
  817391
  817409
  824002
  574124
  729897
  827406
  645976
  601351
  798852
  537021
  440257
  409701
  626841
  796521
  824943
  582031
  464530
  499418
  750298
  457885
  573344
  479498
  484246
  383604
  389457
  627167
  392033
  817530
  440749
  714755
  709900
  479457
  526358
  513520
  488937
  527845
  550963
  708681
  636487
  801725
  760303
  602712
  460507
]
3.60 ms
(2.29%)
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
  383604
  386214
  389457
  391885
  392033
  393350
  402788
  409701
  437265
  438010
  438100
  440257
  440749
  456027
  456220
  457885
  459935
  460507
  460782
  461161
  464530
  477213
  478143
  479457
  479498
  484246
  487604
  488937
  492010
  499418
  500277
  501066
  503020
  506315
  506492
  512757
  513520
  526358
  527845
  537021
  537622
  544636
  545896
  546885
  550963
  554101
  554955
  555549
  555670
  555672
  556154
  557596
  558715
  561242
  567862
  573344
  574124
  576744
  582031
  582448
  588862
  593714
  595848
  599805
  599818
  601351
  602712
  609187
  612482
  617710
  622615
  623731
  626841
  627167
  636487
  643636
  645976
  650275
  659065
  660090
  664514
  667406
  691125
  708681
  709900
  713924
  714755
  718703
  721275
  729357
  729897
  729903
  745685
  748134
  748699
  750298
  756914
  760303
  763886
  769573
  773446
  784410
  786040
  796521
  798735
  798852
  801725
  807289
  817214
  817391
  817409
  817470
  817530
  817672
  818808
  819937
  824002
  824943
  825846
  827406
]
2.20 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс жен вмашин"
]
2.01 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахает жену в машине…"
]
1.89 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс жен вмашин"
]
1.87 ms
(1.19%)
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.