GET https://search.jues.net/search/embeds/4?q=anal%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.00 ms
(86.92%)
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
  16897
  29367
  89199
  91458
  285923
  345851
  382460
  382955
  389431
  393531
  396110
  396408
  397353
  400035
  401142
  401306
  401858
  402659
  403151
  404216
  404734
  406404
  407282
  413112
  413183
  415191
  417395
  418058
  418193
  418690
  419030
  428586
  429353
  429384
  431629
  432304
  437189
  439169
  443877
  444841
  451605
  453081
  459070
  459484
  461480
  466690
  468089
  478464
  478482
  478740
  479496
  490076
  492176
  493223
  494386
  505324
  510132
  511357
  512911
  515441
  520400
  523645
  531913
  539126
  556855
  560630
  561703
  565164
  570576
  573651
  574848
  586546
  590273
  590334
  594162
  596350
  600064
  601524
  604259
  605791
  610689
  611857
  630289
  641946
  644326
  652910
  653215
  653229
  653488
  653505
  653555
  659408
  682936
  691567
  697311
  706331
  712713
  712718
  721329
  721428
  722585
  722890
  738199
  742197
  744630
  744942
  751571
  753841
  754200
  756081
  760915
  761482
  777054
  787448
  797504
  802539
  810402
  812343
  821288
  826180
]
16.32 ms
(8.50%)
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
  644326
  590334
  630289
  761482
  760915
  742197
  744630
  744942
  756081
  812343
  397353
  415191
  432304
  429353
  403151
  16897
  29367
  505324
  418058
  396110
  413112
  600064
  605791
  601524
  466690
  439169
  417395
  400035
  490076
  389431
  826180
  721329
  653229
  653488
  691567
  697311
  653505
  682936
  712718
  610689
  590273
  594162
  604259
  777054
  753841
  754200
  751571
  641946
  401858
  396408
  407282
  459070
  556855
  91458
  401306
  402659
  429384
  573651
  596350
  797504
  810402
  345851
  382955
  404734
  413183
  437189
  419030
  478740
  461480
  478482
  510132
  520400
  523645
  652910
  787448
  738199
  802539
  393531
  285923
  406404
  611857
  418690
  428586
  492176
  561703
  468089
  404216
  511357
  512911
  382460
  401142
  531913
  570576
  560630
  586546
  444841
  453081
  478464
  479496
  459484
  494386
  539126
  451605
  89199
  418193
  431629
  443877
  821288
  493223
  515441
  565164
  574848
  706331
  721428
  722585
  722890
  659408
  712713
  653215
  653555
]
2.52 ms
(1.31%)
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
  16897
  29367
  89199
  91458
  285923
  345851
  382460
  382955
  389431
  393531
  396110
  396408
  397353
  400035
  401142
  401306
  401858
  402659
  403151
  404216
  404734
  406404
  407282
  413112
  413183
  415191
  417395
  418058
  418193
  418690
  419030
  428586
  429353
  429384
  431629
  432304
  437189
  439169
  443877
  444841
  451605
  453081
  459070
  459484
  461480
  466690
  468089
  478464
  478482
  478740
  479496
  490076
  492176
  493223
  494386
  505324
  510132
  511357
  512911
  515441
  520400
  523645
  531913
  539126
  556855
  560630
  561703
  565164
  570576
  573651
  574848
  586546
  590273
  590334
  594162
  596350
  600064
  601524
  604259
  605791
  610689
  611857
  630289
  641946
  644326
  652910
  653215
  653229
  653488
  653505
  653555
  659408
  682936
  691567
  697311
  706331
  712713
  712718
  721329
  721428
  722585
  722890
  738199
  742197
  744630
  744942
  751571
  753841
  754200
  756081
  760915
  761482
  777054
  787448
  797504
  802539
  810402
  812343
  821288
  826180
]
1.68 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal beautiful"
]
1.52 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал красивая"
]
1.51 ms
(0.79%)
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.