GET https://search.jues.net/search/embeds/2?q=hotel%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.80 ms
(54.24%)
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
  437310
  444044
  446204
  448284
  451127
  452256
  463481
  474421
  476510
  492931
  494115
  495434
  504091
  506131
  511016
  511295
  513156
  513828
  514677
  515580
  516476
  519047
  519200
  520427
  520943
  522776
  534375
  554881
  559173
  563932
  569408
  569921
  571976
  585771
  589723
  591306
  594228
  594415
  596901
  605442
  624226
  636371
  642657
  650456
  723892
  751572
  770225
  779012
  797437
  804927
  812777
  815594
]
45.93 ms
(32.87%)
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:
[
  "hotel mom"
  "hotel mom"
  "hotel mom"
  20
]
8.28 ms
(5.93%)
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
  797437
  476510
  474421
  463481
  494115
  492931
  504091
  437310
  815594
  451127
  446204
  448284
  511016
  516476
  534375
  569408
  569921
  650456
  554881
  594415
  636371
  589723
  642657
  723892
  751572
  779012
  804927
  444044
  520943
  506131
  519047
  495434
  513156
  511295
  514677
  519200
  522776
  571976
  585771
  605442
  812777
  520427
  515580
  559173
  591306
  452256
  513828
  770225
  563932
  596901
  594228
  624226
]
2.39 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
  437310
  444044
  446204
  448284
  451127
  452256
  463481
  474421
  476510
  492931
  494115
  495434
  504091
  506131
  511016
  511295
  513156
  513828
  514677
  515580
  516476
  519047
  519200
  520427
  520943
  522776
  534375
  554881
  559173
  563932
  569408
  569921
  571976
  585771
  589723
  591306
  594228
  594415
  596901
  605442
  624226
  636371
  642657
  650456
  723892
  751572
  770225
  779012
  797437
  804927
  812777
  815594
]
2.07 ms
(1.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hotel mom"
]
1.89 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hotel mom"
]
1.71 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hotel mom"
]
1.67 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.