Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.99 ms
(86.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
  387285
  387693
  398543
  407423
  411811
  415849
  429492
  443969
  444707
  449699
  456937
  457376
  457946
  460901
  462215
  464046
  464896
  468142
  469502
  471083
  476833
  478215
  495385
  502767
  507606
  512558
  515408
  516807
  518203
  518214
  521401
  524865
  526437
  529842
  532416
  539219
  539851
  542370
  542784
  545125
  550246
  550875
  551822
  552017
  557471
  559358
  561519
  565686
  566659
  567718
  573169
  573519
  577598
  579410
  580128
  582153
  584312
  586411
  587232
  589833
  592933
  595072
  595991
  596324
  601792
  601795
  603061
  603346
  604937
  605990
  606554
  607331
  616843
  617369
  620082
  623399
  633412
  644436
  645528
  651259
  657545
  660431
  661991
  662370
  667328
  669892
  676436
  677748
  677862
  680665
  686768
  689073
  693648
  693806
  695707
  697184
  700042
  701221
  701580
  705317
  707566
  713169
  713298
  717943
  718393
  718517
  719977
  722302
  723458
  812488
  812715
  814147
  814188
  816111
  816124
  817722
  818465
  825843
  825874
  826752
]
16.16 ms
(8.53%)
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
  812488
  812715
  411811
  460901
  464896
  387285
  449699
  515408
  507606
  521401
  524865
  456937
  468142
  502767
  516807
  542784
  580128
  573519
  601792
  407423
  457946
  471083
  478215
  518203
  518214
  512558
  387693
  398543
  444707
  415849
  429492
  443969
  814188
  816124
  825843
  826752
  814147
  816111
  817722
  818465
  825874
  464046
  469502
  457376
  462215
  539219
  539851
  526437
  529842
  495385
  532416
  476833
  550246
  551822
  559358
  561519
  566659
  577598
  579410
  542370
  557471
  567718
  582153
  550875
  552017
  565686
  584312
  645528
  660431
  662370
  677748
  680665
  693648
  701221
  713298
  718393
  723458
  651259
  667328
  676436
  677862
  686768
  689073
  695707
  705317
  707566
  719977
  722302
  657545
  661991
  669892
  693806
  697184
  700042
  701580
  713169
  717943
  718517
  545125
  573169
  589833
  592933
  601795
  603061
  604937
  607331
  616843
  617369
  620082
  644436
  595072
  595991
  603346
  605990
  606554
  623399
  633412
  586411
  587232
  596324
]
2.82 ms
(1.49%)
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
  387285
  387693
  398543
  407423
  411811
  415849
  429492
  443969
  444707
  449699
  456937
  457376
  457946
  460901
  462215
  464046
  464896
  468142
  469502
  471083
  476833
  478215
  495385
  502767
  507606
  512558
  515408
  516807
  518203
  518214
  521401
  524865
  526437
  529842
  532416
  539219
  539851
  542370
  542784
  545125
  550246
  550875
  551822
  552017
  557471
  559358
  561519
  565686
  566659
  567718
  573169
  573519
  577598
  579410
  580128
  582153
  584312
  586411
  587232
  589833
  592933
  595072
  595991
  596324
  601792
  601795
  603061
  603346
  604937
  605990
  606554
  607331
  616843
  617369
  620082
  623399
  633412
  644436
  645528
  651259
  657545
  660431
  661991
  662370
  667328
  669892
  676436
  677748
  677862
  680665
  686768
  689073
  693648
  693806
  695707
  697184
  700042
  701221
  701580
  705317
  707566
  713169
  713298
  717943
  718393
  718517
  719977
  722302
  723458
  812488
  812715
  814147
  814188
  816111
  816124
  817722
  818465
  825843
  825874
  826752
]
2.14 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam mom"
]
1.77 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер mom"
]
1.55 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер mom"
]

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.