GET https://search.jues.net/search/embeds/4?q=fuck%20and%20hard

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.97 ms
(80.21%)
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
  325867
  416665
  422449
  424190
  424199
  424259
  424261
  438045
  439739
  440993
  444246
  445891
  452305
  456455
  458126
  463384
  474923
  475828
  480709
  486762
  493316
  499159
  513158
  513195
  513503
  516754
  516970
  517556
  519582
  520572
  523130
  524162
  526683
  528258
  529651
  533459
  533519
  535269
  544625
  549528
  551473
  551480
  558886
  562255
  571508
  579507
  581382
  585821
  585909
  590176
  591214
  598494
  599540
  611290
  613277
  623472
  624460
  630919
  635019
  636605
  640837
  645167
  648183
  651789
  661300
  663301
  666784
  667167
  674256
  695145
  696414
  705435
  712398
  715657
  716697
  719392
  722093
  722944
  723954
  734703
  735885
  736228
  736235
  737459
  737907
  738085
  743344
  743749
  748936
  750235
  751707
  753395
  762197
  763136
  763424
  763570
  763868
  767278
  768872
  773533
  781089
  782340
  786485
  787131
  789569
  790284
  793104
  793907
  794411
  795768
  797203
  807643
  810323
  813168
  819719
  824375
  826259
  827520
  827569
]
20.47 ms
(12.94%)
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
  535269
  661300
  611290
  519582
  695145
  640837
  787131
  424199
  452305
  422449
  529651
  439739
  513503
  445891
  571508
  524162
  591214
  513158
  516754
  623472
  493316
  786485
  549528
  723954
  824375
  807643
  826259
  551473
  722093
  562255
  480709
  517556
  666784
  523130
  533519
  516970
  424259
  438045
  558886
  424261
  528258
  551480
  630919
  651789
  768872
  499159
  520572
  750235
  810323
  544625
  782340
  763868
  763136
  474923
  599540
  456455
  486762
  424190
  736228
  738085
  819719
  579507
  719392
  789569
  751707
  743749
  781089
  585821
  513195
  463384
  325867
  715657
  743344
  827520
  667167
  767278
  763424
  598494
  712398
  722944
  705435
  645167
  663301
  696414
  635019
  762197
  737907
  737459
  797203
  526683
  793907
  794411
  748936
  475828
  716697
  440993
  533459
  763570
  458126
  416665
  827569
  674256
  590176
  648183
  585909
  624460
  790284
  734703
  735885
  795768
  826415
  636605
  793104
  444246
  736235
  753395
  613277
  813168
  773533
  581382
]
3.37 ms
(2.13%)
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
  325867
  416665
  422449
  424190
  424199
  424259
  424261
  438045
  439739
  440993
  444246
  445891
  452305
  456455
  458126
  463384
  474923
  475828
  480709
  486762
  493316
  499159
  513158
  513195
  513503
  516754
  516970
  517556
  519582
  520572
  523130
  524162
  526683
  528258
  529651
  533459
  533519
  535269
  544625
  549528
  551473
  551480
  558886
  562255
  571508
  579507
  581382
  585821
  585909
  590176
  591214
  598494
  599540
  611290
  613277
  623472
  624460
  630919
  635019
  636605
  640837
  645167
  648183
  651789
  661300
  663301
  666784
  667167
  674256
  695145
  696414
  705435
  712398
  715657
  716697
  719392
  722093
  722944
  723954
  734703
  735885
  736228
  736235
  737459
  737907
  738085
  743344
  743749
  748936
  750235
  751707
  753395
  762197
  763136
  763424
  763570
  763868
  767278
  768872
  773533
  781089
  782340
  786485
  787131
  789569
  790284
  793104
  793907
  794411
  795768
  797203
  807643
  810323
  813168
  819719
  824375
  826259
  827520
  827569
]
2.06 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck and hard"
]
2.01 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс hard"
]
1.62 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс hard"
]

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.