GET https://search.jues.net/search/embeds/7?q=solo%20milf%20bathroom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.61 ms
(88.12%)
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
  265677
  383685
  421420
  423837
  426297
  428793
  440644
  445401
  446815
  452223
  454382
  463804
  464543
  466452
  475280
  478983
  482441
  492651
  493342
  505385
  508257
  509113
  513174
  518977
  519309
  523156
  523596
  525204
  528536
  529713
  529880
  532118
  532273
  532545
  533140
  533642
  542885
  552382
  553545
  555189
  555321
  557471
  559358
  562048
  566622
  566625
  568136
  568293
  569382
  574086
  575026
  576229
  576759
  577284
  579594
  579707
  579826
  580129
  585284
  589408
  590410
  592184
  594131
  596033
  602591
  603414
  605184
  617065
  619791
  626066
  627311
  628527
  628655
  629387
  632750
  645928
  649489
  662444
  674206
  695603
  697284
  705129
  710379
  710559
  742092
  749359
  751795
  753582
  759133
  759992
  765854
  768385
  770963
  778498
  781309
  784662
  787334
  787599
  789109
  789773
  790810
  793940
  796695
  797180
  797182
  800381
  801016
  803233
  804417
  804420
  804422
  804458
  804713
  806930
  809517
  809548
  810076
  810798
  813802
  823887
]
13.68 ms
(6.53%)
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
  617065
  705129
  710379
  800381
  529880
  523596
  475280
  579707
  553545
  519309
  823887
  813802
  528536
  532118
  533140
  559358
  566622
  577284
  579826
  555321
  557471
  579594
  555189
  575026
  645928
  649489
  697284
  568136
  568293
  569382
  576759
  585284
  596033
  628655
  632750
  602591
  778498
  797182
  803233
  789109
  809548
  753582
  759992
  787334
  790810
  804713
  810076
  751795
  770963
  749359
  768385
  603414
  793940
  804417
  804420
  809517
  463804
  464543
  383685
  513174
  493342
  452223
  590410
  440644
  445401
  518977
  508257
  566625
  574086
  626066
  592184
  784662
  525204
  426297
  428793
  423837
  454382
  478983
  466452
  492651
  446815
  532545
  505385
  529713
  532273
  523156
  533642
  482441
  552382
  562048
  542885
  695603
  674206
  576229
  580129
  594131
  589408
  619791
  605184
  628527
  629387
  789773
  797180
  810798
  796695
  801016
  806930
  759133
  781309
  787599
  765854
  742092
  627311
  710559
  804422
  804458
  421420
  265677
  509113
  662444
]
3.10 ms
(1.48%)
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
  265677
  383685
  421420
  423837
  426297
  428793
  440644
  445401
  446815
  452223
  454382
  463804
  464543
  466452
  475280
  478983
  482441
  492651
  493342
  505385
  508257
  509113
  513174
  518977
  519309
  523156
  523596
  525204
  528536
  529713
  529880
  532118
  532273
  532545
  533140
  533642
  542885
  552382
  553545
  555189
  555321
  557471
  559358
  562048
  566622
  566625
  568136
  568293
  569382
  574086
  575026
  576229
  576759
  577284
  579594
  579707
  579826
  580129
  585284
  589408
  590410
  592184
  594131
  596033
  602591
  603414
  605184
  617065
  619791
  626066
  627311
  628527
  628655
  629387
  632750
  645928
  649489
  662444
  674206
  695603
  697284
  705129
  710379
  710559
  742092
  749359
  751795
  753582
  759133
  759992
  765854
  768385
  770963
  778498
  781309
  784662
  787334
  787599
  789109
  789773
  790810
  793940
  796695
  797180
  797182
  800381
  801016
  803233
  804417
  804420
  804422
  804458
  804713
  806930
  809517
  809548
  810076
  810798
  813802
  823887
]
2.26 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло milf ван"
]
2.14 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло milf ван"
]
1.98 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo milf bathroom"
]
1.73 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.