GET https://search.jues.net/search/embeds?q=japanese%20wife%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.04 ms
(46.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
  424615
  435611
  435618
  438588
  464676
  467715
  499885
  502533
  509776
  516873
  533133
  533295
  533300
  546522
  549440
  550724
  551975
  551987
  552036
  556387
  557709
  568257
  575379
  580129
  588390
  590981
  599789
  615371
  615947
  622615
  622629
  643145
  643447
  646457
  651065
  672212
  672217
  712475
  785566
  785568
  785571
  819181
]
47.64 ms
(37.98%)
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:
[
  "japanese wife solo"
  "japanese wife solo"
  "japanese wife solo"
  20
]
9.04 ms
(7.21%)
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
  550724
  551975
  588390
  622615
  435618
  533300
  549440
  622629
  509776
  533295
  646457
  546522
  643447
  464676
  435611
  672217
  651065
  785566
  785571
  575379
  621014
  551987
  556387
  580129
  615947
  785568
  438588
  533133
  568257
  557709
  552036
  712475
  615371
  643145
  424615
  819181
  672212
  499885
  599789
  467715
  590981
  516873
  502533
]
3.11 ms
(2.48%)
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
  424615
  435611
  435618
  438588
  464676
  467715
  499885
  502533
  509776
  516873
  533133
  533295
  533300
  546522
  549440
  550724
  551975
  551987
  552036
  556387
  557709
  568257
  575379
  580129
  588390
  590981
  599789
  615371
  615947
  622615
  622629
  643145
  643447
  646457
  651065
  672212
  672217
  712475
  785566
  785568
  785571
  819181
]
2.27 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "japanese wife solo"
]
1.98 ms
(1.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "японк азиатк жен соло"
]
1.66 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "японк азиатк жен соло"
]

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.