GET https://search.jues.net/search/embeds/3?q=huge%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.66 ms
(86.24%)
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
  74135
  154257
  154491
  154826
  182232
  384397
  389794
  393313
  393314
  397437
  398073
  401769
  401810
  402628
  402632
  413418
  416695
  416704
  429601
  466427
  467715
  473446
  477090
  511866
  513830
  521139
  524675
  529793
  531822
  531839
  531850
  531856
  531866
  534532
  534537
  539185
  541377
  543127
  543897
  545438
  547458
  547854
  548834
  550916
  550925
  553130
  559360
  564222
  564291
  564295
  567122
  568501
  573183
  574375
  574656
  579673
  583712
  601208
  605208
  608076
  609887
  618231
  628097
  629281
  630793
  632254
  655242
  658784
  658802
  662049
  662856
  664189
  665958
  666898
  669073
  670366
  671002
  671020
  672938
  680252
  695875
  697473
  713501
  713507
  720186
  722428
  723461
  728269
  738476
  738822
  740932
  742363
  744266
  745083
  745128
  749067
  749084
  749221
  749271
  752603
  752652
  752664
  752675
  752681
  752712
  752755
  755821
  759179
  766943
  770254
  770262
  782836
  784775
  788192
  799695
  799696
  803134
  808331
  814487
  819218
]
12.66 ms
(7.71%)
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
  154491
  154826
  393314
  402628
  413418
  429601
  467715
  574375
  583712
  720186
  655242
  608076
  628097
  629281
  154257
  389794
  416704
  477090
  513830
  534532
  534537
  529793
  547458
  541377
  548834
  564222
  564295
  658784
  664189
  669073
  697473
  722428
  553130
  567122
  632254
  601208
  799695
  799696
  755821
  752652
  752675
  744266
  770254
  749271
  630793
  416695
  402632
  74135
  401810
  511866
  524675
  531839
  531850
  662049
  695875
  579673
  605208
  609887
  782836
  752603
  752712
  738476
  749084
  384397
  752664
  808331
  393313
  401769
  819218
  521139
  531822
  531856
  466427
  573183
  550916
  574656
  658802
  662856
  665958
  666898
  672938
  680252
  713501
  713507
  784775
  788192
  740932
  752681
  728269
  749067
  749221
  766943
  770262
  738822
  742363
  752755
  745083
  745128
  618231
  803134
  398073
  182232
  759179
  671020
  670366
  397437
  814487
  473446
  539185
  531866
  559360
  543897
  564291
  543127
  545438
  547854
  550925
  568501
  671002
  723461
]
2.98 ms
(1.81%)
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
  74135
  154257
  154491
  154826
  182232
  384397
  389794
  393313
  393314
  397437
  398073
  401769
  401810
  402628
  402632
  413418
  416695
  416704
  429601
  466427
  467715
  473446
  477090
  511866
  513830
  521139
  524675
  529793
  531822
  531839
  531850
  531856
  531866
  534532
  534537
  539185
  541377
  543127
  543897
  545438
  547458
  547854
  548834
  550916
  550925
  553130
  559360
  564222
  564291
  564295
  567122
  568501
  573183
  574375
  574656
  579673
  583712
  601208
  605208
  608076
  609887
  618231
  628097
  629281
  630793
  632254
  655242
  658784
  658802
  662049
  662856
  664189
  665958
  666898
  669073
  670366
  671002
  671020
  672938
  680252
  695875
  697473
  713501
  713507
  720186
  722428
  723461
  728269
  738476
  738822
  740932
  742363
  744266
  745083
  745128
  749067
  749084
  749221
  749271
  752603
  752652
  752664
  752675
  752681
  752712
  752755
  755821
  759179
  766943
  770254
  770262
  782836
  784775
  788192
  799695
  799696
  803134
  808331
  814487
  819218
]
1.88 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные анал"
]
1.74 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge anal"
]
1.48 ms
(0.90%)
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.