GET https://search.jues.net/search/embeds/9?q=mature%20double%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.00 ms
(77.84%)
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
  72822
  96761
  129902
  181397
  188556
  193342
  310295
  310758
  320078
  381883
  398773
  400185
  403641
  404192
  406307
  411751
  414358
  419524
  426394
  431643
  432299
  435695
  443726
  443777
  445943
  446275
  456614
  457791
  460168
  460208
  464132
  467619
  468042
  469555
  473005
  474627
  474661
  474685
  476905
  479071
  484629
  484700
  486426
  493088
  493587
  494419
  514601
  518554
  522898
  530373
  531249
  534129
  534536
  536212
  536359
  537220
  538925
  547477
  551057
  556774
  571213
  583730
  592384
  595761
  600346
  603692
  604403
  606514
  614220
  625783
  628110
  644309
  645904
  647602
  666579
  667922
  671714
  673613
  673719
  676088
  677723
  678962
  690809
  692188
  692796
  703062
  705278
  711997
  712891
  717839
  717880
  720236
  720873
  721715
  724309
  724996
  736226
  742356
  742804
  744389
  748475
  748529
  756383
  760240
  765236
  770402
  788294
  789841
  790389
  797461
  801899
  803645
  815210
  815866
  817156
  817537
  817866
  818290
  820678
  820765
]
23.19 ms
(14.10%)
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
  419524
  411751
  467619
  474661
  474627
  474685
  484700
  514601
  556774
  486426
  536359
  530373
  676088
  712891
  188556
  400185
  403641
  406307
  432299
  435695
  431643
  414358
  445943
  457791
  469555
  518554
  494419
  522898
  468042
  493587
  603692
  600346
  625783
  443726
  460208
  464132
  531249
  592384
  628110
  724996
  736226
  770402
  476905
  446275
  456614
  678962
  443777
  484629
  571213
  595761
  193342
  310758
  398773
  820678
  460168
  537220
  479071
  547477
  788294
  790389
  797461
  756383
  724309
  742356
  748475
  606514
  721715
  72822
  404192
  473005
  493088
  129902
  181397
  310295
  320078
  381883
  426394
  817156
  818290
  815210
  817537
  817866
  820765
  815866
  534129
  534536
  538925
  536212
  583730
  551057
  647602
  690809
  705278
  711997
  717880
  666579
  673613
  677723
  717839
  720236
  645904
  667922
  671714
  673719
  692188
  692796
  614220
  644309
  604403
  801899
  803645
  744389
  789841
  760240
  742804
  748529
  765236
  703062
  720873
  96761
]
6.97 ms
(4.24%)
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
  72822
  96761
  129902
  181397
  188556
  193342
  310295
  310758
  320078
  381883
  398773
  400185
  403641
  404192
  406307
  411751
  414358
  419524
  426394
  431643
  432299
  435695
  443726
  443777
  445943
  446275
  456614
  457791
  460168
  460208
  464132
  467619
  468042
  469555
  473005
  474627
  474661
  474685
  476905
  479071
  484629
  484700
  486426
  493088
  493587
  494419
  514601
  518554
  522898
  530373
  531249
  534129
  534536
  536212
  536359
  537220
  538925
  547477
  551057
  556774
  571213
  583730
  592384
  595761
  600346
  603692
  604403
  606514
  614220
  625783
  628110
  644309
  645904
  647602
  666579
  667922
  671714
  673613
  673719
  676088
  677723
  678962
  690809
  692188
  692796
  703062
  705278
  711997
  712891
  717839
  717880
  720236
  720873
  721715
  724309
  724996
  736226
  742356
  742804
  744389
  748475
  748529
  756383
  760240
  765236
  770402
  788294
  789841
  790389
  797461
  801899
  803645
  815210
  815866
  817156
  817537
  817866
  818290
  820678
  820765
]
1.72 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature double anal"
]
1.66 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature double анал"
]
1.59 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature 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.