GET https://search.jues.net/search/embeds/8?q=homemade%20shower%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.60 ms
(85.28%)
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
  386751
  396286
  415095
  417268
  418353
  418627
  420440
  421236
  421294
  434259
  435114
  437407
  437663
  440650
  443396
  447902
  451338
  452367
  452666
  453501
  454428
  454617
  455873
  456778
  459342
  461693
  467920
  467979
  468278
  469727
  473269
  473679
  473784
  474994
  475599
  477949
  478588
  480969
  483593
  484105
  485332
  485870
  486661
  487656
  488816
  491722
  492926
  493082
  493439
  495324
  495808
  496956
  498949
  505161
  509576
  513430
  513941
  515627
  515651
  520337
  520382
  520670
  521656
  524204
  524905
  526147
  526609
  527298
  529240
  531799
  534333
  544087
  546372
  552498
  555186
  557559
  560002
  561563
  561937
  562055
  563820
  565115
  565561
  567216
  569241
  571351
  571971
  574043
  577243
  577897
  579821
  586926
  592873
  593136
  594414
  594979
  595043
  600799
  602402
  602632
  602724
  602849
  606268
  606297
  612404
  612469
  619362
  662796
  680550
  713080
  714258
  732915
  752454
  765040
  766182
  784922
  787332
  791981
  810138
  810916
]
17.45 ms
(9.82%)
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
  452666
  468278
  475599
  461693
  455873
  473784
  420440
  467979
  469727
  459342
  485870
  513941
  498949
  520382
  524905
  534333
  810916
  752454
  454428
  452367
  418353
  515651
  483593
  713080
  714258
  467920
  592873
  491722
  396286
  437407
  443396
  421294
  435114
  418627
  451338
  477949
  447902
  520670
  524204
  531799
  527298
  474994
  544087
  555186
  569241
  571351
  579821
  577243
  680550
  562055
  563820
  567216
  586926
  602724
  602849
  612404
  602632
  612469
  606297
  784922
  791981
  766182
  765040
  619362
  810138
  480969
  473679
  473269
  478588
  526609
  529240
  488816
  495808
  496956
  484105
  485332
  521656
  526147
  486661
  487656
  509576
  513430
  495324
  505161
  437663
  594414
  421236
  552498
  434259
  454617
  520337
  515627
  787332
  493439
  561937
  594979
  593136
  602402
  662796
  557559
  415095
  574043
  493082
  595043
  606268
  600799
  732915
  453501
  492926
  386751
  565561
  417268
  440650
  456778
  546372
  577897
  560002
  561563
  565115
  571971
]
2.76 ms
(1.55%)
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
  386751
  396286
  415095
  417268
  418353
  418627
  420440
  421236
  421294
  434259
  435114
  437407
  437663
  440650
  443396
  447902
  451338
  452367
  452666
  453501
  454428
  454617
  455873
  456778
  459342
  461693
  467920
  467979
  468278
  469727
  473269
  473679
  473784
  474994
  475599
  477949
  478588
  480969
  483593
  484105
  485332
  485870
  486661
  487656
  488816
  491722
  492926
  493082
  493439
  495324
  495808
  496956
  498949
  505161
  509576
  513430
  513941
  515627
  515651
  520337
  520382
  520670
  521656
  524204
  524905
  526147
  526609
  527298
  529240
  531799
  534333
  544087
  546372
  552498
  555186
  557559
  560002
  561563
  561937
  562055
  563820
  565115
  565561
  567216
  569241
  571351
  571971
  574043
  577243
  577897
  579821
  586926
  592873
  593136
  594414
  594979
  595043
  600799
  602402
  602632
  602724
  602849
  606268
  606297
  612404
  612469
  619362
  662796
  680550
  713080
  714258
  732915
  752454
  765040
  766182
  784922
  787332
  791981
  810138
  810916
]
1.80 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade shower pov"
]
1.45 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск shower пов"
]
1.26 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск shower пов"
]

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.