GET https://search.jues.net/search/embeds?q=teen%20ass%20cam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
92.35 ms
(57.86%)
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
  30841
  302443
  388803
  392498
  405709
  406105
  412515
  416794
  417486
  420434
  423725
  423913
  426611
  428848
  428932
  429931
  429933
  429946
  430261
  430397
  434900
  446497
  446745
  452496
  453208
  453223
  453820
  454799
  460321
  468423
  470012
  474361
  475237
  475876
  476774
  480428
  482687
  483469
  491707
  507514
  509837
  512512
  513219
  521353
  527920
  529149
  529810
  530934
  544204
  548749
  550480
  552235
  552480
  559673
  568262
  571193
  574846
  575798
  580230
  582735
  583687
  584887
  595867
  597825
  598469
  598728
  603002
  615730
  652954
  669545
  677354
  720232
  727794
  756845
]
42.58 ms
(26.68%)
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:
[
  "teen ass cam"
  "teen ass cam"
  "teen ass cam"
  20
]
14.63 ms
(9.16%)
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
  30841
  652954
  677354
  529810
  669545
  582735
  544204
  720232
  454799
  598728
  412515
  575798
  568262
  580230
  509837
  428932
  434900
  483469
  527920
  417486
  453820
  530934
  598469
  552235
  597825
  428848
  453223
  550480
  615730
  529149
  420434
  423725
  476774
  468423
  446497
  480428
  388803
  406105
  430397
  595867
  727794
  756845
  423913
  513219
  453208
  302443
  426611
  475876
  475237
  392498
  574846
  559673
  583687
  429946
  430261
  521353
  512512
  429931
  416794
  482687
  552480
  548749
  452496
  571193
  474361
  470012
  460321
  429933
  405709
  491707
  507514
  446745
  603002
  584887
]
2.26 ms
(1.41%)
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
  30841
  302443
  388803
  392498
  405709
  406105
  412515
  416794
  417486
  420434
  423725
  423913
  426611
  428848
  428932
  429931
  429933
  429946
  430261
  430397
  434900
  446497
  446745
  452496
  453208
  453223
  453820
  454799
  460321
  468423
  470012
  474361
  475237
  475876
  476774
  480428
  482687
  483469
  491707
  507514
  509837
  512512
  513219
  521353
  527920
  529149
  529810
  530934
  544204
  548749
  550480
  552235
  552480
  559673
  568262
  571193
  574846
  575798
  580230
  582735
  583687
  584887
  595867
  597825
  598469
  598728
  603002
  615730
  652954
  669545
  677354
  720232
  727794
  756845
]
2.16 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen ass cam"
]
1.93 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen жоп cam"
]
1.83 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen жоп cam"
]

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.