GET https://search.jues.net/search/embeds/9?q=blonde%20big%20toys

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.51 ms
(50.64%)
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
  394608
  401318
  416989
  418686
  420291
  426527
  428103
  432077
  433227
  436178
  441024
  442673
  444606
  446084
  452601
  454107
  458391
  459535
  462450
  463082
  465605
  465613
  476120
  476752
  477442
  494492
  497874
  504518
  504841
  506269
  513569
  513576
  515358
  517095
  518599
  519157
  519561
  520763
  527416
  527915
  527975
  528993
  530000
  533978
  542954
  545300
  545698
  550343
  584492
  584929
  590562
  591247
  598080
  605182
  606202
  624084
  631504
  667748
]
45.26 ms
(32.97%)
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:
[
  "blonde big toys"
  "blonde big toys"
  "blonde big toys"
  20
]
12.60 ms
(9.18%)
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
  465613
  476120
  513569
  454107
  458391
  463082
  606202
  477442
  476752
  513576
  519157
  530000
  459535
  426527
  515358
  533978
  545698
  517095
  444606
  527915
  394608
  452601
  590562
  465605
  527975
  432077
  433227
  519561
  631504
  446084
  420291
  667748
  591247
  550343
  584492
  428103
  442673
  416989
  462450
  504841
  497874
  542954
  441024
  545300
  605182
  401318
  518599
  584929
  527416
  528993
  494492
  436178
  506269
  520763
  504518
  598080
  624084
  418686
]
2.49 ms
(1.81%)
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
  394608
  401318
  416989
  418686
  420291
  426527
  428103
  432077
  433227
  436178
  441024
  442673
  444606
  446084
  452601
  454107
  458391
  459535
  462450
  463082
  465605
  465613
  476120
  476752
  477442
  494492
  497874
  504518
  504841
  506269
  513569
  513576
  515358
  517095
  518599
  519157
  519561
  520763
  527416
  527915
  527975
  528993
  530000
  533978
  542954
  545300
  545698
  550343
  584492
  584929
  590562
  591247
  598080
  605182
  606202
  624084
  631504
  667748
]
2.03 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde big toys"
]
2.02 ms
(1.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая большие toys"
]
1.70 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая большие toys"
]
1.64 ms
(1.20%)
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.