GET https://search.jues.net/search/embeds/10?q=homemade%20little

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.20 ms
(65.83%)
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
  396275
  402724
  416512
  421526
  421967
  434369
  441645
  444660
  453162
  456523
  456925
  462331
  462991
  468280
  477554
  477773
  494815
  497951
  498623
  499089
  500268
  500288
  501338
  509345
  509969
  509997
  514315
  515203
  517665
  518131
  518275
  518761
  520011
  520984
  523492
  524301
  525154
  527074
  538281
  561980
  571012
  572318
  575197
  582376
  587939
  602519
  603810
  603875
  606002
  606762
  610404
  614408
  622666
  628282
]
13.26 ms
(12.99%)
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
  477554
  456925
  518761
  498623
  572318
  614408
  587939
  462331
  402724
  462991
  416512
  494815
  500288
  571012
  468280
  456523
  499089
  520011
  500268
  514315
  524301
  520984
  628282
  434369
  396275
  421967
  561980
  527074
  444660
  538281
  602519
  622666
  515203
  421526
  497951
  441645
  509997
  582376
  509969
  610404
  523492
  518131
  509345
  606002
  517665
  606762
  525154
  603810
  453162
  518275
  501338
  477773
  575197
  603875
]
11.87 ms
(11.63%)
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:
[
  "homemade little"
  "homemade little"
  "homemade little"
  20
]
2.61 ms
(2.55%)
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
  396275
  402724
  416512
  421526
  421967
  434369
  441645
  444660
  453162
  456523
  456925
  462331
  462991
  468280
  477554
  477773
  494815
  497951
  498623
  499089
  500268
  500288
  501338
  509345
  509969
  509997
  514315
  515203
  517665
  518131
  518275
  518761
  520011
  520984
  523492
  524301
  525154
  527074
  538281
  561980
  571012
  572318
  575197
  582376
  587939
  602519
  603810
  603875
  606002
  606762
  610404
  614408
  622666
  628282
]
1.96 ms
(1.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade little"
]
1.78 ms
(1.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск little"
]
1.64 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск little"
]

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.