GET https://search.jues.net/search/embeds/5?q=dick%20handjob

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.53 ms
(86.76%)
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
  23884
  89362
  422259
  443854
  467606
  472600
  522160
  529678
  533731
  540207
  543780
  545433
  546264
  547108
  547182
  548269
  548811
  578206
  591829
  633065
  657321
  661291
  665449
  671697
  674121
  681053
  695609
  697855
  702386
  709259
  712200
  716512
  717452
  718158
  720873
  721991
  725394
  726085
  727941
  730687
  730980
  733543
  734062
  734348
  735341
  736256
  736772
  737486
  737613
  739670
  739684
  741665
  741880
  741914
  741935
  741943
  745270
  746854
  748442
  752150
  752181
  754438
  761375
  761406
  766394
  767600
  767737
  768813
  769206
  771194
  772309
  773380
  774136
  774318
  774406
  779457
  780167
  780516
  781616
  783675
  783862
  784580
  784943
  786668
  787234
  792516
  792926
  793147
  794670
  795803
  797225
  800447
  801393
  802084
  802996
  803062
  804152
  804247
  805249
  806014
  806689
  808193
  811403
  813399
  813419
  818191
  821796
  824099
  824902
  825836
  825837
  826080
  826993
  827065
  828030
  828221
  828240
  828789
]
9.95 ms
(6.14%)
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
  828240
  826993
  540207
  717452
  718158
  712200
  716512
  795803
  800447
  802084
  803062
  806689
  813399
  786668
  794670
  806014
  813419
  752181
  761406
  769206
  774318
  784580
  805249
  733543
  761375
  766394
  768813
  741943
  730687
  767600
  772309
  748442
  781616
  792516
  793147
  802996
  23884
  727941
  818191
  467606
  533731
  522160
  472600
  661291
  674121
  681053
  709259
  545433
  591829
  804152
  741935
  720873
  730980
  734062
  739670
  737486
  774406
  825837
  821796
  822656
  824992
  825836
  824099
  824902
  826080
  828789
  828221
  828030
  543780
  547108
  546264
  548269
  665449
  671697
  695609
  702386
  657321
  721991
  548811
  578206
  780167
  783862
  787234
  725394
  726085
  734348
  752150
  771194
  797225
  735341
  736256
  741880
  754438
  739684
  746854
  773380
  745270
  633065
  780516
  783675
  808193
  443854
  89362
  827065
  784943
  779457
  804247
  801393
  811403
  741665
  774136
  736772
  767737
  737613
  741914
  792926
  422259
  529678
  547182
  697855
]
2.96 ms
(1.82%)
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
  23884
  89362
  422259
  443854
  467606
  472600
  522160
  529678
  533731
  540207
  543780
  545433
  546264
  547108
  547182
  548269
  548811
  578206
  591829
  633065
  657321
  661291
  665449
  671697
  674121
  681053
  695609
  697855
  702386
  709259
  712200
  716512
  717452
  718158
  720873
  721991
  725394
  726085
  727941
  730687
  730980
  733543
  734062
  734348
  735341
  736256
  736772
  737486
  737613
  739670
  739684
  741665
  741880
  741914
  741935
  741943
  745270
  746854
  748442
  752150
  752181
  754438
  761375
  761406
  766394
  767600
  767737
  768813
  769206
  771194
  772309
  773380
  774136
  774318
  774406
  779457
  780167
  780516
  781616
  783675
  783862
  784580
  784943
  786668
  787234
  792516
  792926
  793147
  794670
  795803
  797225
  800447
  801393
  802084
  802996
  803062
  804152
  804247
  805249
  806014
  806689
  808193
  811403
  813399
  813419
  818191
  821796
  824099
  824902
  825836
  825837
  826080
  826993
  827065
  828030
  828221
  828240
  828789
]
2.24 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член дрочк член"
]
2.16 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.08 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick handjob"
]
2.06 ms
(1.27%)
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.