GET https://search.jues.net/search/embeds?q=step%20mom%20vintage

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.38 ms
(51.19%)
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
  543579
  544577
  544589
  547607
  547909
  547912
  547932
  550224
  553278
  554319
  554786
  557991
  558003
  560390
  561002
  561480
  561590
  562976
  562993
  562996
  563099
  563123
  563125
  563142
  563151
  563157
  563195
  563196
  563208
  563212
  563213
  563218
  563222
  563225
  563423
  563426
  563432
  563433
  563436
  563441
  563450
  563452
  563453
  563455
  563456
  564298
  564565
  567416
  567430
  573215
  574231
  581266
  590396
  590417
  606782
  638631
  699596
  730524
]
45.88 ms
(34.85%)
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 mom vintage"
  "step mom vintage"
  "step mom vintage"
  20
]
9.00 ms
(6.84%)
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
  573215
  544589
  564298
  544577
  563452
  730524
  547607
  563099
  567430
  563433
  547912
  553278
  563157
  562976
  562996
  563123
  560390
  563195
  561002
  563142
  550224
  563213
  563222
  563423
  563426
  590417
  561590
  547909
  563208
  563212
  563436
  564565
  574231
  562993
  563455
  699596
  563453
  590396
  638631
  563125
  554786
  563196
  554319
  557991
  563432
  581266
  563151
  563225
  563450
  606782
  563218
  563456
  547932
  543579
  558003
  561480
  563441
  567416
]
2.50 ms
(1.90%)
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
  543579
  544577
  544589
  547607
  547909
  547912
  547932
  550224
  553278
  554319
  554786
  557991
  558003
  560390
  561002
  561480
  561590
  562976
  562993
  562996
  563099
  563123
  563125
  563142
  563151
  563157
  563195
  563196
  563208
  563212
  563213
  563218
  563222
  563225
  563423
  563426
  563432
  563433
  563436
  563441
  563450
  563452
  563453
  563455
  563456
  564298
  564565
  567416
  567430
  573215
  574231
  581266
  590396
  590417
  606782
  638631
  699596
  730524
]
1.99 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step mom vintage"
]
1.76 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step mom vintage"
]
1.38 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step mom vintage"
]

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.