GET https://search.jues.net/search/embeds?q=arab%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
88.90 ms
(70.73%)
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
  538583
  540388
  540391
  540429
  542345
  543115
  543139
  543153
  543203
  543489
  543506
  543889
  550240
  550253
  552045
  556965
  562335
  568053
  570737
  570740
  577086
  577111
  578182
  578288
  583534
  586463
  590750
  591798
  591865
  598929
  600094
  604561
  611028
  613444
  618752
  621534
  622923
  628510
  632549
  642430
  655880
  658553
  707516
  710258
  714421
  725461
  747879
  751192
  752518
  791789
  794850
  800084
  816803
  827589
  827994
  828193
  828794
]
17.52 ms
(13.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:
[
  "arab cum"
  "arab cum"
  "arab cum"
  20
]
8.58 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
  540388
  540391
  540429
  604561
  577086
  577111
  658553
  591798
  628510
  552045
  543506
  586463
  590750
  583534
  794850
  542345
  538583
  550240
  600094
  828193
  543153
  578288
  828794
  543115
  751192
  714421
  791789
  613444
  621534
  827589
  827994
  655880
  752518
  642430
  707516
  725461
  543203
  591865
  826156
  543889
  556965
  598929
  800084
  747879
  632549
  543139
  543489
  570740
  622923
  618752
  710258
  578182
  550253
  816803
  562335
  611028
  570737
  568053
]
3.17 ms
(2.52%)
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
  538583
  540388
  540391
  540429
  542345
  543115
  543139
  543153
  543203
  543489
  543506
  543889
  550240
  550253
  552045
  556965
  562335
  568053
  570737
  570740
  577086
  577111
  578182
  578288
  583534
  586463
  590750
  591798
  591865
  598929
  600094
  604561
  611028
  613444
  618752
  621534
  622923
  628510
  632549
  642430
  655880
  658553
  707516
  710258
  714421
  725461
  747879
  751192
  752518
  791789
  794850
  800084
  816803
  827589
  827994
  828193
  828794
]
2.26 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "arab cum"
]
1.97 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "араб cum"
]
1.73 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "араб cum"
]

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.