GET https://search.jues.net/search/embeds?q=mouth%20tongue

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
88.52 ms
(79.66%)
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
  427971
  434810
  448507
  471925
  485552
  488134
  514997
  521653
  523658
  523793
  540805
  548892
  552363
  558325
  579754
  593364
  598300
  598733
  602310
  602665
  611304
  615042
  615391
  616995
  629515
  638178
  672289
  718468
  718502
  719812
  720137
  729559
  731468
  746117
  746357
  748895
  759691
  772276
  772357
  772383
  773374
  780250
  780260
  780965
  781188
  784060
  790706
  791608
  797929
  804526
  824970
  825305
  827108
]
7.21 ms
(6.49%)
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
  638178
  602665
  780250
  824970
  729559
  602310
  827108
  746357
  488134
  825305
  791608
  593364
  772357
  548892
  718502
  720137
  784060
  781188
  797929
  772276
  773374
  780260
  471925
  611304
  804526
  790706
  748895
  629515
  718468
  719812
  772383
  780965
  485552
  672289
  552363
  598733
  616995
  598300
  615391
  731468
  746117
  615042
  434810
  558325
  427971
  540805
  759691
  523658
  448507
  521653
  523793
  579754
  514997
]
6.48 ms
(5.83%)
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:
[
  "mouth tongue"
  "mouth tongue"
  "mouth tongue"
  20
]
2.27 ms
(2.05%)
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
  427971
  434810
  448507
  471925
  485552
  488134
  514997
  521653
  523658
  523793
  540805
  548892
  552363
  558325
  579754
  593364
  598300
  598733
  602310
  602665
  611304
  615042
  615391
  616995
  629515
  638178
  672289
  718468
  718502
  719812
  720137
  729559
  731468
  746117
  746357
  748895
  759691
  772276
  772357
  772383
  773374
  780250
  780260
  780965
  781188
  784060
  790706
  791608
  797929
  804526
  824970
  825305
  827108
]
1.94 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth tongue"
]
1.78 ms
(1.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth tongue"
]
1.64 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mouth tongue"
]

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.