GET https://search.jues.net/search/embeds/4?q=milf%20outdoor

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.79 ms
(79.53%)
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
  401933
  416886
  430377
  434741
  437959
  438042
  443387
  445605
  448313
  450312
  451943
  451990
  452080
  452663
  453190
  454640
  455227
  455514
  456607
  456893
  457735
  457786
  458359
  458925
  459128
  464301
  469736
  470500
  471170
  471442
  472859
  476227
  476270
  480067
  481557
  484084
  484086
  484161
  484165
  487500
  488543
  489087
  490586
  493547
  494938
  497034
  497236
  497829
  500931
  503695
  504024
  509024
  511066
  512936
  515555
  518223
  518308
  519895
  522610
  522881
  526105
  527549
  528416
  528913
  531423
  532355
  533313
  537251
  537943
  542456
  545365
  545943
  545965
  547427
  548316
  551922
  552955
  554260
  555233
  555616
  557548
  561509
  562358
  562367
  562368
  563333
  566694
  567086
  568077
  569153
  572840
  573365
  577349
  579746
  581025
  583984
  585163
  590306
  597196
  601990
  603652
  604424
  606636
  618239
  619486
  619823
  628730
  637460
  646202
  646433
  649905
  649912
  690410
  691598
  725527
  787586
  789846
]
19.58 ms
(13.22%)
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
  691598
  649905
  545365
  554260
  561509
  567086
  606636
  585163
  725527
  604424
  789846
  448313
  430377
  438042
  490586
  537943
  487500
  497034
  484161
  453190
  481557
  471442
  450312
  470500
  504024
  532355
  494938
  497236
  518308
  528913
  471170
  472859
  480067
  547427
  563333
  568077
  545965
  548316
  557548
  583984
  542456
  579746
  690410
  590306
  443387
  455514
  445605
  488543
  489087
  493547
  497829
  522881
  527549
  649912
  454640
  457735
  476270
  484084
  452663
  456893
  484086
  503695
  509024
  512936
  518223
  533313
  526105
  519895
  476227
  551922
  566694
  569153
  552955
  555233
  646202
  555616
  581025
  619823
  603652
  628730
  619486
  787586
  451990
  455227
  434741
  437959
  459128
  522610
  531423
  452080
  458925
  484165
  515555
  500931
  528416
  646433
  618239
  456607
  457786
  511066
  458359
  464301
  545943
  572840
  577349
  601990
  401933
  451943
  573365
  469736
  637460
  597196
  537251
  562368
  562358
  416886
  562367
]
2.93 ms
(1.98%)
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
  401933
  416886
  430377
  434741
  437959
  438042
  443387
  445605
  448313
  450312
  451943
  451990
  452080
  452663
  453190
  454640
  455227
  455514
  456607
  456893
  457735
  457786
  458359
  458925
  459128
  464301
  469736
  470500
  471170
  471442
  472859
  476227
  476270
  480067
  481557
  484084
  484086
  484161
  484165
  487500
  488543
  489087
  490586
  493547
  494938
  497034
  497236
  497829
  500931
  503695
  504024
  509024
  511066
  512936
  515555
  518223
  518308
  519895
  522610
  522881
  526105
  527549
  528416
  528913
  531423
  532355
  533313
  537251
  537943
  542456
  545365
  545943
  545965
  547427
  548316
  551922
  552955
  554260
  555233
  555616
  557548
  561509
  562358
  562367
  562368
  563333
  566694
  567086
  568077
  569153
  572840
  573365
  577349
  579746
  581025
  583984
  585163
  590306
  597196
  601990
  603652
  604424
  606636
  618239
  619486
  619823
  628730
  637460
  646202
  646433
  649905
  649912
  690410
  691598
  725527
  787586
  789846
]
2.51 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf outdoor"
]
1.94 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf outdoor"
]
1.80 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf outdoor"
]

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.