GET https://search.jues.net/search/embeds/3?q=real%20homemade%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.04 ms
(85.40%)
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
  393810
  397089
  412548
  420877
  426660
  427714
  428587
  432743
  432745
  433729
  435057
  441192
  442463
  444831
  448518
  448519
  457146
  458044
  458443
  459061
  461306
  462681
  463360
  463636
  467895
  469716
  476475
  483902
  485420
  485527
  487272
  492222
  496585
  497636
  502384
  505150
  507176
  507608
  507823
  510619
  514796
  520490
  520790
  521763
  523429
  532940
  538537
  541084
  541755
  550480
  552097
  552211
  557718
  557843
  558582
  558592
  559996
  560416
  562484
  563251
  564091
  564557
  565284
  569067
  569443
  575648
  575932
  591468
  594167
  597036
  598133
  598623
  599081
  599155
  602714
  604384
  605831
  608472
  609343
  610121
  610522
  610526
  615250
  615841
  616910
  619797
  622866
  626685
  627305
  627308
  630716
  630736
  632095
  636951
  639040
  645696
  647060
  652121
  657543
  658110
  658208
  658216
  658223
  658226
  658989
  668083
  684895
  692817
  720078
  736470
  741998
  760214
  772517
  786048
  787379
  789253
  797439
  807419
  817445
  817716
]
17.52 ms
(8.96%)
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
  598623
  507823
  538537
  658216
  610522
  619797
  397089
  602714
  541755
  510619
  496585
  428587
  427714
  610121
  393810
  469716
  645696
  564557
  807419
  787379
  462681
  636951
  760214
  476475
  557843
  627308
  639040
  562484
  668083
  692817
  647060
  657543
  658223
  658226
  630736
  630716
  615841
  435057
  626685
  609343
  608472
  610526
  789253
  442463
  432743
  483902
  615250
  736470
  502384
  521763
  448519
  514796
  441192
  420877
  817716
  461306
  463636
  569443
  658208
  684895
  594167
  772517
  720078
  458443
  458044
  741998
  559996
  575932
  622866
  432745
  520790
  569067
  550480
  604384
  786048
  467895
  457146
  487272
  492222
  485527
  463360
  433729
  505150
  552097
  565284
  598133
  541084
  575648
  658989
  652121
  632095
  616910
  485420
  658110
  605831
  627305
  597036
  599155
  459061
  507608
  558582
  797439
  426660
  520490
  557718
  552211
  599081
  591468
  817445
  497636
  558592
  564091
  560416
  563251
  412548
  523429
  444831
  448518
  532940
  507176
]
3.20 ms
(1.64%)
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
  393810
  397089
  412548
  420877
  426660
  427714
  428587
  432743
  432745
  433729
  435057
  441192
  442463
  444831
  448518
  448519
  457146
  458044
  458443
  459061
  461306
  462681
  463360
  463636
  467895
  469716
  476475
  483902
  485420
  485527
  487272
  492222
  496585
  497636
  502384
  505150
  507176
  507608
  507823
  510619
  514796
  520490
  520790
  521763
  523429
  532940
  538537
  541084
  541755
  550480
  552097
  552211
  557718
  557843
  558582
  558592
  559996
  560416
  562484
  563251
  564091
  564557
  565284
  569067
  569443
  575648
  575932
  591468
  594167
  597036
  598133
  598623
  599081
  599155
  602714
  604384
  605831
  608472
  609343
  610121
  610522
  610526
  615250
  615841
  616910
  619797
  622866
  626685
  627305
  627308
  630716
  630736
  632095
  636951
  639040
  645696
  647060
  652121
  657543
  658110
  658208
  658216
  658223
  658226
  658989
  668083
  684895
  692817
  720078
  736470
  741998
  760214
  772517
  786048
  787379
  789253
  797439
  807419
  817445
  817716
]
2.40 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real домашн любительск teen"
]
1.92 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real homemade teen"
]
1.83 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real домашн любительск teen"
]
1.68 ms
(0.86%)
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.