GET https://search.jues.net/search/embeds/7?q=mother%20chubby

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.57 ms
(83.65%)
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
  188437
  191398
  370794
  382413
  385388
  391394
  391703
  391923
  391950
  392930
  392956
  396397
  397621
  400478
  400481
  401480
  403321
  408278
  411345
  411360
  411848
  413075
  414871
  415342
  420254
  420473
  421899
  422819
  423494
  424123
  439454
  439727
  441353
  441406
  441838
  446522
  454171
  454508
  455995
  459635
  460486
  462557
  463991
  464361
  467109
  475682
  480497
  483456
  503834
  504665
  516028
  536473
  544793
  549836
  551473
  583992
  602293
  610062
  620508
  652992
  700061
  709285
  712693
  715543
  717621
  718611
  724039
  725207
  725475
  727445
  727507
  732597
  733116
  733130
  733155
  736219
  736894
  739608
  739925
  739950
  739985
  741559
  742561
  742763
  743800
  745516
  745966
  748391
  749109
  758151
  761164
  765464
  765493
  765669
  766636
  768366
  769311
  774427
  774605
  781913
  781992
  788568
  795962
  795984
  796112
  797191
  797461
  800402
  807995
  823736
  824517
  824837
  824845
  825069
  826161
  826389
  826701
  828145
  828494
  828605
]
19.31 ms
(10.52%)
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
  795984
  736894
  724039
  727507
  739925
  739950
  742561
  748391
  749109
  765464
  768366
  743800
  736219
  739608
  742763
  761164
  610062
  709285
  717621
  774605
  795962
  796112
  391923
  391950
  483456
  188437
  391703
  392956
  828145
  551473
  788568
  745516
  758151
  700061
  825069
  826161
  823736
  826389
  824517
  828494
  828605
  718611
  741559
  385388
  391394
  413075
  774427
  826701
  824845
  824837
  583992
  712693
  715543
  652992
  544793
  620508
  781913
  733155
  781992
  807995
  732597
  725207
  733130
  745966
  727445
  765669
  733116
  766636
  422819
  463991
  420254
  392930
  397621
  401480
  441353
  441406
  441838
  408278
  423494
  439454
  454171
  464361
  460486
  467109
  459635
  602293
  800402
  769311
  797191
  797461
  725475
  739985
  765493
  424123
  396397
  400478
  400481
  439727
  455995
  370794
  411360
  411848
  414871
  420473
  446522
  504665
  503834
  516028
  475682
  549836
  403321
  480497
  454508
  462557
  536473
  191398
  382413
  415342
  411345
  421899
]
3.41 ms
(1.85%)
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
  188437
  191398
  370794
  382413
  385388
  391394
  391703
  391923
  391950
  392930
  392956
  396397
  397621
  400478
  400481
  401480
  403321
  408278
  411345
  411360
  411848
  413075
  414871
  415342
  420254
  420473
  421899
  422819
  423494
  424123
  439454
  439727
  441353
  441406
  441838
  446522
  454171
  454508
  455995
  459635
  460486
  462557
  463991
  464361
  467109
  475682
  480497
  483456
  503834
  504665
  516028
  536473
  544793
  549836
  551473
  583992
  602293
  610062
  620508
  652992
  700061
  709285
  712693
  715543
  717621
  718611
  724039
  725207
  725475
  727445
  727507
  732597
  733116
  733130
  733155
  736219
  736894
  739608
  739925
  739950
  739985
  741559
  742561
  742763
  743800
  745516
  745966
  748391
  749109
  758151
  761164
  765464
  765493
  765669
  766636
  768366
  769311
  774427
  774605
  781913
  781992
  788568
  795962
  795984
  796112
  797191
  797461
  800402
  807995
  823736
  824517
  824837
  824845
  825069
  826161
  826389
  826701
  828145
  828494
  828605
]
2.14 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother chubby"
]
1.58 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин chubby"
]
1.54 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин chubby"
]

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.