GET https://search.jues.net/search/embeds/2?q=%D1%81%20%D0%B1%D0%B0%D0%BB%D0%BA%D0%BE%D0%BD%D0%B0

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.58 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.88 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с балкона"
]
3 14.30 ms
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
  570882
  602835
  789584
  798843
  812120
  766395
  726604
  736190
  768994
  776306
  785759
  798789
  576723
  520346
  430560
  504786
  539350
  710278
  718029
  714836
  602637
  590718
  777177
  785682
  793117
  812509
  766056
  793008
  763836
  759313
  768048
  781004
  782306
  782500
  803702
  484153
  537135
  576506
  710335
  680397
  689871
  690679
  614006
  629754
  627738
  632418
  777593
  781920
  790806
  795597
  726047
  766051
  626993
  777995
  6739
  437178
  534572
  541035
  696642
  645526
  663191
  577673
  605226
  624143
  618273
  795079
  785681
  795829
  725417
  791311
  801545
  766472
  749346
  777531
  777972
  787558
  460087
  439159
  531549
  555826
  660649
  706546
  694930
  713963
  718786
  671563
  680900
  617336
  639126
  620188
  783907
  786383
  787308
  741737
  808154
  750712
  736273
  752131
  753684
  605087
  624497
  629260
  477603
  450846
  539503
  520391
  507104
  526716
  569875
  548418
  586394
  588719
  607658
  624140
  592079
  600197
  780130
  780321
  786389
  728300
]
4 3.12 ms
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
  6739
  430560
  437178
  439159
  450846
  460087
  477603
  484153
  504786
  507104
  520346
  520391
  526716
  531549
  534572
  537135
  539350
  539503
  541035
  548418
  555826
  569875
  570882
  576506
  576723
  577673
  586394
  590718
  592079
  600197
  602637
  602835
  605087
  605226
  607658
  614006
  617336
  618273
  620188
  624140
  624143
  624497
  626993
  627738
  629260
  629754
  632418
  639126
  645526
  660649
  663191
  671563
  680397
  680900
  689871
  690679
  694930
  696642
  706546
  710278
  710335
  713963
  714836
  718029
  718786
  725417
  726047
  726604
  728300
  736190
  736273
  741737
  749346
  750712
  752131
  753684
  759313
  763836
  766051
  766056
  766395
  766472
  768048
  768994
  776306
  777177
  777531
  777593
  777972
  777995
  780130
  780321
  781004
  781920
  782306
  782500
  783907
  785682
  785759
  786383
  786389
  787308
  787558
  789584
  790806
  791311
  793008
  793117
  795079
  795597
  795829
  798789
  798843
  801545
  803702
  808154
  812120
  812509
]
5 224.23 ms
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
  6739
  430560
  437178
  439159
  450846
  460087
  477603
  484153
  504786
  507104
  520346
  520391
  526716
  531549
  534572
  537135
  539350
  539503
  541035
  548418
  555826
  569875
  570882
  576506
  576723
  577673
  586394
  590718
  592079
  600197
  602637
  602835
  605087
  605226
  607658
  614006
  617336
  618273
  620188
  624140
  624143
  624497
  626993
  627738
  629260
  629754
  632418
  639126
  645526
  660649
  663191
  671563
  680397
  680900
  689871
  690679
  694930
  696642
  706546
  710278
  710335
  713963
  714836
  718029
  718786
  725417
  726047
  726604
  728300
  736190
  736273
  741737
  749346
  750712
  752131
  753684
  759313
  763836
  766051
  766056
  766395
  766472
  768048
  768994
  776306
  777177
  777531
  777593
  777972
  777995
  780130
  780321
  781004
  781920
  782306
  782500
  783907
  785682
  785759
  786383
  786389
  787308
  787558
  789584
  790806
  791311
  793008
  793117
  795079
  795597
  795829
  798789
  798843
  801545
  803702
  808154
  812120
  812509
]
6 2.02 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "балкон"
]
7 1.57 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "балкон"
]
8 213.77 ms
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
]

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.