GET https://search.jues.net/search/embeds/4?q=skinny%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.95 ms
(89.31%)
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
  130022
  142773
  382501
  382986
  396011
  397739
  400006
  411447
  411744
  414956
  421484
  429138
  443417
  448359
  451015
  451455
  451698
  453674
  470315
  484116
  493079
  498980
  498988
  504711
  512204
  522372
  542179
  543726
  549780
  551221
  552186
  552225
  553213
  554181
  554718
  557640
  560026
  561153
  561920
  561972
  562228
  562299
  562300
  562485
  567458
  567531
  568042
  569017
  570507
  570567
  570571
  570856
  571546
  572428
  573792
  582941
  583314
  584723
  585595
  586989
  587243
  590292
  593193
  595978
  600362
  607301
  621509
  629092
  631337
  634263
  647627
  653246
  653290
  661701
  665221
  672444
  672586
  680390
  682908
  683275
  688989
  689212
  696237
  698147
  698832
  703279
  703628
  707538
  708804
  709396
  712831
  718127
  718934
  719453
  722805
  723668
  725328
  731762
  734481
  739536
  768555
  768933
  773194
  775617
  777625
  777940
  780843
  782745
  791371
  792800
  793212
  802821
  802976
  804902
  805652
  810842
  813444
  814134
  817367
  819910
]
9.73 ms
(5.47%)
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
  484116
  552225
  554718
  557640
  562485
  570567
  570856
  572428
  567531
  551221
  560026
  653246
  661701
  703628
  707538
  718934
  719453
  665221
  682908
  698147
  712831
  718127
  653290
  688989
  698832
  708804
  561920
  567458
  583314
  587243
  607301
  629092
  590292
  585595
  600362
  586989
  621509
  631337
  634263
  793212
  805652
  810842
  777625
  777940
  780843
  782745
  802821
  813444
  723668
  725328
  739536
  804902
  731762
  768555
  768933
  773194
  703279
  709396
  775617
  791371
  792800
  802976
  382986
  400006
  142773
  421484
  470315
  411744
  414956
  451455
  397739
  448359
  451015
  595978
  734481
  722805
  593193
  130022
  396011
  382501
  443417
  429138
  411447
  819910
  814134
  817367
  453674
  451698
  504711
  522372
  498980
  498988
  512204
  493079
  562299
  570571
  573792
  542179
  549780
  554181
  561153
  561972
  562300
  569017
  582941
  584723
  543726
  552186
  553213
  562228
  568042
  570507
  571546
  672444
  672586
  689212
  696237
  647627
  680390
  683275
]
2.29 ms
(1.28%)
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
  130022
  142773
  382501
  382986
  396011
  397739
  400006
  411447
  411744
  414956
  421484
  429138
  443417
  448359
  451015
  451455
  451698
  453674
  470315
  484116
  493079
  498980
  498988
  504711
  512204
  522372
  542179
  543726
  549780
  551221
  552186
  552225
  553213
  554181
  554718
  557640
  560026
  561153
  561920
  561972
  562228
  562299
  562300
  562485
  567458
  567531
  568042
  569017
  570507
  570567
  570571
  570856
  571546
  572428
  573792
  582941
  583314
  584723
  585595
  586989
  587243
  590292
  593193
  595978
  600362
  607301
  621509
  629092
  631337
  634263
  647627
  653246
  653290
  661701
  665221
  672444
  672586
  680390
  682908
  683275
  688989
  689212
  696237
  698147
  698832
  703279
  703628
  707538
  708804
  709396
  712831
  718127
  718934
  719453
  722805
  723668
  725328
  731762
  734481
  739536
  768555
  768933
  773194
  775617
  777625
  777940
  780843
  782745
  791371
  792800
  793212
  802821
  802976
  804902
  805652
  810842
  813444
  814134
  817367
  819910
]
2.23 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny hot"
]
1.67 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые hot"
]
1.49 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые hot"
]

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.