GET https://search.jues.net/search/embeds/6?q=gangbang%20double%20penetration

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.55 ms
(86.46%)
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
  96100
  97098
  109313
  130089
  130429
  130506
  210072
  382381
  383387
  387228
  387287
  387301
  388097
  388492
  395270
  397302
  400936
  400938
  400956
  401262
  404192
  414337
  414341
  414344
  414360
  420190
  421264
  421564
  422049
  425181
  429764
  429768
  429805
  437855
  443334
  443777
  462209
  467605
  468655
  474678
  483544
  488721
  492563
  519567
  522133
  525626
  526130
  526891
  527412
  530010
  530624
  530788
  530796
  530935
  531126
  532789
  532792
  534627
  536290
  536616
  537206
  537894
  540404
  540573
  541846
  545382
  545488
  552010
  562823
  565247
  565255
  580262
  580290
  581349
  583921
  586770
  589240
  595768
  603132
  606508
  613146
  623510
  628376
  628392
  630297
  632580
  632639
  632657
  633521
  634131
  636321
  637100
  642041
  647879
  649579
  650762
  653447
  666883
  666897
  676087
  676110
  677801
  678067
  678073
  680255
  683259
  702164
  707262
  716887
  741283
  742226
  742459
  748357
  756023
  762257
  775818
  794230
  800588
  801923
  811497
]
14.21 ms
(8.11%)
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
  748357
  762257
  742459
  742226
  741283
  756023
  623510
  707262
  775818
  794230
  397302
  210072
  382381
  400956
  109313
  130089
  404192
  488721
  540573
  532789
  545488
  429805
  400936
  422049
  414341
  414344
  429768
  437855
  483544
  468655
  526130
  530796
  525626
  531126
  537894
  526891
  530935
  562823
  580290
  541846
  545382
  552010
  580262
  581349
  676087
  680255
  666883
  586770
  606508
  630297
  632580
  603132
  613146
  632657
  589240
  637100
  642041
  800588
  811497
  632639
  716887
  443334
  443777
  467605
  462209
  474678
  492563
  421564
  530010
  534627
  540404
  678067
  683259
  676110
  677801
  666897
  565247
  628376
  636321
  628392
  414337
  388097
  420190
  429764
  530624
  536290
  532792
  522133
  530788
  536616
  537206
  565255
  647879
  649579
  650762
  653447
  678073
  702164
  583921
  634131
  595768
  801923
  633521
  527412
  519567
  383387
  130429
  130506
  395270
  96100
  97098
  388492
  387287
  387301
  387228
  400938
  401262
  425181
  421264
  414360
]
2.68 ms
(1.53%)
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
  96100
  97098
  109313
  130089
  130429
  130506
  210072
  382381
  383387
  387228
  387287
  387301
  388097
  388492
  395270
  397302
  400936
  400938
  400956
  401262
  404192
  414337
  414341
  414344
  414360
  420190
  421264
  421564
  422049
  425181
  429764
  429768
  429805
  437855
  443334
  443777
  462209
  467605
  468655
  474678
  483544
  488721
  492563
  519567
  522133
  525626
  526130
  526891
  527412
  530010
  530624
  530788
  530796
  530935
  531126
  532789
  532792
  534627
  536290
  536616
  537206
  537894
  540404
  540573
  541846
  545382
  545488
  552010
  562823
  565247
  565255
  580262
  580290
  581349
  583921
  586770
  589240
  595768
  603132
  606508
  613146
  623510
  628376
  628392
  630297
  632580
  632639
  632657
  633521
  634131
  636321
  637100
  642041
  647879
  649579
  650762
  653447
  666883
  666897
  676087
  676110
  677801
  678067
  678073
  680255
  683259
  702164
  707262
  716887
  741283
  742226
  742459
  748357
  756023
  762257
  775818
  794230
  800588
  801923
  811497
]
1.87 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gangbang double penetration"
]
1.73 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "gangbang double penetration"
]
1.44 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "gangbang double penetration"
]

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.