GET https://search.jues.net/search/embeds?q=fat%20pussy%20toys

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.10 ms
(65.22%)
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
  50436
  382805
  385855
  392937
  398235
  401202
  415874
  435391
  438772
  444916
  452086
  452351
  453002
  453400
  467705
  468321
  474914
  482799
  499350
  506269
  508929
  509978
  509988
  512172
  517650
  520911
  526209
  540588
  541760
  550827
  554455
  591869
  593241
  601488
  602321
  628649
  636463
  647636
  678716
  700306
  711133
  726121
  746144
  758880
  768756
  793072
  806085
  814190
  816736
  820368
]
23.77 ms
(19.85%)
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:
[
  "fat pussy toys"
  "fat pussy toys"
  "fat pussy toys"
  20
]
7.93 ms
(6.62%)
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
  50436
  820368
  816736
  593241
  591869
  746144
  392937
  793072
  711133
  398235
  806085
  636463
  768756
  602321
  540588
  467705
  499350
  814190
  526209
  508929
  601488
  726121
  468321
  453002
  385855
  452351
  554455
  541760
  700306
  758880
  382805
  482799
  647636
  509978
  512172
  550827
  678716
  628649
  401202
  452086
  517650
  453400
  435391
  474914
  444916
  415874
  509988
  520911
  438772
  506269
]
3.00 ms
(2.50%)
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
  50436
  382805
  385855
  392937
  398235
  401202
  415874
  435391
  438772
  444916
  452086
  452351
  453002
  453400
  467705
  468321
  474914
  482799
  499350
  506269
  508929
  509978
  509988
  512172
  517650
  520911
  526209
  540588
  541760
  550827
  554455
  591869
  593241
  601488
  602321
  628649
  636463
  647636
  678716
  700306
  711133
  726121
  746144
  758880
  768756
  793072
  806085
  814190
  816736
  820368
]
2.08 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fat pussy toys"
]
1.74 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fat pussy toys"
]
1.67 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fat pussy toys"
]
1.44 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.