GET https://search.jues.net/search/embeds?q=%D1%80%D0%B5%D1%82%D1%80%D0%BE%20%D0%BF%D0%BE%D1%80%D0%BD

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.59 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.82 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ретро порн"
]
3 14.86 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
  538927
  538924
  628330
  538954
  707287
  606841
  543660
  750065
  561367
  556988
  556759
  583871
  750061
  750062
  525752
  576644
  660150
  630309
  482074
  490013
  541396
  581273
  592461
  750063
  525747
  490034
  548297
  576709
  576718
  576622
  576712
  750060
  513947
  541374
  524990
  576715
  592476
  472312
  519227
  541607
  581350
  750064
  511392
  576713
  576645
  576711
  526888
  581401
  621698
  513025
  511031
  465107
  545944
  549214
  541594
  524986
  453161
  622375
  577371
  541631
  606425
  628326
  519241
  538816
  524987
  524951
  615539
  544263
  648201
  648199
  581279
  544312
  544321
  544270
  615535
  538829
  543661
  538838
  538930
  677737
  727436
  538856
  538888
  547869
  592516
  548292
  583581
  615542
  544322
  548287
  548281
  628317
  541339
  544323
  574292
  538905
  525757
  538843
  668151
  593270
  620145
  538910
  541360
  559129
  581332
  668153
  668158
  628325
  719140
  538863
  538956
  491783
  583878
  548277
  592465
  525750
  668157
  592541
  300522
  539649
]
4 2.63 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
  300522
  453161
  465107
  472312
  482074
  490013
  490034
  491783
  511031
  511392
  513025
  513947
  519227
  519241
  524951
  524986
  524987
  524990
  525747
  525750
  525752
  525757
  526888
  538816
  538829
  538838
  538843
  538856
  538863
  538888
  538905
  538910
  538924
  538927
  538930
  538954
  538956
  539649
  541339
  541360
  541374
  541396
  541594
  541607
  541631
  543660
  543661
  544263
  544270
  544312
  544321
  544322
  544323
  545944
  547869
  548277
  548281
  548287
  548292
  548297
  549214
  556759
  556988
  559129
  561367
  574292
  576622
  576644
  576645
  576709
  576711
  576712
  576713
  576715
  576718
  577371
  581273
  581279
  581332
  581350
  581401
  583581
  583871
  583878
  592461
  592465
  592476
  592516
  592541
  593270
  606425
  606841
  615535
  615539
  615542
  620145
  621698
  622375
  628317
  628325
  628326
  628330
  630309
  648199
  648201
  660150
  668151
  668153
  668157
  668158
  677737
  707287
  719140
  727436
  750060
  750061
  750062
  750063
  750064
  750065
]
5 129.26 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
  300522
  453161
  465107
  472312
  482074
  490013
  490034
  491783
  511031
  511392
  513025
  513947
  519227
  519241
  524951
  524986
  524987
  524990
  525747
  525750
  525752
  525757
  526888
  538816
  538829
  538838
  538843
  538856
  538863
  538888
  538905
  538910
  538924
  538927
  538930
  538954
  538956
  539649
  541339
  541360
  541374
  541396
  541594
  541607
  541631
  543660
  543661
  544263
  544270
  544312
  544321
  544322
  544323
  545944
  547869
  548277
  548281
  548287
  548292
  548297
  549214
  556759
  556988
  559129
  561367
  574292
  576622
  576644
  576645
  576709
  576711
  576712
  576713
  576715
  576718
  577371
  581273
  581279
  581332
  581350
  581401
  583581
  583871
  583878
  592461
  592465
  592476
  592516
  592541
  593270
  606425
  606841
  615535
  615539
  615542
  620145
  621698
  622375
  628317
  628325
  628326
  628330
  630309
  648199
  648201
  660150
  668151
  668153
  668157
  668158
  677737
  707287
  719140
  727436
  750060
  750061
  750062
  750063
  750064
  750065
]
6 2.25 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр порн"
]
7 1.83 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр порн"
]
8 21.36 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.