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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.20 ms
(62.48%)
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
  100685
  100976
  101789
  388672
  391674
  393309
  408880
  408911
  416242
  417478
  462424
  466633
  466636
  466637
  466950
  473213
  485059
  493789
  511571
  514300
  514833
  514839
  515006
  516025
  516071
  520619
  523229
  523591
  525028
  533841
  533843
  533845
  538070
  539493
  545255
  550827
  553788
  567734
  568566
  579350
  611365
  611394
  620105
  621992
  675869
  681802
  734262
  742870
  746958
  749166
  755109
  757261
  803393
  818682
  825341
]
28.86 ms
(22.77%)
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:
[
  "dutch girl"
  "dutch girl"
  "dutch girl"
  20
]
7.49 ms
(5.91%)
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
  393309
  545255
  391674
  388672
  408911
  408880
  473213
  514839
  466633
  466636
  466950
  462424
  466637
  621992
  514833
  485059
  533841
  523229
  101789
  803393
  818682
  681802
  749166
  515006
  742870
  757261
  675869
  567734
  533843
  734262
  100976
  825341
  100685
  533845
  611394
  755109
  746958
  539493
  516071
  553788
  417478
  493789
  538070
  525028
  620105
  416242
  520619
  514300
  568566
  611365
  511571
  579350
  550827
  523591
  516025
]
2.49 ms
(1.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dutch girl"
]
2.48 ms
(1.96%)
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
  100685
  100976
  101789
  388672
  391674
  393309
  408880
  408911
  416242
  417478
  462424
  466633
  466636
  466637
  466950
  473213
  485059
  493789
  511571
  514300
  514833
  514839
  515006
  516025
  516071
  520619
  523229
  523591
  525028
  533841
  533843
  533845
  538070
  539493
  545255
  550827
  553788
  567734
  568566
  579350
  611365
  611394
  620105
  621992
  675869
  681802
  734262
  742870
  746958
  749166
  755109
  757261
  803393
  818682
  825341
]
2.17 ms
(1.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.14 ms
(1.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dutch девушк"
]
1.93 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dutch девушк"
]

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.