GET https://search.jues.net/search/embeds/4?q=grandpa%20teens

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.18 ms
(83.45%)
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
  21220
  163368
  233346
  251476
  295529
  295700
  372346
  382372
  382378
  382884
  382979
  386103
  386593
  387027
  388482
  390894
  391246
  393783
  394238
  394456
  396165
  396554
  396734
  397158
  402036
  446376
  458036
  465631
  487910
  488306
  509054
  515110
  515227
  528353
  544303
  544308
  548573
  550436
  550662
  552013
  554265
  556408
  562103
  562105
  569664
  578470
  580466
  584674
  588625
  593402
  599148
  600105
  600121
  606956
  607167
  612083
  613471
  614849
  618873
  618886
  624464
  630834
  631601
  644194
  644660
  646939
  663910
  670476
  676510
  676525
  677054
  678802
  682510
  682511
  682538
  684574
  684582
  694537
  694538
  696273
  700660
  708802
  708807
  709639
  710970
  712810
  712830
  712896
  714478
  720429
  722665
  722670
  722672
  722688
  722705
  724904
  732422
  732457
  735516
  735814
  743034
  744278
  747832
  754206
  759572
  759642
  759647
  766020
  776878
  778602
  783885
  789283
  789806
  800249
  807967
  812115
  812132
  819963
  824090
  827117
]
21.56 ms
(11.03%)
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
  394456
  295700
  396734
  396554
  388482
  393783
  458036
  550436
  446376
  487910
  528353
  386593
  382979
  382884
  163368
  382378
  387027
  391246
  819963
  827117
  515110
  515227
  488306
  544308
  556408
  544303
  676525
  678802
  682511
  694538
  696273
  712830
  714478
  722688
  684582
  600121
  593402
  618886
  624464
  600105
  607167
  612083
  776878
  783885
  800249
  724904
  743034
  789806
  747832
  759647
  766020
  754206
  732422
  732457
  735516
  735814
  744278
  759642
  759572
  700660
  708802
  709639
  778602
  812132
  233346
  295529
  21220
  386103
  396165
  394238
  550662
  251476
  382372
  372346
  390894
  397158
  402036
  824090
  509054
  465631
  562105
  569664
  548573
  554265
  584674
  552013
  562103
  578470
  580466
  670476
  676510
  722672
  646939
  663910
  677054
  684574
  694537
  712810
  720429
  722665
  722705
  682510
  682538
  708807
  710970
  712896
  722670
  588625
  613471
  630834
  644194
  631601
  644660
  599148
  606956
  614849
  618873
  789283
  807967
  812115
]
2.98 ms
(1.52%)
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
  21220
  163368
  233346
  251476
  295529
  295700
  372346
  382372
  382378
  382884
  382979
  386103
  386593
  387027
  388482
  390894
  391246
  393783
  394238
  394456
  396165
  396554
  396734
  397158
  402036
  446376
  458036
  465631
  487910
  488306
  509054
  515110
  515227
  528353
  544303
  544308
  548573
  550436
  550662
  552013
  554265
  556408
  562103
  562105
  569664
  578470
  580466
  584674
  588625
  593402
  599148
  600105
  600121
  606956
  607167
  612083
  613471
  614849
  618873
  618886
  624464
  630834
  631601
  644194
  644660
  646939
  663910
  670476
  676510
  676525
  677054
  678802
  682510
  682511
  682538
  684574
  684582
  694537
  694538
  696273
  700660
  708802
  708807
  709639
  710970
  712810
  712830
  712896
  714478
  720429
  722665
  722670
  722672
  722688
  722705
  724904
  732422
  732457
  735516
  735814
  743034
  744278
  747832
  754206
  759572
  759642
  759647
  766020
  776878
  778602
  783885
  789283
  789806
  800249
  807967
  812115
  812132
  819963
  824090
  827117
]
2.71 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "grandpa teens"
]
2.04 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "grandpa teens"
]
1.34 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "grandpa 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.