GET https://search.jues.net/search/embeds/3?q=old%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.89 ms
(82.96%)
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
  3616
  16971
  152027
  382402
  391492
  392493
  393715
  395908
  397410
  398544
  398554
  401391
  422358
  445040
  466014
  470302
  506211
  507263
  518852
  546138
  548016
  565648
  577276
  577836
  579740
  585583
  585623
  589652
  594051
  594067
  596686
  603617
  604487
  611193
  627380
  631551
  631828
  637828
  637898
  641032
  644699
  660799
  663372
  663404
  665399
  678711
  684101
  684812
  687796
  695849
  702382
  707741
  710769
  715406
  716991
  718143
  721125
  721223
  725227
  726284
  726556
  728470
  730714
  730780
  732171
  734672
  735709
  736410
  738287
  738317
  738320
  738339
  738530
  741093
  744377
  746371
  747171
  747230
  747926
  748091
  750205
  750638
  755143
  756097
  757278
  762951
  764193
  764808
  765931
  776028
  778188
  778722
  780672
  782261
  782499
  786204
  786491
  790834
  793694
  795577
  795594
  796185
  796857
  798527
  800283
  800317
  800761
  801624
  802186
  803857
  813867
  814490
  823923
  825285
  826723
  827084
  827094
  827868
  827908
]
14.81 ms
(10.16%)
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
  728470
  738339
  744377
  746371
  755143
  726556
  748091
  750205
  604487
  637828
  715406
  716991
  778188
  780672
  397410
  393715
  627380
  579740
  398554
  401391
  823923
  684101
  718143
  695849
  585623
  802186
  152027
  684812
  702382
  603617
  725227
  422358
  466014
  470302
  16971
  506211
  518852
  665399
  663404
  756097
  795594
  445040
  585583
  392493
  382402
  398544
  813867
  826723
  827084
  827094
  827868
  827908
  825285
  507263
  565648
  577836
  660799
  707741
  721125
  678711
  687796
  721223
  548016
  577276
  631828
  637898
  589652
  594051
  594067
  596686
  644699
  631551
  641032
  778722
  782499
  786204
  776028
  782261
  786491
  796185
  800317
  734672
  736410
  741093
  795577
  796857
  798527
  800761
  801624
  803857
  726284
  750638
  757278
  730714
  730780
  738317
  738320
  738530
  747171
  764808
  732171
  735709
  738287
  747926
  762951
  764193
  765931
  611193
  627511
  790834
  800283
  395908
  663372
  710769
  546138
  793694
  747230
  391492
  3616
  814490
]
2.66 ms
(1.83%)
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
  3616
  16971
  152027
  382402
  391492
  392493
  393715
  395908
  397410
  398544
  398554
  401391
  422358
  445040
  466014
  470302
  506211
  507263
  518852
  546138
  548016
  565648
  577276
  577836
  579740
  585583
  585623
  589652
  594051
  594067
  596686
  603617
  604487
  611193
  627380
  631551
  631828
  637828
  637898
  641032
  644699
  660799
  663372
  663404
  665399
  678711
  684101
  684812
  687796
  695849
  702382
  707741
  710769
  715406
  716991
  718143
  721125
  721223
  725227
  726284
  726556
  728470
  730714
  730780
  732171
  734672
  735709
  736410
  738287
  738317
  738320
  738339
  738530
  741093
  744377
  746371
  747171
  747230
  747926
  748091
  750205
  750638
  755143
  756097
  757278
  762951
  764193
  764808
  765931
  776028
  778188
  778722
  780672
  782261
  782499
  786204
  786491
  790834
  793694
  795577
  795594
  796185
  796857
  798527
  800283
  800317
  800761
  801624
  802186
  803857
  813867
  814490
  823923
  825285
  826723
  827084
  827094
  827868
  827908
]
2.03 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old wife"
]
1.83 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old жен"
]
1.83 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old жен"
]

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.