Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.71 ms
(55.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "a skinny man"
]
141.62 ms
(37.17%)
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
  23065
  192691
  249773
  395392
  395585
  395895
  400459
  401987
  416288
  416797
  419855
  422978
  422993
  423006
  423023
  425707
  425832
  426159
  429234
  429748
  430057
  430949
  431975
  444935
  445803
  446518
  447247
  451708
  461714
  467225
  468714
  485197
  494820
  501892
  509448
  518330
  534178
  539381
  544349
  544350
  546703
  547389
  549258
  552014
  552599
  552711
  559605
  565545
  565944
  568018
  572611
  573565
  574001
  579950
  585140
  591520
  599406
  601689
  603126
  606124
  606260
  607291
  609866
  610243
  618901
  624238
  646343
  654619
  656361
  656751
  657420
  658014
  658296
  659161
  659642
  663899
  668814
  670038
  670313
  674536
  682600
  685355
  685612
  687187
  694541
  697168
  700541
  702674
  703510
  710959
  719997
  720505
  720766
  721813
  724572
  735985
  737417
  737763
  744443
  748584
  761071
  775621
  789299
  789313
  790971
  797705
  802560
  807537
  810234
  810843
  817035
  817385
  817622
  817630
  817685
  818379
  819993
  820205
  822137
  823534
]
19.21 ms
(5.04%)
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
  400459
  461714
  430949
  468714
  501892
  509448
  534178
  494820
  518330
  485197
  249773
  23065
  192691
  817385
  820205
  817035
  817630
  817685
  817622
  818379
  819993
  822137
  823534
  467225
  539381
  547389
  552599
  573565
  579950
  549258
  565545
  565944
  544349
  544350
  552014
  552711
  559605
  568018
  657420
  659161
  670313
  685355
  685612
  719997
  720505
  646343
  658296
  659642
  663899
  670038
  682600
  694541
  697168
  720766
  654619
  656361
  656751
  658014
  668814
  674536
  687187
  700541
  702674
  710959
  721813
  546703
  572611
  574001
  599406
  603126
  606124
  606260
  591520
  601689
  607291
  624238
  610243
  618901
  797705
  802560
  724572
  735985
  737417
  790971
  810234
  748584
  737763
  761071
  744443
  609866
  703510
  775621
  789299
  789313
  807537
  810843
  395585
  395392
  395895
  401987
  416288
  422978
  422993
  423006
  423023
  425707
  426159
  429748
  419855
  425832
  431975
  444935
  416797
  429234
  430057
  585140
  446518
  447247
  451708
  445803
]
3.42 ms
(0.90%)
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
  23065
  192691
  249773
  395392
  395585
  395895
  400459
  401987
  416288
  416797
  419855
  422978
  422993
  423006
  423023
  425707
  425832
  426159
  429234
  429748
  430057
  430949
  431975
  444935
  445803
  446518
  447247
  451708
  461714
  467225
  468714
  485197
  494820
  501892
  509448
  518330
  534178
  539381
  544349
  544350
  546703
  547389
  549258
  552014
  552599
  552711
  559605
  565545
  565944
  568018
  572611
  573565
  574001
  579950
  585140
  591520
  599406
  601689
  603126
  606124
  606260
  607291
  609866
  610243
  618901
  624238
  646343
  654619
  656361
  656751
  657420
  658014
  658296
  659161
  659642
  663899
  668814
  670038
  670313
  674536
  682600
  685355
  685612
  687187
  694541
  697168
  700541
  702674
  703510
  710959
  719997
  720505
  720766
  721813
  724572
  735985
  737417
  737763
  744443
  748584
  761071
  775621
  789299
  789313
  790971
  797705
  802560
  807537
  810234
  810843
  817035
  817385
  817622
  817630
  817685
  818379
  819993
  820205
  822137
  823534
]
1.93 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые мужчин"
]
1.52 ms
(0.40%)
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.