Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.39 ms
(86.29%)
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
  4123
  6763
  12387
  15364
  49365
  60843
  143396
  183239
  213017
  341079
  357750
  382072
  382270
  388850
  393428
  422157
  423088
  442545
  450300
  471700
  509189
  509238
  528392
  529241
  533618
  533630
  535433
  535854
  537502
  540470
  542481
  543966
  545281
  549894
  550116
  566379
  566428
  569762
  592110
  597460
  601420
  616059
  617898
  618747
  626376
  636888
  645464
  645576
  658759
  674333
  675544
  685103
  691157
  695382
  708504
  717659
  726156
  734324
  741133
  744354
  744373
  759856
  760489
  768577
  769970
  770995
  795586
  795763
  798697
  801010
  803055
  811114
  815376
  817170
  818142
  818298
  818300
  818302
  818507
  818535
  819830
  820857
  821707
  822580
  823708
  823755
  824030
  824266
  824286
  824324
  824965
  825049
  825067
  825901
  825920
  825955
  826099
  826175
  826190
  826210
  826380
  826397
  826444
  826567
  826985
  828067
  828199
  828295
  828409
  828470
  828478
  828502
  828525
  828631
  828643
]
9.44 ms
(7.12%)
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
  691157
  801010
  817170
  823708
  826175
  825955
  826210
  828067
  828525
  566379
  645576
  717659
  726156
  382270
  533618
  528392
  143396
  393428
  357750
  382072
  341079
  49365
  60843
  818507
  824286
  824965
  825901
  826190
  815376
  818302
  822580
  824030
  824266
  826397
  826567
  826985
  818142
  818298
  818300
  821707
  824380
  826099
  826444
  820857
  823755
  825920
  828199
  828409
  828295
  828470
  828643
  828502
  828631
  509238
  533630
  537502
  540470
  529241
  535854
  542481
  549894
  550116
  566428
  543966
  685103
  695382
  645464
  675544
  658759
  674333
  708504
  601420
  592110
  617898
  618747
  798697
  769970
  803055
  811114
  744354
  759856
  741133
  760489
  770995
  795763
  213017
  825049
  818535
  826340
  825067
  828478
  636888
  616059
  4123
  15364
  183239
  12387
  768577
  423088
  734324
  450300
  509189
  442545
  422157
  535433
  569762
  471700
  545281
  597460
  795586
  763882
  744373
  766674
  766118
  626376
  6763
  388850
  819830
  826380
  824324
]
2.66 ms
(2.00%)
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
  4123
  6763
  12387
  15364
  49365
  60843
  143396
  183239
  213017
  341079
  357750
  382072
  382270
  388850
  393428
  422157
  423088
  442545
  450300
  471700
  509189
  509238
  528392
  529241
  533618
  533630
  535433
  535854
  537502
  540470
  542481
  543966
  545281
  549894
  550116
  566379
  566428
  569762
  592110
  597460
  601420
  616059
  617898
  618747
  626376
  636888
  645464
  645576
  658759
  674333
  675544
  685103
  691157
  695382
  708504
  717659
  726156
  734324
  741133
  744354
  744373
  759856
  760489
  768577
  769970
  770995
  795586
  795763
  798697
  801010
  803055
  811114
  815376
  817170
  818142
  818298
  818300
  818302
  818507
  818535
  819830
  820857
  821707
  822580
  823708
  823755
  824030
  824266
  824286
  824324
  824965
  825049
  825067
  825901
  825920
  825955
  826099
  826175
  826190
  826210
  826380
  826397
  826444
  826567
  826985
  828067
  828199
  828295
  828409
  828470
  828478
  828502
  828525
  828631
  828643
]
1.65 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп большая большие жоп"
]
1.52 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп большая большие жоп"
]
1.45 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass big ass"
]

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.