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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.54 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.97 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vintage 1994"
]
3 14.77 ms
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
  429862
  566678
  418978
  490034
  489462
  525747
  519266
  504252
  507686
  511393
  544311
  576709
  576718
  583837
  583581
  541380
  563099
  576712
  593878
  603214
  615542
  628170
  750060
  470407
  388110
  511422
  519012
  519268
  490044
  539591
  668572
  539594
  538907
  566679
  566683
  695600
  693984
  695636
  681764
  484767
  524987
  524990
  538817
  554783
  576715
  720795
  592489
  588631
  592444
  592550
  472312
  515014
  522915
  519227
  538917
  542481
  566450
  566799
  651675
  692022
  674333
  490025
  519246
  581350
  750064
  476476
  525462
  511028
  820139
  538920
  542492
  544262
  563994
  694508
  703517
  668411
  721170
  682825
  712703
  582768
  592513
  605629
  621622
  623927
  720647
  538950
  538953
  572638
  568593
  581330
  562986
  566417
  566446
  569857
  699703
  687096
  687132
  693043
  696254
  593360
  638391
  592487
  519251
  522914
  541334
  548278
  576713
  571434
  576645
  576711
  592514
  592541
  524969
  489468
  538861
  544357
  571183
  548269
  692447
  700661
]
4 2.89 ms
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
  388110
  418978
  429862
  470407
  472312
  476476
  484767
  489462
  489468
  490025
  490034
  490044
  504252
  507686
  511028
  511393
  511422
  515014
  519012
  519227
  519246
  519251
  519266
  519268
  522914
  522915
  524969
  524987
  524990
  525462
  525747
  538817
  538861
  538907
  538917
  538920
  538950
  538953
  539591
  539594
  541334
  541380
  542481
  542492
  544262
  544311
  544357
  548269
  548278
  554783
  562986
  563099
  563994
  566417
  566446
  566450
  566678
  566679
  566683
  566799
  568593
  569857
  571183
  571434
  572638
  576645
  576709
  576711
  576712
  576713
  576715
  576718
  581330
  581350
  582768
  583581
  583837
  588631
  592444
  592487
  592489
  592513
  592514
  592541
  592550
  593360
  593878
  603214
  605629
  615542
  621622
  623927
  628170
  638391
  651675
  668411
  668572
  674333
  681764
  682825
  687096
  687132
  692022
  692447
  693043
  693984
  694508
  695600
  695636
  696254
  699703
  700661
  703517
  712703
  720647
  720795
  721170
  750060
  750064
  820139
]
5 168.31 ms
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
  388110
  418978
  429862
  470407
  472312
  476476
  484767
  489462
  489468
  490025
  490034
  490044
  504252
  507686
  511028
  511393
  511422
  515014
  519012
  519227
  519246
  519251
  519266
  519268
  522914
  522915
  524969
  524987
  524990
  525462
  525747
  538817
  538861
  538907
  538917
  538920
  538950
  538953
  539591
  539594
  541334
  541380
  542481
  542492
  544262
  544311
  544357
  548269
  548278
  554783
  562986
  563099
  563994
  566417
  566446
  566450
  566678
  566679
  566683
  566799
  568593
  569857
  571183
  571434
  572638
  576645
  576709
  576711
  576712
  576713
  576715
  576718
  581330
  581350
  582768
  583581
  583837
  588631
  592444
  592487
  592489
  592513
  592514
  592541
  592550
  593360
  593878
  603214
  605629
  615542
  621622
  623927
  628170
  638391
  651675
  668411
  668572
  674333
  681764
  682825
  687096
  687132
  692022
  692447
  693043
  693984
  694508
  695600
  695636
  696254
  699703
  700661
  703517
  712703
  720647
  720795
  721170
  750060
  750064
  820139
]
6 1.64 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "vintage"
]
7 1.64 ms
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.