GET https://search.jues.net/search/embeds/2?q=omg%20big%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.68 ms
(61.50%)
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
  435131
  435930
  437863
  449299
  450194
  464391
  472550
  476485
  476937
  482074
  492535
  497478
  502588
  517874
  518325
  519388
  520198
  521525
  522999
  525560
  528146
  528269
  528661
  533747
  539618
  542218
  543590
  545305
  552959
  552969
  558812
  559044
  562616
  564203
  565220
  565412
  567139
  572769
  579612
  579848
  583576
  587550
  593664
  593768
  599015
  603164
  610021
  610311
  619761
  622332
  623962
  631083
  678916
  687849
  724931
  743108
  797570
  799413
]
26.40 ms
(20.38%)
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:
[
  "omg big dick"
  "omg big dick"
  "omg big dick"
  20
]
15.36 ms
(11.85%)
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
  572769
  525560
  565220
  539618
  518325
  437863
  623962
  476485
  622332
  558812
  610021
  797570
  799413
  476937
  482074
  543590
  724931
  435930
  449299
  502588
  587550
  593768
  528269
  528661
  521525
  552959
  520198
  522999
  583576
  593664
  743108
  435131
  517874
  472550
  464391
  519388
  678916
  599015
  603164
  565412
  492535
  687849
  579848
  619761
  631083
  497478
  450194
  579612
  542218
  528146
  562616
  533747
  610311
  545305
  567139
  552969
  559044
  564203
]
1.99 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "omg big dick"
]
1.84 ms
(1.42%)
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
  435131
  435930
  437863
  449299
  450194
  464391
  472550
  476485
  476937
  482074
  492535
  497478
  502588
  517874
  518325
  519388
  520198
  521525
  522999
  525560
  528146
  528269
  528661
  533747
  539618
  542218
  543590
  545305
  552959
  552969
  558812
  559044
  562616
  564203
  565220
  565412
  567139
  572769
  579612
  579848
  583576
  587550
  593664
  593768
  599015
  603164
  610021
  610311
  619761
  622332
  623962
  631083
  678916
  687849
  724931
  743108
  797570
  799413
]
1.51 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "omg большой большие член"
]
1.48 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "omg большой большие член"
]

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.