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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.08 ms
(82.51%)
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
  7196
  96259
  341782
  383641
  387636
  391275
  395552
  395674
  395727
  401127
  404939
  404952
  407357
  413391
  419064
  424362
  426032
  426197
  429763
  431412
  435391
  436718
  439850
  443364
  445493
  447470
  448552
  451572
  452843
  457163
  459395
  460222
  468626
  469764
  473387
  473782
  474610
  488805
  494151
  497805
  500300
  503673
  506324
  507646
  509805
  509875
  510392
  510394
  515892
  522283
  522899
  523312
  530249
  530798
  531230
  533517
  533949
  535644
  536202
  536650
  537925
  537933
  545407
  545416
  547852
  550669
  550798
  565241
  565243
  565249
  565251
  589761
  595209
  597566
  598057
  599002
  599306
  601559
  601635
  603628
  617408
  617412
  624041
  629333
  632699
  633818
  640783
  641986
  642000
  642149
  645001
  645327
  647928
  647937
  649192
  649497
  653343
  654400
  656301
  658777
  672711
  675021
  676624
  677671
  678517
  679728
  702675
  716868
  720138
  720708
  723494
  741277
  741542
  744744
  745928
  750565
  756687
  790981
  808327
]
16.28 ms
(10.33%)
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
  391275
  401127
  404952
  426032
  436718
  429763
  419064
  452843
  473782
  448552
  459395
  497805
  494151
  523312
  530798
  509875
  537933
  550669
  545407
  545416
  649192
  647937
  672711
  677671
  645327
  647928
  565251
  633818
  597566
  599002
  617408
  632699
  601559
  603628
  595209
  807580
  741542
  808327
  745928
  617412
  702675
  473387
  383641
  395727
  424362
  435391
  460222
  7196
  407357
  474610
  488805
  510392
  530249
  654400
  547852
  503673
  645001
  716868
  536202
  506324
  656301
  642149
  756687
  750565
  96259
  341782
  404939
  431412
  426197
  443364
  439850
  457163
  468626
  522899
  531230
  533517
  533949
  515892
  535644
  536650
  537925
  509805
  565243
  565249
  649497
  678517
  679728
  675021
  676624
  565241
  589761
  629333
  641986
  598057
  642000
  601635
  624041
  640783
  741277
  720708
  395552
  445493
  395674
  451572
  469764
  447470
  500300
  510394
  522283
  507646
  720138
  387636
  413391
  653343
  658777
  723494
  550798
  599306
  790981
  744744
]
3.16 ms
(2.00%)
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
  7196
  96259
  341782
  383641
  387636
  391275
  395552
  395674
  395727
  401127
  404939
  404952
  407357
  413391
  419064
  424362
  426032
  426197
  429763
  431412
  435391
  436718
  439850
  443364
  445493
  447470
  448552
  451572
  452843
  457163
  459395
  460222
  468626
  469764
  473387
  473782
  474610
  488805
  494151
  497805
  500300
  503673
  506324
  507646
  509805
  509875
  510392
  510394
  515892
  522283
  522899
  523312
  530249
  530798
  531230
  533517
  533949
  535644
  536202
  536650
  537925
  537933
  545407
  545416
  547852
  550669
  550798
  565241
  565243
  565249
  565251
  589761
  595209
  597566
  598057
  599002
  599306
  601559
  601635
  603628
  617408
  617412
  624041
  629333
  632699
  633818
  640783
  641986
  642000
  642149
  645001
  645327
  647928
  647937
  649192
  649497
  653343
  654400
  656301
  658777
  672711
  675021
  676624
  677671
  678517
  679728
  702675
  716868
  720138
  720708
  723494
  741277
  741542
  744744
  745928
  750565
  756687
  790981
  808327
]
2.39 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double penetration teens"
]
2.14 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double penetration teens"
]
1.71 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double penetration teens"
]

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.