GET https://search.jues.net/search/embeds/9?q=vintage%201994

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.84 ms
(85.80%)
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
  541402
  543661
  544267
  544297
  544302
  546550
  546719
  548299
  549307
  554541
  556796
  557372
  557895
  560369
  561575
  562595
  563433
  564286
  565227
  566445
  566551
  567430
  568265
  568337
  571206
  573787
  581347
  581382
  581385
  581621
  582670
  593820
  598028
  606417
  621608
  645838
  646042
  646224
  648211
  648463
  649138
  649956
  650593
  650829
  651163
  651178
  651182
  652573
  652856
  652971
  652983
  659262
  665751
  668562
  670052
  670111
  670388
  670393
  671747
  671925
  671927
  672095
  672105
  672723
  673170
  674072
  677740
  678432
  685279
  685288
  690834
  691485
  691998
  692110
  692231
  692258
  692349
  692360
  692473
  693039
  693041
  693486
  694023
  694052
  694073
  694172
  694197
  694455
  694495
  694522
  694528
  694565
  695180
  695191
  695196
  695621
  695631
  695923
  695941
  696278
  697258
  697273
  697328
  697790
  698497
  698548
  699695
  699753
  703040
  703085
  703533
  705295
  706620
  708790
  710317
  712714
  715097
  716570
  717934
  720375
]
13.95 ms
(8.04%)
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
  557372
  560369
  564286
  568265
  573787
  581347
  582670
  541402
  543661
  544267
  544297
  544302
  546550
  549307
  554541
  557895
  561575
  562595
  565227
  566551
  567430
  568337
  581382
  581621
  646042
  646224
  648211
  648463
  649138
  649956
  650593
  650829
  651178
  659262
  668562
  670393
  671925
  672095
  674072
  685279
  691485
  692258
  692349
  692473
  693039
  694052
  694455
  694495
  694522
  694528
  695196
  695631
  695923
  696278
  703040
  703533
  706620
  710317
  712714
  716570
  652983
  670052
  671927
  672723
  673170
  678432
  690834
  692110
  693486
  694023
  694172
  694197
  694565
  695621
  695941
  697258
  697273
  697328
  697790
  698497
  698548
  699695
  705295
  717934
  720375
  645838
  651163
  651182
  652573
  652856
  652971
  665751
  670111
  670388
  671747
  672105
  677740
  685288
  691998
  692231
  692360
  693041
  694073
  695180
  695191
  699753
  703085
  708790
  715097
  546719
  548299
  556796
  563433
  566445
  571206
  581385
  593820
  598028
  606417
  621608
]
3.07 ms
(1.77%)
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
  541402
  543661
  544267
  544297
  544302
  546550
  546719
  548299
  549307
  554541
  556796
  557372
  557895
  560369
  561575
  562595
  563433
  564286
  565227
  566445
  566551
  567430
  568265
  568337
  571206
  573787
  581347
  581382
  581385
  581621
  582670
  593820
  598028
  606417
  621608
  645838
  646042
  646224
  648211
  648463
  649138
  649956
  650593
  650829
  651163
  651178
  651182
  652573
  652856
  652971
  652983
  659262
  665751
  668562
  670052
  670111
  670388
  670393
  671747
  671925
  671927
  672095
  672105
  672723
  673170
  674072
  677740
  678432
  685279
  685288
  690834
  691485
  691998
  692110
  692231
  692258
  692349
  692360
  692473
  693039
  693041
  693486
  694023
  694052
  694073
  694172
  694197
  694455
  694495
  694522
  694528
  694565
  695180
  695191
  695196
  695621
  695631
  695923
  695941
  696278
  697258
  697273
  697328
  697790
  698497
  698548
  699695
  699753
  703040
  703085
  703533
  705295
  706620
  708790
  710317
  712714
  715097
  716570
  717934
  720375
]
2.05 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vintage 1994"
]
1.92 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "vintage"
]
1.74 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "vintage"
]

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.