GET https://search.jues.net/search/embeds/3?q=anus%20gape

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.17 ms
(47.91%)
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
  154133
  385021
  387480
  390713
  392015
  392019
  398221
  398684
  398741
  402626
  402632
  410676
  413641
  414090
  416000
  416593
  416609
  416632
  419648
  424195
  426475
  428045
  428956
  429703
  429888
  432283
  441495
  443198
  443239
  443243
  444544
  445351
  445974
  448257
  448802
  449073
  451336
  455901
  460813
  461937
  466564
  468680
  468835
  469131
  471681
  478257
  480206
  480493
  484809
  487414
  493334
  493691
  495758
  497950
  498641
  499869
  500333
  508885
  512447
  512749
  517797
  518191
  519365
  519369
  520419
  522340
  526232
  529116
  530110
  530429
  530700
  531647
  534586
  535429
  536783
  538977
  540680
  541278
  541851
  541867
  546005
  547423
  548157
  555992
  556044
  556426
  565174
  572640
  575178
  583665
  592187
  592362
  593275
  595454
  598760
  600540
  602249
  618780
  628397
  629333
  634067
  636948
  643681
  670357
  673254
  696111
  740118
  755930
  770022
  782351
  788193
  790133
  796370
  802248
  805784
  810294
  813646
  816596
  824883
]
209.00 ms
(44.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anus gape"
]
27.95 ms
(5.89%)
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
  634067
  805784
  410676
  398221
  628397
  519369
  546005
  565174
  495758
  493334
  519365
  443239
  443243
  413641
  449073
  484809
  471695
  508885
  520419
  530110
  530700
  535429
  518191
  522340
  529116
  469131
  541278
  555992
  575178
  419648
  428045
  455901
  154133
  392019
  387480
  416593
  432283
  414090
  416632
  443198
  487414
  493691
  540680
  499869
  530429
  534586
  500333
  538977
  531647
  461937
  471681
  480206
  541867
  548157
  583665
  592362
  600540
  643681
  424195
  392015
  402632
  445351
  451336
  460813
  498641
  670357
  696111
  782351
  802248
  755930
  398741
  497950
  813646
  416000
  444544
  448257
  517797
  536783
  512447
  740118
  480493
  816596
  426475
  636948
  602249
  441495
  429703
  398684
  445974
  448802
  512749
  526232
  556044
  556426
  541851
  572640
  629333
  593275
  618780
  466564
  429888
  468680
  478257
  385021
  673254
  788193
  796370
  592187
  428956
  824883
  790133
  770022
  810294
  547423
  598760
  468835
  595454
  390713
  402626
  416609
]
4.16 ms
(0.88%)
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
  154133
  385021
  387480
  390713
  392015
  392019
  398221
  398684
  398741
  402626
  402632
  410676
  413641
  414090
  416000
  416593
  416609
  416632
  419648
  424195
  426475
  428045
  428956
  429703
  429888
  432283
  441495
  443198
  443239
  443243
  444544
  445351
  445974
  448257
  448802
  449073
  451336
  455901
  460813
  461937
  466564
  468680
  468835
  469131
  471681
  478257
  480206
  480493
  484809
  487414
  493334
  493691
  495758
  497950
  498641
  499869
  500333
  508885
  512447
  512749
  517797
  518191
  519365
  519369
  520419
  522340
  526232
  529116
  530110
  530429
  530700
  531647
  534586
  535429
  536783
  538977
  540680
  541278
  541851
  541867
  546005
  547423
  548157
  555992
  556044
  556426
  565174
  572640
  575178
  583665
  592187
  592362
  593275
  595454
  598760
  600540
  602249
  618780
  628397
  629333
  634067
  636948
  643681
  670357
  673254
  696111
  740118
  755930
  770022
  782351
  788193
  790133
  796370
  802248
  805784
  810294
  813646
  816596
  824883
]
2.13 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анус большая большие дырк"
]
1.91 ms
(0.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анус большая большие дырк"
]
1.85 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.