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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.65 ms
(86.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
  39356
  325984
  373741
  391209
  394165
  396354
  401757
  401993
  402242
  404734
  405088
  410318
  411025
  411033
  413258
  413592
  413685
  414067
  415761
  418368
  419432
  420513
  421378
  427475
  428639
  428870
  429214
  430105
  431979
  432805
  447494
  448366
  448520
  451727
  452777
  453535
  454278
  457953
  459166
  462026
  463939
  468094
  473782
  473959
  478030
  478908
  479758
  481166
  484274
  490023
  490076
  491712
  492380
  494062
  494409
  494526
  511722
  514892
  518997
  523806
  523871
  530953
  537987
  548650
  556331
  556336
  558031
  561674
  566654
  568169
  569257
  573400
  574807
  576104
  576107
  576314
  578374
  585190
  585963
  594208
  594531
  595392
  595508
  596649
  597071
  598012
  598470
  598501
  598780
  600050
  600114
  604255
  605324
  605339
  609147
  618514
  623435
  623968
  626254
  626255
  626256
  627740
  628310
  644291
  647899
  653543
  659403
  699718
  715566
  719937
  733845
  741548
  750691
  753023
  753320
  756319
  780608
  797375
  823453
  828600
]
14.72 ms
(7.86%)
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
  626254
  628310
  644291
  585963
  598501
  605339
  594531
  623968
  600050
  741548
  756319
  733845
  750691
  715566
  719937
  780608
  797375
  401757
  402242
  404734
  411033
  454278
  391209
  405088
  325984
  396354
  413258
  419432
  494062
  511722
  490076
  494409
  39356
  494526
  576104
  569257
  576314
  604255
  457953
  492380
  523871
  609147
  413592
  523806
  828600
  653543
  566654
  595508
  373741
  428870
  413685
  410318
  430105
  414067
  418368
  823453
  448520
  452777
  490023
  451727
  473959
  514892
  537987
  530953
  478908
  548650
  568169
  573400
  556331
  556336
  576107
  558031
  574807
  647899
  659403
  699718
  598012
  598470
  605324
  623435
  626256
  585190
  595392
  597071
  598780
  618514
  627740
  753023
  753320
  626255
  448366
  453535
  468094
  428639
  394165
  401993
  421378
  429214
  411025
  420513
  427475
  447494
  463939
  479758
  462026
  481166
  491712
  518997
  484274
  432805
  459166
  478030
  473782
  578374
  561674
  594208
  596649
  600114
  415761
  431979
]
2.38 ms
(1.27%)
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
  39356
  325984
  373741
  391209
  394165
  396354
  401757
  401993
  402242
  404734
  405088
  410318
  411025
  411033
  413258
  413592
  413685
  414067
  415761
  418368
  419432
  420513
  421378
  427475
  428639
  428870
  429214
  430105
  431979
  432805
  447494
  448366
  448520
  451727
  452777
  453535
  454278
  457953
  459166
  462026
  463939
  468094
  473782
  473959
  478030
  478908
  479758
  481166
  484274
  490023
  490076
  491712
  492380
  494062
  494409
  494526
  511722
  514892
  518997
  523806
  523871
  530953
  537987
  548650
  556331
  556336
  558031
  561674
  566654
  568169
  569257
  573400
  574807
  576104
  576107
  576314
  578374
  585190
  585963
  594208
  594531
  595392
  595508
  596649
  597071
  598012
  598470
  598501
  598780
  600050
  600114
  604255
  605324
  605339
  609147
  618514
  623435
  623968
  626254
  626255
  626256
  627740
  628310
  644291
  647899
  653543
  659403
  699718
  715566
  719937
  733845
  741548
  750691
  753023
  753320
  756319
  780608
  797375
  823453
  828600
]
2.07 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen natural"
]
1.96 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen натуральная натуральные"
]
1.62 ms
(0.87%)
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.