Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.75 ms
(84.38%)
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
  992
  392449
  393735
  398907
  408558
  410057
  413195
  419543
  422631
  423015
  431673
  464273
  465168
  468756
  477993
  485197
  486201
  495024
  499891
  501892
  504303
  510464
  522591
  529080
  534178
  536670
  537148
  538891
  541597
  543203
  549267
  552210
  552927
  553889
  556033
  557005
  559145
  565265
  569686
  570050
  570778
  572111
  572382
  574125
  576058
  579480
  589134
  591145
  598431
  609866
  614339
  622394
  624709
  624864
  632969
  644989
  645004
  653496
  654151
  655366
  680177
  684088
  693023
  703510
  721325
  724572
  725403
  730432
  730676
  730788
  733824
  734481
  735985
  737417
  737763
  738222
  742193
  744443
  747650
  748584
  750242
  761071
  775621
  778510
  780808
  785171
  789299
  789313
  790971
  791325
  791748
  794079
  796859
  797573
  801136
  802522
  802560
  807537
  810701
  810843
  814084
  814299
  816214
  816549
  817310
  817623
  817683
  817816
  819047
  820155
  821496
  821578
  821861
  821928
  822167
  822182
  823357
  824921
  825682
]
21.91 ms
(10.29%)
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
  778510
  785171
  791325
  794079
  796859
  797573
  788760
  802522
  802560
  724572
  725403
  730676
  735985
  737417
  738222
  790971
  791748
  801136
  733824
  748584
  737763
  761071
  742193
  744443
  730432
  750242
  609866
  624709
  703510
  775621
  780808
  789299
  789313
  807537
  810843
  419543
  392449
  422631
  410057
  408558
  423015
  645004
  465168
  522591
  464273
  579480
  559145
  576058
  565265
  653496
  680177
  684088
  693023
  598431
  622394
  624864
  589134
  591145
  614339
  810701
  734481
  730788
  747650
  632969
  721325
  477993
  431673
  468756
  499891
  501892
  510464
  534178
  504303
  485197
  569686
  570050
  495024
  393735
  992
  398907
  413195
  814084
  814299
  816214
  817683
  817816
  823357
  644989
  819047
  821578
  816549
  817623
  820155
  821928
  822182
  824921
  817310
  821496
  821861
  822167
  825682
  486201
  536670
  529080
  538891
  537148
  549267
  552927
  553889
  574125
  541597
  543203
  552210
  556033
  557005
  570778
  572111
  572382
  654151
  655366
]
3.05 ms
(1.43%)
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
  992
  392449
  393735
  398907
  408558
  410057
  413195
  419543
  422631
  423015
  431673
  464273
  465168
  468756
  477993
  485197
  486201
  495024
  499891
  501892
  504303
  510464
  522591
  529080
  534178
  536670
  537148
  538891
  541597
  543203
  549267
  552210
  552927
  553889
  556033
  557005
  559145
  565265
  569686
  570050
  570778
  572111
  572382
  574125
  576058
  579480
  589134
  591145
  598431
  609866
  614339
  622394
  624709
  624864
  632969
  644989
  645004
  653496
  654151
  655366
  680177
  684088
  693023
  703510
  721325
  724572
  725403
  730432
  730676
  730788
  733824
  734481
  735985
  737417
  737763
  738222
  742193
  744443
  747650
  748584
  750242
  761071
  775621
  778510
  780808
  785171
  789299
  789313
  790971
  791325
  791748
  794079
  796859
  797573
  801136
  802522
  802560
  807537
  810701
  810843
  814084
  814299
  816214
  816549
  817310
  817623
  817683
  817816
  819047
  820155
  821496
  821578
  821861
  821928
  822167
  822182
  823357
  824921
  825682
]
2.47 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old skinny"
]
2.26 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old худые"
]
2.08 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old худые"
]

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.