GET https://search.jues.net/search/embeds/9?q=%D1%81%D0%BE%D0%BB%D0%BE%20%D1%81%D0%B8%D1%81%D1%8C%D0%BA%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.20 ms
(88.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
  173963
  197711
  385267
  390949
  412582
  463351
  522166
  524476
  528870
  532398
  533843
  536521
  536531
  539751
  541488
  542259
  544965
  547004
  550147
  550152
  557872
  558092
  558110
  559832
  559970
  562553
  562561
  562704
  565117
  565128
  566672
  567542
  568112
  568179
  568243
  573209
  575634
  576478
  578643
  580900
  583755
  593206
  601079
  601590
  603972
  604906
  604926
  607072
  613067
  613527
  618678
  619899
  627696
  629528
  629757
  633460
  633694
  634453
  636710
  644035
  644048
  644127
  644344
  650446
  651074
  664528
  671554
  672743
  674483
  686601
  692135
  702615
  709191
  712239
  712617
  725433
  726814
  731806
  736031
  744217
  745057
  752188
  752195
  752330
  753038
  754666
  754938
  756393
  761952
  772544
  772902
  774730
  776452
  777430
  778524
  780998
  781926
  781940
  786110
  793051
  797199
  797784
  800146
  801390
  802320
  803023
  803754
  806359
  806956
  807179
  808041
  808313
  808395
  808607
  811094
  811959
  812769
  817640
  819273
  825642
]
9.36 ms
(5.69%)
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
  550147
  568179
  541488
  559832
  580900
  583755
  557872
  558092
  558110
  562553
  672743
  674483
  671554
  712617
  709191
  559970
  562561
  575634
  578643
  604906
  634453
  644344
  633694
  603972
  627696
  636710
  644048
  644035
  808395
  800146
  811094
  736031
  752195
  752330
  753038
  786110
  802320
  803023
  725433
  726814
  761952
  754938
  772902
  754666
  756393
  776452
  777430
  778524
  793051
  797199
  803754
  807179
  808607
  811959
  812769
  412582
  197711
  385267
  390949
  532398
  565128
  173963
  819273
  817640
  825642
  463351
  536521
  536531
  524476
  533843
  522166
  528870
  539751
  547004
  550152
  568112
  573209
  576478
  542259
  544965
  565117
  568243
  567542
  650446
  664528
  651074
  686601
  692135
  702615
  712239
  562704
  566672
  601079
  601590
  607072
  629528
  644127
  593206
  613067
  613527
  629757
  633460
  604926
  618678
  619899
  774730
  780998
  781926
  781940
  797784
  806956
  808313
  808041
  772544
  801390
  806359
  731806
  745057
  744217
  752188
]
2.70 ms
(1.64%)
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
  173963
  197711
  385267
  390949
  412582
  463351
  522166
  524476
  528870
  532398
  533843
  536521
  536531
  539751
  541488
  542259
  544965
  547004
  550147
  550152
  557872
  558092
  558110
  559832
  559970
  562553
  562561
  562704
  565117
  565128
  566672
  567542
  568112
  568179
  568243
  573209
  575634
  576478
  578643
  580900
  583755
  593206
  601079
  601590
  603972
  604906
  604926
  607072
  613067
  613527
  618678
  619899
  627696
  629528
  629757
  633460
  633694
  634453
  636710
  644035
  644048
  644127
  644344
  650446
  651074
  664528
  671554
  672743
  674483
  686601
  692135
  702615
  709191
  712239
  712617
  725433
  726814
  731806
  736031
  744217
  745057
  752188
  752195
  752330
  753038
  754666
  754938
  756393
  761952
  772544
  772902
  774730
  776452
  777430
  778524
  780998
  781926
  781940
  786110
  793051
  797199
  797784
  800146
  801390
  802320
  803023
  803754
  806359
  806956
  807179
  808041
  808313
  808395
  808607
  811094
  811959
  812769
  817640
  819273
  825642
]
2.11 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло сиськи"
]
1.87 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло сиськ"
]
1.48 ms
(0.90%)
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.