Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.77 ms
(84.13%)
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
  39142
  146050
  185567
  384266
  384906
  385548
  388453
  392658
  398221
  401654
  414297
  457307
  459536
  465104
  477561
  479070
  479146
  483640
  483758
  499694
  510510
  512196
  515721
  521351
  525168
  529743
  530823
  531059
  531668
  531689
  532175
  532183
  532279
  532704
  533259
  533269
  533335
  533558
  533666
  535653
  535806
  536079
  536220
  536951
  537027
  537794
  538090
  538116
  538615
  539250
  542697
  543003
  543029
  543244
  546251
  548832
  570902
  626783
  628489
  702443
  706891
  711668
  717939
  719742
  720360
  721069
  721650
  727663
  730625
  730884
  731199
  732164
  733361
  735682
  736744
  737326
  738875
  739882
  742617
  745336
  746530
  747038
  749419
  753538
  755605
  757639
  760173
  760691
  760918
  761718
  809750
  815435
  815764
  815822
  815903
  818704
  818747
  818925
  819709
  819738
  820543
  820638
  820983
  823045
  823133
  825107
  826061
  826116
  826179
  826587
  827098
  828005
  828058
  828382
  828430
  828459
  828462
  828700
]
11.15 ms
(7.52%)
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
  414297
  384266
  185567
  826081
  828462
  465104
  499694
  532175
  546251
  730625
  733361
  738875
  732164
  757639
  459536
  818747
  823105
  823133
  815822
  825107
  826061
  826179
  815903
  818925
  815435
  815764
  826116
  828382
  828058
  828005
  828459
  828430
  457307
  532279
  532704
  533259
  536220
  538615
  521351
  531689
  532183
  533558
  512196
  530823
  531668
  536951
  537027
  537794
  538116
  510510
  533269
  533335
  479146
  543003
  742617
  760918
  727663
  730884
  731199
  755605
  745336
  760691
  717939
  809750
  401654
  392658
  398221
  826587
  827098
  760173
  753538
  388453
  385548
  39142
  819709
  818704
  820543
  820983
  823045
  819738
  820638
  828700
  483640
  477561
  539250
  531059
  533666
  525168
  529743
  535806
  538090
  515721
  535653
  536079
  479070
  483758
  542697
  543244
  543029
  548832
  570902
  721650
  706891
  719742
  702443
  711668
  720360
  721069
  626783
  628489
  737326
  747038
  735682
  736744
  746530
  749419
  739882
  761718
  146050
  384906
]
4.14 ms
(2.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.71 ms
(1.83%)
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
  39142
  146050
  185567
  384266
  384906
  385548
  388453
  392658
  398221
  401654
  414297
  457307
  459536
  465104
  477561
  479070
  479146
  483640
  483758
  499694
  510510
  512196
  515721
  521351
  525168
  529743
  530823
  531059
  531668
  531689
  532175
  532183
  532279
  532704
  533259
  533269
  533335
  533558
  533666
  535653
  535806
  536079
  536220
  536951
  537027
  537794
  538090
  538116
  538615
  539250
  542697
  543003
  543029
  543244
  546251
  548832
  570902
  626783
  628489
  702443
  706891
  711668
  717939
  719742
  720360
  721069
  721650
  727663
  730625
  730884
  731199
  732164
  733361
  735682
  736744
  737326
  738875
  739882
  742617
  745336
  746530
  747038
  749419
  753538
  755605
  757639
  760173
  760691
  760918
  761718
  809750
  815435
  815764
  815822
  815903
  818704
  818747
  818925
  819709
  819738
  820543
  820638
  820983
  823045
  823133
  825107
  826061
  826116
  826179
  826587
  827098
  828005
  828058
  828382
  828430
  828459
  828462
  828700
]
2.01 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член ххх"
]
1.81 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член ххх"
]
1.71 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.