GET https://search.jues.net/search/embeds?q=fit%20young%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.22 ms
(61.14%)
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
  397793
  400760
  403642
  409088
  416428
  418013
  422909
  441293
  452540
  485325
  514113
  514479
  531120
  532164
  536387
  539192
  545363
  545533
  553703
  575194
  583507
  589232
  623473
  637436
  670758
  673976
  680176
  684970
  702163
  702168
  708389
  714474
  723675
  724286
  742241
  758465
  768451
  781308
  787955
  796236
  801356
  811080
]
19.13 ms
(20.80%)
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:
[
  "fit young girl"
  "fit young girl"
  "fit young girl"
  20
]
7.20 ms
(7.83%)
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
  637436
  787955
  781308
  684970
  708389
  723675
  623473
  758465
  673976
  811080
  441293
  514479
  768451
  397793
  796236
  724286
  416428
  400760
  485325
  452540
  545533
  714474
  403642
  536387
  801356
  539192
  422909
  670758
  589232
  742241
  409088
  553703
  702168
  702163
  514113
  583507
  680176
  545363
  575194
  418013
  531120
  532164
]
2.67 ms
(2.91%)
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
  397793
  400760
  403642
  409088
  416428
  418013
  422909
  441293
  452540
  485325
  514113
  514479
  531120
  532164
  536387
  539192
  545363
  545533
  553703
  575194
  583507
  589232
  623473
  637436
  670758
  673976
  680176
  684970
  702163
  702168
  708389
  714474
  723675
  724286
  742241
  758465
  768451
  781308
  787955
  796236
  801356
  811080
]
1.92 ms
(2.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fit young girl"
]
1.67 ms
(1.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fit young девушк"
]
1.62 ms
(1.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fit young девушк"
]

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.