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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
362.57 ms
(93.10%)
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
  117687
  118086
  346126
  346173
  383742
  410664
  419557
  432274
  435539
  439023
  439138
  440068
  441106
  441107
  441233
  441834
  441952
  446781
  450484
  451775
  456229
  456239
  457698
  459204
  467196
  475226
  478904
  481169
  483704
  487275
  487422
  488752
  492181
  497480
  498697
  502212
  502457
  507314
  508909
  511343
  515435
  521814
  527911
  530942
  531789
  534576
  534585
  536128
  538925
  541325
  547483
  549081
  554257
  554851
  554858
  561040
  562164
  566822
  571846
  573198
  573206
  575369
  576545
  576916
  584048
  584367
  586914
  590729
  597163
  600087
  600348
  605725
  615693
  628094
  629934
  633887
  634071
  639381
  639736
  639804
  641997
  642035
  643187
  656895
  660373
  660411
  661036
  661915
  664226
  666016
  671018
  671045
  672950
  680423
  686106
  702157
  705466
  706038
  708069
  709559
  709693
  712268
  713142
  713460
  715790
  717535
  723930
  735124
  745806
  747073
  750641
  752631
  752667
  762294
  782842
  786911
  788788
  790136
  791370
  796837
]
16.64 ms
(4.27%)
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
  702157
  713142
  660373
  666016
  671018
  671045
  672950
  686106
  576545
  586914
  642035
  597163
  639804
  590729
  633887
  762294
  723930
  752667
  715790
  439023
  483704
  511343
  502457
  346126
  566822
  661036
  709559
  639381
  643187
  796837
  735124
  708069
  562164
  488752
  441106
  440068
  457698
  459204
  534576
  534585
  538925
  487275
  575369
  656895
  664226
  705466
  790136
  747073
  639736
  441233
  481169
  515435
  521814
  605725
  487422
  527911
  584367
  713460
  750641
  752631
  712268
  117687
  554858
  450484
  451775
  536128
  507314
  508909
  573206
  576916
  554257
  584048
  706038
  346173
  410664
  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
]
2.84 ms
(0.73%)
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
  117687
  118086
  346126
  346173
  383742
  410664
  419557
  432274
  435539
  439023
  439138
  440068
  441106
  441107
  441233
  441834
  441952
  446781
  450484
  451775
  456229
  456239
  457698
  459204
  467196
  475226
  478904
  481169
  483704
  487275
  487422
  488752
  492181
  497480
  498697
  502212
  502457
  507314
  508909
  511343
  515435
  521814
  527911
  530942
  531789
  534576
  534585
  536128
  538925
  541325
  547483
  549081
  554257
  554851
  554858
  561040
  562164
  566822
  571846
  573198
  573206
  575369
  576545
  576916
  584048
  584367
  586914
  590729
  597163
  600087
  600348
  605725
  615693
  628094
  629934
  633887
  634071
  639381
  639736
  639804
  641997
  642035
  643187
  656895
  660373
  660411
  661036
  661915
  664226
  666016
  671018
  671045
  672950
  680423
  686106
  702157
  705466
  706038
  708069
  709559
  709693
  712268
  713142
  713460
  715790
  717535
  723930
  735124
  745806
  747073
  750641
  752631
  752667
  762294
  782842
  786911
  788788
  790136
  791370
  796837
]
2.06 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг девушк"
]
1.93 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting girl"
]
1.55 ms
(0.40%)
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.