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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.62 ms
(83.58%)
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
  390908
  467861
  472320
  530363
  530559
  533394
  533555
  534104
  537583
  537636
  537740
  537759
  540698
  541334
  541587
  541623
  541699
  541874
  542188
  542960
  542961
  544296
  544455
  544529
  545109
  549371
  549976
  550336
  551915
  556783
  558776
  559119
  559120
  562837
  563875
  566252
  566502
  567476
  568005
  571201
  571244
  571428
  571679
  573076
  573104
  573627
  574244
  577356
  580256
  581401
  584221
  598486
  601347
  603259
  604069
  605345
  617768
  620696
  621705
  624451
  628172
  628294
  629182
  631294
  639189
  639397
  640147
  642773
  648633
  649548
  654006
  659554
  663320
  669481
  677459
  680195
  680497
  680769
  688524
  689493
  689740
  690672
  701524
  703519
  709225
  710298
  710876
  711117
  713197
  715160
  720048
  730479
  744111
  745506
  746832
  747552
  750158
  753717
  755110
  756011
  761268
  771233
  772940
  774683
  778216
  779404
  782306
  786208
  787905
  790406
  793117
  795824
  797663
  803742
  813862
  814191
  816842
  816846
  823505
  827674
]
14.24 ms
(9.79%)
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
  659554
  562837
  605345
  628294
  604069
  533394
  568005
  558776
  573104
  711117
  715160
  573076
  537740
  713197
  753717
  629182
  541334
  566502
  549976
  551915
  542960
  703519
  550336
  556783
  563875
  603259
  598486
  642773
  541623
  816846
  537583
  537759
  533555
  648633
  710876
  639189
  620696
  639397
  778216
  790406
  747552
  755110
  772940
  786208
  771233
  744111
  472320
  549371
  559120
  581401
  544455
  566252
  571679
  580256
  571201
  621705
  624451
  541699
  816842
  823505
  827674
  540698
  545109
  680497
  709225
  663320
  680769
  689493
  689740
  567476
  584221
  640147
  797663
  746832
  761268
  710298
  577356
  541874
  544529
  571244
  601347
  813862
  814191
  467861
  530363
  530559
  534104
  537636
  573627
  677459
  688524
  690672
  701524
  649548
  654006
  669481
  720048
  628172
  631294
  774683
  795824
  803742
  779404
  793117
  756011
  730479
  745506
  750158
  617768
  782306
  787905
  390908
  541587
  544296
  559119
  571428
  542961
  542188
  574244
  680195
]
2.91 ms
(2.00%)
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
  390908
  467861
  472320
  530363
  530559
  533394
  533555
  534104
  537583
  537636
  537740
  537759
  540698
  541334
  541587
  541623
  541699
  541874
  542188
  542960
  542961
  544296
  544455
  544529
  545109
  549371
  549976
  550336
  551915
  556783
  558776
  559119
  559120
  562837
  563875
  566252
  566502
  567476
  568005
  571201
  571244
  571428
  571679
  573076
  573104
  573627
  574244
  577356
  580256
  581401
  584221
  598486
  601347
  603259
  604069
  605345
  617768
  620696
  621705
  624451
  628172
  628294
  629182
  631294
  639189
  639397
  640147
  642773
  648633
  649548
  654006
  659554
  663320
  669481
  677459
  680195
  680497
  680769
  688524
  689493
  689740
  690672
  701524
  703519
  709225
  710298
  710876
  711117
  713197
  715160
  720048
  730479
  744111
  745506
  746832
  747552
  750158
  753717
  755110
  756011
  761268
  771233
  772940
  774683
  778216
  779404
  782306
  786208
  787905
  790406
  793117
  795824
  797663
  803742
  813862
  814191
  816842
  816846
  823505
  827674
]
1.75 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens film"
]
1.73 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens фильм"
]
1.53 ms
(1.05%)
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.