GET https://search.jues.net/search/embeds/7?q=girls%20fisting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.20 ms
(53.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк фистинг"
]
150.33 ms
(38.98%)
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
  118086
  346173
  383742
  386707
  392005
  402619
  410664
  415029
  419557
  426291
  432274
  435539
  439052
  439138
  441057
  441107
  441834
  441925
  441952
  444079
  446781
  450484
  451775
  455021
  456229
  456239
  462495
  462986
  467196
  474891
  475226
  478904
  492181
  497480
  498697
  502212
  507314
  508904
  508909
  511923
  513978
  513982
  527920
  529797
  529897
  530942
  531789
  531869
  531877
  532736
  534552
  536128
  536375
  537861
  541325
  547466
  547468
  547474
  547483
  547488
  547849
  549081
  554257
  554851
  559298
  559368
  561040
  569053
  571846
  573198
  573204
  573206
  575378
  576438
  576916
  577005
  580121
  584048
  596428
  600087
  600348
  610029
  615693
  619108
  619996
  627514
  628094
  628485
  629934
  634071
  641997
  642058
  644018
  648224
  660411
  661915
  665973
  668645
  669038
  671044
  678798
  680423
  684706
  685061
  706038
  709693
  717535
  720007
  744992
  745806
  760507
  782842
  786911
  788788
  789529
  791370
  792747
  800282
  820083
  825791
]
18.26 ms
(4.74%)
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
  527920
  450484
  451775
  462986
  536128
  507314
  508909
  573206
  576916
  554257
  584048
  706038
  346173
  410664
  508904
  573198
  782842
  432274
  467196
  446781
  475226
  492181
  561040
  628094
  788788
  629934
  709693
  439138
  456229
  456239
  497480
  383742
  435539
  502212
  530942
  498697
  531789
  554851
  571846
  541325
  547483
  549081
  680423
  717535
  660411
  661915
  600348
  634071
  600087
  641997
  791370
  745806
  615693
  786911
  118086
  478904
  441107
  441834
  441952
  419557
  441057
  559368
  455021
  513982
  531877
  536375
  537861
  529897
  534552
  513978
  529797
  531869
  532736
  547849
  569053
  577005
  576438
  648224
  684706
  685061
  720007
  665973
  678798
  559298
  610029
  619996
  642058
  644018
  628485
  619108
  789529
  760507
  415029
  474891
  441925
  444079
  511923
  386707
  402619
  825791
  575378
  596428
  627514
  792747
  744992
  392005
  820083
  800282
  426291
  439052
  462495
  547466
  547488
  573204
  547468
  547474
  580121
  668645
  669038
  671044
]
2.62 ms
(0.68%)
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
  118086
  346173
  383742
  386707
  392005
  402619
  410664
  415029
  419557
  426291
  432274
  435539
  439052
  439138
  441057
  441107
  441834
  441925
  441952
  444079
  446781
  450484
  451775
  455021
  456229
  456239
  462495
  462986
  467196
  474891
  475226
  478904
  492181
  497480
  498697
  502212
  507314
  508904
  508909
  511923
  513978
  513982
  527920
  529797
  529897
  530942
  531789
  531869
  531877
  532736
  534552
  536128
  536375
  537861
  541325
  547466
  547468
  547474
  547483
  547488
  547849
  549081
  554257
  554851
  559298
  559368
  561040
  569053
  571846
  573198
  573204
  573206
  575378
  576438
  576916
  577005
  580121
  584048
  596428
  600087
  600348
  610029
  615693
  619108
  619996
  627514
  628094
  628485
  629934
  634071
  641997
  642058
  644018
  648224
  660411
  661915
  665973
  668645
  669038
  671044
  678798
  680423
  684706
  685061
  706038
  709693
  717535
  720007
  744992
  745806
  760507
  782842
  786911
  788788
  789529
  791370
  792747
  800282
  820083
  825791
]
2.13 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls fisting"
]
2.04 ms
(0.53%)
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.