GET https://search.jues.net/search/embeds/6?q=anal%20cock%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
416.75 ms
(47.37%)
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
  386662
  387515
  389788
  392525
  398388
  402439
  415875
  467910
  480038
  488298
  493493
  499083
  509976
  537662
  541073
  549069
  555086
  590297
  591995
  592161
  595447
  602400
  608545
  612905
  619476
  620258
  625937
  625980
  629172
  633813
  641792
  647119
  650167
  654918
  659055
  660403
  661606
  668091
  669403
  673670
  681523
  684669
  692723
  705291
  707928
  708867
  710909
  712574
  712582
  712591
  715453
  715800
  717921
  719942
  719960
  722329
  722474
  722597
  725113
  726179
  728372
  728675
  730383
  730744
  731198
  734964
  736321
  736921
  738718
  742742
  743961
  744645
  747500
  748748
  748795
  749336
  749794
  750100
  750273
  750280
  752184
  753472
  755030
  756095
  757043
  757052
  757180
  757403
  757535
  758087
  758216
  760894
  761605
  761718
  761767
  761784
  762104
  762411
  763418
  764867
  767808
  768867
  769754
  769767
  769774
  769804
  769811
  769841
  769917
  770866
  778115
  786199
  787063
  796081
  801543
  806332
  811074
  813005
  825378
  825961
]
232.86 ms
(26.47%)
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
  386662
  387515
  389788
  392525
  398388
  402439
  415875
  467910
  480038
  488298
  493493
  499083
  509976
  537662
  541073
  549069
  555086
  590297
  591995
  592161
  595447
  602400
  608545
  612905
  619476
  620258
  625937
  625980
  629172
  633813
  641792
  647119
  650167
  654918
  659055
  660403
  661606
  668091
  669403
  673670
  681523
  684669
  692723
  705291
  707928
  708867
  710909
  712574
  712582
  712591
  715453
  715800
  717921
  719942
  719960
  722329
  722474
  722597
  725113
  726179
  728372
  728675
  730383
  730744
  731198
  734964
  736321
  736921
  738718
  742742
  743961
  744645
  747500
  748748
  748795
  749336
  749794
  750100
  750273
  750280
  752184
  753472
  755030
  756095
  757043
  757052
  757180
  757403
  757535
  758087
  758216
  760894
  761605
  761718
  761767
  761784
  762104
  762411
  763418
  764867
  767808
  768867
  769754
  769767
  769774
  769804
  769811
  769841
  769917
  770866
  778115
  786199
  787063
  796081
  801543
  806332
  811074
  813005
  825378
  825961
]
211.40 ms
(24.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal cock anal"
]
13.54 ms
(1.54%)
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
  753472
  757043
  760894
  762104
  762411
  764867
  728675
  744645
  748795
  752184
  757403
  758087
  761767
  763418
  767808
  731198
  736921
  738718
  747500
  749336
  749794
  750273
  761718
  768867
  769767
  769917
  602400
  629172
  705291
  708867
  710909
  719942
  722329
  796081
  801543
  806332
  386662
  387515
  537662
  467910
  493493
  541073
  591995
  633813
  758216
  755030
  719960
  659055
  661606
  625980
  770866
  787063
  480038
  650167
  654918
  712574
  712582
  722597
  692723
  647119
  668091
  684669
  707928
  715800
  722474
  608545
  641792
  590297
  592161
  612905
  778115
  813005
  786199
  736321
  743961
  757052
  761784
  769841
  728372
  734964
  757180
  769811
  730383
  730744
  769754
  769804
  742742
  757535
  761605
  750100
  750280
  769774
  625937
  402439
  392525
  825961
  825378
  509976
  389788
  398388
  415875
  499083
  488298
  549069
  669403
  712591
  660403
  673670
  681523
  715453
  717921
  555086
  595447
  620258
  619476
  811074
  725113
  756095
  726179
  748748
]
2.00 ms
(0.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал cock анал"
]
1.82 ms
(0.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.16%)
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.