GET https://search.jues.net/search/embeds/4?q=amateur%20sucks

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.06 ms
(83.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
  397062
  466349
  500818
  530260
  532807
  534697
  539442
  543683
  547992
  561244
  567240
  578348
  578635
  588122
  588501
  609177
  613664
  613785
  616809
  616920
  620883
  623882
  626274
  630821
  642539
  651565
  652998
  653347
  662432
  667101
  667178
  673159
  681759
  687403
  690626
  693326
  697937
  699145
  705084
  707901
  711392
  711850
  717077
  717709
  721996
  726271
  726474
  730656
  731445
  736632
  739592
  740191
  743567
  745447
  747290
  750022
  751293
  752288
  752343
  752363
  753620
  754549
  754619
  758064
  759213
  763036
  763042
  763074
  764861
  766478
  767428
  769429
  769650
  772292
  777474
  778926
  779300
  780465
  780726
  781484
  781547
  783078
  783786
  784006
  784230
  786784
  787205
  787386
  788383
  788419
  788836
  790942
  792001
  795260
  795502
  797882
  798533
  799713
  800757
  801981
  803412
  803724
  804816
  804858
  806694
  807018
  807285
  809181
  811530
  813307
  819882
  823557
  823847
  824703
  826037
  826305
  826482
  826590
  826683
  826684
]
14.53 ms
(9.14%)
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
  543683
  711392
  717709
  784006
  786784
  788836
  795260
  809181
  781484
  781547
  792001
  798533
  803724
  811530
  752363
  758064
  767428
  799713
  801981
  803412
  747290
  764861
  736632
  763042
  739592
  751293
  753620
  759213
  769650
  730656
  731445
  750022
  609177
  721996
  778926
  784230
  788383
  788419
  795502
  800757
  804816
  807018
  813307
  397062
  500818
  539442
  578635
  578348
  662432
  699145
  707901
  651565
  653347
  667101
  681759
  693326
  652998
  667178
  673159
  687403
  690626
  697937
  711850
  567240
  616809
  613785
  616920
  626274
  642539
  588122
  613664
  763036
  769429
  620883
  466349
  534697
  530260
  780726
  797882
  826482
  826684
  826683
  826590
  826037
  823557
  824703
  823847
  826305
  819882
  532807
  547992
  561244
  705084
  717077
  623882
  588501
  630821
  777474
  780465
  790942
  804858
  779300
  787205
  806694
  745447
  752288
  763074
  766478
  772292
  783078
  783786
  787386
  807285
  740191
  752343
  754549
  754619
  726474
  743567
  726271
]
3.94 ms
(2.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск sucks"
]
2.59 ms
(1.63%)
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
  397062
  466349
  500818
  530260
  532807
  534697
  539442
  543683
  547992
  561244
  567240
  578348
  578635
  588122
  588501
  609177
  613664
  613785
  616809
  616920
  620883
  623882
  626274
  630821
  642539
  651565
  652998
  653347
  662432
  667101
  667178
  673159
  681759
  687403
  690626
  693326
  697937
  699145
  705084
  707901
  711392
  711850
  717077
  717709
  721996
  726271
  726474
  730656
  731445
  736632
  739592
  740191
  743567
  745447
  747290
  750022
  751293
  752288
  752343
  752363
  753620
  754549
  754619
  758064
  759213
  763036
  763042
  763074
  764861
  766478
  767428
  769429
  769650
  772292
  777474
  778926
  779300
  780465
  780726
  781484
  781547
  783078
  783786
  784006
  784230
  786784
  787205
  787386
  788383
  788419
  788836
  790942
  792001
  795260
  795502
  797882
  798533
  799713
  800757
  801981
  803412
  803724
  804816
  804858
  806694
  807018
  807285
  809181
  811530
  813307
  819882
  823557
  823847
  824703
  826037
  826305
  826482
  826590
  826683
  826684
]
1.97 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur sucks"
]
1.49 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск sucks"
]
1.43 ms
(0.90%)
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.