GET https://search.jues.net/search/embeds/7?q=teens%20skinny

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
109.47 ms
(86.19%)
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
  75925
  393724
  398922
  411039
  453863
  484956
  487439
  489499
  509018
  510436
  512294
  517367
  518471
  527506
  530331
  530354
  538809
  547218
  547259
  548196
  548606
  549757
  549887
  549892
  549910
  549920
  550627
  554709
  565048
  566789
  572590
  573076
  574718
  576346
  583841
  586833
  589426
  599935
  599949
  622014
  622223
  629489
  648728
  652900
  652960
  656072
  656990
  657038
  657665
  657715
  657716
  658046
  658063
  658568
  658652
  659526
  659713
  660882
  660923
  665607
  666613
  669413
  674377
  684348
  700913
  709810
  740396
  744580
  754634
  765961
  778357
  795108
  797373
  815292
  815327
  817144
  817778
  817894
  818056
  818231
  819399
  820915
  821025
  821584
  821747
  824071
  824392
  825094
  825603
  825929
  825967
  826300
  826347
  826352
  826569
  827324
  828059
  828132
  828152
  828161
  828212
  828275
  828392
  828504
  828731
  828732
  828813
  828843
]
8.94 ms
(7.04%)
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
  509018
  510436
  512294
  517367
  484956
  489499
  518471
  75925
  411039
  824071
  825929
  825967
  819399
  824569
  824820
  817144
  825094
  826352
  828161
  828152
  828132
  828212
  549910
  550627
  657038
  659713
  684348
  709810
  652960
  658568
  665607
  666613
  547218
  565048
  599935
  589426
  599949
  740396
  744580
  622014
  815327
  827324
  815292
  660882
  554709
  778357
  795108
  566789
  548606
  574718
  576346
  622223
  393724
  487439
  817894
  823213
  825382
  826300
  818231
  818056
  821747
  825603
  821584
  824392
  824566
  825960
  826347
  826569
  828813
  828392
  828275
  828504
  828731
  530331
  530354
  538809
  549920
  549887
  547259
  572590
  652900
  656072
  657716
  659526
  660923
  669413
  657665
  658046
  658063
  658652
  674377
  656990
  657715
  700913
  548196
  549892
  583841
  586833
  629489
  754634
  765961
  797373
  820915
  821025
  453863
  527506
  573076
  549757
  648728
  398922
  824828
  817778
  823395
  821981
  823872
  828204
  828262
  828059
  828843
  828732
]
2.11 ms
(1.66%)
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
  75925
  393724
  398922
  411039
  453863
  484956
  487439
  489499
  509018
  510436
  512294
  517367
  518471
  527506
  530331
  530354
  538809
  547218
  547259
  548196
  548606
  549757
  549887
  549892
  549910
  549920
  550627
  554709
  565048
  566789
  572590
  573076
  574718
  576346
  583841
  586833
  589426
  599935
  599949
  622014
  622223
  629489
  648728
  652900
  652960
  656072
  656990
  657038
  657665
  657715
  657716
  658046
  658063
  658568
  658652
  659526
  659713
  660882
  660923
  665607
  666613
  669413
  674377
  684348
  700913
  709810
  740396
  744580
  754634
  765961
  778357
  795108
  797373
  815292
  815327
  817144
  817778
  817894
  818056
  818231
  819399
  820915
  821025
  821584
  821747
  824071
  824392
  825094
  825603
  825929
  825967
  826300
  826347
  826352
  826569
  827324
  828059
  828132
  828152
  828161
  828212
  828275
  828392
  828504
  828731
  828732
  828813
  828843
]
1.72 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens skinny"
]
1.68 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens худые"
]
1.60 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens худые"
]
1.48 ms
(1.17%)
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.