Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.23 ms
(82.46%)
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
  7157
  185249
  185494
  185708
  185861
  382650
  383005
  389356
  390258
  390282
  395554
  404032
  406435
  407357
  409305
  412222
  415934
  417022
  418400
  418481
  427179
  429357
  431427
  437437
  448337
  451961
  452360
  454044
  454974
  462747
  464474
  470839
  482069
  487010
  487346
  489410
  490070
  493814
  498698
  498875
  499815
  501786
  502006
  503892
  504339
  506147
  514568
  520417
  526821
  526834
  530537
  531416
  538345
  538675
  551288
  551384
  551386
  551392
  551405
  555944
  560186
  561672
  564459
  564619
  565945
  568348
  569622
  572030
  573400
  577775
  583280
  583656
  583669
  584200
  585254
  585910
  586900
  595865
  601115
  604043
  610181
  610243
  623958
  626877
  628345
  629094
  630823
  634162
  636522
  651922
  653250
  654385
  663371
  663381
  663469
  676986
  689293
  694610
  705720
  708800
  726520
  726595
  753443
  764258
  770007
  772942
  785711
  792680
  792775
  799598
  800324
  804688
  805961
  808650
  810789
  811662
  811675
  816031
  825002
  828466
]
18.12 ms
(11.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
  437437
  185494
  448337
  538675
  487010
  569622
  726595
  531416
  502006
  390282
  816031
  828466
  382650
  654385
  583656
  610181
  799598
  810789
  800324
  804688
  811662
  772942
  395554
  390258
  689293
  551386
  555944
  583669
  585254
  785711
  417022
  389356
  415934
  493814
  538345
  383005
  811675
  409305
  452360
  498698
  526821
  565945
  583280
  601115
  482069
  825002
  629094
  764258
  663371
  663469
  610243
  551288
  514568
  653250
  577775
  584200
  623958
  404032
  526834
  487346
  490070
  407357
  470839
  489410
  185861
  7157
  406435
  427179
  429357
  454974
  454044
  504339
  530537
  506147
  561672
  564619
  572030
  564459
  568348
  676986
  694610
  551392
  560186
  586900
  595865
  585910
  626877
  628345
  808650
  726520
  792775
  753443
  604043
  634162
  708800
  418481
  464474
  431427
  503892
  498875
  501786
  520417
  651922
  551405
  636522
  630823
  805961
  792680
  770007
  705720
  185249
  185708
  412222
  499815
  418400
  451961
  462747
  551384
  573400
  663381
]
2.82 ms
(1.73%)
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
  7157
  185249
  185494
  185708
  185861
  382650
  383005
  389356
  390258
  390282
  395554
  404032
  406435
  407357
  409305
  412222
  415934
  417022
  418400
  418481
  427179
  429357
  431427
  437437
  448337
  451961
  452360
  454044
  454974
  462747
  464474
  470839
  482069
  487010
  487346
  489410
  490070
  493814
  498698
  498875
  499815
  501786
  502006
  503892
  504339
  506147
  514568
  520417
  526821
  526834
  530537
  531416
  538345
  538675
  551288
  551384
  551386
  551392
  551405
  555944
  560186
  561672
  564459
  564619
  565945
  568348
  569622
  572030
  573400
  577775
  583280
  583656
  583669
  584200
  585254
  585910
  586900
  595865
  601115
  604043
  610181
  610243
  623958
  626877
  628345
  629094
  630823
  634162
  636522
  651922
  653250
  654385
  663371
  663381
  663469
  676986
  689293
  694610
  705720
  708800
  726520
  726595
  753443
  764258
  770007
  772942
  785711
  792680
  792775
  799598
  800324
  804688
  805961
  808650
  810789
  811662
  811675
  816031
  825002
  828466
]
2.25 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage tits"
]
1.90 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж сиськ"
]
1.89 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.96%)
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.