GET https://search.jues.net/search/embeds/3?q=pussy%20short

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.42 ms
(87.22%)
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
  214560
  238115
  313978
  382490
  386688
  389678
  390233
  396887
  401926
  413316
  452934
  464253
  470421
  471887
  473910
  478979
  507263
  512366
  518823
  520856
  521972
  538956
  539520
  548285
  550647
  565983
  567734
  572424
  576478
  578043
  589669
  615950
  622137
  656453
  657352
  662812
  665450
  672319
  680640
  683505
  686481
  686825
  700328
  703542
  703936
  704336
  705353
  710051
  711879
  715529
  720378
  720482
  720496
  722886
  725189
  727784
  727786
  728097
  731790
  732721
  735570
  736999
  739016
  739160
  739257
  739928
  740235
  741765
  741905
  744183
  744767
  746856
  748599
  748674
  753057
  754255
  755956
  760841
  772882
  772885
  773902
  774121
  774767
  775290
  775401
  783186
  783357
  786746
  788657
  788823
  794629
  797319
  797897
  801048
  802573
  803228
  804359
  805315
  811989
  812544
  813547
  815091
  816206
  817020
  817417
  819067
  820686
  822007
  823773
  824407
  824452
  824814
  825432
  826784
  827139
  827308
  827616
  827692
  827722
]
13.42 ms
(7.48%)
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
  464253
  521972
  512366
  313978
  389678
  396887
  401926
  813547
  822007
  824407
  539520
  507263
  538956
  520856
  576478
  567734
  548285
  662812
  665450
  686825
  703936
  711879
  715529
  720482
  657352
  672319
  686481
  703542
  704336
  720496
  656453
  680640
  683505
  700328
  710051
  572424
  578043
  615950
  622137
  589669
  775401
  802573
  803228
  805315
  774767
  775290
  776019
  783186
  786746
  794629
  725189
  727786
  739016
  739257
  744183
  744767
  748599
  772882
  773902
  783357
  788657
  788823
  797319
  797897
  801048
  804359
  811989
  812544
  740235
  746856
  727784
  728097
  731790
  735570
  739160
  741765
  753057
  754255
  755956
  760841
  732721
  739928
  741905
  748674
  772885
  736999
  774121
  705353
  720378
  722886
  390233
  473910
  386688
  565983
  550647
  470421
  238115
  214560
  382490
  413316
  819067
  820686
  817020
  826784
  827139
  827308
  827616
  827722
  827692
  815091
  817417
  823773
  816206
  824452
  824814
  825432
  471887
  452934
  478979
  518823
]
2.67 ms
(1.49%)
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
  214560
  238115
  313978
  382490
  386688
  389678
  390233
  396887
  401926
  413316
  452934
  464253
  470421
  471887
  473910
  478979
  507263
  512366
  518823
  520856
  521972
  538956
  539520
  548285
  550647
  565983
  567734
  572424
  576478
  578043
  589669
  615950
  622137
  656453
  657352
  662812
  665450
  672319
  680640
  683505
  686481
  686825
  700328
  703542
  703936
  704336
  705353
  710051
  711879
  715529
  720378
  720482
  720496
  722886
  725189
  727784
  727786
  728097
  731790
  732721
  735570
  736999
  739016
  739160
  739257
  739928
  740235
  741765
  741905
  744183
  744767
  746856
  748599
  748674
  753057
  754255
  755956
  760841
  772882
  772885
  773902
  774121
  774767
  775290
  775401
  783186
  783357
  786746
  788657
  788823
  794629
  797319
  797897
  801048
  802573
  803228
  804359
  805315
  811989
  812544
  813547
  815091
  816206
  817020
  817417
  819067
  820686
  822007
  823773
  824407
  824452
  824814
  825432
  826784
  827139
  827308
  827616
  827692
  827722
]
1.91 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy short"
]
1.72 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy short"
]
1.63 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy short"
]
1.57 ms
(0.88%)
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.