GET https://search.jues.net/search/embeds/8?q=films%20long

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.27 ms
(84.40%)
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
  490811
  538891
  539627
  540257
  541329
  541373
  541378
  541388
  541597
  541602
  541605
  541607
  541625
  541674
  541781
  541872
  542190
  544267
  544308
  544339
  544340
  546550
  546747
  546779
  546954
  547265
  547353
  548228
  549267
  549302
  549362
  549369
  549405
  549780
  549945
  549973
  550003
  550322
  557352
  562838
  563079
  563530
  566696
  566698
  567008
  567368
  569295
  570778
  571024
  571240
  572535
  572550
  572653
  574204
  576657
  576684
  576694
  576715
  576722
  577364
  577370
  580863
  581352
  581353
  583827
  583854
  588631
  589761
  592403
  592456
  592533
  592550
  605512
  615735
  615737
  615741
  615747
  618868
  619409
  628297
  628312
  628314
  628319
  649956
  654400
  668950
  670107
  670111
  670117
  671316
  671754
  672105
  672131
  675327
  681118
  681148
  681153
  688078
  694023
  702456
  702895
  702974
  702977
  703437
  704084
  706610
  708790
  719062
  722664
  724867
  730853
  732437
  752072
  755463
  756418
  758987
  789625
  800629
  815531
  815941
]
14.33 ms
(9.51%)
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
  542190
  546779
  547353
  567368
  572550
  576722
  549362
  566696
  571024
  572653
  576715
  581352
  541674
  541781
  576694
  670117
  670107
  672131
  562838
  563530
  577370
  588631
  615741
  618868
  592550
  619409
  628312
  592533
  615747
  815531
  815941
  540257
  538891
  547265
  549267
  550003
  550322
  583827
  541597
  569295
  544267
  544339
  544340
  546550
  549405
  549945
  570778
  649956
  681118
  681148
  688078
  702977
  654400
  675327
  694023
  668950
  670111
  671316
  672105
  681153
  702456
  702895
  704084
  708790
  549973
  557352
  605512
  628297
  615737
  628319
  789625
  758987
  800629
  730853
  756418
  732437
  755463
  724867
  752072
  702974
  703437
  706610
  719062
  722664
  576657
  541329
  541373
  541378
  541872
  546747
  548228
  572535
  574204
  577364
  541388
  541605
  541625
  541602
  541607
  546954
  563079
  581353
  583854
  671754
  566698
  571240
  576684
  580863
  589761
  628314
  592403
  592456
  615735
  490811
  539627
  544308
  549369
  567008
  549302
  549780
]
2.70 ms
(1.79%)
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
  490811
  538891
  539627
  540257
  541329
  541373
  541378
  541388
  541597
  541602
  541605
  541607
  541625
  541674
  541781
  541872
  542190
  544267
  544308
  544339
  544340
  546550
  546747
  546779
  546954
  547265
  547353
  548228
  549267
  549302
  549362
  549369
  549405
  549780
  549945
  549973
  550003
  550322
  557352
  562838
  563079
  563530
  566696
  566698
  567008
  567368
  569295
  570778
  571024
  571240
  572535
  572550
  572653
  574204
  576657
  576684
  576694
  576715
  576722
  577364
  577370
  580863
  581352
  581353
  583827
  583854
  588631
  589761
  592403
  592456
  592533
  592550
  605512
  615735
  615737
  615741
  615747
  618868
  619409
  628297
  628312
  628314
  628319
  649956
  654400
  668950
  670107
  670111
  670117
  671316
  671754
  672105
  672131
  675327
  681118
  681148
  681153
  688078
  694023
  702456
  702895
  702974
  702977
  703437
  704084
  706610
  708790
  719062
  722664
  724867
  730853
  732437
  752072
  755463
  756418
  758987
  789625
  800629
  815531
  815941
]
1.92 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "films long"
]
1.66 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм длинные"
]
1.33 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.