GET https://search.jues.net/search/embeds/9?q=close%20up%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.64 ms
(53.69%)
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
  392751
  529418
  530205
  551002
  553244
  600235
  602756
  614866
  619013
  624649
  629168
  647108
  662089
  692076
  704583
  709698
  714535
  714989
  719233
  719972
  720324
  720864
  724567
  726959
  727184
  727979
  730222
  731399
  732200
  732875
  734210
  734722
  735963
  736228
  740280
  740974
  742820
  744623
  744678
  746945
  747549
  747798
  748134
  748430
  749307
  752034
  761259
  761301
  761328
  761433
  762522
  763144
  763165
  763186
  763603
  764622
  764749
  764788
  765964
  766046
  766064
  766069
  766870
  767345
  767435
  767781
  767807
  768263
  768653
  768809
  769931
  771684
  772805
  772823
  773237
  777797
  778454
  778775
  779735
  781338
  781431
  781441
  781538
  782608
  783061
  784086
  784195
  785265
  785959
  786251
  787225
  787409
  788651
  788658
  789125
  790131
  790588
  791767
  792972
  793759
  795327
  795795
  796279
  796303
  797862
  798694
  798717
  801347
  803736
  803748
  803890
  804844
  805384
  806313
  809742
  810338
]
160.63 ms
(41.53%)
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
  392751
  529418
  530205
  551002
  553244
  600235
  602756
  614866
  619013
  624649
  629168
  647108
  662089
  692076
  704583
  709698
  714535
  714989
  719233
  719972
  720324
  720864
  724567
  726959
  727184
  727979
  730222
  731399
  732200
  732875
  734210
  734722
  735963
  736228
  740280
  740974
  742820
  744623
  744678
  746945
  747549
  747798
  748134
  748430
  749307
  752034
  761259
  761301
  761328
  761433
  762522
  763144
  763165
  763186
  763603
  764622
  764749
  764788
  765964
  766046
  766064
  766069
  766870
  767345
  767435
  767781
  767807
  768263
  768653
  768809
  769931
  771684
  772805
  772823
  773237
  777797
  778454
  778775
  779735
  781338
  781431
  781441
  781538
  782608
  783061
  784086
  784195
  785265
  785959
  786251
  787225
  787409
  788651
  788658
  789125
  790131
  790588
  791767
  792972
  793759
  795327
  795795
  796279
  796303
  797862
  798694
  798717
  801347
  803736
  803748
  803890
  804844
  805384
  806313
  809742
  810338
]
11.84 ms
(3.06%)
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
  747549
  748134
  764788
  767345
  767576
  768263
  773237
  781338
  781431
  781538
  784086
  784195
  785265
  785959
  787225
  787409
  788658
  789125
  790131
  790588
  791767
  795327
  798717
  801347
  803736
  805384
  809742
  731399
  732875
  742820
  761259
  761301
  761328
  763165
  763603
  764749
  765964
  766064
  768809
  768810
  724567
  727979
  734210
  744623
  764269
  769681
  771684
  748430
  752034
  762522
  763144
  763186
  766870
  767435
  767781
  768653
  769931
  735963
  740974
  744678
  761433
  764622
  766046
  766069
  767807
  772805
  772823
  602756
  629168
  704583
  720324
  777797
  778454
  778775
  779735
  782608
  783061
  786251
  792972
  793759
  796279
  796303
  797862
  798694
  803748
  803890
  804844
  806313
  810338
  719972
  720864
  781441
  709698
  553244
  662089
  719233
  647108
  692076
  600235
  619013
  795795
  730222
  734722
  749307
  740280
  726959
  732200
  624649
  392751
  529418
  530205
  551002
  714989
  614866
  736228
  788651
  727184
  747798
  746945
  714535
]
1.91 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "close up dick"
]
1.50 ms
(0.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "close up член"
]
1.31 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "close up член"
]

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.