Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.82 ms
(85.97%)
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
  4350
  37730
  37980
  38953
  53654
  53683
  69440
  73926
  76122
  79862
  81174
  84901
  91603
  92249
  157318
  176941
  177651
  188025
  330565
  339037
  382799
  383225
  383480
  384039
  384519
  384908
  385113
  385426
  385938
  386625
  386854
  386900
  386994
  387000
  387304
  387318
  388344
  389295
  391451
  394543
  397097
  397249
  398362
  398523
  398724
  399647
  399902
  400551
  400955
  401387
  403245
  403346
  403862
  405483
  408201
  408875
  411625
  413116
  414248
  415047
  415533
  415800
  420122
  421567
  422337
  422406
  422506
  429220
  431603
  432200
  432657
  433619
  434962
  440642
  443863
  443889
  444120
  444229
  444486
  444517
  444715
  446880
  446893
  447758
  452197
  455271
  457274
  458127
  458238
  458303
  459291
  460652
  460700
  461935
  461947
  464291
  466045
  468785
  469818
  471571
  472359
  472755
  473323
  478028
  478354
  479374
  480013
  484056
  486822
  489441
  492018
  492626
  496039
  503911
  506697
  510630
  510735
  670588
  680630
  684176
]
14.86 ms
(8.20%)
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
  432200
  444715
  447758
  458303
  472755
  486822
  489441
  492626
  457274
  458238
  461947
  484056
  452197
  460652
  471571
  478028
  496039
  479374
  684176
  670588
  680630
  37730
  53683
  69440
  81174
  188025
  382799
  384908
  385113
  387000
  443889
  460700
  468785
  37980
  383225
  398724
  399902
  405483
  466045
  176941
  386625
  386900
  422506
  459291
  4350
  76122
  330565
  385938
  387318
  397249
  398523
  414248
  415533
  415800
  461935
  472359
  478354
  492018
  510735
  506697
  503911
  510630
  385426
  386854
  73926
  79862
  91603
  92249
  383480
  384039
  384519
  157318
  177651
  394543
  339037
  38953
  53654
  84901
  389295
  388344
  386994
  387304
  391451
  397097
  398362
  399647
  400551
  400955
  401387
  403245
  403346
  403862
  408201
  432657
  444120
  444229
  408875
  420122
  422337
  444486
  444517
  413116
  415047
  422406
  411625
  431603
  433619
  443863
  421567
  429220
  434962
  440642
  446880
  446893
  464291
  469818
  473323
  480013
  455271
  458127
]
3.10 ms
(1.71%)
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
  4350
  37730
  37980
  38953
  53654
  53683
  69440
  73926
  76122
  79862
  81174
  84901
  91603
  92249
  157318
  176941
  177651
  188025
  330565
  339037
  382799
  383225
  383480
  384039
  384519
  384908
  385113
  385426
  385938
  386625
  386854
  386900
  386994
  387000
  387304
  387318
  388344
  389295
  391451
  394543
  397097
  397249
  398362
  398523
  398724
  399647
  399902
  400551
  400955
  401387
  403245
  403346
  403862
  405483
  408201
  408875
  411625
  413116
  414248
  415047
  415533
  415800
  420122
  421567
  422337
  422406
  422506
  429220
  431603
  432200
  432657
  433619
  434962
  440642
  443863
  443889
  444120
  444229
  444486
  444517
  444715
  446880
  446893
  447758
  452197
  455271
  457274
  458127
  458238
  458303
  459291
  460652
  460700
  461935
  461947
  464291
  466045
  468785
  469818
  471571
  472359
  472755
  473323
  478028
  478354
  479374
  480013
  484056
  486822
  489441
  492018
  492626
  496039
  503911
  506697
  510630
  510735
  670588
  680630
  684176
]
2.23 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "темные"
]
1.88 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "темными"
]
1.55 ms
(0.86%)
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.