GET https://search.jues.net/search/embeds/2?q=teen%20pawg

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.81 ms
(62.27%)
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
  402715
  402723
  410891
  422642
  424781
  434430
  436530
  441416
  441466
  444959
  451010
  452257
  452261
  452786
  459339
  459612
  463280
  464097
  464102
  464704
  470133
  471148
  473461
  475000
  484183
  484224
  491781
  502384
  502603
  508542
  510170
  520671
  526951
  545836
  548842
  556807
  557327
  559948
  579701
  584887
  592621
  596196
  609839
  627018
  649970
  650488
  658992
  696128
  698124
  713701
  717929
  738262
  755974
  787075
  787624
  788881
]
22.71 ms
(19.69%)
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:
[
  "teen pawg"
  "teen pawg"
  "teen pawg"
  20
]
10.21 ms
(8.85%)
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
  402723
  410891
  484224
  502384
  510170
  556807
  713701
  717929
  658992
  548842
  788881
  787624
  738262
  441416
  422642
  444959
  470133
  424781
  484183
  436530
  459339
  464102
  508542
  502603
  557327
  650488
  696128
  627018
  787075
  434430
  452786
  441466
  452257
  452261
  459612
  464097
  464704
  545836
  592621
  473461
  475000
  402715
  451010
  471148
  520671
  579701
  596196
  755974
  463280
  491781
  526951
  649970
  559948
  584887
  698124
  609839
]
3.37 ms
(2.92%)
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
  402715
  402723
  410891
  422642
  424781
  434430
  436530
  441416
  441466
  444959
  451010
  452257
  452261
  452786
  459339
  459612
  463280
  464097
  464102
  464704
  470133
  471148
  473461
  475000
  484183
  484224
  491781
  502384
  502603
  508542
  510170
  520671
  526951
  545836
  548842
  556807
  557327
  559948
  579701
  584887
  592621
  596196
  609839
  627018
  649970
  650488
  658992
  696128
  698124
  713701
  717929
  738262
  755974
  787075
  787624
  788881
]
1.96 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen pawg"
]
1.84 ms
(1.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen pawg"
]
1.74 ms
(1.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen pawg"
]

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.