Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.68 ms
(84.37%)
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
  69704
  382474
  390806
  393063
  394235
  400179
  400931
  401466
  407600
  411055
  412716
  413253
  413270
  417343
  418017
  420577
  420586
  424950
  425054
  428794
  431652
  437791
  438838
  443457
  444653
  447494
  450398
  451283
  451382
  454828
  455696
  456375
  457874
  458558
  458747
  459466
  459700
  461524
  461811
  462518
  463737
  463939
  464096
  466144
  466673
  468577
  471327
  471972
  472210
  473985
  475353
  477194
  482388
  483197
  489844
  489863
  490809
  492831
  496644
  509667
  512651
  514051
  515662
  521760
  522127
  525772
  528025
  531626
  533030
  535794
  536876
  536937
  538740
  542206
  549373
  551519
  551677
  553854
  556807
  576069
  582526
  584424
  586553
  589947
  593382
  601772
  603945
  604064
  605833
  617103
  619472
  629044
  650317
  652253
  654974
  668294
  673782
  678339
  700251
  708725
  724935
  736380
  741989
  750222
  754650
  763553
  764869
  768587
  768695
  779124
  779190
  779557
  783154
  784312
  787002
  793495
  799652
  800171
  806956
  813524
]
13.19 ms
(8.78%)
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
  783154
  787002
  407600
  412716
  428794
  459466
  462518
  471972
  473985
  390806
  393063
  431652
  454828
  456375
  459700
  437791
  458747
  477194
  411055
  461524
  461811
  489863
  512651
  525772
  536937
  483197
  522127
  492831
  515662
  528025
  536876
  463737
  444653
  586553
  482388
  549373
  551519
  654974
  629044
  604064
  603945
  779124
  800171
  741989
  768695
  724935
  617103
  69704
  420577
  538740
  553854
  551677
  652253
  678339
  779557
  806956
  736380
  382474
  542206
  700251
  650317
  673782
  708725
  799652
  813524
  784312
  763553
  793495
  401466
  490809
  535794
  619472
  754650
  768587
  750222
  424950
  400179
  443457
  413270
  413253
  458558
  450398
  455696
  496644
  531626
  556807
  576069
  582526
  584424
  668294
  589947
  593382
  605833
  601772
  779190
  764869
  420586
  451382
  466673
  475353
  394235
  400931
  417343
  418017
  438838
  447494
  457874
  463939
  468577
  425054
  451283
  464096
  466144
  471327
  472210
  489844
  509667
  533030
  514051
  521760
]
2.77 ms
(1.85%)
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
  69704
  382474
  390806
  393063
  394235
  400179
  400931
  401466
  407600
  411055
  412716
  413253
  413270
  417343
  418017
  420577
  420586
  424950
  425054
  428794
  431652
  437791
  438838
  443457
  444653
  447494
  450398
  451283
  451382
  454828
  455696
  456375
  457874
  458558
  458747
  459466
  459700
  461524
  461811
  462518
  463737
  463939
  464096
  466144
  466673
  468577
  471327
  471972
  472210
  473985
  475353
  477194
  482388
  483197
  489844
  489863
  490809
  492831
  496644
  509667
  512651
  514051
  515662
  521760
  522127
  525772
  528025
  531626
  533030
  535794
  536876
  536937
  538740
  542206
  549373
  551519
  551677
  553854
  556807
  576069
  582526
  584424
  586553
  589947
  593382
  601772
  603945
  604064
  605833
  617103
  619472
  629044
  650317
  652253
  654974
  668294
  673782
  678339
  700251
  708725
  724935
  736380
  741989
  750222
  754650
  763553
  764869
  768587
  768695
  779124
  779190
  779557
  783154
  784312
  787002
  793495
  799652
  800171
  806956
  813524
]
1.93 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие красивая"
]
1.90 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big beautiful"
]
1.85 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.22%)
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.