GET https://search.jues.net/search/embeds/6?q=hot%20beauty

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.36 ms
(85.23%)
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
  38068
  38261
  66747
  150461
  384836
  385757
  387601
  394581
  395434
  395699
  395861
  397560
  397971
  402137
  403147
  403555
  403589
  413143
  414302
  414765
  419101
  419220
  427493
  427800
  428300
  430948
  445850
  448707
  449623
  450779
  454057
  467339
  468800
  504980
  510064
  512641
  514394
  515623
  515652
  516032
  521473
  522573
  524478
  524485
  525470
  530724
  531707
  532980
  534018
  537354
  542600
  554528
  560510
  587299
  593193
  598232
  609966
  624888
  631386
  632267
  633748
  663254
  665930
  671730
  673056
  702332
  717037
  719237
  721112
  721197
  725581
  735752
  736818
  738437
  741299
  746964
  747258
  751228
  751370
  754476
  760681
  760687
  762218
  770015
  770356
  770920
  773408
  773707
  773822
  774675
  775379
  777385
  779354
  781244
  783322
  784151
  786258
  787182
  788458
  788865
  789412
  790055
  792356
  792585
  796435
  797675
  800223
  802381
  802694
  805431
  807214
  808730
  809354
  809490
  810477
  814042
  816363
  818273
  818284
]
18.53 ms
(9.27%)
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
  738923
  746964
  762218
  770015
  773707
  736818
  738437
  751370
  754476
  770356
  773408
  751228
  631386
  702332
  717037
  719237
  721197
  777385
  779354
  781244
  783322
  787182
  788458
  788865
  789412
  792585
  800223
  802381
  807214
  384836
  403147
  414765
  66747
  397971
  397560
  403589
  512641
  395699
  38261
  402137
  403555
  814042
  816363
  818273
  818284
  468800
  531707
  515623
  530724
  532980
  537354
  510064
  524485
  534018
  554528
  542600
  560510
  663254
  665930
  671730
  673056
  587299
  632267
  598232
  624888
  775379
  805431
  808730
  809490
  810477
  774675
  809354
  770920
  784151
  790055
  796435
  747258
  760687
  773822
  725581
  735752
  741299
  760681
  609966
  721112
  786258
  792356
  797675
  802694
  385757
  394581
  419220
  428300
  467339
  387601
  414302
  448707
  419101
  445850
  454057
  395861
  413143
  427493
  427800
  449623
  430948
  450779
  514394
  521473
  504980
  524478
  516032
  525470
  515652
  522573
  593193
  633748
  150461
  395434
  38068
]
3.64 ms
(1.82%)
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
  38068
  38261
  66747
  150461
  384836
  385757
  387601
  394581
  395434
  395699
  395861
  397560
  397971
  402137
  403147
  403555
  403589
  413143
  414302
  414765
  419101
  419220
  427493
  427800
  428300
  430948
  445850
  448707
  449623
  450779
  454057
  467339
  468800
  504980
  510064
  512641
  514394
  515623
  515652
  516032
  521473
  522573
  524478
  524485
  525470
  530724
  531707
  532980
  534018
  537354
  542600
  554528
  560510
  587299
  593193
  598232
  609966
  624888
  631386
  632267
  633748
  663254
  665930
  671730
  673056
  702332
  717037
  719237
  721112
  721197
  725581
  735752
  736818
  738437
  741299
  746964
  747258
  751228
  751370
  754476
  760681
  760687
  762218
  770015
  770356
  770920
  773408
  773707
  773822
  774675
  775379
  777385
  779354
  781244
  783322
  784151
  786258
  787182
  788458
  788865
  789412
  790055
  792356
  792585
  796435
  797675
  800223
  802381
  802694
  805431
  807214
  808730
  809354
  809490
  810477
  814042
  816363
  818273
  818284
]
2.04 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot beauty"
]
1.88 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot beauty"
]
1.74 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot beauty"
]
1.69 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.