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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
93.51 ms
(66.81%)
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
]
27.03 ms
(19.31%)
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:
[
  "cum arab"
  "cum arab"
  "cum arab"
  20
]
9.02 ms
(6.44%)
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
  604561
  591798
  552045
  577111
  540429
  540388
  577086
  658553
  628510
  543506
  586463
  590750
  583534
  794850
  542345
  540391
  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
]
2.65 ms
(1.89%)
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.09 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum arab"
]
2.02 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum араб"
]
1.86 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum араб"
]
1.79 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.