GET https://search.jues.net/search/embeds/7?q=village%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.96 ms
(68.70%)
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
  417634
  445245
  489068
  513129
  523641
  541688
  549605
  551935
  556112
  564473
  565808
  572321
  575198
  588208
  600142
  603010
  614737
  615394
  645966
  649362
  650306
  660364
  664140
  666054
  669973
  674702
  678704
  680653
  716962
  716980
  717749
  724028
  724319
  728363
  735240
  739171
  740679
  745908
  747174
  747290
  752163
  757042
  759341
  767997
  771534
  779344
  788480
  789051
  789672
  794818
  802612
  807888
  816630
  818722
  825719
]
19.75 ms
(15.78%)
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:
[
  "village girl"
  "village girl"
  "village girl"
  20
]
10.20 ms
(8.15%)
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
  551935
  735240
  828624
  716980
  541688
  816630
  717749
  825719
  802612
  788480
  745908
  716962
  747290
  818722
  664140
  759341
  789051
  771534
  669973
  600142
  807888
  724028
  767997
  724319
  666054
  740679
  789672
  650306
  645966
  489068
  445245
  747174
  565808
  660364
  549605
  678704
  779344
  757042
  794818
  739171
  556112
  649362
  523641
  588208
  728363
  680653
  603010
  564473
  674702
  513129
  575198
  417634
  572321
  615394
  752163
  614737
]
2.33 ms
(1.86%)
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
  417634
  445245
  489068
  513129
  523641
  541688
  549605
  551935
  556112
  564473
  565808
  572321
  575198
  588208
  600142
  603010
  614737
  615394
  645966
  649362
  650306
  660364
  664140
  666054
  669973
  674702
  678704
  680653
  716962
  716980
  717749
  724028
  724319
  728363
  735240
  739171
  740679
  745908
  747174
  747290
  752163
  757042
  759341
  767997
  771534
  779344
  788480
  789051
  789672
  794818
  802612
  807888
  816630
  818722
  825719
]
2.15 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "village girl"
]
1.77 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "деревня девушк"
]
1.56 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "деревня девушк"
]

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.