Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
200.17 ms
(89.01%)
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
  424280
  515844
  523594
  530108
  530159
  536269
  541186
  543750
  545017
  545994
  547163
  549561
  549789
  550566
  551481
  551588
  552691
  552900
  553082
  554019
  556382
  557415
  557690
  558520
  558865
  560327
  560566
  560755
  562294
  562485
  565849
  567742
  567969
  568030
  568188
  571769
  573198
  573289
  573791
  574608
  575603
  575666
  576836
  577258
  578082
  582340
  584140
  588541
  593239
  593933
  595800
  598547
  600227
  603125
  603136
  604266
  608765
  610693
  611178
  614897
  618532
  620317
  622510
  625620
  625699
  632719
  632905
  648765
  661005
  661440
  661540
  662495
  667242
  667388
  670064
  673852
  674909
  679247
  681343
  682929
  685889
  686453
  690032
  692627
  695515
  709466
  715652
  716502
  716504
  716973
  726458
  727261
  727382
  735558
  735562
  736638
  737140
  738219
  738770
  742195
  743111
  748548
  750360
  751376
  754264
  754505
  785251
  786547
  789493
  793680
  793982
  809904
  813925
  816194
  818234
  821855
  825967
  826852
  828249
  828587
]
13.78 ms
(6.13%)
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
  692627
  661440
  620317
  632719
  603125
  560755
  550566
  648765
  567969
  786547
  727382
  726458
  715652
  568030
  551588
  577258
  604266
  573791
  600227
  670064
  545017
  737140
  738770
  826852
  818234
  828587
  547163
  667242
  603136
  625620
  625699
  530108
  556382
  608765
  685889
  593933
  557415
  598547
  816194
  543750
  584140
  686453
  809904
  748548
  751376
  793982
  750360
  754264
  754505
  709466
  785251
  536269
  551481
  568188
  595800
  736638
  821855
  523594
  560566
  573289
  553082
  558520
  549789
  562294
  571769
  578082
  727261
  825967
  673852
  575603
  541186
  565849
  662495
  661005
  674909
  679247
  695515
  681343
  690032
  582340
  588541
  593239
  622510
  424280
  661540
  716504
  552900
  611178
  667388
  545994
  614897
  828249
  575666
  574608
  552691
  576836
  618532
  793680
  632905
  813925
  530159
  515844
  549561
  554019
  562485
  557690
  558865
  560327
  567742
  682929
  716973
  716502
  573198
  610693
  735562
  742195
  789493
  738219
  735558
  743111
]
2.81 ms
(1.25%)
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
  424280
  515844
  523594
  530108
  530159
  536269
  541186
  543750
  545017
  545994
  547163
  549561
  549789
  550566
  551481
  551588
  552691
  552900
  553082
  554019
  556382
  557415
  557690
  558520
  558865
  560327
  560566
  560755
  562294
  562485
  565849
  567742
  567969
  568030
  568188
  571769
  573198
  573289
  573791
  574608
  575603
  575666
  576836
  577258
  578082
  582340
  584140
  588541
  593239
  593933
  595800
  598547
  600227
  603125
  603136
  604266
  608765
  610693
  611178
  614897
  618532
  620317
  622510
  625620
  625699
  632719
  632905
  648765
  661005
  661440
  661540
  662495
  667242
  667388
  670064
  673852
  674909
  679247
  681343
  682929
  685889
  686453
  690032
  692627
  695515
  709466
  715652
  716502
  716504
  716973
  726458
  727261
  727382
  735558
  735562
  736638
  737140
  738219
  738770
  742195
  743111
  748548
  750360
  751376
  754264
  754505
  785251
  786547
  789493
  793680
  793982
  809904
  813925
  816194
  818234
  821855
  825967
  826852
  828249
  828587
]
2.41 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск маленькая"
]
2.08 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur small"
]
1.96 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск маленькая"
]
1.69 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.