Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.59 ms
(85.41%)
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
  233504
  391881
  396064
  398714
  398784
  402219
  408489
  410741
  412528
  414647
  418034
  424493
  425748
  425889
  428402
  429591
  429959
  432211
  435263
  438838
  439049
  439376
  441759
  442155
  443428
  443754
  444128
  444198
  444247
  446077
  447083
  447518
  449000
  451484
  451700
  453586
  456262
  458738
  459600
  460029
  461150
  461776
  462728
  465332
  467758
  469899
  469900
  470334
  473905
  473979
  477137
  477908
  479033
  479088
  479283
  479613
  480028
  480831
  481061
  481187
  482095
  482763
  482767
  483233
  483373
  484577
  487006
  490597
  491438
  494111
  498900
  500391
  503706
  504251
  508035
  510652
  512643
  512650
  513282
  516151
  522461
  525938
  538376
  538419
  541734
  546659
  552211
  552248
  558599
  560942
  561669
  562226
  562976
  563206
  563584
  563993
  570040
  570051
  570198
  570204
  570259
  570280
  570307
  570418
  570506
  570646
  572363
  572467
  573543
  573596
  573675
  573711
  573826
  573954
  574588
  578997
  581360
  587055
  596670
  598553
]
14.88 ms
(8.55%)
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
  396064
  398784
  435263
  447518
  459600
  391881
  429591
  439376
  453586
  460029
  479283
  408489
  443754
  447083
  516151
  483233
  498900
  504251
  508035
  513282
  522461
  483373
  487006
  525938
  538376
  512643
  512650
  482763
  570051
  570418
  598553
  596670
  443428
  233504
  410741
  444128
  465332
  467758
  473979
  479033
  425748
  432211
  438838
  412528
  414647
  451700
  510652
  484577
  494111
  500391
  482767
  469899
  481061
  469900
  477137
  479088
  482095
  558599
  562976
  563206
  570040
  570646
  572363
  573543
  573596
  581360
  552211
  563584
  570198
  570506
  572467
  573675
  573711
  573954
  574588
  546659
  561669
  563993
  570259
  570280
  570307
  552248
  560942
  562226
  570204
  573826
  578997
  587055
  428402
  462728
  479613
  480028
  441759
  449000
  461150
  470334
  402219
  425889
  439049
  461776
  473905
  477908
  481187
  398714
  418034
  424493
  429959
  442155
  444198
  444247
  480831
  446077
  451484
  456262
  458738
  491438
  503706
  538419
  541734
  490597
]
3.17 ms
(1.82%)
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
  233504
  391881
  396064
  398714
  398784
  402219
  408489
  410741
  412528
  414647
  418034
  424493
  425748
  425889
  428402
  429591
  429959
  432211
  435263
  438838
  439049
  439376
  441759
  442155
  443428
  443754
  444128
  444198
  444247
  446077
  447083
  447518
  449000
  451484
  451700
  453586
  456262
  458738
  459600
  460029
  461150
  461776
  462728
  465332
  467758
  469899
  469900
  470334
  473905
  473979
  477137
  477908
  479033
  479088
  479283
  479613
  480028
  480831
  481061
  481187
  482095
  482763
  482767
  483233
  483373
  484577
  487006
  490597
  491438
  494111
  498900
  500391
  503706
  504251
  508035
  510652
  512643
  512650
  513282
  516151
  522461
  525938
  538376
  538419
  541734
  546659
  552211
  552248
  558599
  560942
  561669
  562226
  562976
  563206
  563584
  563993
  570040
  570051
  570198
  570204
  570259
  570280
  570307
  570418
  570506
  570646
  572363
  572467
  573543
  573596
  573675
  573711
  573826
  573954
  574588
  578997
  581360
  587055
  596670
  598553
]
2.06 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая руская"
]
1.96 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая русск"
]
1.68 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.94%)
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.