GET https://search.jues.net/search/embeds?q=mom%20free%20and

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.65 ms
(44.32%)
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:
[
  "mom free and"
  "mom free and"
  "mom free and"
  20
]
68.27 ms
(44.07%)
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
  401235
  413518
  414184
  424481
  433671
  443797
  486539
  496096
  513471
  515413
  519034
  519037
  521261
  522126
  523356
  529518
  529830
  533959
  536313
  538234
  549778
  550032
  554394
  557259
  573501
  577491
  582531
  591506
  598631
  600386
  601324
  601923
  607637
  611343
  611351
  612067
  621676
  623889
  636485
  638790
  644688
  664578
  686835
  698437
  702835
  704558
  724122
  736146
  742007
  771880
  786376
  788821
  789764
  789973
  790014
  790744
  796456
  807368
  807456
  820337
  821760
  822460
]
9.65 ms
(6.23%)
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
  536313
  644688
  549778
  424481
  807368
  600386
  807456
  786376
  698437
  611343
  796456
  742007
  724122
  821760
  704558
  598631
  820337
  788821
  822460
  529518
  686835
  638790
  771880
  790014
  736146
  401235
  533959
  529830
  591506
  636485
  612067
  623889
  789973
  790744
  433671
  521261
  486539
  413518
  550032
  664578
  702835
  611351
  621676
  789764
  601923
  522126
  515413
  554394
  496096
  414184
  443797
  607637
  513471
  573501
  582531
  523356
  519037
  538234
  519034
  557259
  577491
  601324
]
1.83 ms
(1.18%)
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
  401235
  413518
  414184
  424481
  433671
  443797
  486539
  496096
  513471
  515413
  519034
  519037
  521261
  522126
  523356
  529518
  529830
  533959
  536313
  538234
  549778
  550032
  554394
  557259
  573501
  577491
  582531
  591506
  598631
  600386
  601324
  601923
  607637
  611343
  611351
  612067
  621676
  623889
  636485
  638790
  644688
  664578
  686835
  698437
  702835
  704558
  724122
  736146
  742007
  771880
  786376
  788821
  789764
  789973
  790014
  790744
  796456
  807368
  807456
  820337
  821760
  822460
]
1.80 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom free and"
]
1.69 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom free"
]
1.48 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom free"
]

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.