Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.50 ms
(85.44%)
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
  86472
  89021
  385355
  395442
  397095
  397398
  405975
  425301
  434317
  435365
  437079
  437444
  443416
  444780
  444986
  447508
  456758
  459379
  460288
  462139
  462284
  462822
  465450
  466232
  466789
  469601
  470342
  470822
  471966
  474050
  476892
  479410
  482059
  483445
  483978
  488381
  490764
  495048
  500622
  500634
  501466
  501690
  502109
  502372
  503966
  505876
  507136
  511475
  513804
  513806
  515264
  517116
  522253
  522331
  524316
  524816
  526870
  528481
  528485
  528516
  530604
  531361
  532131
  533815
  534932
  537983
  538060
  539432
  542605
  556460
  558911
  588842
  595394
  600042
  602244
  628801
  633890
  638505
  641434
  648497
  657256
  668097
  676389
  677581
  695051
  715292
  715952
  721255
  721826
  724814
  726397
  730166
  730547
  730738
  731393
  735307
  736544
  739290
  740096
  741665
  743688
  745723
  745826
  748453
  749485
  753935
  758366
  760868
  762169
  763803
  779590
  795602
  797722
  798277
  811160
  813058
  820321
  824568
  825084
  826240
]
14.24 ms
(8.91%)
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
  795602
  501466
  511475
  532131
  503966
  515264
  462284
  745723
  444780
  460288
  715292
  721826
  600042
  735307
  447508
  470342
  500622
  462139
  507136
  534932
  522253
  533815
  539432
  502109
  502372
  513804
  530604
  537983
  538060
  542605
  695051
  641434
  736544
  395442
  459379
  528516
  437079
  435365
  730738
  741665
  748453
  89021
  444986
  528481
  513806
  465450
  638505
  724814
  760868
  797722
  726397
  385355
  405975
  476892
  488381
  482059
  500634
  501690
  524316
  531361
  633890
  740096
  762169
  753935
  758366
  443416
  437444
  474050
  479410
  397095
  397398
  456758
  471966
  466232
  524816
  517116
  483978
  490764
  495048
  505876
  425301
  824568
  676389
  677581
  648497
  657256
  668097
  715952
  721255
  556460
  558911
  588842
  628801
  595394
  798277
  813058
  749485
  811160
  739290
  743688
  731393
  526870
  820321
  826240
  825084
  763803
  730547
  745826
  730166
  779590
  602244
  434317
  466789
  528485
  483445
  462822
  470822
  522331
  469601
  86472
]
2.36 ms
(1.48%)
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
  86472
  89021
  385355
  395442
  397095
  397398
  405975
  425301
  434317
  435365
  437079
  437444
  443416
  444780
  444986
  447508
  456758
  459379
  460288
  462139
  462284
  462822
  465450
  466232
  466789
  469601
  470342
  470822
  471966
  474050
  476892
  479410
  482059
  483445
  483978
  488381
  490764
  495048
  500622
  500634
  501466
  501690
  502109
  502372
  503966
  505876
  507136
  511475
  513804
  513806
  515264
  517116
  522253
  522331
  524316
  524816
  526870
  528481
  528485
  528516
  530604
  531361
  532131
  533815
  534932
  537983
  538060
  539432
  542605
  556460
  558911
  588842
  595394
  600042
  602244
  628801
  633890
  638505
  641434
  648497
  657256
  668097
  676389
  677581
  695051
  715292
  715952
  721255
  721826
  724814
  726397
  730166
  730547
  730738
  731393
  735307
  736544
  739290
  740096
  741665
  743688
  745723
  745826
  748453
  749485
  753935
  758366
  760868
  762169
  763803
  779590
  795602
  797722
  798277
  811160
  813058
  820321
  824568
  825084
  826240
]
2.01 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой член вебкам"
]
1.67 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член вебкамер"
]
1.43 ms
(0.89%)
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.