Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.11 ms
(84.19%)
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
  388724
  395706
  396242
  400690
  401985
  402160
  426159
  443729
  446405
  448587
  451595
  453597
  456201
  458305
  463809
  463927
  472179
  473766
  473782
  476808
  486275
  487370
  491286
  514796
  521588
  523544
  529034
  529854
  530697
  533010
  539938
  542217
  544209
  544749
  556911
  565159
  565198
  566516
  574897
  587858
  590830
  596586
  596645
  596991
  597066
  597246
  598067
  598638
  598675
  598723
  603077
  603584
  603951
  605323
  605335
  614095
  620300
  620990
  622518
  623200
  629398
  630266
  630773
  633533
  634499
  636277
  637018
  637139
  639957
  642951
  644404
  645980
  648583
  649569
  667268
  671077
  671626
  678799
  685237
  696219
  699624
  706311
  711273
  712162
  713037
  716027
  718532
  720197
  720813
  721298
  721325
  722443
  728369
  738181
  740596
  741113
  741539
  741889
  744852
  752722
  753448
  758496
  760303
  760991
  761576
  770582
  771203
  775962
  779135
  786768
  791000
  793075
  794154
  797165
  799785
  800225
  800553
  800629
  810701
  812922
]
18.18 ms
(9.87%)
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
  711273
  706311
  722443
  544749
  630773
  642951
  791000
  800629
  771203
  741889
  738181
  712162
  718532
  794154
  800225
  396242
  446405
  565159
  544209
  678799
  667268
  671077
  685237
  699624
  645980
  590830
  636277
  637018
  622518
  639957
  779135
  793075
  800553
  786768
  744852
  770582
  797165
  752722
  760303
  761576
  728369
  753448
  741113
  760991
  644404
  713037
  720813
  401985
  426159
  473782
  458305
  533010
  556911
  587858
  597066
  603584
  614095
  629398
  597246
  605323
  623200
  633533
  603951
  634499
  620990
  812922
  453597
  463927
  473766
  476808
  486275
  521588
  514796
  529854
  648583
  720197
  799785
  388724
  596645
  487370
  542217
  456201
  472179
  539938
  565198
  574897
  598723
  598067
  603077
  463809
  491286
  523544
  443729
  530697
  566516
  671626
  696219
  649569
  716027
  598638
  598675
  637139
  596991
  605335
  620300
  810701
  775962
  758496
  741539
  740596
  630266
  721298
  721325
  395706
  448587
  529034
  451595
  596586
  400690
  402160
]
3.44 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
  388724
  395706
  396242
  400690
  401985
  402160
  426159
  443729
  446405
  448587
  451595
  453597
  456201
  458305
  463809
  463927
  472179
  473766
  473782
  476808
  486275
  487370
  491286
  514796
  521588
  523544
  529034
  529854
  530697
  533010
  539938
  542217
  544209
  544749
  556911
  565159
  565198
  566516
  574897
  587858
  590830
  596586
  596645
  596991
  597066
  597246
  598067
  598638
  598675
  598723
  603077
  603584
  603951
  605323
  605335
  614095
  620300
  620990
  622518
  623200
  629398
  630266
  630773
  633533
  634499
  636277
  637018
  637139
  639957
  642951
  644404
  645980
  648583
  649569
  667268
  671077
  671626
  678799
  685237
  696219
  699624
  706311
  711273
  712162
  713037
  716027
  718532
  720197
  720813
  721298
  721325
  722443
  728369
  738181
  740596
  741113
  741539
  741889
  744852
  752722
  753448
  758496
  760303
  760991
  761576
  770582
  771203
  775962
  779135
  786768
  791000
  793075
  794154
  797165
  799785
  800225
  800553
  800629
  810701
  812922
]
2.23 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old teen anal"
]
1.92 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old teen анал"
]
1.82 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old teen анал"
]

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.