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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.22 ms
(89.03%)
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
  538873
  540076
  541376
  541586
  541624
  542493
  542960
  543725
  543825
  544571
  546614
  547431
  548679
  549296
  549762
  549778
  550236
  551020
  556597
  556794
  556842
  557322
  558801
  559012
  559122
  560083
  560088
  560381
  560627
  562844
  563462
  565446
  566158
  566244
  566354
  566475
  566641
  566649
  566673
  566675
  566684
  566886
  567396
  567398
  567403
  567407
  567755
  568266
  568304
  569480
  569858
  569915
  570003
  570021
  570043
  570332
  570669
  571650
  572579
  572582
  572603
  572766
  573114
  573908
  574558
  575424
  576626
  576655
  576711
  577346
  577358
  577381
  581380
  581401
  583851
  583872
  583882
  586813
  587472
  589204
  589747
  592395
  592450
  592451
  592514
  592515
  592522
  592526
  595842
  596336
  598058
  599011
  603161
  605325
  605333
  605342
  606413
  620141
  621025
  627061
  629009
  644330
  649150
  649153
  651951
  652187
  652876
  654089
  669570
  670103
  672138
  677705
  685263
  694160
  694553
  694554
  706899
  719137
  736405
  743063
]
12.61 ms
(6.30%)
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
  566158
  566673
  567755
  541624
  542493
  566244
  652876
  654089
  649150
  651951
  685263
  694160
  694553
  719137
  566649
  567398
  568266
  571650
  572582
  576626
  577346
  606413
  736405
  743063
  620141
  546614
  589747
  538873
  540076
  541376
  543725
  543825
  556597
  556842
  557322
  558801
  560381
  567396
  567403
  570043
  570332
  572603
  575424
  577358
  577381
  583851
  583882
  541586
  548679
  559012
  559122
  565446
  566684
  566886
  569858
  572766
  573114
  547431
  549296
  549762
  556794
  566354
  566475
  567407
  568304
  570669
  576655
  581380
  649153
  652187
  672138
  677705
  694554
  669570
  670103
  551020
  562844
  563462
  570003
  570021
  572579
  573908
  574558
  583872
  589204
  592450
  596336
  598058
  605325
  605342
  586813
  592395
  595842
  599011
  603161
  587472
  592451
  592515
  592522
  592526
  621025
  605333
  627061
  629009
  644330
  706899
  542960
  576711
  592514
  581401
  544571
  549778
  550236
  560083
  560088
  560627
  566641
  566675
  569480
  569915
]
2.56 ms
(1.28%)
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
  538873
  540076
  541376
  541586
  541624
  542493
  542960
  543725
  543825
  544571
  546614
  547431
  548679
  549296
  549762
  549778
  550236
  551020
  556597
  556794
  556842
  557322
  558801
  559012
  559122
  560083
  560088
  560381
  560627
  562844
  563462
  565446
  566158
  566244
  566354
  566475
  566641
  566649
  566673
  566675
  566684
  566886
  567396
  567398
  567403
  567407
  567755
  568266
  568304
  569480
  569858
  569915
  570003
  570021
  570043
  570332
  570669
  571650
  572579
  572582
  572603
  572766
  573114
  573908
  574558
  575424
  576626
  576655
  576711
  577346
  577358
  577381
  581380
  581401
  583851
  583872
  583882
  586813
  587472
  589204
  589747
  592395
  592450
  592451
  592514
  592515
  592522
  592526
  595842
  596336
  598058
  599011
  603161
  605325
  605333
  605342
  606413
  620141
  621025
  627061
  629009
  644330
  649150
  649153
  651951
  652187
  652876
  654089
  669570
  670103
  672138
  677705
  685263
  694160
  694553
  694554
  706899
  719137
  736405
  743063
]
2.03 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр худые"
]
1.82 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro skinny"
]
1.47 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр худые"
]
1.47 ms
(0.73%)
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.