Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.22 ms
(83.72%)
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
  8064
  12880
  15190
  32594
  43207
  83131
  108094
  154576
  212138
  224587
  230925
  233397
  365907
  381970
  382445
  382937
  383588
  383801
  384350
  384452
  385706
  387374
  388425
  393499
  394029
  394045
  394116
  396072
  397166
  398018
  398451
  399190
  400050
  402566
  403411
  407877
  414139
  416321
  417155
  418465
  419558
  420071
  424231
  424843
  426736
  428384
  428810
  434086
  435937
  436982
  437837
  442429
  444728
  445349
  446766
  447133
  447815
  449744
  451622
  453156
  454353
  454358
  454491
  454622
  455129
  456200
  457255
  458133
  459405
  459786
  460160
  460707
  461096
  461190
  461476
  461773
  462923
  465435
  466871
  467012
  469563
  469696
  469813
  470153
  470246
  471130
  473977
  476033
  476967
  477479
  477638
  479392
  482616
  483602
  486808
  487157
  488109
  488296
  488926
  491297
  494911
  495020
  495321
  496201
  498898
  507434
  508727
  509360
  510354
  510655
  515703
  515795
  518556
  520932
  521376
  522818
  526480
  547306
  559388
  573675
]
17.63 ms
(9.96%)
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
  457255
  488926
  573675
  428384
  476033
  451622
  498898
  521376
  382445
  83131
  12880
  388425
  402566
  428810
  547306
  8064
  462923
  473977
  230925
  233397
  382937
  407877
  454358
  477638
  387374
  43207
  458133
  469696
  491297
  495020
  510354
  424231
  437837
  383588
  212138
  108094
  154576
  224587
  394029
  381970
  32594
  396072
  398451
  442429
  420071
  436982
  444728
  434086
  445349
  446766
  460707
  454491
  456200
  459405
  470153
  477479
  482616
  483602
  461096
  466871
  486808
  515795
  559388
  455129
  461476
  465435
  469813
  384350
  398018
  399190
  365907
  384452
  419558
  15190
  393499
  397166
  418465
  426736
  459786
  461773
  476967
  488109
  507434
  510655
  520932
  526480
  488296
  515703
  385706
  394116
  417155
  416321
  424843
  494911
  467012
  447815
  453156
  454622
  461190
  470246
  449744
  495321
  487157
  508727
  509360
  518556
  522818
  383801
  394045
  400050
  403411
  414139
  435937
  471130
  460160
  479392
  447133
  454353
  469563
  496201
]
3.35 ms
(1.89%)
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
  8064
  12880
  15190
  32594
  43207
  83131
  108094
  154576
  212138
  224587
  230925
  233397
  365907
  381970
  382445
  382937
  383588
  383801
  384350
  384452
  385706
  387374
  388425
  393499
  394029
  394045
  394116
  396072
  397166
  398018
  398451
  399190
  400050
  402566
  403411
  407877
  414139
  416321
  417155
  418465
  419558
  420071
  424231
  424843
  426736
  428384
  428810
  434086
  435937
  436982
  437837
  442429
  444728
  445349
  446766
  447133
  447815
  449744
  451622
  453156
  454353
  454358
  454491
  454622
  455129
  456200
  457255
  458133
  459405
  459786
  460160
  460707
  461096
  461190
  461476
  461773
  462923
  465435
  466871
  467012
  469563
  469696
  469813
  470153
  470246
  471130
  473977
  476033
  476967
  477479
  477638
  479392
  482616
  483602
  486808
  487157
  488109
  488296
  488926
  491297
  494911
  495020
  495321
  496201
  498898
  507434
  508727
  509360
  510354
  510655
  515703
  515795
  518556
  520932
  521376
  522818
  526480
  547306
  559388
  573675
]
2.08 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в темные"
]
1.99 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в темных"
]
1.93 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.05%)
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.