GET https://search.jues.net/search/embeds?q=bbw%20in%20pantyhose

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.53 ms
(76.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:
[
  "bbw in pantyhose"
  "bbw in pantyhose"
  "bbw in pantyhose"
  20
]
50.31 ms
(16.95%)
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
  411907
  419045
  445720
  447694
  453397
  464336
  470417
  476315
  485745
  487895
  487943
  516002
  519626
  530745
  542724
  544834
  578525
  587833
  603507
  607959
  625171
  629595
  644813
  667756
  669771
  713437
  724262
  725492
  727049
  745975
  750067
  755989
  781851
  781911
  781923
  807784
  808057
  808071
  810606
  814711
  824067
  824293
  824495
]
8.67 ms
(2.92%)
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
  807784
  824495
  629595
  750067
  713437
  824293
  727049
  724262
  453397
  607959
  781923
  725492
  745975
  625171
  808071
  519626
  781911
  814711
  755989
  544834
  411907
  487943
  487895
  470417
  824067
  476315
  578525
  669771
  667756
  781851
  516002
  419045
  644813
  485745
  447694
  603507
  808057
  445720
  464336
  542724
  530745
  810606
  587833
]
2.59 ms
(0.87%)
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
  411907
  419045
  445720
  447694
  453397
  464336
  470417
  476315
  485745
  487895
  487943
  516002
  519626
  530745
  542724
  544834
  578525
  587833
  603507
  607959
  625171
  629595
  644813
  667756
  669771
  713437
  724262
  725492
  727049
  745975
  750067
  755989
  781851
  781911
  781923
  807784
  808057
  808071
  810606
  814711
  824067
  824293
  824495
]
2.27 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbw in pantyhose"
]
2.05 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbw pantyhose"
]
1.60 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbw pantyhose"
]

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.