GET https://search.jues.net/search/embeds/6?q=gag%20on%20sperm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
229.62 ms
(90.67%)
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
  387588
  392527
  396676
  416933
  418732
  421653
  422957
  424637
  444660
  456333
  461111
  467684
  472350
  477042
  477550
  481319
  484464
  489603
  492110
  499042
  500494
  505451
  509066
  514662
  515884
  516844
  517264
  517620
  525778
  525957
  526223
  527625
  527769
  531264
  532673
  533019
  533977
  534199
  537806
  539435
  542754
  543441
  546255
  546823
  552732
  556580
  560460
  565890
  571280
  574562
  575481
  579872
  582985
  600575
  613319
  621433
  621986
  622658
  622978
  646682
  652129
  656633
  659952
  661652
  673053
  693988
  700895
  709804
  709814
  712514
  713126
  713320
  713970
  719829
  722551
  722993
  726241
  738818
  751860
  758178
  761494
  764485
  765356
  766461
  768952
  778357
  779468
  784215
  790819
  793104
  793301
  793722
  793739
  794945
  797724
  798200
  798704
  805334
  806044
  806864
  807685
  810350
  810582
  814269
  814312
  816998
  817028
  817182
  817280
  817727
  817750
  818522
  819563
  819606
  824051
  824150
  824438
  825516
  827308
  827488
]
13.56 ms
(5.35%)
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
  467684
  422957
  456333
  424637
  472350
  525957
  527625
  489603
  492110
  517264
  526223
  392527
  824051
  817182
  819563
  827308
  817028
  824150
  814312
  818522
  827488
  825516
  527769
  532673
  515884
  533019
  499042
  500494
  509066
  537806
  546823
  552732
  646682
  656633
  659952
  661652
  713320
  722551
  673053
  693988
  709814
  719829
  722993
  546255
  579872
  621986
  790819
  793104
  793722
  805334
  798200
  798704
  764485
  766461
  806864
  726241
  765356
  622658
  713970
  779468
  806044
  810582
  387588
  778357
  793301
  761494
  477042
  652129
  621433
  738818
  484464
  505451
  516844
  565890
  582985
  700895
  709804
  560460
  600575
  793739
  794945
  807685
  768952
  784215
  797724
  758178
  810350
  461111
  542754
  622978
  613319
  444660
  418732
  571280
  751860
  481319
  396676
  421653
  416933
  817750
  824438
  816998
  817280
  817727
  814269
  819606
  477550
  517620
  525778
  531264
  534199
  533977
  539435
  514662
  543441
  575481
  556580
  574562
  712514
  713126
]
3.04 ms
(1.20%)
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
  387588
  392527
  396676
  416933
  418732
  421653
  422957
  424637
  444660
  456333
  461111
  467684
  472350
  477042
  477550
  481319
  484464
  489603
  492110
  499042
  500494
  505451
  509066
  514662
  515884
  516844
  517264
  517620
  525778
  525957
  526223
  527625
  527769
  531264
  532673
  533019
  533977
  534199
  537806
  539435
  542754
  543441
  546255
  546823
  552732
  556580
  560460
  565890
  571280
  574562
  575481
  579872
  582985
  600575
  613319
  621433
  621986
  622658
  622978
  646682
  652129
  656633
  659952
  661652
  673053
  693988
  700895
  709804
  709814
  712514
  713126
  713320
  713970
  719829
  722551
  722993
  726241
  738818
  751860
  758178
  761494
  764485
  765356
  766461
  768952
  778357
  779468
  784215
  790819
  793104
  793301
  793722
  793739
  794945
  797724
  798200
  798704
  805334
  806044
  806864
  807685
  810350
  810582
  814269
  814312
  816998
  817028
  817182
  817280
  817727
  817750
  818522
  819563
  819606
  824051
  824150
  824438
  825516
  827308
  827488
]
2.16 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм сперм"
]
1.70 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gag on sperm"
]
1.69 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм сперм"
]
1.46 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.