GET https://search.jues.net/search/embeds/2?q=1st%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
310.32 ms
(81.79%)
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
  404175
  406132
  415230
  419358
  419783
  420891
  425740
  426383
  432929
  434669
  439467
  446162
  458437
  460099
  466611
  467577
  468548
  468694
  469182
  471716
  476115
  495690
  523021
  527414
  530034
  530054
  530789
  530836
  531174
  531179
  531239
  532343
  532963
  534842
  534992
  536339
  536546
  537685
  537917
  537933
  538428
  544803
  550415
  556037
  560664
  566022
  580264
  589145
  603622
  604172
  620205
  621946
  631597
  649110
  677777
  696214
  750827
  799990
  800262
  810404
]
51.01 ms
(13.45%)
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:
[
  "1st sex"
  "1st sex"
  "1st sex"
  20
]
8.99 ms
(2.37%)
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
  467577
  406132
  530034
  696214
  750827
  810404
  534992
  531179
  799990
  495690
  566022
  446162
  468694
  466611
  471716
  538428
  476115
  589145
  439467
  530836
  434669
  468548
  531239
  536546
  530054
  649110
  800262
  469182
  537917
  537933
  415230
  404175
  458437
  419358
  460099
  536339
  544803
  530789
  425740
  560664
  426383
  420891
  631597
  419783
  604172
  537685
  532343
  432929
  531174
  534842
  603622
  580264
  532963
  523021
  556037
  677777
  550415
  621946
  527414
  620205
]
2.31 ms
(0.61%)
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
  404175
  406132
  415230
  419358
  419783
  420891
  425740
  426383
  432929
  434669
  439467
  446162
  458437
  460099
  466611
  467577
  468548
  468694
  469182
  471716
  476115
  495690
  523021
  527414
  530034
  530054
  530789
  530836
  531174
  531179
  531239
  532343
  532963
  534842
  534992
  536339
  536546
  537685
  537917
  537933
  538428
  544803
  550415
  556037
  560664
  566022
  580264
  589145
  603622
  604172
  620205
  621946
  631597
  649110
  677777
  696214
  750827
  799990
  800262
  810404
]
1.88 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "1st sex"
]
1.87 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "1st секс"
]
1.52 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "1st секс"
]

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.