GET https://search.jues.net/search/embeds/8?q=first%20teens

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.30 ms
(83.00%)
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
  547078
  547702
  548002
  552203
  553722
  558421
  560239
  562175
  565159
  565344
  566019
  566030
  566037
  573506
  574636
  588615
  594258
  603779
  606277
  612783
  614902
  618862
  619476
  619774
  622403
  625379
  627759
  633241
  633928
  634422
  635236
  635578
  637018
  644057
  653139
  653178
  653619
  659420
  659931
  660743
  664462
  664760
  666465
  671077
  672052
  672891
  674220
  674285
  676517
  678799
  680143
  681881
  685892
  686997
  687896
  692452
  693322
  693765
  697491
  698248
  700979
  703586
  704025
  704540
  712366
  714367
  715196
  716099
  716529
  717433
  722583
  723159
  723964
  726464
  728362
  728369
  731874
  732354
  732412
  735772
  737162
  737416
  738872
  739436
  743760
  744840
  746788
  747563
  750334
  752722
  753814
  757468
  758272
  761659
  765130
  766969
  770582
  772729
  775922
  777888
  781052
  782505
  782959
  790542
  790632
  792183
  793075
  793663
  794917
  796699
  797863
  802805
  802953
  805107
  805525
  806672
  807967
  808255
  810511
  811742
]
16.12 ms
(9.67%)
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
  547078
  547702
  548002
  558421
  560239
  566019
  553722
  565159
  566037
  574636
  552203
  565344
  566030
  659420
  659931
  660743
  664462
  672891
  674220
  676517
  678799
  680143
  687896
  693765
  700979
  703586
  704540
  715196
  716099
  716529
  653178
  653619
  664760
  666465
  671077
  672052
  681881
  685892
  686997
  692452
  704025
  717433
  653139
  674285
  693322
  697491
  698248
  712366
  714367
  722583
  723159
  562175
  573506
  606277
  618862
  622403
  635236
  635578
  588615
  614902
  625379
  633241
  634422
  619774
  627759
  633928
  637018
  644057
  594258
  603779
  612783
  619476
  782505
  790632
  793075
  797863
  807967
  810511
  811742
  775922
  777888
  781052
  782959
  790542
  796699
  805525
  723964
  739436
  744840
  761659
  770582
  772729
  792183
  793663
  794917
  802805
  802953
  805107
  806672
  808255
  726464
  732354
  737162
  738872
  752722
  766969
  728369
  753814
  765130
  728362
  731874
  732412
  735772
  737416
  746788
  747563
  750334
  757468
  743760
  758272
]
5.48 ms
(3.29%)
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
  547078
  547702
  548002
  552203
  553722
  558421
  560239
  562175
  565159
  565344
  566019
  566030
  566037
  573506
  574636
  588615
  594258
  603779
  606277
  612783
  614902
  618862
  619476
  619774
  622403
  625379
  627759
  633241
  633928
  634422
  635236
  635578
  637018
  644057
  653139
  653178
  653619
  659420
  659931
  660743
  664462
  664760
  666465
  671077
  672052
  672891
  674220
  674285
  676517
  678799
  680143
  681881
  685892
  686997
  687896
  692452
  693322
  693765
  697491
  698248
  700979
  703586
  704025
  704540
  712366
  714367
  715196
  716099
  716529
  717433
  722583
  723159
  723964
  726464
  728362
  728369
  731874
  732354
  732412
  735772
  737162
  737416
  738872
  739436
  743760
  744840
  746788
  747563
  750334
  752722
  753814
  757468
  758272
  761659
  765130
  766969
  770582
  772729
  775922
  777888
  781052
  782505
  782959
  790542
  790632
  792183
  793075
  793663
  794917
  796699
  797863
  802805
  802953
  805107
  805525
  806672
  807967
  808255
  810511
  811742
]
1.78 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "first teens"
]
1.76 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "first teens"
]
1.64 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "first 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.