GET https://search.jues.net/search/embeds/7?q=teen%20sweet

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.79 ms
(82.17%)
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
  395395
  396757
  403229
  406125
  415053
  416242
  420494
  430814
  443396
  453816
  454118
  456221
  471990
  478655
  480419
  480727
  487154
  495673
  502302
  509084
  510512
  519487
  523709
  524719
  527508
  528379
  530494
  532442
  537319
  539489
  542146
  542706
  548744
  552110
  552467
  552508
  552609
  554366
  561713
  562272
  564630
  567726
  571050
  571074
  577553
  579178
  583027
  587977
  592431
  592459
  595572
  595646
  598395
  600081
  600242
  600501
  600610
  604147
  605380
  607800
  609896
  613443
  613850
  625901
  637965
  643681
  654394
  659410
  666723
  672408
  677342
  677957
  679713
  683787
  687185
  696500
  704658
  708551
  717867
  717898
  718710
  723932
  727690
  728287
  730098
  730372
  731971
  732878
  733856
  733889
  733896
  733907
  736291
  737786
  740407
  742224
  747439
  749723
  750426
  750637
  751307
  751722
  752685
  758557
  761474
  763536
  772449
  773664
  775231
  775780
  775849
  777502
  779054
  788800
  791385
  796981
  800568
  802765
  813128
]
15.54 ms
(10.84%)
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
  605380
  637965
  779054
  800568
  813128
  775231
  802765
  737786
  750637
  772449
  773664
  747439
  750426
  752685
  723932
  733856
  740407
  742224
  727690
  728287
  751307
  751722
  736291
  758557
  761474
  609896
  613443
  777502
  791385
  796981
  420494
  403229
  395395
  396757
  415053
  524719
  510512
  523709
  519487
  530494
  552508
  552467
  659410
  732878
  406125
  443396
  416242
  430814
  595572
  454118
  453816
  471990
  480727
  487154
  456221
  478655
  480419
  495673
  502302
  509084
  527508
  537319
  528379
  539489
  532442
  552110
  562272
  567726
  542706
  552609
  561713
  564630
  571050
  577553
  583027
  542146
  548744
  579178
  654394
  677342
  696500
  704658
  717867
  717898
  674534
  677957
  679713
  683787
  687185
  666723
  672408
  708551
  554366
  571074
  587977
  592459
  595646
  598395
  613850
  604147
  600501
  592431
  600081
  600242
  600610
  775780
  775849
  733889
  733896
  733907
  749723
  730098
  731971
  763536
  730372
  607800
  625901
  643681
  718710
  788800
]
2.77 ms
(1.93%)
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
  395395
  396757
  403229
  406125
  415053
  416242
  420494
  430814
  443396
  453816
  454118
  456221
  471990
  478655
  480419
  480727
  487154
  495673
  502302
  509084
  510512
  519487
  523709
  524719
  527508
  528379
  530494
  532442
  537319
  539489
  542146
  542706
  548744
  552110
  552467
  552508
  552609
  554366
  561713
  562272
  564630
  567726
  571050
  571074
  577553
  579178
  583027
  587977
  592431
  592459
  595572
  595646
  598395
  600081
  600242
  600501
  600610
  604147
  605380
  607800
  609896
  613443
  613850
  625901
  637965
  643681
  654394
  659410
  666723
  672408
  677342
  677957
  679713
  683787
  687185
  696500
  704658
  708551
  717867
  717898
  718710
  723932
  727690
  728287
  730098
  730372
  731971
  732878
  733856
  733889
  733896
  733907
  736291
  737786
  740407
  742224
  747439
  749723
  750426
  750637
  751307
  751722
  752685
  758557
  761474
  763536
  772449
  773664
  775231
  775780
  775849
  777502
  779054
  788800
  791385
  796981
  800568
  802765
  813128
]
2.16 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen sweet"
]
1.77 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen милая"
]
1.75 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.10%)
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.