GET https://search.jues.net/search/embeds/10?q=pissing%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.46 ms
(89.37%)
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
  463420
  500311
  533913
  534529
  540107
  540135
  540139
  540149
  540159
  542076
  542182
  542285
  542439
  544234
  545319
  545993
  547414
  550066
  550559
  550560
  551037
  551912
  552382
  552602
  552604
  553317
  553674
  554191
  554714
  554723
  555216
  555220
  555281
  555774
  555776
  558624
  562048
  571708
  573386
  574444
  574452
  576509
  577543
  580129
  581033
  583536
  584283
  588389
  589337
  589362
  592576
  593734
  595605
  598499
  601684
  605846
  609998
  610199
  614675
  615391
  627233
  629315
  629649
  630105
  632887
  633206
  633823
  637163
  641778
  650919
  651903
  652779
  657777
  664562
  670266
  670853
  678662
  696776
  707495
  710471
  714374
  721958
  724317
  724552
  729287
  732589
  734364
  736265
  737438
  743470
  746021
  747069
  747137
  750308
  751640
  752840
  754209
  757569
  768157
  771623
  775212
  784501
  793671
  794019
  795979
  797240
  798273
  799435
  799934
  801406
  801825
  803691
  803700
  803960
  804235
  808659
  811366
  812326
  814318
  816168
]
13.47 ms
(6.49%)
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
  540139
  534529
  562048
  583536
  554191
  554723
  714374
  664562
  696776
  721958
  545319
  547414
  552604
  555776
  580129
  632887
  589362
  592576
  588389
  747137
  797240
  771623
  724552
  746021
  750308
  747069
  754209
  633823
  710471
  804235
  601684
  794019
  795979
  798273
  555281
  571708
  542439
  542182
  651903
  652779
  657777
  670853
  558624
  598499
  609998
  629315
  605846
  615391
  629649
  816168
  540159
  540135
  533913
  551912
  552382
  574444
  545993
  581033
  544234
  550066
  551037
  553674
  576509
  707495
  650919
  678662
  555220
  573386
  610199
  775212
  801825
  803700
  812326
  799934
  803691
  803960
  732589
  743470
  751640
  757569
  724317
  752840
  784501
  801406
  814318
  463420
  553317
  670266
  637163
  633206
  540107
  540149
  500311
  554714
  542076
  542285
  577543
  555216
  550559
  550560
  552602
  555774
  574452
  584283
  593734
  641778
  627233
  589337
  630105
  595605
  614675
  811366
  793671
  799435
  736265
  737438
  808659
  729287
  734364
  768157
]
2.56 ms
(1.23%)
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
  463420
  500311
  533913
  534529
  540107
  540135
  540139
  540149
  540159
  542076
  542182
  542285
  542439
  544234
  545319
  545993
  547414
  550066
  550559
  550560
  551037
  551912
  552382
  552602
  552604
  553317
  553674
  554191
  554714
  554723
  555216
  555220
  555281
  555774
  555776
  558624
  562048
  571708
  573386
  574444
  574452
  576509
  577543
  580129
  581033
  583536
  584283
  588389
  589337
  589362
  592576
  593734
  595605
  598499
  601684
  605846
  609998
  610199
  614675
  615391
  627233
  629315
  629649
  630105
  632887
  633206
  633823
  637163
  641778
  650919
  651903
  652779
  657777
  664562
  670266
  670853
  678662
  696776
  707495
  710471
  714374
  721958
  724317
  724552
  729287
  732589
  734364
  736265
  737438
  743470
  746021
  747069
  747137
  750308
  751640
  752840
  754209
  757569
  768157
  771623
  775212
  784501
  793671
  794019
  795979
  797240
  798273
  799435
  799934
  801406
  801825
  803691
  803700
  803960
  804235
  808659
  811366
  812326
  814318
  816168
]
1.65 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pissing любительск"
]
1.64 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pissing amateur"
]
1.37 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pissing любительск"
]

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.