GET https://search.jues.net/search/embeds/3?q=blowjob%20twice

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
52.28 ms
(60.95%)
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
  420352
  427138
  428110
  428208
  428531
  442367
  448426
  449715
  460370
  467721
  467731
  469225
  471494
  492315
  495768
  496563
  505611
  510272
  512532
  512539
  516013
  516308
  517843
  518153
  519499
  521043
  524136
  525262
  529777
  550898
  552459
  569300
  572238
  575828
  587421
  593832
  601634
  621655
  625861
  625968
  682303
  700307
  714109
]
12.79 ms
(14.91%)
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:
[
  "blowjob twice"
  "blowjob twice"
  "blowjob twice"
  20
]
9.63 ms
(11.23%)
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
  550898
  700307
  448426
  524136
  492315
  519499
  587421
  714109
  467721
  525262
  518153
  449715
  442367
  572238
  601634
  569300
  496563
  427138
  529777
  552459
  420352
  575828
  469225
  428531
  625968
  460370
  516013
  495768
  510272
  428110
  682303
  467731
  428208
  512539
  593832
  621655
  512532
  505611
  517843
  516308
  625861
  521043
  471494
]
3.27 ms
(3.81%)
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
  420352
  427138
  428110
  428208
  428531
  442367
  448426
  449715
  460370
  467721
  467731
  469225
  471494
  492315
  495768
  496563
  505611
  510272
  512532
  512539
  516013
  516308
  517843
  518153
  519499
  521043
  524136
  525262
  529777
  550898
  552459
  569300
  572238
  575828
  587421
  593832
  601634
  621655
  625861
  625968
  682303
  700307
  714109
]
2.18 ms
(2.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob twice"
]
2.03 ms
(2.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс twice"
]
1.93 ms
(2.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс twice"
]
1.67 ms
(1.94%)
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.