GET https://search.jues.net/search/embeds/8?q=skinny%20young%20anal

Query Metrics

7 Database Queries
7 Different statements
187.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
148.73 ms
(79.48%)
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
  395622
  401939
  402235
  404779
  411174
  412852
  413649
  415200
  417080
  417775
  418605
  422582
  422594
  422947
  422958
  422960
  423037
  423071
  423205
  423259
  423426
  426152
  427308
  429808
  429906
  435646
  447888
  453793
  462470
  463937
  463950
  468612
  473909
  481998
  490143
  491354
  495793
  505086
  510578
  514805
  516615
  520736
  522949
  523985
  530025
  536275
  541076
  543877
  545393
  545604
  545698
  546200
  550228
  550684
  551915
  555948
  559389
  559942
  560387
  561632
  565245
  565249
  567166
  569156
  570708
  576020
  580256
  580298
  583725
  584022
  584492
  590542
  592514
  595775
  597494
  598057
  598092
  599454
  600290
  601635
  605338
  607125
  609244
  613177
  613832
  614023
  614718
  618347
  618865
  619571
  622331
  624179
  624505
  628363
  628376
  628388
  631965
  632001
  637086
  637093
  640813
  645997
  650158
  660439
  666535
  666540
  666550
  666878
  680112
  680159
  680167
  684566
  702164
  712995
  716030
  716032
  753476
  760936
  790036
  827054
]
18.34 ms
(9.80%)
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
  570708
  580256
  584492
  650158
  546200
  413649
  827054
  411174
  402235
  753476
  609244
  429906
  401939
  565245
  640813
  417775
  422958
  423259
  426152
  462470
  468612
  514805
  567166
  551915
  569156
  584022
  660439
  684566
  680167
  559389
  583725
  592514
  618865
  631965
  590542
  598092
  618347
  622331
  632001
  619571
  415200
  418605
  481998
  423071
  495793
  520736
  490143
  523985
  423037
  429808
  422582
  422947
  463937
  530025
  560387
  550684
  565249
  543877
  559942
  666540
  666550
  680112
  702164
  716032
  712995
  614023
  624505
  598057
  624179
  628376
  600290
  601635
  628388
  595775
  605338
  716030
  790036
  447888
  473909
  395622
  404779
  422594
  491354
  516615
  505086
  412852
  423426
  561632
  607125
  599454
  614718
  435646
  510578
  576020
  597494
  760936
  422960
  545604
  555948
  541076
  550228
  580298
  666535
  645997
  666878
  680159
  545393
  545698
  637093
  637086
  613832
  628363
  613177
  423205
  522949
  453793
  536275
  417080
  427308
  463950
]
10.99 ms
(5.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
3.20 ms
(1.71%)
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
  395622
  401939
  402235
  404779
  411174
  412852
  413649
  415200
  417080
  417775
  418605
  422582
  422594
  422947
  422958
  422960
  423037
  423071
  423205
  423259
  423426
  426152
  427308
  429808
  429906
  435646
  447888
  453793
  462470
  463937
  463950
  468612
  473909
  481998
  490143
  491354
  495793
  505086
  510578
  514805
  516615
  520736
  522949
  523985
  530025
  536275
  541076
  543877
  545393
  545604
  545698
  546200
  550228
  550684
  551915
  555948
  559389
  559942
  560387
  561632
  565245
  565249
  567166
  569156
  570708
  576020
  580256
  580298
  583725
  584022
  584492
  590542
  592514
  595775
  597494
  598057
  598092
  599454
  600290
  601635
  605338
  607125
  609244
  613177
  613832
  614023
  614718
  618347
  618865
  619571
  622331
  624179
  624505
  628363
  628376
  628388
  631965
  632001
  637086
  637093
  640813
  645997
  650158
  660439
  666535
  666540
  666550
  666878
  680112
  680159
  680167
  684566
  702164
  712995
  716030
  716032
  753476
  760936
  790036
  827054
]
2.61 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny young anal"
]
1.65 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые young анал"
]
1.61 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые young анал"
]

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.