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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
46.97 ms
(51.64%)
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
  393833
  436047
  447934
  459252
  460896
  488476
  492651
  513174
  515054
  517027
  520219
  523832
  529916
  530103
  530687
  530710
  532148
  533711
  533756
  534657
  535413
  546783
  552547
  554804
  559206
  560316
  564955
  572273
  579706
  597431
  597738
  609040
  613647
  617812
  643287
  644598
  644879
  708184
  778883
  806801
]
27.26 ms
(29.97%)
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:
[
  "upskirt big amateur"
  "upskirt big amateur"
  "upskirt big amateur"
  20
]
7.26 ms
(7.98%)
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
  532148
  644598
  535413
  552547
  597431
  579706
  778883
  708184
  644879
  533756
  559206
  530710
  529916
  530687
  613647
  609040
  393833
  533711
  806801
  643287
  488476
  513174
  560316
  617812
  447934
  492651
  459252
  534657
  530103
  546783
  515054
  597738
  554804
  460896
  520219
  517027
  564955
  523832
  436047
  572273
]
2.20 ms
(2.42%)
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
  393833
  436047
  447934
  459252
  460896
  488476
  492651
  513174
  515054
  517027
  520219
  523832
  529916
  530103
  530687
  530710
  532148
  533711
  533756
  534657
  535413
  546783
  552547
  554804
  559206
  560316
  564955
  572273
  579706
  597431
  597738
  609040
  613647
  617812
  643287
  644598
  644879
  708184
  778883
  806801
]
2.07 ms
(2.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "upskirt big amateur"
]
1.99 ms
(2.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "upskirt большие любительск"
]
1.63 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "upskirt большие любительск"
]
1.57 ms
(1.73%)
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.