GET https://search.jues.net/search/embeds?q=sex%20truck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
52.35 ms
(45.65%)
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
  382518
  420104
  469042
  481375
  493382
  518592
  520545
  521684
  522163
  525102
  525538
  525923
  538854
  540462
  540652
  541028
  546856
  547062
  550077
  556683
  562411
  565827
  599149
  599801
  601213
  605913
  614007
  620062
  642926
  702699
  704425
  706905
  719945
  721271
  725274
  732959
  734397
  758413
  767646
  768996
  791570
  794852
  810466
  817404
  821558
  827963
  827974
]
45.02 ms
(39.26%)
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:
[
  "sex truck"
  "sex truck"
  "sex truck"
  20
]
7.59 ms
(6.62%)
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
  469042
  525102
  642926
  562411
  719945
  821558
  732959
  721271
  827974
  725274
  768996
  702699
  794852
  827963
  620062
  706905
  791570
  541028
  565827
  540462
  758413
  817404
  481375
  704425
  521684
  522163
  614007
  767646
  734397
  520545
  599801
  556683
  550077
  525923
  810466
  599149
  382518
  540652
  546856
  420104
  547062
  601213
  493382
  525538
  538854
  518592
  605913
]
2.36 ms
(2.06%)
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
  382518
  420104
  469042
  481375
  493382
  518592
  520545
  521684
  522163
  525102
  525538
  525923
  538854
  540462
  540652
  541028
  546856
  547062
  550077
  556683
  562411
  565827
  599149
  599801
  601213
  605913
  614007
  620062
  642926
  702699
  704425
  706905
  719945
  721271
  725274
  732959
  734397
  758413
  767646
  768996
  791570
  794852
  810466
  817404
  821558
  827963
  827974
]
2.28 ms
(1.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex truck"
]
1.80 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс truck"
]
1.67 ms
(1.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс truck"
]

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.