GET https://search.jues.net/search/embeds?q=dick%20size

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
417.70 ms
(78.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член size"
]
80.70 ms
(15.23%)
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
  381964
  395159
  396883
  419051
  456109
  460803
  465605
  468791
  471645
  473063
  475833
  515307
  517784
  524758
  532791
  537797
  545514
  578396
  581252
  587930
  593277
  599996
  623877
  629396
  634095
  690100
  691531
  693955
  714261
  727209
  727399
  732377
  738724
  738891
  745874
  750210
  766099
  773894
  782396
  785397
  793975
  794787
  795665
  797750
  804710
  808148
  808876
  809775
  815528
  815554
  817508
  826707
  826952
  827166
]
12.98 ms
(2.45%)
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:
[
  "dick size"
  "dick size"
  "dick size"
  20
]
9.77 ms
(1.84%)
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
  815554
  727209
  809775
  773894
  766099
  396883
  381964
  808876
  826952
  815528
  738724
  738891
  795665
  808148
  793975
  750210
  537797
  817508
  826707
  623877
  395159
  827166
  581252
  727399
  794787
  804710
  515307
  690100
  471645
  587930
  468791
  745874
  691531
  732377
  797750
  629396
  545514
  782396
  456109
  714261
  473063
  419051
  634095
  785397
  460803
  693955
  593277
  524758
  599996
  475833
  465605
  517784
  532791
  578396
]
3.28 ms
(0.62%)
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
  381964
  395159
  396883
  419051
  456109
  460803
  465605
  468791
  471645
  473063
  475833
  515307
  517784
  524758
  532791
  537797
  545514
  578396
  581252
  587930
  593277
  599996
  623877
  629396
  634095
  690100
  691531
  693955
  714261
  727209
  727399
  732377
  738724
  738891
  745874
  750210
  766099
  773894
  782396
  785397
  793975
  794787
  795665
  797750
  804710
  808148
  808876
  809775
  815528
  815554
  817508
  826707
  826952
  827166
]
1.98 ms
(0.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член size"
]
1.92 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick size"
]
1.42 ms
(0.27%)
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.