GET https://search.jues.net/search/embeds/5?q=casting%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.93 ms
(84.36%)
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
  384558
  407602
  417865
  422524
  422557
  422618
  422920
  423264
  443693
  445057
  446267
  446298
  453122
  472223
  480376
  482818
  491670
  493931
  495374
  509920
  514574
  519682
  520629
  523184
  524664
  526116
  529035
  531429
  531430
  536676
  547061
  550374
  550377
  550379
  550408
  551394
  553276
  554068
  558049
  561471
  566158
  568579
  574192
  579668
  580185
  580776
  582548
  589268
  591137
  611565
  611933
  612207
  612946
  615796
  615978
  638346
  641677
  644078
  644493
  644956
  650657
  651881
  652187
  665027
  665296
  667311
  667614
  667679
  667900
  668888
  671832
  672588
  673371
  680185
  694048
  700659
  703100
  705404
  705717
  709636
  709732
  712332
  714167
  714171
  715528
  715722
  716181
  716528
  717645
  717689
  718236
  719102
  720384
  722330
  722596
  725363
  725564
  727698
  730313
  732420
  732425
  735821
  736408
  737070
  741966
  742031
  742610
  743021
  744995
  747604
  754141
  758986
  760034
  765710
  766851
  773683
  789845
  804751
  814070
  826327
]
13.79 ms
(8.95%)
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
  509920
  524664
  491670
  495374
  493931
  526116
  514574
  417865
  644956
  826327
  520629
  566158
  665027
  671832
  703100
  651881
  667311
  717645
  718236
  650657
  668888
  673371
  712332
  717689
  720384
  722596
  551394
  561471
  579668
  611565
  638346
  641677
  644493
  589268
  591137
  612207
  612946
  615796
  644078
  789845
  804751
  727698
  730313
  736408
  743021
  747604
  758986
  760034
  765710
  766851
  725363
  732425
  741966
  742031
  742610
  744995
  725564
  732420
  735821
  737070
  754141
  773683
  611933
  715528
  715722
  716181
  443693
  536676
  615978
  529035
  568579
  680185
  446267
  384558
  422618
  423264
  407602
  422524
  445057
  422920
  422557
  814070
  482818
  453122
  446298
  519682
  531429
  531430
  523184
  472223
  480376
  550374
  553276
  558049
  580776
  582548
  547061
  550377
  550379
  550408
  554068
  574192
  580185
  652187
  667900
  700659
  709732
  714167
  716528
  719102
  722330
  665296
  667614
  667679
  672588
  694048
  705404
  705717
  709636
  714171
]
2.58 ms
(1.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг old"
]
2.30 ms
(1.49%)
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
  384558
  407602
  417865
  422524
  422557
  422618
  422920
  423264
  443693
  445057
  446267
  446298
  453122
  472223
  480376
  482818
  491670
  493931
  495374
  509920
  514574
  519682
  520629
  523184
  524664
  526116
  529035
  531429
  531430
  536676
  547061
  550374
  550377
  550379
  550408
  551394
  553276
  554068
  558049
  561471
  566158
  568579
  574192
  579668
  580185
  580776
  582548
  589268
  591137
  611565
  611933
  612207
  612946
  615796
  615978
  638346
  641677
  644078
  644493
  644956
  650657
  651881
  652187
  665027
  665296
  667311
  667614
  667679
  667900
  668888
  671832
  672588
  673371
  680185
  694048
  700659
  703100
  705404
  705717
  709636
  709732
  712332
  714167
  714171
  715528
  715722
  716181
  716528
  717645
  717689
  718236
  719102
  720384
  722330
  722596
  725363
  725564
  727698
  730313
  732420
  732425
  735821
  736408
  737070
  741966
  742031
  742610
  743021
  744995
  747604
  754141
  758986
  760034
  765710
  766851
  773683
  789845
  804751
  814070
  826327
]
1.99 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting old"
]
1.79 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг old"
]
1.64 ms
(1.07%)
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.