GET https://search.jues.net/search/embeds/6?q=teens%20film

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.62 ms
(87.64%)
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
  405911
  467670
  490811
  532086
  538832
  539624
  541361
  541597
  541605
  541625
  541643
  544261
  544307
  544308
  544326
  544340
  546747
  546954
  547352
  547859
  547869
  548228
  549265
  549267
  549362
  549405
  549421
  549780
  549899
  549945
  550322
  556796
  557206
  557352
  560091
  562857
  563530
  563532
  566697
  567368
  569295
  570778
  570804
  572544
  572563
  572568
  572653
  574204
  574269
  574281
  576722
  579922
  580253
  581119
  581320
  583827
  583854
  589761
  593299
  614327
  618868
  619409
  622412
  629966
  648963
  649536
  654400
  668950
  670114
  671316
  671760
  672099
  672112
  678008
  681115
  681148
  682466
  683371
  684267
  684961
  688078
  690860
  694537
  700743
  702088
  702895
  702974
  702977
  703040
  703070
  703535
  704084
  704540
  705915
  706612
  708418
  708790
  709211
  712714
  713695
  715501
  719059
  719062
  719094
  722190
  722197
  722664
  722684
  724867
  727299
  730853
  732437
  737621
  744278
  752072
  756418
  758987
  786031
  788462
  800629
]
14.10 ms
(7.16%)
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
  567368
  576722
  549362
  572653
  563532
  574269
  563530
  581320
  593299
  618868
  619409
  709211
  467670
  539624
  532086
  549267
  550322
  581119
  583827
  541597
  544307
  544326
  569295
  544340
  549405
  549945
  570778
  681148
  688078
  702977
  703040
  712714
  654400
  668950
  671316
  702895
  704084
  708790
  549421
  556796
  557352
  788462
  758987
  800629
  730853
  737621
  756418
  732437
  724867
  752072
  702974
  703535
  715501
  719062
  722664
  538832
  546747
  548228
  574204
  541605
  541625
  544261
  566697
  546954
  580253
  583854
  572544
  589761
  490811
  544308
  579922
  549780
  570804
  547352
  572568
  649536
  700743
  719059
  719094
  678008
  683371
  702088
  722684
  648963
  672099
  684267
  684961
  706612
  708418
  722190
  547869
  549899
  557206
  562857
  572563
  622412
  786031
  727299
  744278
  614327
  629966
  703070
  722197
  541643
  405911
  560091
  574281
  541361
  547859
  549265
  681115
  690860
  704540
  705915
  670114
  694537
  713695
  671760
  672112
  682466
]
4.02 ms
(2.04%)
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
  405911
  467670
  490811
  532086
  538832
  539624
  541361
  541597
  541605
  541625
  541643
  544261
  544307
  544308
  544326
  544340
  546747
  546954
  547352
  547859
  547869
  548228
  549265
  549267
  549362
  549405
  549421
  549780
  549899
  549945
  550322
  556796
  557206
  557352
  560091
  562857
  563530
  563532
  566697
  567368
  569295
  570778
  570804
  572544
  572563
  572568
  572653
  574204
  574269
  574281
  576722
  579922
  580253
  581119
  581320
  583827
  583854
  589761
  593299
  614327
  618868
  619409
  622412
  629966
  648963
  649536
  654400
  668950
  670114
  671316
  671760
  672099
  672112
  678008
  681115
  681148
  682466
  683371
  684267
  684961
  688078
  690860
  694537
  700743
  702088
  702895
  702974
  702977
  703040
  703070
  703535
  704084
  704540
  705915
  706612
  708418
  708790
  709211
  712714
  713695
  715501
  719059
  719062
  719094
  722190
  722197
  722664
  722684
  724867
  727299
  730853
  732437
  737621
  744278
  752072
  756418
  758987
  786031
  788462
  800629
]
1.65 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens film"
]
1.60 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens фильм"
]
1.38 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens фильм"
]

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.