GET https://search.jues.net/search/embeds/8?q=18%20teen%20porn

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.61 ms
(83.24%)
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
  324288
  381776
  387437
  414767
  417782
  420358
  423581
  423721
  436304
  445771
  447557
  449450
  453228
  455855
  469824
  470067
  472244
  472350
  472471
  479352
  480419
  484819
  484851
  489489
  491650
  491659
  491716
  491719
  491720
  491726
  492773
  495818
  501325
  511709
  511735
  511751
  511753
  511762
  511820
  512247
  513007
  513280
  513696
  513771
  516818
  519492
  522569
  522791
  522792
  523529
  524579
  525957
  526868
  527540
  527620
  527625
  527626
  527632
  527792
  528963
  529069
  529173
  529188
  534977
  534992
  534996
  535051
  536913
  538221
  543821
  552954
  558844
  567765
  573630
  573873
  574498
  574512
  574538
  574580
  574863
  574873
  575066
  575079
  575087
  575094
  575112
  575150
  575470
  575522
  575726
  575729
  575748
  575784
  575791
  575792
  575795
  575799
  575803
  575811
  576023
  576025
  576041
  576046
  576079
  576100
  576345
  576360
  576372
  576401
  576403
  599162
  600049
  649566
  650326
  671816
  679389
  694028
  708741
  722915
  774178
]
17.77 ms
(10.52%)
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
  479352
  447557
  528963
  491720
  522791
  527792
  538221
  484819
  491659
  522569
  523529
  420358
  381776
  469824
  512247
  529069
  575522
  575799
  575811
  576046
  576100
  576403
  574498
  575079
  575150
  575470
  575803
  576360
  576372
  558844
  573630
  573873
  574512
  574580
  574863
  575726
  575748
  575784
  575792
  576345
  576401
  671816
  694028
  722915
  567765
  575112
  576025
  576041
  576079
  774178
  708741
  470067
  472350
  511753
  522792
  527620
  491716
  491719
  511709
  525957
  491650
  491726
  492773
  511751
  527625
  511735
  511762
  513280
  513771
  526868
  527626
  423721
  453228
  480419
  529188
  511820
  529173
  524579
  527540
  536913
  575066
  552954
  574873
  599162
  600049
  387437
  516818
  527632
  575087
  575094
  575729
  575795
  576023
  575791
  679389
  574538
  472471
  519492
  489489
  484851
  324288
  436304
  414767
  423581
  417782
  445771
  449450
  455855
  472244
  501325
  534992
  534977
  535051
  534996
  495818
  513007
  513696
  543821
  649566
  650326
]
3.21 ms
(1.90%)
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
  324288
  381776
  387437
  414767
  417782
  420358
  423581
  423721
  436304
  445771
  447557
  449450
  453228
  455855
  469824
  470067
  472244
  472350
  472471
  479352
  480419
  484819
  484851
  489489
  491650
  491659
  491716
  491719
  491720
  491726
  492773
  495818
  501325
  511709
  511735
  511751
  511753
  511762
  511820
  512247
  513007
  513280
  513696
  513771
  516818
  519492
  522569
  522791
  522792
  523529
  524579
  525957
  526868
  527540
  527620
  527625
  527626
  527632
  527792
  528963
  529069
  529173
  529188
  534977
  534992
  534996
  535051
  536913
  538221
  543821
  552954
  558844
  567765
  573630
  573873
  574498
  574512
  574538
  574580
  574863
  574873
  575066
  575079
  575087
  575094
  575112
  575150
  575470
  575522
  575726
  575729
  575748
  575784
  575791
  575792
  575795
  575799
  575803
  575811
  576023
  576025
  576041
  576046
  576079
  576100
  576345
  576360
  576372
  576401
  576403
  599162
  600049
  649566
  650326
  671816
  679389
  694028
  708741
  722915
  774178
]
2.03 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 teen porn"
]
1.90 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 teen porn"
]
1.78 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 teen porn"
]
1.62 ms
(0.96%)
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.