Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.29 ms
(82.42%)
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
  12193
  187986
  188561
  223663
  231522
  358849
  381818
  382791
  386037
  386630
  387490
  388318
  391087
  391277
  392208
  392632
  393856
  397113
  397445
  397876
  397881
  398932
  400645
  400826
  400835
  400849
  401203
  402131
  407551
  415843
  421891
  423505
  433359
  437471
  439628
  441774
  443626
  444208
  450243
  451209
  452182
  453686
  457452
  457464
  457895
  471336
  471422
  475224
  477418
  478365
  478374
  480062
  481445
  485638
  486820
  489849
  492631
  493755
  495157
  495852
  499331
  509151
  516028
  517426
  523390
  524134
  528501
  530359
  543123
  543994
  545868
  549568
  549779
  549822
  549828
  549840
  549848
  554235
  555992
  561033
  563641
  566917
  571103
  573728
  579336
  584771
  591130
  591820
  599502
  604332
  698154
  702031
  710282
  714561
  724999
  725188
  727863
  731259
  731345
  733530
  739923
  739927
  742716
  742749
  746682
  750303
  757240
  761025
  761188
  765644
  767058
  784299
  788518
  791602
  794914
  796714
  797348
  800906
  802195
  811702
]
16.21 ms
(10.92%)
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
  727863
  731259
  757240
  739927
  746682
  750303
  765644
  724999
  742716
  742749
  761025
  761188
  788518
  802195
  392208
  388318
  358849
  386630
  188561
  12193
  530359
  223663
  393856
  397113
  441774
  471422
  499331
  545868
  796714
  784299
  794914
  797348
  725188
  767058
  733530
  714561
  231522
  397445
  400645
  451209
  386037
  382791
  187986
  392632
  381818
  443626
  450243
  489849
  457895
  477418
  481445
  492631
  524134
  528501
  495852
  523390
  495157
  517426
  471336
  486820
  543994
  543123
  566917
  702031
  561033
  604332
  591820
  599502
  811702
  791602
  731345
  739923
  698154
  710282
  800906
  387490
  391087
  398932
  400835
  423505
  421891
  444208
  509151
  493755
  516028
  397881
  401203
  407551
  415843
  437471
  485638
  554235
  555992
  579336
  549568
  571103
  573728
  584771
  549779
  549822
  549828
  549840
  549848
  563641
  591130
  400826
  402131
  475224
  478365
  478374
  480062
  391277
  439628
  397876
  400849
  433359
  453686
  457452
  457464
  452182
]
2.93 ms
(1.98%)
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
  12193
  187986
  188561
  223663
  231522
  358849
  381818
  382791
  386037
  386630
  387490
  388318
  391087
  391277
  392208
  392632
  393856
  397113
  397445
  397876
  397881
  398932
  400645
  400826
  400835
  400849
  401203
  402131
  407551
  415843
  421891
  423505
  433359
  437471
  439628
  441774
  443626
  444208
  450243
  451209
  452182
  453686
  457452
  457464
  457895
  471336
  471422
  475224
  477418
  478365
  478374
  480062
  481445
  485638
  486820
  489849
  492631
  493755
  495157
  495852
  499331
  509151
  516028
  517426
  523390
  524134
  528501
  530359
  543123
  543994
  545868
  549568
  549779
  549822
  549828
  549840
  549848
  554235
  555992
  561033
  563641
  566917
  571103
  573728
  579336
  584771
  591130
  591820
  599502
  604332
  698154
  702031
  710282
  714561
  724999
  725188
  727863
  731259
  731345
  733530
  739923
  739927
  742716
  742749
  746682
  750303
  757240
  761025
  761188
  765644
  767058
  784299
  788518
  791602
  794914
  796714
  797348
  800906
  802195
  811702
]
1.98 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy mature"
]
1.75 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак mature"
]
1.72 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак mature"
]
1.51 ms
(1.02%)
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.