GET https://search.jues.net/search/embeds/3?q=solo%20creamy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.31 ms
(86.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
  399908
  418131
  418132
  418671
  420874
  421759
  434382
  435625
  436055
  436116
  437369
  439240
  441046
  446176
  453216
  454641
  457376
  457383
  459563
  462948
  464852
  465454
  467923
  471110
  472548
  487254
  497720
  497909
  498303
  500745
  502447
  510331
  516548
  527469
  541802
  541858
  559199
  564755
  571350
  574198
  577458
  579611
  580379
  580500
  589150
  595524
  607692
  612715
  617606
  619636
  628610
  634742
  636488
  641534
  643380
  661590
  662425
  662438
  668623
  675402
  681359
  697242
  704687
  707478
  708594
  708748
  739827
  740123
  740848
  744178
  747432
  751337
  753193
  756480
  756776
  757057
  757483
  762153
  767351
  770261
  773298
  776031
  777287
  778869
  782079
  782094
  782855
  782891
  783486
  783709
  783927
  784113
  784121
  784126
  784127
  785012
  785857
  786662
  786687
  786895
  787095
  787516
  787771
  787774
  791441
  793116
  793127
  795402
  796999
  797048
  802255
  804678
  806444
  806623
  806714
  806834
  806958
  813136
  824769
]
14.06 ms
(7.29%)
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
  399908
  471110
  436055
  487254
  467923
  435625
  437369
  418132
  457376
  500745
  527469
  541802
  668623
  708594
  681359
  707478
  708748
  628610
  636488
  782855
  786662
  787095
  787771
  802255
  804678
  778869
  786895
  791441
  740123
  740848
  747432
  785857
  797048
  806444
  806505
  806623
  806958
  744178
  762153
  767351
  756480
  756776
  739827
  753193
  757483
  704687
  777287
  782079
  783927
  785012
  796999
  459563
  472548
  436116
  418671
  824769
  453216
  464852
  516548
  497720
  574198
  541858
  564755
  577458
  661590
  662425
  697242
  607692
  617606
  619636
  641534
  776031
  787774
  786687
  793127
  795402
  757057
  782891
  784113
  784126
  784127
  787516
  793116
  806714
  770261
  773298
  751337
  782094
  783709
  784121
  806834
  813136
  434382
  510331
  502447
  498303
  571350
  420874
  421759
  418131
  439240
  441046
  454641
  462948
  446176
  457383
  465454
  497909
  559199
  580379
  662438
  675402
  579611
  580500
  589150
  612715
  634742
  643380
  595524
  783486
]
3.01 ms
(1.56%)
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
  399908
  418131
  418132
  418671
  420874
  421759
  434382
  435625
  436055
  436116
  437369
  439240
  441046
  446176
  453216
  454641
  457376
  457383
  459563
  462948
  464852
  465454
  467923
  471110
  472548
  487254
  497720
  497909
  498303
  500745
  502447
  510331
  516548
  527469
  541802
  541858
  559199
  564755
  571350
  574198
  577458
  579611
  580379
  580500
  589150
  595524
  607692
  612715
  617606
  619636
  628610
  634742
  636488
  641534
  643380
  661590
  662425
  662438
  668623
  675402
  681359
  697242
  704687
  707478
  708594
  708748
  739827
  740123
  740848
  744178
  747432
  751337
  753193
  756480
  756776
  757057
  757483
  762153
  767351
  770261
  773298
  776031
  777287
  778869
  782079
  782094
  782855
  782891
  783486
  783709
  783927
  784113
  784121
  784126
  784127
  785012
  785857
  786662
  786687
  786895
  787095
  787516
  787771
  787774
  791441
  793116
  793127
  795402
  796999
  797048
  802255
  804678
  806444
  806623
  806714
  806834
  806958
  813136
  824769
]
2.36 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.34 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo creamy"
]
2.02 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло creamy"
]
1.66 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло creamy"
]

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.