GET https://search.jues.net/search/embeds/2?q=candy%20candy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.58 ms
(75.94%)
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
  387676
  399662
  420566
  430400
  433143
  447489
  456541
  456586
  464864
  465763
  469533
  471800
  480636
  480645
  481316
  484137
  486407
  487917
  489663
  491729
  491730
  503675
  506170
  511743
  512932
  513510
  520235
  522272
  534797
  536872
  549479
  563489
  566705
  568455
  574578
  574781
  574893
  575117
  575501
  576119
  579337
  586596
  590482
  597012
  624111
  647333
  649134
  652172
  666523
  670367
  701337
  758803
]
10.54 ms
(10.06%)
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
  511743
  484137
  387676
  430400
  520235
  575501
  549479
  574893
  670367
  574781
  464864
  433143
  456586
  465763
  399662
  481316
  489663
  512932
  471800
  456541
  503675
  566705
  579337
  574578
  652172
  575117
  576119
  758803
  491729
  536872
  491730
  420566
  480645
  666523
  480636
  447489
  522272
  506170
  469533
  487917
  486407
  563489
  513510
  534797
  586596
  701337
  568455
  647333
  624111
  649134
  590482
  597012
]
4.73 ms
(4.52%)
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:
[
  "candy candy"
  "candy candy"
  "candy candy"
  20
]
2.64 ms
(2.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "candy candy"
]
2.35 ms
(2.25%)
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
  387676
  399662
  420566
  430400
  433143
  447489
  456541
  456586
  464864
  465763
  469533
  471800
  480636
  480645
  481316
  484137
  486407
  487917
  489663
  491729
  491730
  503675
  506170
  511743
  512932
  513510
  520235
  522272
  534797
  536872
  549479
  563489
  566705
  568455
  574578
  574781
  574893
  575117
  575501
  576119
  579337
  586596
  590482
  597012
  624111
  647333
  649134
  652172
  666523
  670367
  701337
  758803
]
1.88 ms
(1.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "candy candy"
]
1.33 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "candy candy"
]

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.