Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.93 ms
(85.34%)
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
  13492
  190925
  247347
  324395
  388770
  390569
  401053
  401957
  404777
  405505
  407876
  411189
  415734
  417042
  422666
  425014
  426367
  430348
  430377
  435483
  437676
  443594
  443765
  445620
  448733
  452163
  454373
  454886
  455972
  457668
  465611
  466807
  471881
  473247
  476327
  478814
  478949
  482239
  484205
  484624
  486081
  487442
  493097
  493539
  503569
  503895
  504345
  505809
  509317
  511399
  513090
  516320
  518940
  519016
  523901
  526268
  526421
  527980
  529137
  536391
  543854
  547928
  550137
  554911
  556816
  556817
  558077
  558835
  559845
  561380
  563014
  566781
  578412
  580971
  581737
  587161
  588647
  590303
  592438
  594126
  594243
  599997
  600023
  600239
  600432
  601052
  604156
  604782
  604885
  604896
  632267
  644265
  644371
  666830
  687862
  697078
  717731
  717862
  726625
  726956
  727087
  728188
  728232
  728444
  737473
  741615
  759855
  759890
  759896
  770546
  771251
  775774
  775793
  796243
  796250
  801382
  803488
  803495
  805008
  814515
]
17.03 ms
(9.44%)
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
  717731
  687862
  558835
  594126
  600023
  604896
  604156
  604885
  632267
  644265
  587161
  599997
  600432
  594243
  600239
  601052
  805008
  775774
  775793
  803488
  727087
  737473
  759896
  801382
  759890
  726956
  728444
  741615
  771251
  726625
  759855
  473247
  190925
  407876
  437676
  476327
  504345
  529137
  486081
  493539
  425014
  516320
  443765
  519016
  518940
  559845
  543854
  563014
  566781
  411189
  523901
  493097
  484624
  13492
  390569
  401053
  404777
  405505
  814515
  457668
  452163
  448733
  454373
  482239
  505809
  526421
  465611
  466807
  556817
  558077
  580971
  547928
  550137
  578412
  717862
  697078
  556816
  561380
  581737
  588647
  604782
  590303
  592438
  796250
  728232
  770546
  644371
  401957
  443594
  478949
  417042
  422666
  426367
  247347
  430377
  478814
  430348
  435483
  445620
  509317
  511399
  484205
  503895
  536391
  487442
  527980
  415734
  454886
  388770
  471881
  503569
  526268
  455972
  513090
  554911
  324395
  666830
  796243
  803495
  728188
]
2.67 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
  13492
  190925
  247347
  324395
  388770
  390569
  401053
  401957
  404777
  405505
  407876
  411189
  415734
  417042
  422666
  425014
  426367
  430348
  430377
  435483
  437676
  443594
  443765
  445620
  448733
  452163
  454373
  454886
  455972
  457668
  465611
  466807
  471881
  473247
  476327
  478814
  478949
  482239
  484205
  484624
  486081
  487442
  493097
  493539
  503569
  503895
  504345
  505809
  509317
  511399
  513090
  516320
  518940
  519016
  523901
  526268
  526421
  527980
  529137
  536391
  543854
  547928
  550137
  554911
  556816
  556817
  558077
  558835
  559845
  561380
  563014
  566781
  578412
  580971
  581737
  587161
  588647
  590303
  592438
  594126
  594243
  599997
  600023
  600239
  600432
  601052
  604156
  604782
  604885
  604896
  632267
  644265
  644371
  666830
  687862
  697078
  717731
  717862
  726625
  726956
  727087
  728188
  728232
  728444
  737473
  741615
  759855
  759890
  759896
  770546
  771251
  775774
  775793
  796243
  796250
  801382
  803488
  803495
  805008
  814515
]
1.92 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "грудаст зрелая женщин"
]
1.70 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дал грудастой зрелке"
]
1.58 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "грудаст зрелая женщин"
]
1.56 ms
(0.86%)
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.