GET https://search.jues.net/search/embeds/2?q=mature%20suck%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.91 ms
(67.59%)
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
  389921
  397269
  397906
  405507
  417292
  429604
  437663
  439546
  440874
  445350
  448558
  451492
  452297
  454210
  455151
  455206
  458873
  460642
  464532
  470543
  479060
  483145
  484628
  486870
  491628
  495393
  497793
  506043
  510286
  513113
  514736
  518818
  525882
  528443
  554511
  557182
  558781
  567416
  579574
  589642
  593003
  593018
  597207
  598840
  601853
  666784
  726519
  726528
  726538
  726713
  726714
  748375
  776448
  794943
  796014
  814859
]
23.11 ms
(17.37%)
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:
[
  "mature suck boy"
  "mature suck boy"
  "mature suck boy"
  20
]
9.78 ms
(7.35%)
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
  601853
  554511
  452297
  445350
  464532
  579574
  598840
  796014
  726538
  748375
  776448
  794943
  458873
  525882
  491628
  405507
  448558
  483145
  557182
  666784
  593018
  451492
  397906
  514736
  479060
  506043
  593003
  726519
  726713
  440874
  439546
  389921
  397269
  597207
  484628
  429604
  455206
  454210
  417292
  437663
  460642
  726528
  497793
  814859
  528443
  726714
  513113
  518818
  589642
  495393
  486870
  455151
  558781
  470543
  567416
  510286
]
3.28 ms
(2.47%)
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
  389921
  397269
  397906
  405507
  417292
  429604
  437663
  439546
  440874
  445350
  448558
  451492
  452297
  454210
  455151
  455206
  458873
  460642
  464532
  470543
  479060
  483145
  484628
  486870
  491628
  495393
  497793
  506043
  510286
  513113
  514736
  518818
  525882
  528443
  554511
  557182
  558781
  567416
  579574
  589642
  593003
  593018
  597207
  598840
  601853
  666784
  726519
  726528
  726538
  726713
  726714
  748375
  776448
  794943
  796014
  814859
]
2.06 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature suck boy"
]
1.76 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature suck парен"
]
1.66 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature suck парен"
]
1.47 ms
(1.11%)
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.