GET https://search.jues.net/search/embeds/5?q=wife%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.58 ms
(89.14%)
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
  62251
  247538
  389760
  394218
  421420
  424048
  424145
  424165
  433379
  437403
  439362
  440526
  441206
  441295
  441910
  444991
  447721
  448172
  448752
  450955
  457005
  457872
  459470
  460284
  465481
  468157
  468159
  480314
  488923
  495376
  502201
  504460
  507254
  509610
  509872
  513507
  514865
  515992
  517265
  523927
  526682
  530635
  534655
  536814
  541265
  542433
  542756
  547643
  552299
  552373
  552569
  552863
  553225
  553746
  558245
  568707
  574050
  575714
  577105
  577664
  581998
  586199
  586279
  588267
  588458
  593195
  593734
  594152
  596968
  600936
  603008
  607118
  610122
  613152
  613162
  614088
  618401
  618533
  619713
  620089
  626477
  633216
  641547
  644206
  648112
  663547
  693635
  693939
  707518
  709024
  714944
  728605
  731194
  733415
  736174
  737438
  739699
  742356
  750072
  750831
  757826
  759132
  763081
  766892
  776186
  776610
  782940
  790843
  791033
  799720
  804235
  804265
  804449
  808017
  811366
  812751
  823775
  824427
  825092
]
16.60 ms
(6.80%)
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
  791033
  804235
  424048
  247538
  421420
  433379
  468159
  440526
  448752
  480314
  488923
  502201
  389760
  509610
  575714
  610122
  619713
  633216
  823775
  62251
  441295
  824427
  825092
  459470
  450955
  468157
  460284
  530635
  526682
  507254
  517265
  504460
  514865
  523927
  534655
  536814
  542433
  552863
  558245
  574050
  577664
  542756
  547643
  552299
  568707
  577105
  541265
  552373
  552569
  553225
  648112
  693635
  693939
  707518
  709024
  553746
  581998
  593734
  641547
  644206
  588458
  613152
  613162
  614088
  618401
  620089
  586279
  596968
  600936
  586199
  588267
  593195
  594152
  603008
  607118
  618533
  776610
  811366
  728605
  737438
  759132
  782940
  804449
  808017
  812751
  736174
  757826
  733415
  750072
  766892
  742356
  763081
  731194
  739699
  750831
  626477
  714944
  776186
  790843
  804265
  3793
  437403
  457005
  424165
  439362
  457872
  441206
  465481
  509872
  495376
  513507
  515992
  447721
  444991
  441910
  663547
  424145
  448172
  394218
  799720
]
3.14 ms
(1.29%)
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
  62251
  247538
  389760
  394218
  421420
  424048
  424145
  424165
  433379
  437403
  439362
  440526
  441206
  441295
  441910
  444991
  447721
  448172
  448752
  450955
  457005
  457872
  459470
  460284
  465481
  468157
  468159
  480314
  488923
  495376
  502201
  504460
  507254
  509610
  509872
  513507
  514865
  515992
  517265
  523927
  526682
  530635
  534655
  536814
  541265
  542433
  542756
  547643
  552299
  552373
  552569
  552863
  553225
  553746
  558245
  568707
  574050
  575714
  577105
  577664
  581998
  586199
  586279
  588267
  588458
  593195
  593734
  594152
  596968
  600936
  603008
  607118
  610122
  613152
  613162
  614088
  618401
  618533
  619713
  620089
  626477
  633216
  641547
  644206
  648112
  663547
  693635
  693939
  707518
  709024
  714944
  728605
  731194
  733415
  736174
  737438
  739699
  742356
  750072
  750831
  757826
  759132
  763081
  766892
  776186
  776610
  782940
  790843
  791033
  799720
  804235
  804265
  804449
  808017
  811366
  812751
  823775
  824427
  825092
]
1.80 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife shower"
]
1.80 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен shower"
]
1.62 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.64%)
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.