GET https://search.jues.net/search/embeds/9?q=chubby%20anal%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.87 ms
(80.96%)
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
  31329
  187786
  188501
  382413
  389729
  391477
  391917
  397861
  400801
  400832
  402876
  404739
  411203
  411352
  411975
  412299
  413465
  414767
  416117
  419979
  421811
  421813
  421841
  421849
  421860
  421867
  421894
  422185
  422186
  422191
  422192
  422210
  425931
  428115
  431504
  433380
  439634
  439687
  439722
  439778
  439791
  439817
  439821
  439856
  440222
  442122
  442814
  444836
  444870
  445564
  445707
  447094
  449104
  449375
  451463
  452318
  457433
  457437
  457442
  457449
  457461
  457464
  461129
  470201
  472299
  472679
  473464
  473479
  473750
  478525
  482192
  483629
  488363
  489299
  489400
  490517
  491164
  491769
  506865
  510840
  513158
  519309
  523824
  525085
  526523
  542247
  543592
  549825
  552290
  557327
  562342
  563127
  570978
  571399
  575027
  581126
  584029
  589718
  591988
  601754
  607023
  626887
  639787
  669387
  696513
  718576
  726244
  726839
  728446
  733146
  736225
  741764
  748253
  758803
  760859
  761463
  788545
  794832
  800399
  811013
]
22.84 ms
(12.59%)
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
  422191
  411203
  449104
  452318
  473479
  513158
  581126
  543592
  549825
  626887
  421813
  422210
  433380
  421849
  421860
  439634
  439687
  439817
  439856
  470201
  478525
  412299
  421811
  421841
  421867
  421894
  422185
  422186
  425931
  439722
  444870
  445564
  451463
  457442
  457449
  457464
  473750
  439778
  439791
  439821
  440222
  442122
  442814
  445707
  457437
  472679
  422192
  457433
  457461
  526523
  483629
  489299
  506865
  523824
  491164
  519309
  575027
  472299
  188501
  391917
  400801
  402876
  444836
  411975
  413465
  414767
  416117
  428115
  419979
  431504
  473464
  489400
  490517
  491769
  447094
  449375
  510840
  525085
  461129
  482192
  488363
  542247
  557327
  571399
  570978
  552290
  562342
  669387
  696513
  718576
  563127
  584029
  589718
  591988
  607023
  639787
  601754
  788545
  811013
  794832
  758803
  800399
  728446
  736225
  726244
  748253
  760859
  726839
  733146
  741764
  761463
  31329
  187786
  382413
  389729
  391477
  397861
  400832
  404739
  411352
]
4.58 ms
(2.52%)
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
  31329
  187786
  188501
  382413
  389729
  391477
  391917
  397861
  400801
  400832
  402876
  404739
  411203
  411352
  411975
  412299
  413465
  414767
  416117
  419979
  421811
  421813
  421841
  421849
  421860
  421867
  421894
  422185
  422186
  422191
  422192
  422210
  425931
  428115
  431504
  433380
  439634
  439687
  439722
  439778
  439791
  439817
  439821
  439856
  440222
  442122
  442814
  444836
  444870
  445564
  445707
  447094
  449104
  449375
  451463
  452318
  457433
  457437
  457442
  457449
  457461
  457464
  461129
  470201
  472299
  472679
  473464
  473479
  473750
  478525
  482192
  483629
  488363
  489299
  489400
  490517
  491164
  491769
  506865
  510840
  513158
  519309
  523824
  525085
  526523
  542247
  543592
  549825
  552290
  557327
  562342
  563127
  570978
  571399
  575027
  581126
  584029
  589718
  591988
  601754
  607023
  626887
  639787
  669387
  696513
  718576
  726244
  726839
  728446
  733146
  736225
  741764
  748253
  758803
  760859
  761463
  788545
  794832
  800399
  811013
]
2.03 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby анал анал"
]
1.79 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby anal anal"
]
1.53 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby анал анал"
]

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.