GET https://search.jues.net/search/embeds?q=lingerie%20young

Query Metrics

8 Database Queries
8 Different statements
109.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
68.39 ms
(62.25%)
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
  172291
  181902
  387281
  389639
  400182
  400865
  411685
  413174
  413499
  419095
  420038
  422832
  439623
  440481
  441611
  443580
  445345
  453191
  464631
  468715
  471053
  512332
  516009
  522013
  523367
  525329
  525935
  548549
  551268
  569246
  574595
  576417
  582801
  590627
  608787
  622929
  623618
  624286
  628811
  673048
  684298
  699610
  702522
  707703
  712973
  714309
  717663
  718878
  720624
  720693
  724734
  726707
  726777
  742507
  743178
  770475
  788107
  789690
  796115
  801858
  815268
  816935
  825683
]
22.11 ms
(20.12%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "lingerie young"
  "lingerie young"
  "lingerie young"
  20
]
9.04 ms
(8.23%)
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
  443580
  702522
  825683
  622929
  770475
  684298
  801858
  413174
  712973
  172291
  453191
  673048
  742507
  717663
  413499
  525935
  422832
  816935
  569246
  718878
  624286
  590627
  796115
  724734
  743178
  788107
  420038
  441611
  551268
  623618
  445345
  468715
  181902
  387281
  464631
  523367
  574595
  720624
  726777
  471053
  389639
  419095
  699610
  576417
  411685
  440481
  512332
  714309
  720693
  582801
  726707
  400182
  525329
  815268
  628811
  400865
  548549
  707703
  789690
  516009
  608787
  439623
  522013
]
2.44 ms
(2.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "lingerie young"
]
2.24 ms
(2.04%)
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
  172291
  181902
  387281
  389639
  400182
  400865
  411685
  413174
  413499
  419095
  420038
  422832
  439623
  440481
  441611
  443580
  445345
  453191
  464631
  468715
  471053
  512332
  516009
  522013
  523367
  525329
  525935
  548549
  551268
  569246
  574595
  576417
  582801
  590627
  608787
  622929
  623618
  624286
  628811
  673048
  684298
  699610
  702522
  707703
  712973
  714309
  717663
  718878
  720624
  720693
  724734
  726707
  726777
  742507
  743178
  770475
  788107
  789690
  796115
  801858
  815268
  816935
  825683
]
1.98 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lingerie young"
]
1.91 ms
(1.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "lingerie young"
]
1.74 ms
(1.59%)
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.