GET https://search.jues.net/search/embeds/5?q=dildo%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.02 ms
(81.73%)
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
  182036
  386732
  413008
  429892
  432683
  434361
  434903
  435136
  435529
  439340
  443432
  446251
  447337
  448854
  467588
  467875
  468148
  468616
  475420
  477496
  477516
  485472
  494530
  508917
  508924
  510729
  511053
  513220
  513522
  518505
  531879
  534443
  551589
  562578
  563154
  567245
  578731
  588169
  589166
  591527
  596440
  601460
  602281
  607683
  607706
  613690
  617577
  619570
  621391
  624688
  626082
  634750
  640242
  647383
  653028
  659057
  662151
  666974
  674625
  676416
  679929
  680754
  687369
  696584
  697543
  700042
  700690
  700906
  704072
  709937
  710233
  713186
  715802
  716001
  718987
  722390
  726066
  730461
  730781
  738461
  738501
  739126
  739140
  739146
  739802
  739821
  740503
  751044
  753120
  753190
  760598
  767267
  772230
  772654
  774883
  777761
  778864
  779718
  782052
  785816
  785967
  785979
  788528
  791600
  796872
  797773
  798243
  798291
  801627
  802650
  808446
  811690
  811723
  820162
  823353
  824630
  827287
  827393
]
16.33 ms
(11.31%)
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
  435529
  477516
  508924
  510729
  494530
  518505
  448854
  607706
  468616
  563154
  596440
  824630
  827393
  823353
  826398
  508917
  386732
  439340
  827287
  820162
  531879
  534443
  551589
  567245
  653028
  679929
  709937
  718987
  647383
  662151
  674625
  676416
  687369
  700906
  710233
  700690
  722390
  624688
  607683
  634750
  588169
  617577
  619570
  621391
  774883
  785816
  786867
  801627
  808446
  738501
  753190
  760598
  797773
  811723
  726066
  739146
  751044
  772654
  730781
  739126
  739140
  740503
  753120
  738461
  739821
  767267
  772230
  739802
  602281
  777761
  778864
  782052
  785979
  791600
  796872
  802650
  182036
  511053
  477496
  434361
  447337
  435136
  443432
  468148
  475420
  513220
  485472
  589166
  798243
  811690
  730461
  626082
  798291
  446251
  467588
  467875
  429892
  513522
  715802
  713186
  432683
  434903
  413008
  562578
  659057
  666974
  704072
  696584
  716001
  680754
  697543
  700042
  578731
  640242
  591527
  601460
  613690
  779718
  785967
  788528
]
2.54 ms
(1.76%)
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
  182036
  386732
  413008
  429892
  432683
  434361
  434903
  435136
  435529
  439340
  443432
  446251
  447337
  448854
  467588
  467875
  468148
  468616
  475420
  477496
  477516
  485472
  494530
  508917
  508924
  510729
  511053
  513220
  513522
  518505
  531879
  534443
  551589
  562578
  563154
  567245
  578731
  588169
  589166
  591527
  596440
  601460
  602281
  607683
  607706
  613690
  617577
  619570
  621391
  624688
  626082
  634750
  640242
  647383
  653028
  659057
  662151
  666974
  674625
  676416
  679929
  680754
  687369
  696584
  697543
  700042
  700690
  700906
  704072
  709937
  710233
  713186
  715802
  716001
  718987
  722390
  726066
  730461
  730781
  738461
  738501
  739126
  739140
  739146
  739802
  739821
  740503
  751044
  753120
  753190
  760598
  767267
  772230
  772654
  774883
  777761
  778864
  779718
  782052
  785816
  785967
  785979
  788528
  791600
  796872
  797773
  798243
  798291
  801627
  802650
  808446
  811690
  811723
  820162
  823353
  824630
  827287
  827393
]
1.98 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo pussy"
]
1.87 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд pussy"
]
1.76 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд pussy"
]

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.