GET https://search.jues.net/search/embeds?q=sisters%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.94 ms
(61.09%)
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
  126458
  382181
  385680
  388647
  395622
  395661
  397371
  397915
  400705
  401073
  401278
  404318
  405029
  408326
  414177
  420510
  422642
  428451
  446268
  447855
  459896
  464385
  479820
  496454
  497958
  508518
  516659
  521784
  525688
  525946
  533519
  534201
  536580
  593972
  614992
  631948
  653636
  737134
  760958
  765265
  772449
  781584
  787033
  801271
  805069
  806058
  807471
  811938
]
25.39 ms
(21.86%)
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:
[
  "sisters teen"
  "sisters teen"
  "sisters teen"
  20
]
10.17 ms
(8.76%)
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
  781584
  593972
  397915
  397371
  126458
  382181
  787033
  801271
  400705
  388647
  765265
  772449
  807471
  496454
  653636
  805069
  806058
  422642
  385680
  408326
  459896
  811938
  631948
  395661
  401073
  446268
  405029
  414177
  404318
  447855
  534201
  536580
  737134
  401278
  420510
  533519
  760958
  395622
  516659
  497958
  525946
  521784
  428451
  479820
  508518
  614992
  464385
  525688
]
2.58 ms
(2.22%)
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
  126458
  382181
  385680
  388647
  395622
  395661
  397371
  397915
  400705
  401073
  401278
  404318
  405029
  408326
  414177
  420510
  422642
  428451
  446268
  447855
  459896
  464385
  479820
  496454
  497958
  508518
  516659
  521784
  525688
  525946
  533519
  534201
  536580
  593972
  614992
  631948
  653636
  737134
  760958
  765265
  772449
  781584
  787033
  801271
  805069
  806058
  807471
  811938
]
1.94 ms
(1.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sisters teen"
]
1.81 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sisters teen"
]
1.75 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sisters teen"
]
1.56 ms
(1.34%)
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.