GET https://search.jues.net/search/embeds/6?q=extreme%20slave

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.16 ms
(49.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
186.97 ms
(44.72%)
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
  390322
  409506
  414381
  419116
  420203
  420267
  420406
  423563
  423657
  425118
  425910
  426368
  432243
  436358
  443103
  443383
  448377
  448873
  459703
  461056
  463762
  463780
  467888
  469023
  471935
  475984
  478048
  478090
  478511
  491762
  492762
  496086
  503406
  511067
  511251
  511489
  512224
  512871
  515371
  515969
  516765
  517847
  518917
  519317
  520961
  522130
  522157
  522205
  523266
  523868
  524501
  526891
  527116
  527916
  529855
  530005
  530010
  530053
  530269
  530487
  530771
  530805
  530808
  531261
  531419
  532792
  532948
  533367
  533368
  533538
  533557
  534797
  535023
  535584
  536262
  536340
  536684
  537241
  537247
  537885
  542975
  551049
  559176
  560286
  566563
  580290
  583702
  592557
  593818
  593843
  595602
  605437
  618088
  623832
  634185
  637036
  638052
  648524
  648589
  648861
  653672
  664459
  674943
  683262
  689529
  713320
  718232
  720635
  733160
  736336
  742836
  764485
  778096
  782544
  784246
  792590
  793113
  796020
  796749
  796773
]
16.70 ms
(3.99%)
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
  653672
  595602
  618088
  784246
  782544
  736336
  527116
  523266
  478048
  566563
  648589
  664459
  551049
  560286
  605437
  471935
  674943
  436358
  432243
  423657
  414381
  463762
  448873
  530010
  533538
  536340
  536684
  537241
  537885
  512224
  522130
  532792
  533368
  518917
  530005
  531261
  532948
  533367
  496086
  511489
  522205
  524501
  530771
  542975
  648861
  634185
  390322
  409506
  448377
  419116
  425910
  443383
  459703
  425118
  467888
  475984
  511251
  515371
  491762
  515969
  503406
  520961
  527916
  478511
  511067
  512871
  683262
  623832
  533557
  530808
  637036
  559176
  713320
  648524
  689529
  583702
  592557
  593843
  593818
  778096
  793113
  796020
  796749
  733160
  742836
  764485
  792590
  796773
  638052
  718232
  720635
  420267
  420203
  426368
  423563
  443103
  420406
  463780
  469023
  461056
  478090
  492762
  522157
  529855
  530269
  535023
  537247
  523868
  534797
  530053
  531419
  536262
  516765
  517847
  519317
  526891
  530487
  530805
  535584
  580290
]
2.49 ms
(0.60%)
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
  390322
  409506
  414381
  419116
  420203
  420267
  420406
  423563
  423657
  425118
  425910
  426368
  432243
  436358
  443103
  443383
  448377
  448873
  459703
  461056
  463762
  463780
  467888
  469023
  471935
  475984
  478048
  478090
  478511
  491762
  492762
  496086
  503406
  511067
  511251
  511489
  512224
  512871
  515371
  515969
  516765
  517847
  518917
  519317
  520961
  522130
  522157
  522205
  523266
  523868
  524501
  526891
  527116
  527916
  529855
  530005
  530010
  530053
  530269
  530487
  530771
  530805
  530808
  531261
  531419
  532792
  532948
  533367
  533368
  533538
  533557
  534797
  535023
  535584
  536262
  536340
  536684
  537241
  537247
  537885
  542975
  551049
  559176
  560286
  566563
  580290
  583702
  592557
  593818
  593843
  595602
  605437
  618088
  623832
  634185
  637036
  638052
  648524
  648589
  648861
  653672
  664459
  674943
  683262
  689529
  713320
  718232
  720635
  733160
  736336
  742836
  764485
  778096
  782544
  784246
  792590
  793113
  796020
  796749
  796773
]
2.34 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор доминирован"
]
1.80 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme slave"
]
1.68 ms
(0.40%)
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.