GET https://search.jues.net/search/embeds/5?q=piss%20in%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.93 ms
(85.29%)
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
  460860
  476270
  502210
  538854
  540143
  542076
  542456
  545233
  545337
  545993
  546614
  548226
  550705
  552820
  554381
  554704
  555616
  555967
  555991
  556323
  558732
  558956
  559017
  559023
  560218
  563333
  563388
  563399
  563591
  564602
  565119
  568293
  568436
  568777
  570941
  575411
  576509
  576652
  579351
  581033
  581053
  581929
  584147
  584950
  587532
  588398
  588554
  591221
  593855
  597841
  597873
  598099
  598193
  601856
  602215
  603552
  606235
  607238
  607325
  614327
  614346
  614382
  615605
  617135
  618301
  618308
  623337
  626841
  628382
  631136
  631879
  633768
  635283
  635519
  640755
  640789
  642018
  643700
  643706
  647993
  650742
  650813
  650919
  652779
  653513
  658865
  661303
  666991
  672760
  673941
  678502
  685701
  699562
  714119
  714577
  714581
  721949
  726434
  734846
  740268
  741862
  744280
  745978
  748154
  751470
  757569
  784294
  793623
  796577
  798630
  800492
  803214
  809741
  810347
  811010
  811992
  812564
  817881
  818906
  828593
]
17.24 ms
(8.92%)
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
  606235
  581033
  576509
  650919
  672760
  810347
  811992
  744280
  726434
  721949
  554704
  554381
  568436
  650742
  673941
  559023
  614346
  652779
  584147
  699562
  796577
  740268
  741862
  748154
  558956
  581053
  653513
  602215
  591221
  618301
  626841
  614382
  658865
  714577
  545337
  587532
  800492
  784294
  811010
  678502
  555967
  584950
  617135
  607238
  560218
  565119
  615605
  751470
  745978
  598193
  563591
  597841
  812564
  476270
  576652
  581929
  597873
  555991
  661303
  542456
  633768
  575411
  588398
  818906
  568777
  563399
  640789
  640755
  650813
  564602
  555616
  579351
  546614
  538854
  714119
  563388
  598099
  607325
  628382
  559017
  603552
  642018
  550705
  685701
  647993
  548226
  556323
  601856
  623337
  631136
  545233
  618308
  635519
  635283
  631879
  828593
  798630
  757569
  540143
  809741
  793623
  558732
  614327
  643700
  552820
  502210
  643706
  803214
  545993
  542076
  734846
  563333
  588554
  568293
  817881
  460860
  593855
  666991
  714581
  570941
]
3.08 ms
(1.59%)
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
  460860
  476270
  502210
  538854
  540143
  542076
  542456
  545233
  545337
  545993
  546614
  548226
  550705
  552820
  554381
  554704
  555616
  555967
  555991
  556323
  558732
  558956
  559017
  559023
  560218
  563333
  563388
  563399
  563591
  564602
  565119
  568293
  568436
  568777
  570941
  575411
  576509
  576652
  579351
  581033
  581053
  581929
  584147
  584950
  587532
  588398
  588554
  591221
  593855
  597841
  597873
  598099
  598193
  601856
  602215
  603552
  606235
  607238
  607325
  614327
  614346
  614382
  615605
  617135
  618301
  618308
  623337
  626841
  628382
  631136
  631879
  633768
  635283
  635519
  640755
  640789
  642018
  643700
  643706
  647993
  650742
  650813
  650919
  652779
  653513
  658865
  661303
  666991
  672760
  673941
  678502
  685701
  699562
  714119
  714577
  714581
  721949
  726434
  734846
  740268
  741862
  744280
  745978
  748154
  751470
  757569
  784294
  793623
  796577
  798630
  800492
  803214
  809741
  810347
  811010
  811992
  812564
  817881
  818906
  828593
]
2.31 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss in public"
]
2.10 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг на улиц"
]
1.86 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.