Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.43 ms
(85.91%)
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
  387334
  390139
  391289
  396439
  396941
  397483
  398543
  398558
  399422
  400587
  400598
  400996
  404684
  407407
  407462
  411074
  411904
  413700
  413737
  414173
  414225
  415802
  418425
  418739
  421524
  423584
  440563
  441770
  441957
  442623
  442915
  443135
  445288
  451213
  452175
  452240
  454460
  456067
  457546
  466881
  473383
  475097
  481101
  481927
  482735
  483723
  485383
  488393
  489033
  489266
  491214
  493119
  495520
  529419
  531817
  539440
  554451
  563768
  565302
  569762
  577420
  584020
  589120
  601098
  612229
  612243
  617536
  643443
  648503
  651102
  660400
  661536
  663405
  663443
  663459
  663873
  663913
  663973
  664274
  664792
  664848
  665124
  665230
  665351
  665471
  665840
  665854
  665876
  666763
  667263
  667523
  667526
  667597
  667672
  667675
  668869
  668880
  669652
  669742
  669766
  681216
  700849
  774609
  776415
  781764
  781772
  781778
  781782
  781854
  781855
  781869
  790963
  794872
  797175
  810715
  813793
  813802
  813807
  813818
  814723
]
14.52 ms
(7.50%)
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
  387334
  390139
  391289
  396439
  396941
  397483
  400587
  398558
  399422
  400598
  398543
  400996
  404684
  407462
  413700
  413737
  441770
  442623
  411904
  423584
  440563
  441957
  443135
  407407
  411074
  418425
  418739
  421524
  414173
  414225
  415802
  442915
  445288
  813807
  813793
  813802
  813818
  814723
  451213
  452240
  457546
  493119
  452175
  466881
  475097
  483723
  488393
  489033
  454460
  456067
  481927
  482735
  485383
  489266
  491214
  529419
  539440
  531817
  495520
  473383
  481101
  563768
  554451
  577420
  648503
  663405
  663459
  663973
  664848
  665351
  665840
  665854
  665876
  666763
  667597
  669652
  669766
  681216
  651102
  660400
  661536
  663913
  664792
  667263
  667523
  668869
  700849
  663443
  663873
  664274
  665124
  665230
  665471
  667526
  667672
  667675
  668880
  669742
  565302
  569762
  584020
  589120
  601098
  612229
  612243
  617536
  643443
  774609
  776415
  781764
  781772
  781782
  781854
  781855
  781869
  790963
  794872
  797175
  781778
  810715
]
4.91 ms
(2.53%)
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
  387334
  390139
  391289
  396439
  396941
  397483
  398543
  398558
  399422
  400587
  400598
  400996
  404684
  407407
  407462
  411074
  411904
  413700
  413737
  414173
  414225
  415802
  418425
  418739
  421524
  423584
  440563
  441770
  441957
  442623
  442915
  443135
  445288
  451213
  452175
  452240
  454460
  456067
  457546
  466881
  473383
  475097
  481101
  481927
  482735
  483723
  485383
  488393
  489033
  489266
  491214
  493119
  495520
  529419
  531817
  539440
  554451
  563768
  565302
  569762
  577420
  584020
  589120
  601098
  612229
  612243
  617536
  643443
  648503
  651102
  660400
  661536
  663405
  663443
  663459
  663873
  663913
  663973
  664274
  664792
  664848
  665124
  665230
  665351
  665471
  665840
  665854
  665876
  666763
  667263
  667523
  667526
  667597
  667672
  667675
  668869
  668880
  669652
  669742
  669766
  681216
  700849
  774609
  776415
  781764
  781772
  781778
  781782
  781854
  781855
  781869
  790963
  794872
  797175
  810715
  813793
  813802
  813807
  813818
  814723
]
2.29 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстушке"
]
2.28 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная"
]
1.78 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.78%)
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.