GET https://search.jues.net/search/embeds/4?q=retro%20skinny

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.69 ms
(84.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
  418978
  541324
  542471
  542502
  542604
  543495
  543756
  544206
  544313
  544468
  545520
  545528
  545642
  547892
  547930
  548289
  549300
  549856
  550327
  556795
  557993
  558008
  560080
  561353
  562287
  562824
  562830
  562840
  562842
  562848
  563415
  563533
  563534
  563540
  566246
  566297
  566686
  566695
  566857
  566865
  566938
  566952
  567393
  567728
  567990
  568026
  568185
  568287
  568601
  568954
  569788
  571242
  571243
  571439
  572176
  572556
  573105
  573761
  573779
  573905
  574216
  574247
  575468
  576420
  576639
  576681
  576705
  577177
  577351
  577363
  577376
  580775
  581260
  581315
  581354
  581386
  581618
  583902
  584008
  584244
  586015
  587795
  589692
  590696
  590928
  590948
  592388
  592486
  592500
  593514
  595888
  600320
  601695
  603041
  605322
  605324
  605328
  605330
  617648
  618299
  619406
  619470
  619485
  622830
  644289
  644310
  644311
  644321
  644379
  646336
  649196
  652577
  670040
  670112
  693864
  694119
  699694
  703039
  706946
  744259
]
14.51 ms
(9.26%)
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
  571439
  575468
  576420
  577363
  584244
  542502
  549856
  563533
  566938
  568026
  569788
  573761
  583902
  584008
  543495
  547892
  557993
  562287
  562840
  574247
  576639
  576705
  581386
  670040
  699694
  706946
  646336
  649196
  652577
  693864
  694119
  556795
  562824
  562848
  563415
  566865
  572556
  574216
  581315
  581354
  586015
  592486
  592500
  593514
  600320
  605324
  590928
  590948
  619406
  619470
  644379
  587795
  592388
  595888
  601695
  603041
  617648
  644321
  589692
  590696
  605322
  605328
  605330
  618299
  619485
  644311
  744259
  622830
  644289
  644310
  703039
  580775
  418978
  541324
  543756
  544206
  544313
  544468
  545528
  548289
  562830
  562842
  566297
  567393
  567728
  567990
  568185
  568601
  568954
  571242
  577351
  581260
  542604
  560080
  563540
  566686
  566695
  566857
  571243
  572176
  573905
  577177
  577376
  542471
  545520
  545642
  547930
  549300
  558008
  561353
  563534
  566246
  566952
  568287
  573105
  573779
  576681
  581618
  670112
  550327
]
3.28 ms
(2.09%)
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
  418978
  541324
  542471
  542502
  542604
  543495
  543756
  544206
  544313
  544468
  545520
  545528
  545642
  547892
  547930
  548289
  549300
  549856
  550327
  556795
  557993
  558008
  560080
  561353
  562287
  562824
  562830
  562840
  562842
  562848
  563415
  563533
  563534
  563540
  566246
  566297
  566686
  566695
  566857
  566865
  566938
  566952
  567393
  567728
  567990
  568026
  568185
  568287
  568601
  568954
  569788
  571242
  571243
  571439
  572176
  572556
  573105
  573761
  573779
  573905
  574216
  574247
  575468
  576420
  576639
  576681
  576705
  577177
  577351
  577363
  577376
  580775
  581260
  581315
  581354
  581386
  581618
  583902
  584008
  584244
  586015
  587795
  589692
  590696
  590928
  590948
  592388
  592486
  592500
  593514
  595888
  600320
  601695
  603041
  605322
  605324
  605328
  605330
  617648
  618299
  619406
  619470
  619485
  622830
  644289
  644310
  644311
  644321
  644379
  646336
  649196
  652577
  670040
  670112
  693864
  694119
  699694
  703039
  706946
  744259
]
2.29 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro skinny"
]
1.77 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр худые"
]
1.68 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр худые"
]
1.56 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.