GET https://search.jues.net/search/embeds?q=atm%20swallow%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.29 ms
(49.45%)
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
  497459
  530681
  531115
  533915
  534027
  534032
  534378
  535505
  537890
  539203
  540518
  541197
  541201
  542583
  542595
  545410
  545611
  600363
  628333
  628382
  628383
  630537
  630764
  631195
  631200
  632635
  632978
  633451
  633743
  633770
  633792
  634115
  634116
  634139
  634780
  634801
  636293
  636296
  637021
  637141
  639716
  640784
  641975
  642060
  644916
  645258
  645858
  646896
  647313
  647830
  647936
  647952
  647972
  648257
  648809
  666899
  666901
  696204
  696579
  696582
  707391
]
43.89 ms
(31.78%)
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:
[
  "atm swallow teen"
  "atm swallow teen"
  "atm swallow teen"
  20
]
16.68 ms
(12.08%)
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
  645258
  632635
  637141
  642060
  636296
  530681
  631195
  640784
  636293
  645858
  696204
  648809
  637021
  631200
  541201
  633451
  641975
  541197
  630764
  639716
  497459
  539203
  707391
  630537
  534032
  537890
  534378
  647313
  634139
  531115
  542583
  542595
  646896
  666899
  633743
  535505
  540518
  696579
  666901
  634116
  647936
  696582
  647830
  647952
  633770
  600363
  628382
  633792
  534027
  647972
  634115
  632978
  634801
  644916
  545410
  545611
  628383
  634780
  648257
  628333
  533915
]
2.16 ms
(1.56%)
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
  497459
  530681
  531115
  533915
  534027
  534032
  534378
  535505
  537890
  539203
  540518
  541197
  541201
  542583
  542595
  545410
  545611
  600363
  628333
  628382
  628383
  630537
  630764
  631195
  631200
  632635
  632978
  633451
  633743
  633770
  633792
  634115
  634116
  634139
  634780
  634801
  636293
  636296
  637021
  637141
  639716
  640784
  641975
  642060
  644916
  645258
  645858
  646896
  647313
  647830
  647936
  647952
  647972
  648257
  648809
  666899
  666901
  696204
  696579
  696582
  707391
]
2.10 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "atm swallow teen"
]
1.80 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "atm глота teen"
]
1.68 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "atm глота teen"
]

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.