GET https://search.jues.net/search/embeds/3?q=piss%20and

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.63 ms
(85.92%)
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
  540059
  540135
  540136
  540326
  541166
  542397
  542498
  542719
  544229
  544234
  545424
  547409
  547566
  552604
  553674
  553695
  554191
  554714
  554717
  554723
  555261
  555406
  555421
  555773
  558624
  561025
  561049
  562036
  562493
  564205
  567515
  574452
  575026
  575326
  575847
  576580
  577188
  580984
  582505
  583057
  583536
  593028
  596606
  596972
  599902
  603414
  605179
  607312
  607676
  621710
  621713
  627233
  628387
  628535
  628668
  629315
  629820
  630105
  630468
  631439
  631898
  632887
  634145
  634810
  637080
  637163
  639626
  640239
  640856
  641561
  641985
  646081
  650127
  664562
  665326
  666045
  666579
  667450
  668526
  670272
  670794
  671782
  672324
  672765
  676112
  677293
  678135
  679577
  680112
  680118
  680172
  680204
  680493
  680778
  695835
  696996
  700919
  707495
  720598
  724317
  752616
  766348
  771623
  775212
  788888
  793466
  797224
  797230
  801406
  801825
  803691
  803700
  804417
  806268
  812225
  812248
  814318
  825968
  826491
  827401
]
14.11 ms
(8.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
  555421
  575326
  575847
  547566
  575026
  670794
  680493
  680778
  700919
  671782
  621710
  629820
  631898
  596606
  628668
  788888
  752616
  797224
  603414
  630468
  641561
  804417
  561049
  541166
  607312
  640239
  797230
  680112
  696996
  677293
  545424
  564205
  634145
  599902
  825968
  827401
  628535
  540059
  540135
  580984
  583536
  542498
  554191
  554723
  561025
  544234
  553674
  577188
  583057
  707495
  646081
  664562
  666579
  672765
  680204
  552604
  632887
  596972
  775212
  801825
  803700
  803691
  771623
  724317
  634810
  801406
  540136
  666045
  665326
  640856
  812248
  814318
  544229
  554714
  576580
  567515
  542397
  542719
  547409
  555773
  562036
  695835
  672324
  680172
  670272
  679577
  554717
  558624
  574452
  607676
  629315
  639626
  641985
  621713
  627233
  637163
  605179
  630105
  766348
  806268
  720598
  793466
  668526
  676112
  650127
  678135
  680118
  628387
  637080
  540326
  826491
  562493
  553695
  667450
  555261
  555406
  582505
  593028
  631439
  812225
]
2.76 ms
(1.66%)
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
  540059
  540135
  540136
  540326
  541166
  542397
  542498
  542719
  544229
  544234
  545424
  547409
  547566
  552604
  553674
  553695
  554191
  554714
  554717
  554723
  555261
  555406
  555421
  555773
  558624
  561025
  561049
  562036
  562493
  564205
  567515
  574452
  575026
  575326
  575847
  576580
  577188
  580984
  582505
  583057
  583536
  593028
  596606
  596972
  599902
  603414
  605179
  607312
  607676
  621710
  621713
  627233
  628387
  628535
  628668
  629315
  629820
  630105
  630468
  631439
  631898
  632887
  634145
  634810
  637080
  637163
  639626
  640239
  640856
  641561
  641985
  646081
  650127
  664562
  665326
  666045
  666579
  667450
  668526
  670272
  670794
  671782
  672324
  672765
  676112
  677293
  678135
  679577
  680112
  680118
  680172
  680204
  680493
  680778
  695835
  696996
  700919
  707495
  720598
  724317
  752616
  766348
  771623
  775212
  788888
  793466
  797224
  797230
  801406
  801825
  803691
  803700
  804417
  806268
  812225
  812248
  814318
  825968
  826491
  827401
]
1.83 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss and"
]
1.69 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг"
]
1.62 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг"
]
1.37 ms
(0.83%)
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.