GET https://search.jues.net/search/embeds/7?q=%D1%85%D1%83%D0%B9%20%D0%B2%20%D0%B4%D1%8B%D1%80%D0%BA%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.84 ms
(84.81%)
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
  7161
  65277
  147073
  149406
  383898
  386300
  386544
  387320
  388341
  390163
  392207
  394700
  396582
  396687
  398221
  399354
  411845
  414318
  414342
  417246
  418861
  420120
  422274
  424116
  424347
  424370
  424581
  428568
  428972
  429804
  429827
  429958
  432255
  432576
  433295
  436059
  440016
  446274
  447990
  448838
  452325
  452602
  454643
  454814
  455060
  455408
  458966
  461443
  464188
  464905
  465790
  473168
  475059
  477118
  477496
  479821
  483564
  485229
  488247
  488803
  489334
  489676
  490689
  490952
  500256
  503167
  503441
  503992
  513313
  513479
  513481
  513495
  513697
  518147
  536128
  542813
  543227
  543236
  543256
  543500
  544704
  546029
  546710
  547759
  547920
  549864
  551421
  552956
  553093
  555098
  556406
  556876
  557387
  558981
  560599
  569313
  574908
  575250
  576142
  581281
  583474
  584754
  588077
  588843
  590174
  592979
  612792
  617164
  622601
  626026
  632059
  652281
  697987
  711686
  735112
  735311
  735450
  738826
  739115
  763797
]
17.45 ms
(9.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
  388341
  414318
  489676
  569313
  396582
  422274
  433295
  622601
  697987
  543227
  576142
  490689
  542813
  652281
  543500
  398221
  546710
  7161
  454814
  399354
  584754
  558981
  556406
  392207
  455060
  503167
  455408
  452325
  428972
  473168
  513495
  536128
  513697
  396687
  556876
  440016
  574908
  503441
  490952
  424347
  411845
  454643
  544704
  461443
  420120
  383898
  735450
  446274
  477496
  555098
  560599
  581281
  583474
  477118
  592979
  464188
  447990
  546029
  543256
  551421
  588843
  552956
  428568
  448838
  489334
  464905
  465790
  483564
  500256
  475059
  549864
  588077
  418861
  518147
  503992
  513479
  513481
  763797
  711686
  632059
  485229
  590174
  424116
  513313
  735311
  390163
  575250
  458966
  147073
  617164
  387320
  394700
  432255
  417246
  479821
  488803
  488247
  547920
  429958
  65277
  543236
  557387
  149406
  547759
  626026
  739115
  553093
  386544
  436059
  386300
  738826
  735112
  429827
  424370
  432576
  424581
  612792
  414342
  452602
  429804
]
3.79 ms
(2.06%)
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
  7161
  65277
  147073
  149406
  383898
  386300
  386544
  387320
  388341
  390163
  392207
  394700
  396582
  396687
  398221
  399354
  411845
  414318
  414342
  417246
  418861
  420120
  422274
  424116
  424347
  424370
  424581
  428568
  428972
  429804
  429827
  429958
  432255
  432576
  433295
  436059
  440016
  446274
  447990
  448838
  452325
  452602
  454643
  454814
  455060
  455408
  458966
  461443
  464188
  464905
  465790
  473168
  475059
  477118
  477496
  479821
  483564
  485229
  488247
  488803
  489334
  489676
  490689
  490952
  500256
  503167
  503441
  503992
  513313
  513479
  513481
  513495
  513697
  518147
  536128
  542813
  543227
  543236
  543256
  543500
  544704
  546029
  546710
  547759
  547920
  549864
  551421
  552956
  553093
  555098
  556406
  556876
  557387
  558981
  560599
  569313
  574908
  575250
  576142
  581281
  583474
  584754
  588077
  588843
  590174
  592979
  612792
  617164
  622601
  626026
  632059
  652281
  697987
  711686
  735112
  735311
  735450
  738826
  739115
  763797
]
1.99 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член в дырк"
]
1.73 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хуй в дырке"
]
1.60 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член в дырк"
]
1.35 ms
(0.74%)
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.