GET https://search.jues.net/search/embeds/4?q=ass%20in%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.48 ms
(86.78%)
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
  33431
  61969
  62251
  191312
  247545
  386787
  392159
  398038
  407509
  421420
  425505
  429824
  440526
  441295
  443706
  445497
  445818
  447138
  450582
  452454
  454048
  454059
  458296
  460626
  465481
  465495
  465675
  466859
  468157
  468159
  473712
  481428
  482641
  483853
  492630
  494647
  495376
  496840
  502762
  507191
  507547
  509610
  513507
  517452
  533930
  538459
  541265
  544147
  550331
  552569
  552863
  553225
  555994
  556504
  565736
  567313
  568818
  578391
  579487
  580251
  580896
  581196
  587103
  587241
  588399
  596968
  600636
  604826
  612458
  613414
  628648
  628667
  644206
  649487
  658920
  662897
  663990
  665199
  667845
  672369
  689042
  693939
  709460
  716640
  718684
  721870
  725244
  735291
  739441
  740262
  740545
  742356
  742409
  745946
  750387
  751067
  751795
  759129
  759146
  765343
  765794
  768884
  769148
  775669
  780620
  780772
  781704
  781928
  783745
  784102
  785803
  798385
  802488
  804436
  807028
  808018
  812763
  818353
  824272
  824370
]
15.95 ms
(8.42%)
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
  750387
  759129
  808018
  725244
  751795
  739441
  742409
  745946
  765343
  769148
  721870
  780772
  784102
  407509
  191312
  450582
  481428
  507547
  62251
  61969
  441295
  465495
  483853
  468157
  473712
  494647
  552863
  541265
  552569
  553225
  568818
  693939
  644206
  596968
  742356
  443706
  465481
  495376
  513507
  502762
  580896
  718684
  587241
  735291
  740262
  398038
  555994
  579487
  600636
  612458
  812763
  447138
  445818
  386787
  33431
  429824
  818353
  824272
  824370
  454048
  458296
  465675
  492630
  496840
  533930
  507191
  538459
  466859
  567313
  578391
  556504
  658920
  665199
  667845
  672369
  689042
  649487
  663990
  709460
  565736
  581196
  587103
  604826
  613414
  588399
  628667
  628648
  781704
  785803
  802488
  804436
  740545
  751067
  759146
  768884
  765794
  775669
  780620
  781928
  783745
  392159
  425505
  421420
  468159
  247545
  440526
  452454
  550331
  445497
  544147
  716640
  798385
  807028
  580251
  662897
  482641
  454059
  460626
  517452
  509610
]
2.60 ms
(1.37%)
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
  33431
  61969
  62251
  191312
  247545
  386787
  392159
  398038
  407509
  421420
  425505
  429824
  440526
  441295
  443706
  445497
  445818
  447138
  450582
  452454
  454048
  454059
  458296
  460626
  465481
  465495
  465675
  466859
  468157
  468159
  473712
  481428
  482641
  483853
  492630
  494647
  495376
  496840
  502762
  507191
  507547
  509610
  513507
  517452
  533930
  538459
  541265
  544147
  550331
  552569
  552863
  553225
  555994
  556504
  565736
  567313
  568818
  578391
  579487
  580251
  580896
  581196
  587103
  587241
  588399
  596968
  600636
  604826
  612458
  613414
  628648
  628667
  644206
  649487
  658920
  662897
  663990
  665199
  667845
  672369
  689042
  693939
  709460
  716640
  718684
  721870
  725244
  735291
  739441
  740262
  740545
  742356
  742409
  745946
  750387
  751067
  751795
  759129
  759146
  765343
  765794
  768884
  769148
  775669
  780620
  780772
  781704
  781928
  783745
  784102
  785803
  798385
  802488
  804436
  807028
  808018
  812763
  818353
  824272
  824370
]
1.68 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп shower"
]
1.64 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп shower"
]
1.60 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass in shower"
]
1.60 ms
(0.84%)
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.