GET https://search.jues.net/search/embeds?q=%D0%B0%D0%BD%D0%B0%D0%BB%20%D0%BA%D0%B8%D1%82%D1%82%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.47 ms
(55.77%)
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:
[
  "анал китти"
  "анал китти"
  "анал китти"
  20
]
84.02 ms
(36.20%)
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
  491786
  513761
  524628
  530018
  530637
  530661
  533932
  534215
  537195
  540574
  541366
  545465
  565254
  567950
  571230
  589408
  590731
  594389
  597236
  599987
  600354
  606801
  613485
  619367
  624505
  632706
  633742
  635258
  637077
  637086
  637694
  638991
  640739
  640771
  643100
  647630
  647969
  647995
  656568
  666865
  673570
  674414
  676087
  704256
  719002
  719009
  719011
  722224
  722636
  741527
  741543
  745384
  749335
  749338
  750554
  762183
  769887
  770986
  795683
]
9.15 ms
(3.94%)
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
  533932
  749338
  597236
  647969
  719002
  647630
  719009
  719011
  722636
  769887
  762183
  567950
  589408
  750554
  770986
  749335
  722224
  637077
  741527
  594389
  741543
  637694
  537195
  613485
  619367
  545465
  795683
  638991
  590731
  571230
  673570
  647995
  674414
  643100
  530018
  600354
  640771
  606801
  656568
  540574
  704256
  624505
  541366
  491786
  745384
  637086
  565254
  676087
  534215
  530661
  640739
  633742
  635258
  666865
  513761
  524628
  632706
  530637
  599987
]
3.26 ms
(1.41%)
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
  491786
  513761
  524628
  530018
  530637
  530661
  533932
  534215
  537195
  540574
  541366
  545465
  565254
  567950
  571230
  589408
  590731
  594389
  597236
  599987
  600354
  606801
  613485
  619367
  624505
  632706
  633742
  635258
  637077
  637086
  637694
  638991
  640739
  640771
  643100
  647630
  647969
  647995
  656568
  666865
  673570
  674414
  676087
  704256
  719002
  719009
  719011
  722224
  722636
  741527
  741543
  745384
  749335
  749338
  750554
  762183
  769887
  770986
  795683
]
1.96 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал китти"
]
1.53 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал китт"
]
1.41 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал китт"
]
1.33 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.