GET https://search.jues.net/search/embeds/4?q=big%20boobs%20doggystyle

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.94 ms
(54.72%)
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
  406089
  423509
  427981
  438372
  443374
  444838
  451478
  452363
  455041
  458407
  458907
  463087
  466010
  467995
  469540
  471459
  471951
  472299
  472474
  485147
  490472
  492972
  493426
  497935
  500016
  504473
  507673
  510194
  511807
  511910
  513360
  514129
  516408
  518393
  523209
  525259
  525261
  528076
  528360
  528923
  529252
  549726
  558071
  564694
  564743
  571809
  580134
  580626
  590488
  595172
  624797
  662412
  670745
  697006
  788264
]
33.15 ms
(27.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:
[
  "big boobs doggystyle"
  "big boobs doggystyle"
  "big boobs doggystyle"
  20
]
12.98 ms
(10.61%)
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
  564694
  558071
  438372
  451478
  471459
  423509
  466010
  492972
  507673
  525261
  511807
  513360
  458407
  549726
  580134
  697006
  590488
  595172
  504473
  528076
  624797
  500016
  463087
  455041
  523209
  516408
  525259
  528360
  580626
  443374
  511910
  467995
  469540
  529252
  490472
  571809
  788264
  471951
  493426
  427981
  510194
  670745
  452363
  444838
  458907
  472299
  406089
  564743
  514129
  485147
  472474
  662412
  518393
  528923
  497935
]
2.62 ms
(2.14%)
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
  406089
  423509
  427981
  438372
  443374
  444838
  451478
  452363
  455041
  458407
  458907
  463087
  466010
  467995
  469540
  471459
  471951
  472299
  472474
  485147
  490472
  492972
  493426
  497935
  500016
  504473
  507673
  510194
  511807
  511910
  513360
  514129
  516408
  518393
  523209
  525259
  525261
  528076
  528360
  528923
  529252
  549726
  558071
  564694
  564743
  571809
  580134
  580626
  590488
  595172
  624797
  662412
  670745
  697006
  788264
]
2.22 ms
(1.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big boobs doggystyle"
]
1.55 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие boobs doggystyle"
]
1.48 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие boobs doggystyle"
]

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.