GET https://search.jues.net/search/embeds/2?q=ass%20jerks

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.85 ms
(58.55%)
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
  447173
  453701
  455060
  455264
  458928
  464138
  467727
  481943
  482270
  483411
  489780
  492529
  504661
  506190
  508593
  509691
  512588
  514661
  514811
  516899
  517372
  520135
  526358
  529481
  543906
  551448
  554207
  563591
  563874
  571349
  576742
  577120
  579516
  581721
  598937
  602397
  603630
  608153
  608534
  609161
  617032
  625262
  670233
  732832
  746136
  790015
  798684
]
24.41 ms
(23.10%)
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:
[
  "ass jerks"
  "ass jerks"
  "ass jerks"
  20
]
9.72 ms
(9.20%)
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
  512588
  563874
  526358
  529481
  492529
  458928
  455060
  455264
  581721
  579516
  625262
  732832
  790015
  447173
  516899
  483411
  543906
  746136
  506190
  467727
  517372
  489780
  481943
  514661
  508593
  577120
  563591
  608153
  617032
  520135
  514811
  464138
  576742
  554207
  453701
  598937
  798684
  609161
  603630
  509691
  551448
  482270
  571349
  504661
  608534
  602397
  670233
]
2.29 ms
(2.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass jerks"
]
2.15 ms
(2.04%)
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
  447173
  453701
  455060
  455264
  458928
  464138
  467727
  481943
  482270
  483411
  489780
  492529
  504661
  506190
  508593
  509691
  512588
  514661
  514811
  516899
  517372
  520135
  526358
  529481
  543906
  551448
  554207
  563591
  563874
  571349
  576742
  577120
  579516
  581721
  598937
  602397
  603630
  608153
  608534
  609161
  617032
  625262
  670233
  732832
  746136
  790015
  798684
]
1.90 ms
(1.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп jerks"
]
1.74 ms
(1.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп jerks"
]

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.