GET https://search.jues.net/search/embeds?q=step%20mother%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.36 ms
(55.86%)
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
  394376
  400237
  407566
  424780
  428450
  448640
  471628
  496112
  497935
  499791
  500674
  517278
  527158
  531919
  532130
  532132
  550642
  550643
  550644
  551028
  552017
  552043
  556397
  556398
  557498
  557499
  557503
  557505
  557509
  557512
  557514
  557518
  557537
  557815
  559857
  560216
  565982
  565983
  565990
  565994
  566002
  566013
  566014
  583207
  588067
  590812
  621034
  621353
  623818
  628653
  694199
  707566
  725230
  758584
  764715
  806285
  812885
  826663
]
34.67 ms
(25.36%)
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:
[
  "step mother asian"
  "step mother asian"
  "step mother asian"
  20
]
16.11 ms
(11.79%)
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
  556398
  559857
  471628
  407566
  621034
  532130
  694199
  565990
  566014
  557498
  565982
  557815
  623818
  552017
  566013
  551028
  394376
  550644
  550643
  557512
  812885
  557518
  557509
  557505
  400237
  557537
  565994
  532132
  552043
  560216
  806285
  557514
  448640
  550642
  556397
  557503
  496112
  566002
  500674
  428450
  583207
  590812
  725230
  527158
  628653
  764715
  588067
  424780
  565983
  557499
  826663
  707566
  531919
  517278
  499791
  758584
  497935
  621353
]
2.38 ms
(1.74%)
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
  394376
  400237
  407566
  424780
  428450
  448640
  471628
  496112
  497935
  499791
  500674
  517278
  527158
  531919
  532130
  532132
  550642
  550643
  550644
  551028
  552017
  552043
  556397
  556398
  557498
  557499
  557503
  557505
  557509
  557512
  557514
  557518
  557537
  557815
  559857
  560216
  565982
  565983
  565990
  565994
  566002
  566013
  566014
  583207
  588067
  590812
  621034
  621353
  623818
  628653
  694199
  707566
  725230
  758584
  764715
  806285
  812885
  826663
]
2.11 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step mother asian"
]
1.88 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step мам женщин азиатк"
]
1.82 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step мам женщин азиатк"
]

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.