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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.14 ms
(67.02%)
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
  396983
  418867
  419487
  423482
  423484
  423491
  423495
  423503
  428157
  430633
  430650
  435468
  447182
  450722
  453935
  457553
  459202
  463926
  473537
  479509
  480270
  482831
  483463
  490718
  494374
  497430
  502287
  512491
  516709
  537948
  539879
  551944
  560511
  574619
  578460
  581897
  587577
  588226
  592770
  594644
  595418
  604102
  622302
  634505
  674477
  686942
  707844
  774709
  781400
  821053
  821859
]
15.19 ms
(14.51%)
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:
[
  "bunny girl"
  "bunny girl"
  "bunny girl"
  20
]
9.82 ms
(9.38%)
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
  502287
  418867
  435468
  497430
  396983
  423482
  774709
  419487
  463926
  483463
  578460
  588226
  781400
  453935
  482831
  423491
  674477
  634505
  537948
  707844
  479509
  423484
  459202
  423495
  594644
  821859
  595418
  430650
  494374
  539879
  622302
  686942
  423503
  457553
  551944
  490718
  450722
  473537
  604102
  512491
  821053
  516709
  574619
  587577
  430633
  428157
  447182
  592770
  480270
  581897
  560511
]
2.35 ms
(2.24%)
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
  396983
  418867
  419487
  423482
  423484
  423491
  423495
  423503
  428157
  430633
  430650
  435468
  447182
  450722
  453935
  457553
  459202
  463926
  473537
  479509
  480270
  482831
  483463
  490718
  494374
  497430
  502287
  512491
  516709
  537948
  539879
  551944
  560511
  574619
  578460
  581897
  587577
  588226
  592770
  594644
  595418
  604102
  622302
  634505
  674477
  686942
  707844
  774709
  781400
  821053
  821859
]
1.93 ms
(1.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bunny девушк"
]
1.72 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bunny girl"
]
1.62 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bunny девушк"
]

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.