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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.77 ms
(85.87%)
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
  68658
  387670
  389579
  391451
  394161
  394490
  397102
  397427
  397760
  402084
  402195
  402398
  404443
  413584
  413641
  416397
  417735
  420083
  421369
  421489
  424387
  426159
  426179
  426675
  428107
  428772
  433164
  433202
  433253
  436316
  439323
  439769
  441326
  441383
  441401
  441623
  447146
  447423
  447434
  447435
  447438
  447486
  447499
  447514
  447807
  452286
  452568
  453824
  464181
  472764
  475237
  476962
  479754
  479774
  480945
  484980
  492822
  494072
  496090
  505130
  513313
  518547
  519841
  528999
  531631
  532286
  535706
  535882
  536505
  536876
  538239
  538604
  538709
  538740
  556573
  565283
  565952
  568127
  570046
  576301
  576980
  580853
  594213
  594353
  597818
  603285
  605323
  609898
  609926
  623200
  631620
  632296
  633533
  634155
  634499
  637122
  637425
  641677
  642044
  642304
  642687
  666865
  666968
  676328
  680127
  685001
  713880
  718714
  796916
  811275
  818183
  818787
  821917
  827279
  828128
  828431
  828433
  828443
  828764
]
16.53 ms
(8.46%)
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
  632296
  642304
  421489
  594353
  603285
  480945
  472764
  452286
  479774
  417735
  426159
  433253
  441326
  441623
  426179
  416397
  433202
  413641
  447423
  479754
  452568
  484980
  453824
  494072
  536876
  518547
  535882
  565283
  565952
  576301
  576980
  685001
  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
  428772
  532286
  536505
  556573
  568127
  676328
  713880
  631620
  641677
  811275
  394490
  391451
  580853
  796916
  718714
  402195
  68658
  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
]
4.11 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
  68658
  387670
  389579
  391451
  394161
  394490
  397102
  397427
  397760
  402084
  402195
  402398
  404443
  413584
  413641
  416397
  417735
  420083
  421369
  421489
  424387
  426159
  426179
  426675
  428107
  428772
  433164
  433202
  433253
  436316
  439323
  439769
  441326
  441383
  441401
  441623
  447146
  447423
  447434
  447435
  447438
  447486
  447499
  447514
  447807
  452286
  452568
  453824
  464181
  472764
  475237
  476962
  479754
  479774
  480945
  484980
  492822
  494072
  496090
  505130
  513313
  518547
  519841
  528999
  531631
  532286
  535706
  535882
  536505
  536876
  538239
  538604
  538709
  538740
  556573
  565283
  565952
  568127
  570046
  576301
  576980
  580853
  594213
  594353
  597818
  603285
  605323
  609898
  609926
  623200
  631620
  632296
  633533
  634155
  634499
  637122
  637425
  641677
  642044
  642304
  642687
  666865
  666968
  676328
  680127
  685001
  713880
  718714
  796916
  811275
  818183
  818787
  821917
  827279
  828128
  828431
  828433
  828443
  828764
]
2.00 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen natural"
]
1.80 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen натуральная натуральные"
]
1.62 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.79%)
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.