GET https://search.jues.net/search/embeds/8?q=young%20girl%20stockings

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.92 ms
(86.58%)
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
  187733
  187789
  358566
  382003
  382075
  382518
  384807
  384901
  395721
  398942
  401200
  404954
  412289
  413457
  419590
  422625
  422646
  422970
  423018
  423271
  423394
  425737
  439320
  446258
  446415
  448445
  448834
  453345
  458725
  460737
  462698
  465786
  467048
  472879
  473472
  479767
  480929
  491530
  497219
  499774
  501801
  508818
  511394
  515206
  515215
  515262
  519982
  522611
  526507
  541879
  542601
  543779
  546051
  551268
  553054
  562128
  564066
  568573
  578397
  579113
  580797
  581096
  581193
  586527
  586649
  590953
  603622
  611507
  615862
  617135
  619471
  627803
  630309
  642750
  664217
  664307
  664955
  664957
  665379
  667476
  680177
  697892
  699586
  706799
  714473
  716543
  718407
  722846
  726332
  727667
  729818
  736826
  742798
  743750
  745785
  746045
  747151
  748143
  750719
  756622
  758552
  770175
  770602
  770896
  774250
  782120
  787890
  797785
  798732
  799208
  804513
  806879
  807976
  810963
  811628
  815567
  816790
  820384
  823261
  823923
]
15.29 ms
(8.08%)
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
  515215
  667476
  716543
  664307
  664957
  580797
  630309
  810963
  748143
  745785
  806879
  615862
  467048
  522611
  816790
  706799
  718407
  664217
  787890
  804513
  798732
  774250
  736826
  462698
  473472
  581193
  581096
  579113
  413457
  425737
  187733
  578397
  384901
  382003
  586649
  358566
  382075
  446415
  501801
  491530
  423018
  448834
  511394
  541879
  519982
  756622
  726332
  412289
  453345
  499774
  515262
  479767
  811628
  398942
  439320
  551268
  553054
  603622
  472879
  542601
  460737
  480929
  497219
  515206
  758552
  743750
  750719
  782120
  382518
  823261
  815567
  526507
  697892
  665379
  619471
  586527
  611507
  797785
  747151
  770175
  770896
  770602
  799208
  807976
  187789
  419590
  568573
  401200
  458725
  448445
  722846
  543779
  404954
  446258
  642750
  727667
  546051
  680177
  423271
  422970
  395721
  590953
  820384
  823923
  746045
  562128
  384807
  422625
  422646
  699586
  664955
  714473
  564066
  617135
  729818
  742798
  627803
  465786
  423394
  508818
]
2.59 ms
(1.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
  187733
  187789
  358566
  382003
  382075
  382518
  384807
  384901
  395721
  398942
  401200
  404954
  412289
  413457
  419590
  422625
  422646
  422970
  423018
  423271
  423394
  425737
  439320
  446258
  446415
  448445
  448834
  453345
  458725
  460737
  462698
  465786
  467048
  472879
  473472
  479767
  480929
  491530
  497219
  499774
  501801
  508818
  511394
  515206
  515215
  515262
  519982
  522611
  526507
  541879
  542601
  543779
  546051
  551268
  553054
  562128
  564066
  568573
  578397
  579113
  580797
  581096
  581193
  586527
  586649
  590953
  603622
  611507
  615862
  617135
  619471
  627803
  630309
  642750
  664217
  664307
  664955
  664957
  665379
  667476
  680177
  697892
  699586
  706799
  714473
  716543
  718407
  722846
  726332
  727667
  729818
  736826
  742798
  743750
  745785
  746045
  747151
  748143
  750719
  756622
  758552
  770175
  770602
  770896
  774250
  782120
  787890
  797785
  798732
  799208
  804513
  806879
  807976
  810963
  811628
  815567
  816790
  820384
  823261
  823923
]
2.01 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young girl stockings"
]
1.94 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young девушк чулк нижн бел"
]
1.69 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young девушк чулк нижн бел"
]

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.