Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.94 ms
(83.06%)
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
  234584
  382578
  393004
  400878
  403896
  404418
  404644
  417485
  426940
  428716
  441149
  444933
  445135
  445237
  451092
  453018
  454138
  454511
  454566
  454979
  455408
  456049
  456219
  460402
  461606
  464194
  467124
  468043
  468388
  468503
  470154
  470245
  471407
  474061
  474597
  474735
  478589
  478640
  478796
  483413
  485511
  490783
  493584
  496724
  497439
  497470
  497873
  498548
  499382
  501264
  502457
  502714
  503203
  505325
  505889
  507343
  507665
  508284
  509825
  511828
  514152
  514400
  515497
  516693
  519712
  521476
  521792
  522348
  522470
  523886
  524891
  525604
  537051
  543255
  544438
  545637
  546955
  547556
  554949
  554997
  555752
  557544
  558720
  563074
  563164
  563352
  564267
  566819
  567346
  576407
  577372
  577961
  588066
  588146
  590498
  591729
  591812
  591835
  592071
  592355
  592444
  592489
  593577
  593625
  594874
  596368
  596459
  598753
  598932
  604344
  610607
  610712
  611603
  617350
  621523
  621759
  626569
  633607
  677356
  689004
]
18.29 ms
(11.01%)
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
  677356
  554949
  588146
  611603
  633607
  404644
  454138
  464194
  474597
  426940
  445135
  445237
  470245
  519712
  498548
  509825
  496724
  451092
  566819
  591835
  588066
  593577
  593625
  234584
  467124
  478589
  497439
  505325
  521476
  543255
  545637
  544438
  546955
  689004
  592071
  598932
  621759
  591812
  596368
  598753
  626569
  400878
  468388
  455408
  470154
  471407
  474061
  454566
  456049
  428716
  478796
  511828
  514152
  485511
  502714
  503203
  483413
  497470
  514400
  523886
  524891
  454979
  497873
  558720
  577961
  591729
  604344
  521792
  403896
  441149
  454511
  453018
  456219
  461606
  468043
  468503
  499382
  537051
  525604
  501264
  505889
  508284
  576407
  577372
  555752
  563164
  563352
  554997
  596459
  590498
  592355
  621523
  382578
  393004
  444933
  507665
  502457
  507343
  404418
  417485
  617350
  474735
  490783
  478640
  493584
  516693
  515497
  522348
  522470
  460402
  547556
  563074
  564267
  567346
  557544
  592489
  594874
  610712
  592444
  610607
]
3.35 ms
(2.01%)
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
  234584
  382578
  393004
  400878
  403896
  404418
  404644
  417485
  426940
  428716
  441149
  444933
  445135
  445237
  451092
  453018
  454138
  454511
  454566
  454979
  455408
  456049
  456219
  460402
  461606
  464194
  467124
  468043
  468388
  468503
  470154
  470245
  471407
  474061
  474597
  474735
  478589
  478640
  478796
  483413
  485511
  490783
  493584
  496724
  497439
  497470
  497873
  498548
  499382
  501264
  502457
  502714
  503203
  505325
  505889
  507343
  507665
  508284
  509825
  511828
  514152
  514400
  515497
  516693
  519712
  521476
  521792
  522348
  522470
  523886
  524891
  525604
  537051
  543255
  544438
  545637
  546955
  547556
  554949
  554997
  555752
  557544
  558720
  563074
  563164
  563352
  564267
  566819
  567346
  576407
  577372
  577961
  588066
  588146
  590498
  591729
  591812
  591835
  592071
  592355
  592444
  592489
  593577
  593625
  594874
  596368
  596459
  598753
  598932
  604344
  610607
  610712
  611603
  617350
  621523
  621759
  626569
  633607
  677356
  689004
]
1.86 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал лёжа"
]
1.66 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал леж"
]
1.50 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.90%)
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.