GET https://search.jues.net/search/embeds/9?q=anal%20anal%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.28 ms
(81.68%)
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
  12983
  150820
  193462
  592428
  593342
  604337
  607568
  610473
  619900
  620144
  624419
  630212
  630403
  630711
  630828
  634415
  707551
  708813
  712786
  713153
  717911
  718119
  719916
  725237
  726926
  727259
  727565
  727573
  728354
  728778
  729247
  729814
  729917
  730084
  734319
  734329
  734469
  734965
  735448
  737148
  737195
  738602
  740450
  740632
  742626
  742723
  743029
  746705
  747505
  748830
  750169
  752621
  752638
  755601
  756782
  757000
  758304
  758701
  759571
  760841
  761011
  761072
  761579
  764180
  765341
  765434
  766692
  767095
  767599
  768195
  768870
  769782
  771361
  771477
  773391
  773407
  775102
  775701
  777031
  778530
  782043
  784305
  788629
  788981
  790840
  790939
  791364
  794169
  794351
  794363
  795141
  795310
  796285
  796314
  796491
  797109
  798814
  800388
  800455
  800594
  800616
  800800
  802051
  802147
  802514
  804705
  805099
  805315
  805784
  807586
  808053
  808341
  810354
  810424
  811474
  811555
  811989
  812017
]
16.68 ms
(11.52%)
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
  634415
  592428
  593342
  610473
  620144
  630828
  619900
  630212
  630403
  630711
  604337
  624419
  777031
  778530
  782043
  800455
  800800
  805315
  775102
  775701
  790939
  795141
  795310
  796285
  804705
  808053
  808341
  729917
  730084
  737195
  743029
  746705
  752638
  755601
  757000
  757075
  759571
  761011
  761579
  765341
  767599
  771477
  790840
  794169
  794363
  796314
  796491
  797109
  800616
  802051
  802147
  805099
  805784
  807586
  811989
  727573
  728354
  734319
  734469
  740450
  747505
  766692
  771361
  725237
  726926
  727259
  729814
  734965
  735448
  737148
  740632
  748830
  750169
  758701
  760841
  768195
  773407
  729247
  734329
  742723
  756782
  758304
  765549
  767095
  768870
  773391
  727565
  728778
  738602
  742626
  752621
  761072
  764180
  765434
  769782
  607568
  707551
  708813
  712786
  713153
  717911
  718119
  719916
  784305
  788629
  788981
  791364
  794351
  798814
  800388
  800594
  802514
  810354
  810424
  811474
  811555
  812017
  12983
  150820
  193462
]
2.68 ms
(1.85%)
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
  12983
  150820
  193462
  592428
  593342
  604337
  607568
  610473
  619900
  620144
  624419
  630212
  630403
  630711
  630828
  634415
  707551
  708813
  712786
  713153
  717911
  718119
  719916
  725237
  726926
  727259
  727565
  727573
  728354
  728778
  729247
  729814
  729917
  730084
  734319
  734329
  734469
  734965
  735448
  737148
  737195
  738602
  740450
  740632
  742626
  742723
  743029
  746705
  747505
  748830
  750169
  752621
  752638
  755601
  756782
  757000
  758304
  758701
  759571
  760841
  761011
  761072
  761579
  764180
  765341
  765434
  766692
  767095
  767599
  768195
  768870
  769782
  771361
  771477
  773391
  773407
  775102
  775701
  777031
  778530
  782043
  784305
  788629
  788981
  790840
  790939
  791364
  794169
  794351
  794363
  795141
  795310
  796285
  796314
  796491
  797109
  798814
  800388
  800455
  800594
  800616
  800800
  802051
  802147
  802514
  804705
  805099
  805315
  805784
  807586
  808053
  808341
  810354
  810424
  811474
  811555
  811989
  812017
]
1.92 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал анал анал"
]
1.84 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал анал анал"
]
1.79 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal anal anal"
]
1.62 ms
(1.12%)
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.