Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.87 ms
(86.64%)
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
  31941
  50537
  63344
  117905
  388135
  416240
  422064
  423982
  438127
  438655
  444187
  447138
  448396
  459472
  459515
  469464
  473129
  473764
  478520
  495172
  499302
  499350
  499941
  504553
  515531
  519158
  530413
  534443
  542423
  544147
  549502
  554699
  555573
  555738
  568803
  577309
  581645
  584355
  585645
  593545
  596144
  596623
  596905
  597435
  604800
  618329
  620219
  628261
  628756
  636587
  636702
  639652
  642995
  650113
  650143
  650928
  659237
  660283
  663293
  675397
  678761
  678924
  679266
  690667
  694751
  699655
  700981
  701968
  702375
  702376
  704662
  706720
  708989
  709061
  713940
  717453
  718817
  719431
  726164
  732567
  736052
  741237
  743184
  749645
  754434
  759115
  759146
  762155
  764414
  770039
  776427
  778448
  780266
  780357
  782305
  782831
  785821
  786932
  787069
  787275
  789054
  791479
  791896
  794082
  802946
  804440
  804937
  805234
  806010
  806468
  807028
  808335
  808540
  809704
  810041
  810390
  811785
  812751
  824102
  826720
]
14.21 ms
(7.95%)
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
  447138
  448396
  459472
  438127
  444187
  473129
  499302
  504553
  495172
  499350
  50537
  63344
  826720
  469464
  581645
  544147
  702376
  650113
  659237
  679266
  701968
  713940
  718817
  660283
  675397
  678761
  690667
  704662
  709061
  719431
  549502
  554699
  555573
  568803
  628261
  618329
  620219
  604800
  639652
  642995
  596905
  780357
  805234
  808335
  776427
  780266
  782831
  806010
  736052
  787069
  794082
  804937
  762155
  754434
  700981
  702375
  791896
  802946
  804440
  807028
  810041
  31941
  759146
  423982
  416240
  459515
  694751
  650928
  585645
  596144
  628756
  778448
  789054
  808540
  810390
  422064
  473764
  478520
  388135
  809704
  596623
  438655
  812751
  732567
  117905
  824102
  519158
  530413
  499941
  515531
  534443
  542423
  584355
  555738
  577309
  706720
  663293
  699655
  708989
  717453
  650143
  678924
  636587
  593545
  597435
  636702
  785821
  806468
  741237
  782305
  786932
  787275
  791479
  811785
  726164
  770039
  759115
  764414
  743184
  749645
]
2.87 ms
(1.61%)
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
  31941
  50537
  63344
  117905
  388135
  416240
  422064
  423982
  438127
  438655
  444187
  447138
  448396
  459472
  459515
  469464
  473129
  473764
  478520
  495172
  499302
  499350
  499941
  504553
  515531
  519158
  530413
  534443
  542423
  544147
  549502
  554699
  555573
  555738
  568803
  577309
  581645
  584355
  585645
  593545
  596144
  596623
  596905
  597435
  604800
  618329
  620219
  628261
  628756
  636587
  636702
  639652
  642995
  650113
  650143
  650928
  659237
  660283
  663293
  675397
  678761
  678924
  679266
  690667
  694751
  699655
  700981
  701968
  702375
  702376
  704662
  706720
  708989
  709061
  713940
  717453
  718817
  719431
  726164
  732567
  736052
  741237
  743184
  749645
  754434
  759115
  759146
  762155
  764414
  770039
  776427
  778448
  780266
  780357
  782305
  782831
  785821
  786932
  787069
  787275
  789054
  791479
  791896
  794082
  802946
  804440
  804937
  805234
  806010
  806468
  807028
  808335
  808540
  809704
  810041
  810390
  811785
  812751
  824102
  826720
]
2.08 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ÐÅ ð┤ÐâÐê ð▓ð░ð¢ð¢ð%ÔǪ"
]
1.82 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац ван ван"
]
1.55 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.75%)
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.