GET https://search.jues.net/search/embeds?q=boobs%20collection

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.78 ms
(70.90%)
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
  396791
  401992
  411720
  420358
  420410
  423196
  426512
  428693
  431904
  434073
  454331
  455008
  456487
  472584
  473341
  476320
  486971
  509303
  511392
  533639
  535315
  542456
  544254
  544585
  554826
  566073
  572740
  574200
  581929
  598177
  603549
  605475
  627743
  629575
  667928
  697258
  699698
  701704
  728461
  742047
  743564
  743846
  744413
  751501
  781821
  784219
  794262
  800805
  803208
  806397
  817033
  822462
  823510
  824046
  825837
]
10.16 ms
(10.79%)
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
  825837
  794262
  401992
  781821
  824046
  544585
  699698
  751501
  743846
  744413
  728461
  701704
  396791
  800805
  434073
  697258
  822462
  428693
  566073
  629575
  742047
  411720
  823510
  454331
  476320
  605475
  806397
  533639
  535315
  572740
  627743
  784219
  509303
  426512
  431904
  473341
  511392
  667928
  803208
  743564
  423196
  472584
  817033
  456487
  486971
  544254
  542456
  554826
  581929
  598177
  420410
  603549
  420358
  455008
  574200
]
6.54 ms
(6.94%)
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:
[
  "boobs collection"
  "boobs collection"
  "boobs collection"
  20
]
3.48 ms
(3.69%)
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
  396791
  401992
  411720
  420358
  420410
  423196
  426512
  428693
  431904
  434073
  454331
  455008
  456487
  472584
  473341
  476320
  486971
  509303
  511392
  533639
  535315
  542456
  544254
  544585
  554826
  566073
  572740
  574200
  581929
  598177
  603549
  605475
  627743
  629575
  667928
  697258
  699698
  701704
  728461
  742047
  743564
  743846
  744413
  751501
  781821
  784219
  794262
  800805
  803208
  806397
  817033
  822462
  823510
  824046
  825837
]
2.04 ms
(2.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs collection"
]
1.86 ms
(1.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs collection"
]
1.79 ms
(1.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs collection"
]

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.