GET https://search.jues.net/search/embeds/9?q=big%20saggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.98 ms
(56.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие saggy"
]
138.28 ms
(37.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
  150897
  385437
  453258
  518860
  524476
  531667
  532395
  532623
  533843
  533898
  537351
  540264
  542259
  547004
  547037
  549483
  555528
  559920
  562704
  565076
  565116
  565232
  566012
  566672
  568112
  568243
  573209
  575980
  601590
  604926
  607444
  613040
  613527
  623951
  631668
  631708
  634691
  634825
  636416
  639300
  639578
  643031
  643645
  650446
  653087
  663415
  664528
  667295
  667762
  671694
  671696
  679701
  680640
  705454
  708829
  710573
  711342
  711636
  714148
  714690
  716349
  717430
  717437
  719530
  725150
  728634
  734097
  734660
  738828
  740442
  745057
  746260
  748550
  754394
  757315
  762305
  769383
  774440
  774730
  776635
  780998
  781790
  781931
  781989
  791054
  797153
  797784
  802706
  803218
  804659
  805328
  805731
  808494
  810121
  811187
  814458
  817540
  818454
  818508
  818673
  818692
  819327
  820373
  820611
  823781
  823978
  824088
  824793
  824903
  825062
  825398
  825974
  826019
  826062
  826388
  826481
  826497
  826550
  826595
  826603
]
14.33 ms
(3.87%)
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
  518860
  524476
  533843
  533898
  540264
  531667
  532395
  532623
  537351
  547004
  565116
  566012
  568112
  573209
  542259
  555528
  568243
  575980
  549483
  559920
  650446
  653087
  664528
  671694
  671696
  717437
  663415
  667295
  679701
  708829
  711342
  717430
  667762
  680640
  714690
  719530
  547037
  562704
  565076
  565232
  566672
  601590
  623951
  631668
  634691
  613040
  636416
  643645
  613527
  604926
  631708
  639300
  639578
  643031
  774730
  776635
  780998
  781931
  797153
  797784
  802706
  811187
  804659
  805328
  805731
  728634
  746260
  762305
  803218
  734097
  745057
  748550
  754394
  757315
  769383
  725150
  738828
  734660
  740442
  607444
  634825
  705454
  710573
  711636
  714148
  716349
  781790
  781989
  791054
  808494
  810121
  453258
  385437
  150897
  814458
  817540
  818454
  818508
  819327
  823781
  823978
  824088
  824793
  824903
  825062
  826019
  826062
  774440
  826481
  826497
  825974
  826550
  826388
  826603
  825398
  826595
  818673
  818692
  820373
  820611
]
2.78 ms
(0.75%)
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
  150897
  385437
  453258
  518860
  524476
  531667
  532395
  532623
  533843
  533898
  537351
  540264
  542259
  547004
  547037
  549483
  555528
  559920
  562704
  565076
  565116
  565232
  566012
  566672
  568112
  568243
  573209
  575980
  601590
  604926
  607444
  613040
  613527
  623951
  631668
  631708
  634691
  634825
  636416
  639300
  639578
  643031
  643645
  650446
  653087
  663415
  664528
  667295
  667762
  671694
  671696
  679701
  680640
  705454
  708829
  710573
  711342
  711636
  714148
  714690
  716349
  717430
  717437
  719530
  725150
  728634
  734097
  734660
  738828
  740442
  745057
  746260
  748550
  754394
  757315
  762305
  769383
  774440
  774730
  776635
  780998
  781790
  781931
  781989
  791054
  797153
  797784
  802706
  803218
  804659
  805328
  805731
  808494
  810121
  811187
  814458
  817540
  818454
  818508
  818673
  818692
  819327
  820373
  820611
  823781
  823978
  824088
  824793
  824903
  825062
  825398
  825974
  826019
  826062
  826388
  826481
  826497
  826550
  826595
  826603
]
2.07 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big saggy"
]
1.90 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие saggy"
]

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.