GET https://search.jues.net/search/embeds/6?q=natural%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.82 ms
(83.52%)
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
  387670
  389579
  391451
  394161
  394490
  397102
  397427
  397760
  402084
  402195
  402398
  404443
  413584
  420083
  421369
  424387
  426675
  428107
  433164
  436316
  439323
  439769
  441383
  441401
  447146
  447434
  447435
  447438
  447486
  447499
  447514
  447807
  464181
  475237
  476962
  492822
  496090
  505130
  513313
  519841
  528999
  531631
  532286
  535706
  536505
  538239
  538604
  538709
  538740
  541920
  542990
  556573
  566973
  567729
  568127
  570046
  575999
  580853
  594213
  597818
  605323
  609898
  609926
  617490
  623200
  631620
  633533
  634155
  634499
  637122
  637425
  641677
  642044
  642687
  645887
  650232
  655021
  657431
  662131
  665900
  666865
  666968
  668532
  671446
  676328
  677450
  678339
  678985
  680127
  684320
  687000
  687512
  688019
  691362
  692214
  692502
  693174
  693859
  694432
  699038
  701152
  703248
  713285
  713880
  715379
  718714
  720915
  796916
  805302
  811275
  818183
  818787
  821917
  827279
  828128
  828431
  828433
  828443
  828764
]
13.91 ms
(9.69%)
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
  680127
  666968
  570046
  605323
  623200
  634155
  637122
  597818
  633533
  637425
  594213
  634499
  609898
  609926
  436316
  441383
  441401
  447807
  475237
  404443
  413584
  420083
  426675
  464181
  476962
  397427
  421369
  424387
  433164
  447438
  447514
  439769
  447146
  447434
  447435
  447486
  447499
  492822
  505130
  496090
  513313
  519841
  666865
  642044
  642687
  532286
  536505
  567729
  556573
  568127
  676328
  713880
  631620
  641677
  617490
  811275
  805302
  394490
  391451
  580853
  796916
  718714
  402195
  439323
  394161
  389579
  387670
  397102
  397760
  402084
  402398
  428107
  827279
  818183
  818787
  821917
  828764
  828128
  828433
  828652
  828431
  828443
  538709
  538740
  531631
  535706
  538239
  538604
  528999
  566973
  542990
  541920
  575999
  650232
  657431
  662131
  665900
  668532
  684320
  688019
  691362
  692502
  693174
  693859
  701152
  713285
  720915
  655021
  677450
  678339
  678985
  687000
  703248
  715379
  645887
  671446
  687512
  692214
  694432
  699038
]
3.02 ms
(2.10%)
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
  387670
  389579
  391451
  394161
  394490
  397102
  397427
  397760
  402084
  402195
  402398
  404443
  413584
  420083
  421369
  424387
  426675
  428107
  433164
  436316
  439323
  439769
  441383
  441401
  447146
  447434
  447435
  447438
  447486
  447499
  447514
  447807
  464181
  475237
  476962
  492822
  496090
  505130
  513313
  519841
  528999
  531631
  532286
  535706
  536505
  538239
  538604
  538709
  538740
  541920
  542990
  556573
  566973
  567729
  568127
  570046
  575999
  580853
  594213
  597818
  605323
  609898
  609926
  617490
  623200
  631620
  633533
  634155
  634499
  637122
  637425
  641677
  642044
  642687
  645887
  650232
  655021
  657431
  662131
  665900
  666865
  666968
  668532
  671446
  676328
  677450
  678339
  678985
  680127
  684320
  687000
  687512
  688019
  691362
  692214
  692502
  693174
  693859
  694432
  699038
  701152
  703248
  713285
  713880
  715379
  718714
  720915
  796916
  805302
  811275
  818183
  818787
  821917
  827279
  828128
  828431
  828433
  828443
  828764
]
2.03 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural teen"
]
1.68 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные teen"
]
1.48 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "натуральная натуральные teen"
]

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.