GET https://search.jues.net/search/embeds/3?q=amateur%20hardcore

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.36 ms
(85.01%)
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
  42536
  92281
  101353
  229024
  382781
  384293
  385021
  385204
  386063
  387473
  390678
  391759
  392751
  393872
  398416
  400534
  497813
  513570
  517658
  526492
  529791
  530587
  531824
  536101
  537966
  538063
  540924
  550807
  550890
  550943
  560546
  562575
  574090
  576552
  580062
  584048
  586409
  590275
  601821
  605173
  612913
  613796
  618242
  618297
  623681
  624484
  627512
  629725
  630419
  631461
  634317
  634734
  634735
  638999
  639347
  639381
  643181
  643187
  643200
  643235
  645673
  650770
  653602
  661036
  679173
  704990
  705028
  706038
  707376
  708069
  709360
  709559
  710194
  715434
  722389
  749023
  752541
  752638
  761265
  763292
  785075
  788598
  789479
  792079
  792272
  792753
  793430
  793456
  794322
  795052
  796768
  796837
  796859
  797284
  797285
  800279
  800317
  801478
  801797
  802347
  803483
  803542
  803576
  806864
  806976
  813114
  814261
  814315
  817124
  819861
  825220
  825848
  827853
  827872
  827874
  827877
  827892
  827899
  827969
]
11.03 ms
(8.13%)
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
  590275
  613796
  639347
  597175
  612913
  643235
  550943
  618242
  627512
  706038
  715434
  386063
  384293
  393872
  392751
  391759
  92281
  42536
  825848
  814261
  817124
  819861
  825220
  536101
  538063
  513570
  540924
  574090
  550807
  550890
  576552
  580062
  584048
  618297
  634734
  586409
  794322
  796768
  797284
  792079
  797285
  800279
  802347
  803576
  752541
  792272
  803542
  382781
  390678
  709559
  385021
  385204
  497813
  803483
  814315
  788598
  793456
  763292
  229024
  623681
  624484
  526492
  709360
  400534
  537966
  827969
  638999
  796859
  792753
  806864
  827877
  827872
  827874
  827853
  827899
  827892
  529791
  653602
  645673
  679173
  634317
  634735
  639381
  643187
  643200
  708069
  517658
  530587
  562575
  629725
  630419
  101353
  796837
  643181
  707376
  387473
  398416
  531824
  560546
  704990
  705028
  650770
  661036
  710194
  722389
  601821
  605173
  631461
  801797
  806976
  789479
  800317
  813114
  749023
  752638
  761265
  785075
  793430
  795052
  801478
]
2.78 ms
(2.05%)
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
  42536
  92281
  101353
  229024
  382781
  384293
  385021
  385204
  386063
  387473
  390678
  391759
  392751
  393872
  398416
  400534
  497813
  513570
  517658
  526492
  529791
  530587
  531824
  536101
  537966
  538063
  540924
  550807
  550890
  550943
  560546
  562575
  574090
  576552
  580062
  584048
  586409
  590275
  601821
  605173
  612913
  613796
  618242
  618297
  623681
  624484
  627512
  629725
  630419
  631461
  634317
  634734
  634735
  638999
  639347
  639381
  643181
  643187
  643200
  643235
  645673
  650770
  653602
  661036
  679173
  704990
  705028
  706038
  707376
  708069
  709360
  709559
  710194
  715434
  722389
  749023
  752541
  752638
  761265
  763292
  785075
  788598
  789479
  792079
  792272
  792753
  793430
  793456
  794322
  795052
  796768
  796837
  796859
  797284
  797285
  800279
  800317
  801478
  801797
  802347
  803483
  803542
  803576
  806864
  806976
  813114
  814261
  814315
  817124
  819861
  825220
  825848
  827853
  827872
  827874
  827877
  827892
  827899
  827969
]
1.88 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hardcore"
]
1.71 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск хардкор"
]
1.41 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.