GET https://search.jues.net/search/embeds/4?q=fucked%20the%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.03 ms
(82.88%)
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
  187195
  382314
  404318
  415580
  419018
  421189
  429289
  430430
  431740
  435865
  444013
  445884
  453033
  453668
  453952
  454398
  454538
  454874
  455776
  461828
  464390
  465545
  466721
  466760
  468811
  471502
  476352
  477414
  478863
  481435
  481636
  482163
  484502
  485174
  488159
  489101
  490133
  490763
  499770
  502028
  503357
  503856
  504562
  506130
  507156
  509386
  510817
  512148
  515889
  519850
  519854
  520820
  523735
  523784
  524368
  527636
  528394
  541913
  543825
  546742
  546904
  547151
  550616
  551787
  551800
  554903
  556209
  556511
  558006
  559572
  560109
  560261
  561441
  561447
  561489
  561639
  563219
  564208
  565454
  565992
  567018
  567914
  569970
  570838
  574446
  574655
  579221
  579347
  580239
  581716
  582221
  584797
  592324
  597859
  598857
  605708
  610831
  611321
  613333
  618384
  643984
  648877
  654096
  662218
  668949
  671396
  676122
  683380
  687271
  690693
  694334
  696126
  697416
  708102
  728271
  734521
  737628
  791425
  811906
  814515
]
16.73 ms
(10.50%)
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
  466760
  454538
  488159
  503856
  504562
  512148
  523735
  528394
  503357
  502028
  509386
  527636
  461828
  485174
  541913
  543825
  546904
  559572
  563219
  565454
  567018
  584797
  567914
  574655
  579347
  546742
  547151
  556511
  654096
  671396
  676122
  683380
  690693
  696126
  648877
  662218
  694334
  697416
  708102
  550616
  560109
  561489
  570838
  574446
  582221
  605708
  611321
  598857
  618384
  592324
  597859
  613333
  643984
  811906
  737628
  728271
  734521
  610831
  791425
  187195
  431740
  465545
  454398
  471502
  421189
  430430
  435865
  445884
  455776
  382314
  453033
  478863
  419018
  444013
  490133
  510817
  524368
  476352
  490763
  404318
  429289
  415580
  814515
  453668
  464390
  466721
  453952
  454874
  468811
  481636
  482163
  489101
  515889
  499770
  519850
  520820
  506130
  507156
  523784
  519854
  477414
  481435
  484502
  560261
  561447
  551787
  551800
  564208
  581716
  554903
  558006
  561441
  565992
  580239
  668949
  687271
  556209
  561639
  569970
  579221
]
2.85 ms
(1.79%)
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
  187195
  382314
  404318
  415580
  419018
  421189
  429289
  430430
  431740
  435865
  444013
  445884
  453033
  453668
  453952
  454398
  454538
  454874
  455776
  461828
  464390
  465545
  466721
  466760
  468811
  471502
  476352
  477414
  478863
  481435
  481636
  482163
  484502
  485174
  488159
  489101
  490133
  490763
  499770
  502028
  503357
  503856
  504562
  506130
  507156
  509386
  510817
  512148
  515889
  519850
  519854
  520820
  523735
  523784
  524368
  527636
  528394
  541913
  543825
  546742
  546904
  547151
  550616
  551787
  551800
  554903
  556209
  556511
  558006
  559572
  560109
  560261
  561441
  561447
  561489
  561639
  563219
  564208
  565454
  565992
  567018
  567914
  569970
  570838
  574446
  574655
  579221
  579347
  580239
  581716
  582221
  584797
  592324
  597859
  598857
  605708
  610831
  611321
  613333
  618384
  643984
  648877
  654096
  662218
  668949
  671396
  676122
  683380
  687271
  690693
  694334
  696126
  697416
  708102
  728271
  734521
  737628
  791425
  811906
  814515
]
2.08 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucked the sleeping"
]
1.92 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucked спящ"
]
1.67 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucked спящ"
]

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.