Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.27 ms
(80.36%)
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
  395144
  399300
  400249
  401799
  403911
  406206
  411623
  417920
  420190
  422169
  429561
  431022
  439574
  439680
  439749
  443780
  444139
  446295
  447959
  448812
  451262
  451476
  451751
  453095
  453099
  454217
  454238
  455197
  457789
  459827
  461025
  462279
  462569
  462709
  463298
  463773
  464282
  465654
  465824
  466003
  466103
  466119
  466213
  466869
  466994
  468834
  468941
  469367
  470287
  471356
  474494
  474529
  474830
  475807
  476251
  476709
  477721
  478372
  479768
  480742
  482289
  482313
  482499
  484432
  484465
  484618
  484653
  484680
  485633
  486111
  486785
  486815
  487758
  489343
  490875
  490920
  490946
  491436
  496505
  498057
  500803
  500912
  504829
  510022
  513976
  517373
  518622
  520002
  520681
  520793
  522314
  523023
  528403
  544493
  549638
  549735
  550233
  555023
  555143
  559061
  559065
  560219
  561484
  563218
  566304
  566370
  567911
  569930
  570068
  573388
  575069
  576074
  576112
  577290
  589708
  599471
  605359
  618949
  621705
  670089
]
24.29 ms
(11.40%)
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
  496505
  504829
  510022
  528403
  487758
  490946
  517373
  523023
  403911
  420190
  482499
  446295
  482289
  463773
  486111
  453099
  466003
  466119
  486815
  500912
  462569
  474529
  559061
  575069
  544493
  549735
  555023
  569930
  567911
  573388
  576074
  401799
  462709
  476251
  411623
  451476
  451751
  454217
  454238
  466213
  422169
  451262
  453095
  455197
  464282
  465654
  469367
  444139
  470287
  500803
  485633
  522314
  484618
  520681
  395144
  406206
  447959
  468834
  559065
  549638
  550233
  555143
  576112
  561484
  570068
  589708
  618949
  605359
  443780
  480742
  400249
  417920
  439680
  463298
  474494
  439574
  439749
  465824
  468941
  431022
  466103
  475807
  479768
  484680
  489343
  490920
  491436
  518622
  520793
  484465
  513976
  520002
  484432
  484653
  486785
  490875
  498057
  466994
  474830
  459827
  476709
  461025
  477721
  577290
  560219
  563218
  566304
  566370
  670089
  599471
  621705
  399300
  482313
  429561
  448812
  462279
  478372
  466869
  471356
  457789
]
9.49 ms
(4.45%)
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
  395144
  399300
  400249
  401799
  403911
  406206
  411623
  417920
  420190
  422169
  429561
  431022
  439574
  439680
  439749
  443780
  444139
  446295
  447959
  448812
  451262
  451476
  451751
  453095
  453099
  454217
  454238
  455197
  457789
  459827
  461025
  462279
  462569
  462709
  463298
  463773
  464282
  465654
  465824
  466003
  466103
  466119
  466213
  466869
  466994
  468834
  468941
  469367
  470287
  471356
  474494
  474529
  474830
  475807
  476251
  476709
  477721
  478372
  479768
  480742
  482289
  482313
  482499
  484432
  484465
  484618
  484653
  484680
  485633
  486111
  486785
  486815
  487758
  489343
  490875
  490920
  490946
  491436
  496505
  498057
  500803
  500912
  504829
  510022
  513976
  517373
  518622
  520002
  520681
  520793
  522314
  523023
  528403
  544493
  549638
  549735
  550233
  555023
  555143
  559061
  559065
  560219
  561484
  563218
  566304
  566370
  567911
  569930
  570068
  573388
  575069
  576074
  576112
  577290
  589708
  599471
  605359
  618949
  621705
  670089
]
2.51 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "возраст"
]
1.96 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "возраст"
]
1.85 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "возраст"
]
1.75 ms
(0.82%)
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.