GET https://search.jues.net/search/embeds?q=big%20ass%20classic

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.73 ms
(55.41%)
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
  386876
  404361
  413648
  423944
  435668
  444238
  462553
  464302
  469272
  469660
  483474
  489443
  502278
  516006
  516010
  519224
  519256
  519262
  524977
  538865
  538895
  541292
  541886
  554784
  559118
  561024
  563153
  574291
  577355
  581350
  587471
  587843
  590943
  619466
  620135
  624893
  628321
  640696
  644255
  695180
  695559
  696322
  703833
  703834
  703842
  704269
  704272
  704273
  704525
  704526
  704528
  704531
  713834
  730272
  735919
  742803
  757517
  793572
  817308
  819678
]
34.18 ms
(27.55%)
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:
[
  "big ass classic"
  "big ass classic"
  "big ass classic"
  20
]
10.08 ms
(8.13%)
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
  386876
  793572
  703842
  644255
  817308
  730272
  742803
  704272
  704273
  695180
  735919
  703834
  695559
  819678
  696322
  563153
  628321
  587843
  538865
  587471
  435668
  413648
  464302
  516010
  519224
  757517
  624893
  423944
  538895
  559118
  519256
  404361
  519262
  516006
  713834
  489443
  502278
  462553
  469272
  561024
  619466
  469660
  577355
  704269
  704528
  574291
  620135
  590943
  541292
  704525
  581350
  640696
  524977
  444238
  704526
  704531
  541886
  483474
  554784
  703833
]
3.16 ms
(2.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass classic"
]
2.64 ms
(2.13%)
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
  386876
  404361
  413648
  423944
  435668
  444238
  462553
  464302
  469272
  469660
  483474
  489443
  502278
  516006
  516010
  519224
  519256
  519262
  524977
  538865
  538895
  541292
  541886
  554784
  559118
  561024
  563153
  574291
  577355
  581350
  587471
  587843
  590943
  619466
  620135
  624893
  628321
  640696
  644255
  695180
  695559
  696322
  703833
  703834
  703842
  704269
  704272
  704273
  704525
  704526
  704528
  704531
  713834
  730272
  735919
  742803
  757517
  793572
  817308
  819678
]
1.80 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп classic"
]
1.73 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп classic"
]

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.