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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.50 ms
(87.28%)
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
  469195
  540170
  540570
  540574
  541856
  542073
  542433
  542447
  544812
  546082
  550201
  552820
  561027
  562054
  563591
  578718
  580976
  581182
  584283
  588554
  595491
  597227
  599911
  604645
  614327
  614675
  618144
  628368
  629830
  630521
  632256
  632565
  632684
  633193
  633511
  634216
  637100
  638133
  639774
  641667
  641778
  643013
  644663
  647726
  647893
  649545
  650109
  650700
  651144
  651147
  664492
  666525
  666853
  666906
  668518
  668534
  671986
  674983
  675523
  676024
  676088
  676632
  676636
  677294
  677671
  678003
  678126
  678159
  678493
  678533
  679016
  679317
  679757
  679774
  680116
  680127
  680138
  680183
  680186
  680189
  680195
  683262
  691337
  702164
  702678
  710452
  714737
  717984
  718782
  719693
  720446
  722966
  725392
  725536
  731099
  733022
  733840
  733842
  736265
  738309
  745978
  747137
  748935
  748937
  749924
  751606
  752736
  763741
  786525
  789114
  800632
  804235
  804403
  804422
  809741
  809800
  810892
  811880
  814706
  827278
]
15.21 ms
(7.65%)
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
  578718
  632684
  786525
  544812
  751606
  552820
  733842
  638133
  651144
  677671
  679317
  679757
  683262
  563591
  599911
  632256
  671986
  747137
  800632
  714737
  804235
  804422
  668534
  676632
  827278
  664492
  647726
  691337
  804403
  629830
  809800
  680195
  680186
  679774
  719693
  710452
  738309
  809741
  720446
  678126
  676088
  550201
  668518
  725392
  718782
  666525
  540574
  632565
  588554
  633511
  614675
  748935
  680189
  680116
  722966
  647893
  680127
  680138
  763741
  650700
  678003
  644663
  595491
  618144
  810892
  789114
  542073
  542447
  748937
  614327
  540570
  702164
  651147
  597227
  628368
  641667
  604645
  666906
  674983
  676636
  542433
  641778
  717984
  630521
  731099
  633193
  541856
  733840
  678533
  649545
  749924
  702678
  469195
  581182
  546082
  643013
  675523
  584283
  736265
  814706
  540170
  811880
  725536
  562054
  561027
  650109
  634216
  733022
  752736
  639774
  676024
  677294
  679016
  666853
  680183
  678159
  745978
  580976
  678493
  637100
]
3.24 ms
(1.63%)
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
  469195
  540170
  540570
  540574
  541856
  542073
  542433
  542447
  544812
  546082
  550201
  552820
  561027
  562054
  563591
  578718
  580976
  581182
  584283
  588554
  595491
  597227
  599911
  604645
  614327
  614675
  618144
  628368
  629830
  630521
  632256
  632565
  632684
  633193
  633511
  634216
  637100
  638133
  639774
  641667
  641778
  643013
  644663
  647726
  647893
  649545
  650109
  650700
  651144
  651147
  664492
  666525
  666853
  666906
  668518
  668534
  671986
  674983
  675523
  676024
  676088
  676632
  676636
  677294
  677671
  678003
  678126
  678159
  678493
  678533
  679016
  679317
  679757
  679774
  680116
  680127
  680138
  680183
  680186
  680189
  680195
  683262
  691337
  702164
  702678
  710452
  714737
  717984
  718782
  719693
  720446
  722966
  725392
  725536
  731099
  733022
  733840
  733842
  736265
  738309
  745978
  747137
  748935
  748937
  749924
  751606
  752736
  763741
  786525
  789114
  800632
  804235
  804403
  804422
  809741
  809800
  810892
  811880
  814706
  827278
]
1.95 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss big tits"
]
1.87 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг большие сиськ"
]
1.60 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг большие сиськ"
]
1.41 ms
(0.71%)
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.