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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.43 ms
(85.62%)
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
  65811
  154707
  397685
  398198
  414103
  419167
  419435
  419461
  423508
  436054
  440659
  445651
  446994
  448351
  457650
  463435
  468236
  477052
  485471
  487281
  502789
  507270
  519379
  534426
  535290
  537138
  537766
  541265
  542124
  544829
  545550
  548153
  551646
  554405
  556183
  557709
  559783
  560026
  573293
  576888
  583093
  585818
  586100
  586995
  589526
  594053
  597663
  602241
  608550
  618259
  618799
  620957
  621382
  622427
  635129
  638744
  640306
  641807
  650150
  654978
  660419
  666856
  669046
  670956
  671531
  680578
  684487
  686338
  688367
  689010
  697108
  705378
  706894
  707432
  709674
  714294
  735535
  739084
  739804
  740858
  744028
  744963
  745066
  745927
  752614
  756779
  758318
  765712
  766415
  769029
  772272
  776011
  777760
  777838
  778779
  780151
  780185
  780339
  781373
  782104
  784035
  784199
  787815
  789234
  790412
  791871
  796332
  796685
  796992
  796996
  803367
  806819
  807122
  807590
  809686
  810752
  812399
  824256
  824573
  826237
]
12.11 ms
(8.20%)
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
  419435
  446994
  440659
  65811
  824256
  824573
  744028
  398198
  414103
  419167
  436054
  445651
  457650
  485471
  448351
  537766
  548153
  709674
  660419
  641807
  608550
  638744
  807590
  766415
  765712
  707432
  826237
  535290
  534426
  560026
  576888
  650150
  686338
  714294
  671531
  680578
  684487
  688367
  654978
  706894
  589526
  597663
  620957
  621382
  640306
  586100
  618259
  777760
  780339
  787815
  803367
  807122
  810752
  812399
  777838
  780151
  796332
  796685
  796992
  796996
  740858
  772272
  789234
  809686
  745066
  735535
  739084
  739804
  744963
  745927
  756779
  758318
  769029
  622427
  635129
  697108
  705378
  776011
  778779
  780185
  781373
  782104
  784035
  784199
  790412
  791871
  806819
  397685
  507270
  689010
  154707
  419461
  423508
  477052
  487281
  468236
  502789
  519379
  537138
  542124
  544829
  554405
  545550
  556183
  573293
  541265
  551646
  559783
  669046
  666856
  670956
  557709
  583093
  602241
  594053
  585818
  618799
  586995
  752614
  463435
]
2.80 ms
(1.90%)
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
  65811
  154707
  397685
  398198
  414103
  419167
  419435
  419461
  423508
  436054
  440659
  445651
  446994
  448351
  457650
  463435
  468236
  477052
  485471
  487281
  502789
  507270
  519379
  534426
  535290
  537138
  537766
  541265
  542124
  544829
  545550
  548153
  551646
  554405
  556183
  557709
  559783
  560026
  573293
  576888
  583093
  585818
  586100
  586995
  589526
  594053
  597663
  602241
  608550
  618259
  618799
  620957
  621382
  622427
  635129
  638744
  640306
  641807
  650150
  654978
  660419
  666856
  669046
  670956
  671531
  680578
  684487
  686338
  688367
  689010
  697108
  705378
  706894
  707432
  709674
  714294
  735535
  739084
  739804
  740858
  744028
  744963
  745066
  745927
  752614
  756779
  758318
  765712
  766415
  769029
  772272
  776011
  777760
  777838
  778779
  780151
  780185
  780339
  781373
  782104
  784035
  784199
  787815
  789234
  790412
  791871
  796332
  796685
  796992
  796996
  803367
  806819
  807122
  807590
  809686
  810752
  812399
  824256
  824573
  826237
]
1.94 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд pussy"
]
1.65 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo pussy"
]
1.40 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд pussy"
]
1.34 ms
(0.91%)
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.