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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
270.36 ms
(90.75%)
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
  97377
  129640
  130468
  388474
  390538
  391070
  397273
  398634
  400941
  400954
  404732
  407290
  414339
  414342
  421200
  426038
  427966
  429088
  429775
  432243
  432799
  443389
  446337
  451565
  467592
  468860
  471317
  474629
  474714
  476103
  482514
  482938
  485133
  491449
  497901
  522872
  522880
  524193
  524196
  526125
  530015
  530022
  530633
  531189
  531198
  532733
  532916
  533003
  533466
  535005
  535620
  536259
  536584
  536586
  536785
  537747
  537771
  541925
  543576
  543855
  544819
  545383
  550200
  562828
  565253
  580263
  581726
  583693
  597254
  600253
  604431
  630678
  630679
  631192
  632333
  632633
  632658
  632703
  633766
  634145
  634154
  636985
  636991
  637031
  637650
  639254
  640801
  644256
  647949
  648862
  649214
  651168
  651620
  656574
  660422
  662023
  666548
  666553
  666877
  674980
  678138
  679025
  679775
  680151
  696331
  704226
  704256
  706629
  706652
  714480
  714552
  717066
  720257
  721846
  748950
  758304
  788249
  794817
  798948
  801942
]
17.48 ms
(5.87%)
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
  533003
  532916
  630679
  639254
  798948
  801942
  714552
  397273
  407290
  97377
  390538
  704256
  565253
  634145
  637031
  758304
  129640
  400941
  400954
  426038
  432799
  414342
  421200
  491449
  497901
  530022
  531189
  522872
  524196
  526125
  532733
  535005
  536259
  531198
  537747
  471317
  474714
  482938
  543576
  580263
  541925
  544819
  583693
  651168
  666877
  674980
  720257
  656574
  666548
  666553
  647949
  649214
  662023
  678138
  714480
  600253
  604431
  632703
  637650
  644256
  631192
  640801
  632333
  632633
  633766
  388474
  429775
  474629
  524193
  130468
  696331
  794817
  717066
  721846
  391070
  536785
  550200
  680151
  706629
  706652
  679025
  648862
  651620
  660422
  679775
  704226
  597254
  630678
  634154
  632658
  636991
  788249
  748950
  451565
  536584
  636985
  398634
  404732
  429088
  443389
  432243
  414339
  427966
  476103
  482514
  468860
  446337
  537771
  530633
  536586
  530015
  533466
  522880
  535620
  467592
  485133
  543855
  545383
  562828
  581726
]
2.60 ms
(0.87%)
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
  97377
  129640
  130468
  388474
  390538
  391070
  397273
  398634
  400941
  400954
  404732
  407290
  414339
  414342
  421200
  426038
  427966
  429088
  429775
  432243
  432799
  443389
  446337
  451565
  467592
  468860
  471317
  474629
  474714
  476103
  482514
  482938
  485133
  491449
  497901
  522872
  522880
  524193
  524196
  526125
  530015
  530022
  530633
  531189
  531198
  532733
  532916
  533003
  533466
  535005
  535620
  536259
  536584
  536586
  536785
  537747
  537771
  541925
  543576
  543855
  544819
  545383
  550200
  562828
  565253
  580263
  581726
  583693
  597254
  600253
  604431
  630678
  630679
  631192
  632333
  632633
  632658
  632703
  633766
  634145
  634154
  636985
  636991
  637031
  637650
  639254
  640801
  644256
  647949
  648862
  649214
  651168
  651620
  656574
  660422
  662023
  666548
  666553
  666877
  674980
  678138
  679025
  679775
  680151
  696331
  704226
  704256
  706629
  706652
  714480
  714552
  717066
  720257
  721846
  748950
  758304
  788249
  794817
  798948
  801942
]
2.01 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gangbang double"
]
1.90 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "gangbang double"
]
1.80 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "gangbang double"
]

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.