Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.28 ms
(84.83%)
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
  401904
  410807
  412875
  414292
  417934
  419063
  420418
  428487
  435515
  435958
  437789
  438987
  443269
  446611
  446678
  448744
  452477
  453614
  453669
  454396
  457308
  458285
  458427
  462724
  469648
  473939
  476478
  476553
  485229
  485996
  486802
  486892
  489594
  496013
  496910
  504488
  504837
  507017
  508519
  513198
  513351
  513384
  513757
  514005
  516060
  519505
  519701
  520035
  522453
  522521
  523977
  524509
  526274
  526280
  533138
  536889
  538022
  542526
  544102
  551564
  558418
  561067
  562147
  565251
  565283
  567041
  567358
  574162
  575178
  578512
  578812
  582243
  582270
  584748
  587292
  588281
  589202
  589407
  592854
  596643
  598201
  600978
  601887
  605989
  606225
  611559
  613558
  619286
  619535
  620818
  621729
  623334
  623930
  624802
  626388
  627419
  643660
  650955
  666816
  676808
  697006
  705160
  720047
  721895
  744844
  747649
  760169
  761602
  766625
  771845
  788252
  788566
  788886
  789583
  790019
  792018
  794214
  805439
  806247
  813346
]
20.90 ms
(10.17%)
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
  705160
  666816
  676808
  720047
  721895
  567041
  578512
  582243
  582270
  589407
  592854
  598201
  619286
  606225
  624802
  589202
  613558
  587292
  627419
  643660
  792018
  805439
  788252
  788566
  806247
  813346
  760169
  789583
  744844
  747649
  761602
  771845
  620818
  410807
  443269
  448744
  453614
  457308
  469648
  417934
  420418
  446678
  473939
  401904
  412875
  419063
  437789
  446611
  458285
  476478
  476553
  435958
  438987
  454396
  462724
  513198
  522453
  533138
  538022
  513351
  489594
  496013
  514005
  519505
  520035
  522521
  486892
  496910
  504837
  513384
  524509
  428487
  414292
  435515
  458427
  486802
  507017
  526274
  513757
  508519
  516060
  504488
  519701
  523977
  526280
  536889
  485229
  485996
  542526
  544102
  565283
  551564
  558418
  567358
  574162
  562147
  575178
  584748
  650955
  697006
  561067
  565251
  578812
  588281
  600978
  626388
  623930
  596643
  605989
  601887
  619535
  788886
  790019
  794214
  766625
  611559
  621729
  623334
  452477
  453669
]
3.21 ms
(1.56%)
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
  401904
  410807
  412875
  414292
  417934
  419063
  420418
  428487
  435515
  435958
  437789
  438987
  443269
  446611
  446678
  448744
  452477
  453614
  453669
  454396
  457308
  458285
  458427
  462724
  469648
  473939
  476478
  476553
  485229
  485996
  486802
  486892
  489594
  496013
  496910
  504488
  504837
  507017
  508519
  513198
  513351
  513384
  513757
  514005
  516060
  519505
  519701
  520035
  522453
  522521
  523977
  524509
  526274
  526280
  533138
  536889
  538022
  542526
  544102
  551564
  558418
  561067
  562147
  565251
  565283
  567041
  567358
  574162
  575178
  578512
  578812
  582243
  582270
  584748
  587292
  588281
  589202
  589407
  592854
  596643
  598201
  600978
  601887
  605989
  606225
  611559
  613558
  619286
  619535
  620818
  621729
  623334
  623930
  624802
  626388
  627419
  643660
  650955
  666816
  676808
  697006
  705160
  720047
  721895
  744844
  747649
  760169
  761602
  766625
  771845
  788252
  788566
  788886
  789583
  790019
  792018
  794214
  805439
  806247
  813346
]
1.95 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сам"
]
1.93 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "саме"
]
1.72 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.71%)
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.