GET https://search.jues.net/search/embeds?q=scandal%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.95 ms
(48.52%)
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
  326017
  397812
  412432
  414753
  415896
  427432
  464646
  482549
  485475
  485481
  486639
  490418
  490743
  490745
  490747
  490748
  496095
  516836
  521185
  528121
  528126
  528129
  528130
  533204
  537831
  541963
  560539
  575193
  601669
  610838
  666137
  676621
  682023
  682179
  687452
  693241
  718600
  720415
  720417
  726328
  732510
  746012
  758136
  779764
  780531
  788692
  797726
  814799
  814910
  815268
  815330
  815872
  816214
  816260
  823405
  828138
]
48.63 ms
(36.90%)
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:
[
  "scandal sex"
  "scandal sex"
  "scandal sex"
  20
]
8.99 ms
(6.82%)
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
  758136
  682179
  528130
  490418
  427432
  682023
  797726
  814799
  575193
  601669
  780531
  746012
  732510
  828138
  676621
  788692
  666137
  779764
  815872
  687452
  537831
  816214
  533204
  823405
  726328
  718600
  412432
  528126
  516836
  541963
  397812
  490743
  528121
  464646
  814910
  414753
  496095
  693241
  720415
  528129
  560539
  610838
  720417
  490748
  486639
  490745
  490747
  816260
  521185
  326017
  815330
  485475
  415896
  485481
  482549
  815268
]
3.03 ms
(2.30%)
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
  326017
  397812
  412432
  414753
  415896
  427432
  464646
  482549
  485475
  485481
  486639
  490418
  490743
  490745
  490747
  490748
  496095
  516836
  521185
  528121
  528126
  528129
  528130
  533204
  537831
  541963
  560539
  575193
  601669
  610838
  666137
  676621
  682023
  682179
  687452
  693241
  718600
  720415
  720417
  726328
  732510
  746012
  758136
  779764
  780531
  788692
  797726
  814799
  814910
  815268
  815330
  815872
  816214
  816260
  823405
  828138
]
2.05 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "scandal sex"
]
1.91 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "scandal секс"
]
1.66 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "scandal секс"
]

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.