GET https://search.jues.net/search/embeds/6?q=red%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
267.00 ms
(29.05%)
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
  742022
  744151
  765678
  736361
  740836
  748366
  761670
  764189
  769532
  722820
  722834
  722852
  775681
  779589
  780547
  782584
  787457
  797053
  799872
  800878
  802655
  804502
  810666
  811047
  462260
  402404
  433697
  461963
  229566
  408694
  383747
  426156
  442999
  436510
  507550
  508938
  557707
  562423
  587070
  743610
  614942
  784307
  401749
  471398
  518323
  518909
  525377
  490513
  562001
  118164
  394738
  264454
  389142
  396958
  403074
  401522
  818484
  824090
  813548
  814922
  817039
  817086
  824735
  814776
  818661
  823533
  825884
  827648
  826030
  477976
  467909
  476422
  494662
  539086
  533550
  468947
  544575
  572331
  646023
  667021
  676491
  683308
  699599
  704072
  710460
  718344
  719923
  660711
  678807
  696071
  696231
  714756
  721438
  661007
  665600
  667015
  668614
  674216
  684594
  689595
  697252
  581760
  614484
  625246
  635250
  603817
  620880
  597044
  600063
  608352
  610374
  621413
  642271
  609551
  641879
  643362
  776265
  784571
  784661
  788225
]
219.61 ms
(23.90%)
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
  118164
  229566
  264454
  383747
  389142
  394738
  396958
  401522
  401749
  402404
  403074
  408694
  426156
  433697
  436510
  442999
  461963
  462260
  467909
  468947
  471398
  476422
  477976
  490513
  494662
  507550
  508938
  518323
  518909
  525377
  533550
  539086
  544575
  557707
  562001
  562423
  572331
  581760
  587070
  597044
  600063
  603817
  608352
  609551
  610374
  614484
  614942
  620880
  621413
  625246
  635250
  641879
  642271
  643362
  646023
  660711
  661007
  665600
  667015
  667021
  668614
  674216
  676491
  678807
  683308
  684594
  689595
  696071
  696231
  697252
  699599
  704072
  710460
  714756
  718344
  719923
  721438
  722820
  722834
  722852
  736361
  740836
  742022
  743610
  744151
  748366
  761670
  764189
  765678
  769532
  775681
  776265
  779589
  780547
  782584
  784307
  784571
  784661
  787457
  788225
  797053
  799872
  800878
  802655
  804502
  810666
  811047
  813548
  814776
  814922
  817039
  817086
  818484
  818661
  823533
  824090
  824735
  825884
  826030
  827648
]
215.62 ms
(23.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red pussy"
]
210.44 ms
(22.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red pussy"
]
2.61 ms
(0.28%)
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
  118164
  229566
  264454
  383747
  389142
  394738
  396958
  401522
  401749
  402404
  403074
  408694
  426156
  433697
  436510
  442999
  461963
  462260
  467909
  468947
  471398
  476422
  477976
  490513
  494662
  507550
  508938
  518323
  518909
  525377
  533550
  539086
  544575
  557707
  562001
  562423
  572331
  581760
  587070
  597044
  600063
  603817
  608352
  609551
  610374
  614484
  614942
  620880
  621413
  625246
  635250
  641879
  642271
  643362
  646023
  660711
  661007
  665600
  667015
  667021
  668614
  674216
  676491
  678807
  683308
  684594
  689595
  696071
  696231
  697252
  699599
  704072
  710460
  714756
  718344
  719923
  721438
  722820
  722834
  722852
  736361
  740836
  742022
  743610
  744151
  748366
  761670
  764189
  765678
  769532
  775681
  776265
  779589
  780547
  782584
  784307
  784571
  784661
  787457
  788225
  797053
  799872
  800878
  802655
  804502
  810666
  811047
  813548
  814776
  814922
  817039
  817086
  818484
  818661
  823533
  824090
  824735
  825884
  826030
  827648
]
2.14 ms
(0.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red pussy"
]
1.60 ms
(0.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.