GET https://search.jues.net/search/embeds?q=creampie%2018%20piss

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.39 ms
(63.81%)
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
  541856
  545389
  559423
  566729
  579856
  599945
  599990
  600363
  613688
  614428
  627807
  631209
  632635
  632645
  632654
  632691
  632703
  633792
  634139
  634780
  639716
  641681
  641955
  642774
  647844
  647860
  647893
  649215
  651168
  651627
  656507
  666534
  666539
  666540
  666850
  666877
  666883
  695123
  702677
  744820
  800949
  827602
]
22.14 ms
(20.08%)
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:
[
  "creampie 18 piss"
  "creampie 18 piss"
  "creampie 18 piss"
  20
]
8.30 ms
(7.52%)
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
  647844
  559423
  614428
  613688
  632635
  541856
  579856
  800949
  639716
  647893
  632703
  634139
  641681
  827602
  634780
  649215
  599945
  632654
  666883
  702677
  632691
  632645
  744820
  641955
  600363
  631209
  545389
  642774
  666534
  651627
  647860
  666850
  656507
  695123
  651168
  666877
  666540
  666539
  599990
  566729
  627807
  633792
]
2.04 ms
(1.85%)
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
  541856
  545389
  559423
  566729
  579856
  599945
  599990
  600363
  613688
  614428
  627807
  631209
  632635
  632645
  632654
  632691
  632703
  633792
  634139
  634780
  639716
  641681
  641955
  642774
  647844
  647860
  647893
  649215
  651168
  651627
  656507
  666534
  666539
  666540
  666850
  666877
  666883
  695123
  702677
  744820
  800949
  827602
]
1.96 ms
(1.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie 18 piss"
]
1.90 ms
(1.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie 18 писсинг"
]
1.72 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie 18 писсинг"
]

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.