GET https://search.jues.net/search/embeds/9?q=big%20boobs%20bathroom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.48 ms
(86.94%)
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
  30885
  36977
  84837
  145343
  185264
  187411
  187516
  188335
  387556
  388087
  394773
  395513
  396615
  404464
  405482
  407064
  407649
  411588
  414430
  415342
  418754
  425640
  427095
  429824
  431321
  442612
  443363
  451795
  453446
  455073
  456281
  458713
  459476
  459970
  462198
  464665
  465222
  465609
  466859
  466903
  467348
  467920
  470630
  471414
  492272
  493229
  494384
  495228
  510206
  516013
  516712
  518189
  518901
  521168
  524470
  526378
  527144
  529764
  532111
  533141
  541551
  541969
  549427
  554374
  555963
  556504
  562463
  563233
  567822
  580153
  580822
  583522
  584481
  589661
  596845
  617065
  618020
  621200
  624497
  628648
  628747
  633954
  636624
  636638
  637201
  637245
  662897
  663990
  665199
  665250
  667293
  693026
  698474
  704121
  709460
  712234
  725244
  736437
  736554
  742409
  744912
  750387
  753713
  754504
  758561
  759114
  759123
  759129
  765863
  787334
  792507
  801374
  801394
  805154
  808540
  815230
  816666
  818909
  819811
  821493
]
16.91 ms
(8.28%)
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
  808540
  750387
  759129
  725244
  736554
  742409
  758561
  753713
  759114
  188335
  145343
  516013
  589661
  465222
  442612
  395513
  388087
  405482
  407649
  431321
  456281
  467920
  521168
  541551
  563233
  583522
  541969
  662897
  554374
  580153
  596845
  744912
  415342
  411588
  425640
  443363
  458713
  529764
  36977
  84837
  185264
  816666
  818909
  819811
  815230
  821493
  712234
  549427
  759123
  754504
  801374
  187411
  30885
  407064
  429824
  526378
  471414
  663990
  636638
  704121
  453446
  492272
  618020
  617065
  624497
  693026
  698474
  464665
  466903
  493229
  455073
  467348
  470630
  524470
  533141
  466859
  580822
  556504
  665199
  667293
  665250
  709460
  633954
  621200
  628648
  801394
  792507
  736437
  187516
  427095
  394773
  387556
  396615
  404464
  465609
  451795
  462198
  518189
  527144
  459970
  567822
  584481
  562463
  555963
  637201
  637245
  636624
  459476
  516712
  495228
  510206
  518901
  787334
  418754
  414430
  494384
  532111
  628747
  765863
  805154
]
3.39 ms
(1.66%)
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
  30885
  36977
  84837
  145343
  185264
  187411
  187516
  188335
  387556
  388087
  394773
  395513
  396615
  404464
  405482
  407064
  407649
  411588
  414430
  415342
  418754
  425640
  427095
  429824
  431321
  442612
  443363
  451795
  453446
  455073
  456281
  458713
  459476
  459970
  462198
  464665
  465222
  465609
  466859
  466903
  467348
  467920
  470630
  471414
  492272
  493229
  494384
  495228
  510206
  516013
  516712
  518189
  518901
  521168
  524470
  526378
  527144
  529764
  532111
  533141
  541551
  541969
  549427
  554374
  555963
  556504
  562463
  563233
  567822
  580153
  580822
  583522
  584481
  589661
  596845
  617065
  618020
  621200
  624497
  628648
  628747
  633954
  636624
  636638
  637201
  637245
  662897
  663990
  665199
  665250
  667293
  693026
  698474
  704121
  709460
  712234
  725244
  736437
  736554
  742409
  744912
  750387
  753713
  754504
  758561
  759114
  759123
  759129
  765863
  787334
  792507
  801374
  801394
  805154
  808540
  815230
  816666
  818909
  819811
  821493
]
1.84 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие boobs ван"
]
1.54 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие boobs ван"
]
1.42 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big boobs bathroom"
]

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.