GET https://search.jues.net/search/embeds/4?q=mature%20kitchen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
240.64 ms
(91.22%)
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
  25650
  66611
  188552
  326017
  327638
  366354
  381795
  382289
  389458
  391253
  391967
  394329
  395905
  398655
  401226
  402125
  404342
  407146
  407685
  407791
  415636
  417292
  417850
  418900
  421835
  421836
  421851
  421868
  421871
  422203
  424093
  425572
  426515
  439635
  439720
  440894
  442010
  444679
  444917
  450220
  452620
  453155
  453230
  453242
  455357
  455428
  457167
  458730
  459946
  460258
  461989
  462136
  462140
  468804
  468890
  469034
  470474
  470939
  472153
  477985
  478372
  482563
  483022
  484397
  485712
  490001
  494809
  497005
  499295
  500046
  501519
  505622
  511314
  512215
  513032
  527773
  529326
  533874
  533877
  533889
  533897
  544834
  555995
  557998
  558883
  559960
  561495
  563111
  568596
  574433
  584192
  586617
  591033
  591067
  591512
  602601
  609227
  668645
  668660
  709257
  714380
  714487
  724996
  726538
  730186
  731788
  735932
  736137
  775473
  795849
  796105
  803428
  810986
  820373
  820381
  823917
  824408
  824461
  827921
  828231
]
13.87 ms
(5.26%)
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
  591033
  394329
  327638
  407791
  415636
  440894
  442010
  462136
  452620
  533897
  497005
  499295
  563111
  668660
  714487
  584192
  602601
  609227
  775473
  796105
  724996
  726538
  736137
  803428
  421836
  455357
  402125
  421851
  455428
  450220
  472153
  494809
  533874
  824461
  828231
  827921
  422203
  470474
  485712
  477985
  824408
  366354
  391253
  426515
  417850
  453230
  459946
  468804
  458730
  533877
  529326
  558883
  555995
  668645
  709257
  559960
  591067
  810986
  389458
  439635
  421835
  424093
  326017
  401226
  461989
  462140
  468890
  439720
  505622
  444679
  478372
  395905
  381795
  66611
  823917
  795849
  568596
  820381
  533889
  188552
  482563
  557998
  586617
  382289
  501519
  484397
  457167
  511314
  391967
  418900
  421871
  470939
  398655
  407146
  417292
  425572
  453155
  453242
  460258
  500046
  513032
  512215
  561495
  714380
  544834
  574433
  591512
  404342
  421868
  444917
  469034
  483022
  490001
  731788
  407685
  25650
  820373
  527773
  730186
  735932
]
2.66 ms
(1.01%)
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
  25650
  66611
  188552
  326017
  327638
  366354
  381795
  382289
  389458
  391253
  391967
  394329
  395905
  398655
  401226
  402125
  404342
  407146
  407685
  407791
  415636
  417292
  417850
  418900
  421835
  421836
  421851
  421868
  421871
  422203
  424093
  425572
  426515
  439635
  439720
  440894
  442010
  444679
  444917
  450220
  452620
  453155
  453230
  453242
  455357
  455428
  457167
  458730
  459946
  460258
  461989
  462136
  462140
  468804
  468890
  469034
  470474
  470939
  472153
  477985
  478372
  482563
  483022
  484397
  485712
  490001
  494809
  497005
  499295
  500046
  501519
  505622
  511314
  512215
  513032
  527773
  529326
  533874
  533877
  533889
  533897
  544834
  555995
  557998
  558883
  559960
  561495
  563111
  568596
  574433
  584192
  586617
  591033
  591067
  591512
  602601
  609227
  668645
  668660
  709257
  714380
  714487
  724996
  726538
  730186
  731788
  735932
  736137
  775473
  795849
  796105
  803428
  810986
  820373
  820381
  823917
  824408
  824461
  827921
  828231
]
1.71 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature kitchen"
]
1.67 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature кухн"
]
1.54 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature кухн"
]

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.