GET https://search.jues.net/search/embeds/2?q=red%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.54 ms
(56.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red анал"
]
144.74 ms
(38.01%)
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
  17037
  229361
  233386
  325983
  386212
  388364
  388734
  395710
  397647
  397652
  397917
  398665
  398885
  404188
  447970
  475317
  512502
  531882
  534193
  542209
  547469
  564222
  569266
  572331
  579616
  585094
  605155
  612832
  623176
  631984
  639755
  642048
  644499
  647344
  651716
  654405
  655151
  657527
  660994
  665714
  668996
  671609
  672913
  674327
  674531
  680186
  691472
  694324
  694345
  697339
  699400
  699587
  701001
  706572
  717913
  722599
  723266
  724086
  725176
  726897
  729228
  731827
  732450
  732804
  735964
  740604
  741573
  742424
  743044
  753445
  756104
  756237
  760913
  761061
  762187
  764868
  764879
  765229
  765391
  765441
  765456
  765507
  765939
  766632
  768870
  769735
  769742
  769760
  769802
  769805
  770310
  777139
  781609
  782470
  782628
  787486
  790203
  791623
  793893
  794852
  797389
  797558
  797969
  800589
  802552
  803526
  805509
  805848
  810354
  811478
  813703
  813947
  815650
  817257
  817311
  819035
  820071
  823649
  824883
  827464
]
13.58 ms
(3.57%)
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
  729228
  741573
  397647
  398665
  813947
  817311
  699400
  668996
  706572
  699587
  723266
  639755
  782470
  793893
  753445
  765441
  760913
  764868
  740604
  765391
  742424
  761061
  717913
  722599
  386212
  512502
  631984
  815650
  827464
  813703
  820071
  823649
  765229
  794852
  768870
  777139
  810354
  395710
  765456
  726897
  17037
  404188
  388364
  764879
  579616
  697339
  325983
  585094
  657527
  701001
  671609
  674531
  547469
  623176
  605155
  782628
  781609
  731827
  732804
  756104
  756237
  769802
  800589
  805509
  805848
  724086
  732450
  735964
  765507
  762187
  642048
  791623
  802552
  397652
  824883
  694345
  644499
  787486
  765939
  743044
  770310
  447970
  769742
  769735
  769760
  769805
  797389
  398885
  680186
  534193
  819035
  817257
  569266
  694324
  654405
  672913
  612832
  797558
  797969
  811478
  725176
  766632
  790203
  397917
  803526
  647344
  229361
  233386
  388734
  475317
  531882
  542209
  564222
  572331
  655151
  665714
  660994
  674327
  691472
  651716
]
3.20 ms
(0.84%)
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
  17037
  229361
  233386
  325983
  386212
  388364
  388734
  395710
  397647
  397652
  397917
  398665
  398885
  404188
  447970
  475317
  512502
  531882
  534193
  542209
  547469
  564222
  569266
  572331
  579616
  585094
  605155
  612832
  623176
  631984
  639755
  642048
  644499
  647344
  651716
  654405
  655151
  657527
  660994
  665714
  668996
  671609
  672913
  674327
  674531
  680186
  691472
  694324
  694345
  697339
  699400
  699587
  701001
  706572
  717913
  722599
  723266
  724086
  725176
  726897
  729228
  731827
  732450
  732804
  735964
  740604
  741573
  742424
  743044
  753445
  756104
  756237
  760913
  761061
  762187
  764868
  764879
  765229
  765391
  765441
  765456
  765507
  765939
  766632
  768870
  769735
  769742
  769760
  769802
  769805
  770310
  777139
  781609
  782470
  782628
  787486
  790203
  791623
  793893
  794852
  797389
  797558
  797969
  800589
  802552
  803526
  805509
  805848
  810354
  811478
  813703
  813947
  815650
  817257
  817311
  819035
  820071
  823649
  824883
  827464
]
2.19 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red anal"
]
1.81 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red анал"
]
1.73 ms
(0.45%)
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.