GET https://search.jues.net/search/embeds?q=beautiful%20models

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.68 ms
(70.38%)
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
  597739
  516845
  772701
  116757
  571220
  741640
  423239
  382097
  757259
  393471
  534803
  434075
  534793
  440629
  427266
  550237
  550677
  599018
  520529
  564562
  395653
  818299
  819272
  820346
  534800
  729328
  619870
  703505
  574593
  473240
  387047
  405565
  569021
  604025
  605412
  512036
  580388
  660273
  556525
  451451
  709407
  654201
  664435
  532531
  402008
  519542
  507880
  590667
  532643
  679801
  599988
]
69.37 ms
(22.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
  116757
  382097
  387047
  393471
  395653
  402008
  405565
  423239
  427266
  434075
  440629
  451451
  473240
  507880
  512036
  516845
  519542
  520529
  532531
  532643
  534793
  534800
  534803
  550237
  550677
  556525
  564562
  569021
  571220
  574593
  580388
  590667
  597739
  599018
  599988
  604025
  605412
  619870
  654201
  660273
  664435
  679801
  703505
  709407
  729328
  741640
  757259
  772701
  818299
  819272
  820346
]
11.74 ms
(3.83%)
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:
[
  "beautiful models"
  "beautiful models"
  "beautiful models"
  20
]
2.39 ms
(0.78%)
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
  116757
  382097
  387047
  393471
  395653
  402008
  405565
  423239
  427266
  434075
  440629
  451451
  473240
  507880
  512036
  516845
  519542
  520529
  532531
  532643
  534793
  534800
  534803
  550237
  550677
  556525
  564562
  569021
  571220
  574593
  580388
  590667
  597739
  599018
  599988
  604025
  605412
  619870
  654201
  660273
  664435
  679801
  703505
  709407
  729328
  741640
  757259
  772701
  818299
  819272
  820346
]
2.10 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая models"
]
2.02 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful models"
]
1.66 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая models"
]
1.51 ms
(0.49%)
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.