Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.43 ms
(85.14%)
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
  207631
  391324
  393881
  394263
  397680
  413224
  426738
  437949
  449972
  452464
  455361
  455963
  458247
  458278
  462086
  463239
  470000
  472314
  472994
  476509
  477042
  479174
  479587
  483675
  484221
  484281
  485058
  486117
  487679
  489459
  490979
  491112
  491626
  492372
  492968
  493437
  494597
  494972
  495244
  495980
  496422
  496668
  499366
  499697
  500552
  501351
  503504
  506271
  506473
  506627
  506785
  507805
  508680
  509189
  510303
  512497
  512605
  512842
  513527
  518432
  518461
  519178
  519338
  521400
  522021
  522631
  522719
  522742
  522950
  524426
  524889
  525406
  526681
  527266
  528505
  529329
  529491
  529845
  529850
  530078
  530193
  532200
  532293
  532298
  534022
  535200
  535247
  535476
  535801
  536166
  536476
  536880
  537095
  537281
  537499
  537817
  538529
  539342
  539357
  539361
  539485
  540396
  543369
  543683
  543916
  584504
  601747
  606082
  620828
  630454
  698711
  713462
  723630
  731364
  740175
  757934
  761192
  761695
  768960
  826243
]
12.71 ms
(8.23%)
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
  620828
  606082
  630454
  761695
  757934
  740175
  761192
  768960
  698711
  455361
  455963
  506271
  484221
  529329
  529491
  528505
  535801
  532298
  535247
  536166
  584504
  479174
  524426
  413224
  519338
  540396
  518432
  522719
  530193
  522742
  538529
  491626
  543369
  513527
  207631
  500552
  506785
  731364
  713462
  426738
  494597
  490979
  394263
  470000
  496422
  522021
  458247
  477042
  493437
  483675
  463239
  484281
  489459
  508680
  512842
  522631
  537281
  539342
  496668
  501351
  512605
  524889
  506473
  532200
  536880
  499366
  510303
  521400
  472994
  487679
  601747
  479587
  486117
  522950
  506627
  495980
  462086
  495244
  503504
  492968
  437949
  458278
  472314
  509189
  393881
  391324
  397680
  723630
  826243
  452464
  492372
  449972
  485058
  491112
  476509
  518461
  529845
  534022
  535200
  536476
  507805
  532293
  537095
  539485
  526681
  527266
  529850
  535476
  537499
  539361
  494972
  499697
  512497
  519178
  525406
  530078
  537817
  539357
  543683
  543916
]
2.69 ms
(1.74%)
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
  207631
  391324
  393881
  394263
  397680
  413224
  426738
  437949
  449972
  452464
  455361
  455963
  458247
  458278
  462086
  463239
  470000
  472314
  472994
  476509
  477042
  479174
  479587
  483675
  484221
  484281
  485058
  486117
  487679
  489459
  490979
  491112
  491626
  492372
  492968
  493437
  494597
  494972
  495244
  495980
  496422
  496668
  499366
  499697
  500552
  501351
  503504
  506271
  506473
  506627
  506785
  507805
  508680
  509189
  510303
  512497
  512605
  512842
  513527
  518432
  518461
  519178
  519338
  521400
  522021
  522631
  522719
  522742
  522950
  524426
  524889
  525406
  526681
  527266
  528505
  529329
  529491
  529845
  529850
  530078
  530193
  532200
  532293
  532298
  534022
  535200
  535247
  535476
  535801
  536166
  536476
  536880
  537095
  537281
  537499
  537817
  538529
  539342
  539357
  539361
  539485
  540396
  543369
  543683
  543916
  584504
  601747
  606082
  620828
  630454
  698711
  713462
  723630
  731364
  740175
  757934
  761192
  761695
  768960
  826243
]
2.08 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.08 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife white sperm"
]
1.85 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен white сперм"
]
1.53 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен white сперм"
]

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.