GET https://search.jues.net/search/embeds?q=masturbation%20upskirt

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
50.06 ms
(59.70%)
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
  387409
  388471
  391150
  413043
  418667
  434135
  436047
  455398
  460890
  468925
  472799
  473099
  494865
  515054
  529351
  532654
  533711
  535356
  541414
  541802
  546783
  552502
  553185
  554492
  555853
  559199
  564955
  589140
  599238
  600744
  601679
  609040
  617472
  624834
  687620
  741660
  778883
  782138
  782152
  789904
  790485
  793127
  806801
]
14.37 ms
(17.14%)
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
  782152
  741660
  541414
  789904
  782138
  532654
  388471
  778883
  553185
  472799
  387409
  600744
  599238
  806801
  554492
  541802
  533711
  687620
  609040
  418667
  559199
  460890
  468925
  494865
  552502
  790485
  473099
  793127
  601679
  413043
  535356
  617472
  455398
  391150
  529351
  546783
  515054
  589140
  555853
  564955
  434135
  436047
  624834
]
10.92 ms
(13.02%)
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:
[
  "masturbation upskirt"
  "masturbation upskirt"
  "masturbation upskirt"
  20
]
2.19 ms
(2.61%)
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
  387409
  388471
  391150
  413043
  418667
  434135
  436047
  455398
  460890
  468925
  472799
  473099
  494865
  515054
  529351
  532654
  533711
  535356
  541414
  541802
  546783
  552502
  553185
  554492
  555853
  559199
  564955
  589140
  599238
  600744
  601679
  609040
  617472
  624834
  687620
  741660
  778883
  782138
  782152
  789904
  790485
  793127
  806801
]
1.97 ms
(2.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation upskirt"
]
1.58 ms
(1.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац upskirt"
]
1.29 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац upskirt"
]

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.