Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.32 ms
(54.99%)
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
  181068
  395687
  405181
  408675
  418967
  419648
  420267
  420391
  423071
  424506
  425332
  429459
  429797
  430204
  430621
  435922
  436095
  437818
  438095
  447400
  447891
  448260
  451974
  452657
  454107
  455718
  463107
  464466
  466376
  468128
  468446
  468860
  470283
  472252
  472777
  474939
  476785
  478672
  483534
  486678
  486706
  489325
  489353
  490894
  491784
  492829
  493963
  495660
  495738
  496762
  502279
  504323
  504376
  504908
  507563
  512988
  513408
  515334
  515544
  516121
  517092
  520717
  520909
  521551
  522238
  523027
  524855
  526772
  529271
  533978
  537596
  541748
  542784
  544123
  544288
  556025
  556913
  560227
  561944
  564758
  566787
  566960
  574384
  574546
  582269
  595510
  598172
  598920
  603850
  604298
  604476
  605445
  606004
  607919
  608658
  613316
  614273
  614308
  624122
  624247
  624430
  624930
  626136
  661528
  661547
  679387
]
141.42 ms
(36.80%)
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
  181068
  395687
  405181
  408675
  418967
  419648
  420267
  420391
  423071
  424506
  425332
  429459
  429797
  430204
  430621
  435922
  436095
  437818
  438095
  447400
  447891
  448260
  451974
  452657
  454107
  455718
  463107
  464466
  466376
  468128
  468446
  468860
  470283
  472252
  472777
  474939
  476785
  478672
  483534
  486678
  486706
  489325
  489353
  490894
  491784
  492829
  493963
  495660
  495738
  496762
  502279
  504323
  504376
  504908
  507563
  512988
  513408
  515334
  515544
  516121
  517092
  520717
  520909
  521551
  522238
  523027
  524855
  526772
  529271
  533978
  537596
  541748
  542784
  544123
  544288
  556025
  556913
  560227
  561944
  564758
  566787
  566960
  574384
  574546
  582269
  595510
  598172
  598920
  603850
  604298
  604476
  605445
  606004
  607919
  608658
  613316
  614273
  614308
  624122
  624247
  624430
  624930
  626136
  661528
  661547
  679387
]
25.27 ms
(6.58%)
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
  436095
  468860
  561944
  679387
  395687
  405181
  492829
  493963
  429459
  516121
  524855
  447891
  463107
  521551
  513408
  542784
  419648
  455718
  181068
  435922
  452657
  464466
  476785
  424506
  474939
  489325
  512988
  515334
  489353
  507563
  483534
  541748
  495738
  466376
  468128
  544288
  470283
  423071
  526772
  486706
  491784
  430204
  598920
  502279
  418967
  425332
  448260
  490894
  495660
  451974
  582269
  607919
  430621
  454107
  472777
  533978
  556913
  626136
  624122
  429797
  472252
  537596
  504908
  566787
  624247
  624930
  604476
  613316
  606004
  661528
  420267
  437818
  564758
  447400
  438095
  560227
  614308
  408675
  504323
  520909
  420391
  603850
  522238
  504376
  496762
  529271
  661547
  566960
  608658
  595510
  605445
  520717
  468446
  598172
  624430
  515544
  574546
  604298
  486678
  523027
  517092
  556025
  614273
  574384
  544123
  478672
]
1.82 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пухлые больше титьки"
]
1.62 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пухлые сиськ"
]
1.42 ms
(0.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.37%)
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.