GET https://search.jues.net/search/embeds/7?q=public%20solo%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.60 ms
(51.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
  6669
  17190
  27757
  188699
  226028
  249788
  291356
  365933
  391133
  396657
  397425
  401189
  401281
  410264
  417080
  419447
  425474
  428860
  435078
  442631
  443986
  444234
  446626
  455745
  457585
  457701
  457736
  458925
  459666
  468705
  469236
  472972
  474270
  474487
  480402
  483814
  485501
  488719
  490859
  500098
  503117
  508177
  512880
  512948
  519243
  531929
  535053
  537943
  541532
  541568
  542223
  554192
  555428
  555601
  558903
  561306
  566687
  569225
  579746
  591861
  602251
  604327
  605218
  618923
  637471
  649105
  649838
  651876
  655601
  659408
  660051
  661287
  671429
  671743
  674001
  674452
  685513
  693353
  693532
  704915
  705710
  705731
  706250
  710890
  711631
  711905
  714473
  715102
  717900
  719142
  719314
  720386
  720732
  722019
  724023
  726922
  727780
  728713
  738630
  743165
  749109
  756002
  756081
  756091
  756192
  758028
  766668
  769091
  785418
  789672
  798737
  800304
  805640
  806243
  815991
  821134
  821892
  822155
  823351
  825536
]
173.84 ms
(43.05%)
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
  6669
  17190
  27757
  188699
  226028
  249788
  291356
  365933
  391133
  396657
  397425
  401189
  401281
  410264
  417080
  419447
  425474
  428860
  435078
  442631
  443986
  444234
  446626
  455745
  457585
  457701
  457736
  458925
  459666
  468705
  469236
  472972
  474270
  474487
  480402
  483814
  485501
  488719
  490859
  500098
  503117
  508177
  512880
  512948
  519243
  531929
  535053
  537943
  541532
  541568
  542223
  554192
  555428
  555601
  558903
  561306
  566687
  569225
  579746
  591861
  602251
  604327
  605218
  618923
  637471
  649105
  649838
  651876
  655601
  659408
  660051
  661287
  671429
  671743
  674001
  674452
  685513
  693353
  693532
  704915
  705710
  705731
  706250
  710890
  711631
  711905
  714473
  715102
  717900
  719142
  719314
  720386
  720732
  722019
  724023
  726922
  727780
  728713
  738630
  743165
  749109
  756002
  756081
  756091
  756192
  758028
  766668
  769091
  785418
  789672
  798737
  800304
  805640
  806243
  815991
  821134
  821892
  822155
  823351
  825536
]
13.49 ms
(3.34%)
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
  428860
  419447
  474270
  512948
  508177
  541568
  457585
  226028
  555601
  6669
  401281
  815991
  822155
  823351
  821892
  825536
  821134
  531929
  555428
  660051
  693353
  711631
  705731
  291356
  488719
  566687
  685513
  705710
  365933
  457701
  435078
  443986
  468705
  396657
  569225
  659408
  671743
  800304
  758028
  720732
  472972
  480402
  561306
  458925
  500098
  554192
  602251
  474487
  425474
  541532
  661287
  693532
  591861
  397425
  410264
  503117
  537943
  483814
  512880
  459666
  714473
  756192
  649838
  446626
  401189
  535053
  651876
  798737
  756091
  455745
  711905
  806243
  769091
  738630
  749109
  618923
  579746
  188699
  391133
  715102
  249788
  785418
  444234
  457736
  485501
  27757
  728713
  17190
  490859
  519243
  649105
  674452
  704915
  655601
  719142
  720386
  674001
  710890
  717900
  604327
  637471
  805640
  743165
  756002
  766668
  724023
  726922
  727780
  756081
  706250
  719314
  722019
  789672
  442631
  469236
  558903
  542223
  671429
  605218
  417080
]
2.20 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public solo anal"
]
1.78 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц соло анал"
]
1.45 ms
(0.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.