Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.09 ms
(86.70%)
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
  3869
  50258
  72782
  188031
  281095
  384046
  384094
  389788
  392524
  397405
  398579
  401872
  406070
  411279
  413008
  417870
  420389
  421783
  428041
  432573
  441336
  441583
  452217
  454460
  454682
  458564
  465223
  466703
  492755
  494694
  510303
  510878
  516044
  518177
  530298
  530498
  531449
  534180
  534480
  534893
  535900
  538480
  539453
  574967
  624351
  631020
  641189
  641247
  699298
  709102
  713021
  720662
  721260
  724905
  727021
  731051
  731398
  732524
  734059
  734574
  738419
  742497
  742740
  744371
  744376
  744751
  745474
  746105
  746629
  747160
  748355
  750284
  750390
  752025
  752246
  752332
  753980
  754313
  755602
  758924
  760554
  762129
  762344
  763477
  764293
  765419
  766573
  766962
  767240
  768230
  770075
  772031
  773938
  778433
  792503
  792534
  794070
  794098
  795619
  795654
  795730
  797059
  800449
  800817
  804023
  809863
  810307
  810323
  811251
  811622
  811712
  811834
  812452
  812835
  814356
  824689
  828808
]
10.29 ms
(6.96%)
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
  731051
  732524
  738419
  744751
  750390
  752246
  755602
  758924
  767240
  770075
  792503
  792534
  800449
  804023
  811251
  811834
  812835
  744371
  748355
  762344
  731398
  742740
  745474
  747160
  750284
  752025
  754313
  762823
  764293
  746105
  746629
  762129
  763477
  765419
  766573
  766962
  769111
  772031
  773938
  724905
  727021
  734059
  734574
  742497
  744376
  752332
  753980
  760554
  768230
  631020
  641189
  641247
  699298
  709102
  713021
  720662
  721260
  774503
  778433
  794070
  794098
  795619
  795654
  795730
  797059
  800817
  809863
  810307
  810323
  811622
  811712
  812452
  3869
  401872
  397405
  50258
  281095
  494694
  828808
  574967
  624351
  72782
  384046
  384094
  188031
  392524
  389788
  398579
  406070
  417870
  421783
  432573
  441336
  411279
  420389
  441583
  413008
  428041
  814356
  824689
  458564
  465223
  466703
  452217
  454460
  454682
  492755
  534180
  535900
  516044
  518177
  534480
  538480
  510878
  530498
  534893
  510303
  530298
  531449
  539453
]
2.71 ms
(1.84%)
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
  3869
  50258
  72782
  188031
  281095
  384046
  384094
  389788
  392524
  397405
  398579
  401872
  406070
  411279
  413008
  417870
  420389
  421783
  428041
  432573
  441336
  441583
  452217
  454460
  454682
  458564
  465223
  466703
  492755
  494694
  510303
  510878
  516044
  518177
  530298
  530498
  531449
  534180
  534480
  534893
  535900
  538480
  539453
  574967
  624351
  631020
  641189
  641247
  699298
  709102
  713021
  720662
  721260
  724905
  727021
  731051
  731398
  732524
  734059
  734574
  738419
  742497
  742740
  744371
  744376
  744751
  745474
  746105
  746629
  747160
  748355
  750284
  750390
  752025
  752246
  752332
  753980
  754313
  755602
  758924
  760554
  762129
  762344
  763477
  764293
  765419
  766573
  766962
  767240
  768230
  770075
  772031
  773938
  778433
  792503
  792534
  794070
  794098
  795619
  795654
  795730
  797059
  800449
  800817
  804023
  809863
  810307
  810323
  811251
  811622
  811712
  811834
  812452
  812835
  814356
  824689
  828808
]
1.82 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скачать порно жопы"
]
1.71 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скача порн жоп"
]
1.58 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.05%)
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.