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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.95 ms
(86.09%)
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
  393271
  396367
  410299
  432804
  492189
  499081
  529661
  531757
  533779
  534506
  537476
  543572
  543704
  545990
  547377
  548973
  548994
  557462
  563961
  567684
  579872
  582842
  590840
  592855
  603127
  604207
  605819
  608466
  612683
  619798
  619805
  620907
  622506
  626686
  628257
  628619
  631436
  632935
  635061
  636496
  636925
  639037
  639950
  642689
  643612
  647084
  647119
  648468
  654906
  655131
  655163
  655185
  656563
  656826
  657234
  661676
  682742
  684400
  686139
  687666
  688722
  694131
  696110
  696122
  700922
  705461
  713671
  715014
  715627
  715761
  715934
  716561
  717955
  719919
  722011
  725009
  725156
  726213
  728669
  734961
  736283
  736321
  737444
  742852
  748075
  750141
  758504
  761502
  761708
  762424
  764157
  765334
  765367
  765713
  767036
  770590
  774250
  777013
  782039
  782184
  783197
  784622
  790415
  791502
  792089
  792739
  793266
  794360
  795309
  796117
  796534
  796949
  797408
  800528
  810287
  810332
  814533
  827874
]
14.89 ms
(8.97%)
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
  612683
  628619
  639037
  643612
  725009
  765106
  543572
  687666
  696110
  696122
  604207
  810287
  396367
  547377
  784622
  715761
  725156
  750141
  774250
  765334
  715014
  782039
  796117
  534506
  563961
  582842
  557462
  647084
  654906
  655131
  657234
  661676
  715627
  648468
  656563
  682742
  684400
  686139
  700922
  655185
  626686
  628257
  635061
  636925
  605819
  619798
  622506
  636496
  603127
  620907
  632935
  590840
  592855
  608466
  631436
  529661
  543704
  792739
  533779
  548994
  688722
  579872
  790415
  796534
  782184
  827874
  705461
  642689
  619805
  796949
  742877
  432804
  713671
  777013
  795309
  742852
  764157
  783197
  797408
  647119
  410299
  814533
  492189
  548973
  567684
  717955
  719919
  655163
  656826
  715934
  722011
  545990
  639950
  793266
  800528
  810332
  791502
  728669
  736283
  737444
  748075
  758504
  761502
  770590
  794360
  762424
  767036
  726213
  734961
  761708
  765713
  765367
  716561
  792089
  694131
  393271
  736321
  531757
  537476
  499081
]
2.01 ms
(1.21%)
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
  393271
  396367
  410299
  432804
  492189
  499081
  529661
  531757
  533779
  534506
  537476
  543572
  543704
  545990
  547377
  548973
  548994
  557462
  563961
  567684
  579872
  582842
  590840
  592855
  603127
  604207
  605819
  608466
  612683
  619798
  619805
  620907
  622506
  626686
  628257
  628619
  631436
  632935
  635061
  636496
  636925
  639037
  639950
  642689
  643612
  647084
  647119
  648468
  654906
  655131
  655163
  655185
  656563
  656826
  657234
  661676
  682742
  684400
  686139
  687666
  688722
  694131
  696110
  696122
  700922
  705461
  713671
  715014
  715627
  715761
  715934
  716561
  717955
  719919
  722011
  725009
  725156
  726213
  728669
  734961
  736283
  736321
  737444
  742852
  748075
  750141
  758504
  761502
  761708
  762424
  764157
  765334
  765367
  765713
  767036
  770590
  774250
  777013
  782039
  782184
  783197
  784622
  790415
  791502
  792089
  792739
  793266
  794360
  795309
  796117
  796534
  796949
  797408
  800528
  810287
  810332
  814533
  827874
]
1.68 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал домашн любительск"
]
1.66 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal home made"
]
1.35 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.