GET https://search.jues.net/search/embeds/6?q=sex%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.27 ms
(88.75%)
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
  3793
  247750
  382031
  382542
  383888
  388591
  389848
  407716
  419432
  420275
  420495
  424165
  425529
  432884
  435737
  439362
  440526
  441295
  443706
  450920
  450955
  454794
  457872
  457947
  458720
  459904
  460284
  460346
  461325
  471182
  473719
  478023
  478558
  478814
  479189
  489377
  496928
  502678
  502689
  502762
  504352
  504460
  506870
  509124
  509797
  513906
  515992
  517265
  522305
  523248
  525062
  530635
  531977
  538991
  552830
  554243
  558245
  559456
  567782
  570873
  577105
  581889
  581998
  584226
  586199
  586279
  593168
  593734
  593856
  603040
  613152
  618401
  618533
  621200
  626618
  628648
  631970
  635227
  650134
  663404
  669200
  671682
  674231
  683798
  690666
  693635
  696123
  701608
  701626
  707518
  714944
  716762
  723917
  727064
  728605
  730327
  731194
  732567
  736174
  736554
  737438
  739699
  740545
  754017
  757826
  758365
  760400
  769148
  776186
  780620
  787368
  790843
  793621
  796349
  804235
  808286
  809631
  811366
  812825
  824427
]
16.36 ms
(6.84%)
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
  621200
  628648
  740545
  780620
  804235
  440526
  383888
  382031
  389848
  824427
  478023
  530635
  517265
  509124
  558245
  559456
  554243
  701626
  650134
  707518
  631970
  586279
  811366
  796349
  728605
  737438
  760400
  787368
  812825
  754017
  739699
  776186
  3793
  443706
  407716
  458720
  424165
  471182
  247750
  419432
  461325
  457947
  502689
  674231
  683798
  690666
  671682
  696123
  793621
  808286
  730327
  736554
  769148
  382542
  581889
  496928
  635227
  593856
  593168
  388591
  478558
  478814
  432884
  435737
  441295
  450955
  460284
  538991
  506870
  504460
  459904
  552830
  577105
  567782
  570873
  669200
  693635
  663404
  701608
  581998
  584226
  593734
  613152
  618401
  626618
  603040
  586199
  618533
  758365
  809631
  732567
  736174
  757826
  723917
  727064
  731194
  714944
  716762
  790843
  450920
  425529
  439362
  457872
  473719
  420495
  522305
  489377
  502762
  513906
  515992
  502678
  509797
  420275
  479189
  454794
  504352
  460346
  525062
  531977
  523248
]
3.30 ms
(1.38%)
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
  3793
  247750
  382031
  382542
  383888
  388591
  389848
  407716
  419432
  420275
  420495
  424165
  425529
  432884
  435737
  439362
  440526
  441295
  443706
  450920
  450955
  454794
  457872
  457947
  458720
  459904
  460284
  460346
  461325
  471182
  473719
  478023
  478558
  478814
  479189
  489377
  496928
  502678
  502689
  502762
  504352
  504460
  506870
  509124
  509797
  513906
  515992
  517265
  522305
  523248
  525062
  530635
  531977
  538991
  552830
  554243
  558245
  559456
  567782
  570873
  577105
  581889
  581998
  584226
  586199
  586279
  593168
  593734
  593856
  603040
  613152
  618401
  618533
  621200
  626618
  628648
  631970
  635227
  650134
  663404
  669200
  671682
  674231
  683798
  690666
  693635
  696123
  701608
  701626
  707518
  714944
  716762
  723917
  727064
  728605
  730327
  731194
  732567
  736174
  736554
  737438
  739699
  740545
  754017
  757826
  758365
  760400
  769148
  776186
  780620
  787368
  790843
  793621
  796349
  804235
  808286
  809631
  811366
  812825
  824427
]
2.10 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex shower"
]
1.82 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс shower"
]
1.72 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.68%)
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.