GET https://search.jues.net/search/embeds/2?q=piss%20panties

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
194.16 ms
(87.47%)
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
  517796
  538998
  540072
  540146
  540159
  541194
  542436
  545601
  546215
  547698
  549023
  550128
  554722
  555055
  555227
  555450
  555773
  555967
  556231
  561768
  563591
  567498
  567510
  568436
  570159
  576506
  577380
  580398
  580868
  583084
  588202
  590226
  598193
  599976
  600360
  600438
  602215
  602395
  611467
  611485
  613851
  623714
  627833
  631202
  631898
  632991
  633206
  633502
  634216
  634780
  635275
  637413
  638740
  639027
  639809
  646930
  649306
  649318
  650608
  661661
  666906
  670266
  672401
  675000
  675010
  677781
  680127
  681535
  696606
  705700
  710584
  714836
  719910
  722005
  723383
  725474
  728860
  729187
  731099
  738118
  738309
  741761
  743512
  746021
  746239
  749143
  757217
  758176
  758797
  761223
  773277
  784246
  793510
  795732
  798877
  801326
  804416
  809358
  809763
  810081
  810087
  811466
  811658
  812217
  813760
  813802
  814058
  814157
  816168
  816603
  817709
  818540
  820347
  824196
  824664
  824896
  826098
  826209
  826296
  826322
]
17.60 ms
(7.93%)
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
  556231
  555450
  547698
  634216
  611485
  623714
  738309
  602395
  758797
  814157
  627833
  570159
  680127
  563591
  746021
  761223
  602215
  646930
  731099
  549023
  633206
  749143
  798877
  743512
  705700
  826296
  793510
  811466
  540072
  555967
  813802
  675010
  826098
  590226
  677781
  816603
  568436
  583084
  661661
  554722
  577380
  555227
  541194
  696606
  675000
  600360
  634780
  795732
  598193
  561768
  710584
  746239
  681535
  758176
  542436
  649318
  631202
  639809
  820347
  588202
  540146
  567510
  809763
  631898
  666906
  540159
  801326
  633502
  567498
  817709
  816168
  550128
  650608
  818540
  826209
  826322
  824664
  824896
  813760
  814058
  517796
  580868
  714836
  719910
  723383
  784246
  725474
  728860
  722005
  810087
  546215
  613851
  649306
  670266
  632991
  635275
  555773
  637413
  824196
  672401
  611467
  638740
  809358
  804416
  810081
  738118
  757217
  811658
  741761
  773277
  729187
  599976
  555055
  538998
  812217
  576506
  545601
  639027
  600438
  580398
]
3.07 ms
(1.38%)
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
  517796
  538998
  540072
  540146
  540159
  541194
  542436
  545601
  546215
  547698
  549023
  550128
  554722
  555055
  555227
  555450
  555773
  555967
  556231
  561768
  563591
  567498
  567510
  568436
  570159
  576506
  577380
  580398
  580868
  583084
  588202
  590226
  598193
  599976
  600360
  600438
  602215
  602395
  611467
  611485
  613851
  623714
  627833
  631202
  631898
  632991
  633206
  633502
  634216
  634780
  635275
  637413
  638740
  639027
  639809
  646930
  649306
  649318
  650608
  661661
  666906
  670266
  672401
  675000
  675010
  677781
  680127
  681535
  696606
  705700
  710584
  714836
  719910
  722005
  723383
  725474
  728860
  729187
  731099
  738118
  738309
  741761
  743512
  746021
  746239
  749143
  757217
  758176
  758797
  761223
  773277
  784246
  793510
  795732
  798877
  801326
  804416
  809358
  809763
  810081
  810087
  811466
  811658
  812217
  813760
  813802
  814058
  814157
  816168
  816603
  817709
  818540
  820347
  824196
  824664
  824896
  826098
  826209
  826296
  826322
]
1.83 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг трусик нижн бел"
]
1.79 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг трусик нижн бел"
]
1.77 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss panties"
]
1.75 ms
(0.79%)
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.