Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.65 ms
(80.12%)
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
  7329
  117073
  119788
  123029
  187289
  282542
  310945
  321814
  374819
  383210
  383980
  384027
  386684
  388685
  388776
  389653
  390388
  390406
  390990
  393284
  394154
  395861
  395978
  396103
  396142
  396222
  396254
  396259
  396685
  396692
  396716
  397054
  397320
  397397
  398909
  401095
  401109
  401303
  401582
  403267
  409048
  447650
  455787
  459999
  468749
  506501
  536245
  554225
  564401
  572020
  577544
  585994
  600358
  603464
  604257
  609238
  627635
  632605
  634536
  634541
  637115
  639809
  640407
  646434
  647955
  649121
  655296
  659400
  664491
  671607
  671649
  672345
  688025
  693186
  695908
  706254
  707314
  712697
  716720
  718542
  719582
  719638
  720164
  720693
  720705
  721153
  728220
  730346
  736286
  743900
  746294
  747516
  748798
  761510
  765770
  766464
  767941
  769070
  769733
  769793
  770334
  777132
  778903
  779750
  784265
  787680
  790518
  790865
  794096
  795858
  799586
  800558
  806044
  809117
  809876
  811077
  814580
  817362
  821380
  823226
]
20.32 ms
(13.06%)
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
  770334
  394154
  7329
  393284
  388776
  383210
  536245
  374819
  627635
  401303
  117073
  321814
  395861
  396142
  823226
  814580
  572020
  655296
  671649
  718542
  766464
  799586
  707314
  790865
  800558
  806044
  388685
  746294
  396259
  817362
  730346
  639809
  778903
  398909
  459999
  712697
  577544
  390406
  721153
  672345
  634541
  728220
  769793
  688025
  719638
  720705
  747516
  695908
  706254
  397397
  395978
  397320
  637115
  632605
  123029
  384027
  396222
  821380
  716720
  664491
  693186
  736286
  748798
  765770
  585994
  468749
  769733
  600358
  646434
  401582
  310945
  761510
  396254
  564401
  401095
  396103
  603464
  403267
  720164
  397054
  671607
  506501
  634536
  554225
  720693
  455787
  386684
  659400
  447650
  396716
  649121
  640407
  777132
  779750
  809117
  784265
  811077
  743900
  719582
  790518
  390990
  282542
  389653
  383980
  795858
  769070
  401109
  409048
  609238
  647955
  767941
  396685
  390388
  396692
  119788
  187289
  604257
  787680
  794096
  809876
]
3.32 ms
(2.14%)
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
  7329
  117073
  119788
  123029
  187289
  282542
  310945
  321814
  374819
  383210
  383980
  384027
  386684
  388685
  388776
  389653
  390388
  390406
  390990
  393284
  394154
  395861
  395978
  396103
  396142
  396222
  396254
  396259
  396685
  396692
  396716
  397054
  397320
  397397
  398909
  401095
  401109
  401303
  401582
  403267
  409048
  447650
  455787
  459999
  468749
  506501
  536245
  554225
  564401
  572020
  577544
  585994
  600358
  603464
  604257
  609238
  627635
  632605
  634536
  634541
  637115
  639809
  640407
  646434
  647955
  649121
  655296
  659400
  664491
  671607
  671649
  672345
  688025
  693186
  695908
  706254
  707314
  712697
  716720
  718542
  719582
  719638
  720164
  720693
  720705
  721153
  728220
  730346
  736286
  743900
  746294
  747516
  748798
  761510
  765770
  766464
  767941
  769070
  769733
  769793
  770334
  777132
  778903
  779750
  784265
  787680
  790518
  790865
  794096
  795858
  799586
  800558
  806044
  809117
  809876
  811077
  814580
  817362
  821380
  823226
]
2.14 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal blowjob"
]
1.84 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал минет оральн секс"
]
1.67 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал минет оральн секс"
]
1.64 ms
(1.06%)
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.