GET https://search.jues.net/search/embeds?q=asian%20wife%20cheating

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.26 ms
(64.57%)
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
  385082
  401507
  427494
  492732
  493046
  515749
  530363
  535093
  542518
  550796
  550882
  552638
  556362
  556383
  556412
  557823
  558425
  558444
  559875
  565995
  565999
  566001
  579632
  579721
  580609
  588242
  594570
  596984
  598515
  601101
  606688
  606699
  606910
  607025
  619417
  623822
  628143
  628175
  632727
  633855
  638544
  651010
  651591
  685814
  702075
  712222
  717274
  717278
  718309
  721946
  743458
  747956
  749807
  758860
  784624
  803450
  804796
  815151
]
25.26 ms
(21.38%)
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:
[
  "asian wife cheating"
  "asian wife cheating"
  "asian wife cheating"
  20
]
7.22 ms
(6.11%)
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
  712222
  632727
  557823
  556412
  596984
  565999
  427494
  685814
  628143
  556383
  515749
  749807
  758860
  559875
  606688
  401507
  747956
  717274
  566001
  552638
  542518
  385082
  651591
  718309
  619417
  530363
  579632
  598515
  556362
  606699
  623822
  721946
  607025
  492732
  743458
  588242
  535093
  638544
  579721
  702075
  784624
  565995
  558444
  815151
  550796
  651010
  580609
  803450
  606910
  558425
  804796
  633855
  628175
  594570
  717278
  493046
  550882
  601101
]
2.05 ms
(1.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.71%)
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
  385082
  401507
  427494
  492732
  493046
  515749
  530363
  535093
  542518
  550796
  550882
  552638
  556362
  556383
  556412
  557823
  558425
  558444
  559875
  565995
  565999
  566001
  579632
  579721
  580609
  588242
  594570
  596984
  598515
  601101
  606688
  606699
  606910
  607025
  619417
  623822
  628143
  628175
  632727
  633855
  638544
  651010
  651591
  685814
  702075
  712222
  717274
  717278
  718309
  721946
  743458
  747956
  749807
  758860
  784624
  803450
  804796
  815151
]
1.95 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian wife cheating"
]
1.94 ms
(1.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк жен cheating"
]
1.43 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк жен cheating"
]

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.