Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.81 ms
(85.39%)
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
  494861
  499902
  500538
  500916
  504810
  508396
  510882
  513826
  519865
  522433
  522784
  523279
  526794
  527072
  527463
  527928
  530646
  532525
  534595
  539397
  546067
  546429
  546433
  547554
  550782
  557102
  559300
  563686
  577147
  578805
  584040
  584095
  586033
  586981
  587950
  588727
  589298
  589647
  591220
  591719
  591901
  591928
  591956
  598297
  602016
  602526
  604352
  610085
  611559
  612237
  613921
  618147
  621171
  623472
  623732
  624377
  627674
  635012
  636147
  649271
  664497
  665998
  667344
  680216
  689917
  697683
  699291
  709486
  716431
  717035
  718332
  718613
  720345
  720352
  723172
  727782
  730148
  730181
  734585
  736681
  738330
  740611
  744749
  746434
  748613
  748805
  750902
  763350
  767292
  768171
  768577
  768643
  768990
  771918
  771925
  773601
  775244
  775313
  776023
  779859
  780658
  781115
  783869
  784606
  785532
  787665
  791320
  791609
  792577
  792989
  793054
  795196
  795223
  796137
  796181
  797407
  802614
  811174
  812981
  813013
]
11.09 ms
(7.41%)
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
  523279
  519865
  522433
  589647
  610085
  612237
  627674
  785532
  795196
  784606
  723172
  526794
  763350
  508396
  780658
  768643
  744749
  746434
  740611
  768577
  689917
  618147
  499902
  500538
  500916
  504810
  557102
  577147
  591928
  613921
  539397
  546067
  546429
  550782
  716431
  649271
  709486
  563686
  635012
  624377
  802614
  734585
  559300
  602526
  587950
  727782
  771918
  796137
  791320
  797407
  748805
  602016
  792577
  534595
  623472
  598297
  611559
  697683
  664497
  510882
  718332
  720352
  776023
  791609
  736681
  768990
  771925
  527928
  621171
  586981
  513826
  584040
  665998
  578805
  588727
  591719
  591220
  591956
  589298
  795223
  793054
  748613
  730181
  768171
  720345
  813013
  781115
  796181
  811174
  783869
  812981
  787665
  522784
  527463
  527072
  530646
  547554
  680216
  586033
  623732
  604352
  775244
  779859
  730148
  738330
  494861
  667344
  584095
  699291
  718613
  636147
  591901
  750902
  532525
  717035
  546433
  775313
  792989
  767292
  773601
]
2.81 ms
(1.87%)
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
  494861
  499902
  500538
  500916
  504810
  508396
  510882
  513826
  519865
  522433
  522784
  523279
  526794
  527072
  527463
  527928
  530646
  532525
  534595
  539397
  546067
  546429
  546433
  547554
  550782
  557102
  559300
  563686
  577147
  578805
  584040
  584095
  586033
  586981
  587950
  588727
  589298
  589647
  591220
  591719
  591901
  591928
  591956
  598297
  602016
  602526
  604352
  610085
  611559
  612237
  613921
  618147
  621171
  623472
  623732
  624377
  627674
  635012
  636147
  649271
  664497
  665998
  667344
  680216
  689917
  697683
  699291
  709486
  716431
  717035
  718332
  718613
  720345
  720352
  723172
  727782
  730148
  730181
  734585
  736681
  738330
  740611
  744749
  746434
  748613
  748805
  750902
  763350
  767292
  768171
  768577
  768643
  768990
  771918
  771925
  773601
  775244
  775313
  776023
  779859
  780658
  781115
  783869
  784606
  785532
  787665
  791320
  791609
  792577
  792989
  793054
  795196
  795223
  796137
  796181
  797407
  802614
  811174
  812981
  813013
]
2.27 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее кончил внутр…"
]
2.00 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск кремпа сперм"
]
1.86 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск кремпа сперм"
]
1.85 ms
(1.24%)
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.