GET https://search.jues.net/search/embeds/2?q=doggystyle%20chubby

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.17 ms
(73.82%)
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
  398966
  429880
  429888
  429892
  440164
  444916
  445098
  447273
  451478
  451523
  452363
  452375
  453415
  454444
  454471
  457569
  459959
  466314
  471780
  472299
  479128
  479487
  484203
  490472
  493470
  495444
  496973
  497234
  498358
  498420
  504473
  504656
  507265
  508703
  509941
  510832
  523209
  528360
  549726
  554466
  570764
  584395
  590144
  590488
  592904
  605903
  605904
  606974
  607432
  646105
  662412
  695173
  697006
  746093
  746171
]
9.60 ms
(9.31%)
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
  746093
  746171
  606974
  452375
  459959
  440164
  454471
  509941
  497234
  452363
  398966
  445098
  453415
  447273
  479487
  484203
  504656
  495444
  466314
  493470
  584395
  695173
  554466
  590144
  592904
  605904
  457569
  496973
  507265
  508703
  570764
  646105
  605903
  607432
  479128
  429892
  451523
  498358
  498420
  454444
  549726
  697006
  590488
  471780
  451478
  429880
  504473
  510832
  444916
  523209
  528360
  490472
  429888
  472299
  662412
]
6.88 ms
(6.66%)
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:
[
  "doggystyle chubby"
  "doggystyle chubby"
  "doggystyle chubby"
  20
]
2.55 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
  398966
  429880
  429888
  429892
  440164
  444916
  445098
  447273
  451478
  451523
  452363
  452375
  453415
  454444
  454471
  457569
  459959
  466314
  471780
  472299
  479128
  479487
  484203
  490472
  493470
  495444
  496973
  497234
  498358
  498420
  504473
  504656
  507265
  508703
  509941
  510832
  523209
  528360
  549726
  554466
  570764
  584395
  590144
  590488
  592904
  605903
  605904
  606974
  607432
  646105
  662412
  695173
  697006
  746093
  746171
]
2.13 ms
(2.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle chubby"
]
2.12 ms
(2.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle chubby"
]
1.99 ms
(1.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle chubby"
]

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.