GET https://search.jues.net/search/embeds/3?q=cock%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.05 ms
(86.77%)
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
  426959
  449872
  455343
  464237
  468190
  479512
  484250
  489796
  495210
  497056
  498984
  501080
  512424
  514341
  519518
  522615
  527075
  527339
  529454
  541954
  542927
  546840
  558394
  558979
  562043
  564941
  565220
  565359
  578067
  579110
  581285
  583779
  589347
  589783
  591211
  592337
  599631
  612048
  620707
  622020
  630399
  633916
  634376
  635357
  639525
  649837
  652283
  655542
  659956
  666991
  668403
  672422
  676760
  678713
  687751
  689478
  691224
  692435
  694425
  694432
  695647
  695654
  695660
  695667
  695677
  695682
  695962
  696019
  696032
  696050
  696051
  696055
  696069
  696432
  696617
  696628
  696673
  696699
  696700
  697088
  698229
  698802
  699859
  700177
  701623
  701644
  702360
  702443
  706067
  709932
  712660
  718530
  720729
  721072
  722304
  726931
  729564
  731002
  731027
  732128
  734030
  738664
  738976
  745994
  746633
  749604
  751769
  757558
  757603
  758942
  767437
  789065
  793210
  797854
  817497
  828032
  828135
  828137
  828139
  828140
]
11.54 ms
(6.63%)
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
  565359
  578067
  449872
  479512
  455343
  522615
  464237
  767437
  498984
  749604
  558394
  678713
  599631
  699859
  789065
  514341
  797854
  527339
  426959
  489796
  484250
  718530
  817497
  546840
  529454
  562043
  793210
  565220
  589783
  468190
  691224
  731002
  751769
  634376
  745994
  757603
  697088
  495210
  828135
  695654
  583779
  746633
  501080
  695647
  695682
  726931
  758942
  558979
  620707
  581285
  687751
  695677
  692435
  668403
  696051
  639525
  630399
  542927
  698229
  622020
  696019
  706067
  695660
  695962
  828137
  828032
  633916
  541954
  702360
  696032
  720729
  722304
  696700
  702443
  579110
  592337
  738664
  731027
  612048
  696432
  497056
  564941
  698802
  696069
  635357
  591211
  589347
  700177
  738976
  828140
  757558
  696050
  649837
  696617
  659956
  676760
  701623
  701644
  734030
  729564
  689478
  828139
  512424
  519518
  732128
  721072
  527075
  655542
  694425
  696055
  712660
  672422
  695667
  709932
  652283
  666991
  694432
  696628
  696673
  696699
]
3.41 ms
(1.96%)
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
  426959
  449872
  455343
  464237
  468190
  479512
  484250
  489796
  495210
  497056
  498984
  501080
  512424
  514341
  519518
  522615
  527075
  527339
  529454
  541954
  542927
  546840
  558394
  558979
  562043
  564941
  565220
  565359
  578067
  579110
  581285
  583779
  589347
  589783
  591211
  592337
  599631
  612048
  620707
  622020
  630399
  633916
  634376
  635357
  639525
  649837
  652283
  655542
  659956
  666991
  668403
  672422
  676760
  678713
  687751
  689478
  691224
  692435
  694425
  694432
  695647
  695654
  695660
  695667
  695677
  695682
  695962
  696019
  696032
  696050
  696051
  696055
  696069
  696432
  696617
  696628
  696673
  696699
  696700
  697088
  698229
  698802
  699859
  700177
  701623
  701644
  702360
  702443
  706067
  709932
  712660
  718530
  720729
  721072
  722304
  726931
  729564
  731002
  731027
  732128
  734030
  738664
  738976
  745994
  746633
  749604
  751769
  757558
  757603
  758942
  767437
  789065
  793210
  797854
  817497
  828032
  828135
  828137
  828139
  828140
]
2.20 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock на улиц"
]
1.98 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock public"
]
1.93 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock на улиц"
]

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.