GET https://search.jues.net/search/embeds/4?q=bbc%20chubby

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.88 ms
(82.04%)
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
  318700
  359067
  366354
  396349
  396526
  396564
  400753
  402876
  404217
  404320
  405061
  405070
  406629
  409119
  411477
  411638
  411747
  417053
  417056
  419483
  419621
  419738
  427241
  428125
  430534
  433047
  440687
  443573
  443991
  446754
  447691
  448542
  452189
  453235
  453531
  453737
  454801
  458001
  460079
  460099
  461032
  461036
  463825
  464336
  464350
  464359
  465698
  466493
  466552
  471890
  473467
  473891
  474619
  476340
  476564
  485266
  485733
  485996
  487588
  488894
  493200
  496551
  499332
  499333
  499336
  500931
  501233
  504121
  512527
  512528
  516661
  521509
  527762
  528363
  528913
  529166
  530110
  531540
  532341
  532629
  532888
  536438
  536569
  539786
  540346
  544834
  545819
  548264
  553296
  554444
  554445
  567143
  569793
  570174
  576616
  578406
  582050
  582935
  598622
  602617
  603298
  605499
  605557
  606769
  610290
  614715
  630870
  637145
  645293
  646938
  653972
  668528
  675515
  693383
  759472
  788252
  808077
  808757
  809272
  815789
]
18.44 ms
(11.39%)
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
  493200
  512527
  359067
  366354
  396349
  402876
  404217
  406629
  440687
  411477
  815789
  453235
  464350
  485266
  453737
  454801
  476340
  452189
  453531
  461032
  461036
  473891
  476564
  488894
  532888
  499333
  532341
  536438
  536569
  528913
  529166
  567143
  569793
  582050
  548264
  570174
  645293
  653972
  693383
  630870
  602617
  603298
  614715
  788252
  404320
  419621
  430534
  419738
  405070
  446754
  521509
  501233
  318700
  400753
  409119
  411638
  411747
  443573
  427241
  458001
  464336
  466493
  471890
  447691
  463825
  465698
  448542
  460079
  473467
  485733
  487588
  499336
  504121
  528363
  530110
  527762
  532629
  539786
  540346
  474619
  485996
  553296
  582935
  554444
  646938
  544834
  576616
  610290
  605557
  808757
  759472
  808077
  396526
  428125
  466552
  419483
  405061
  417056
  396564
  417053
  443991
  460099
  496551
  499332
  500931
  512528
  516661
  531540
  464359
  554445
  545819
  578406
  675515
  668528
  598622
  605499
  637145
  809272
  606769
  433047
]
2.90 ms
(1.79%)
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
  318700
  359067
  366354
  396349
  396526
  396564
  400753
  402876
  404217
  404320
  405061
  405070
  406629
  409119
  411477
  411638
  411747
  417053
  417056
  419483
  419621
  419738
  427241
  428125
  430534
  433047
  440687
  443573
  443991
  446754
  447691
  448542
  452189
  453235
  453531
  453737
  454801
  458001
  460079
  460099
  461032
  461036
  463825
  464336
  464350
  464359
  465698
  466493
  466552
  471890
  473467
  473891
  474619
  476340
  476564
  485266
  485733
  485996
  487588
  488894
  493200
  496551
  499332
  499333
  499336
  500931
  501233
  504121
  512527
  512528
  516661
  521509
  527762
  528363
  528913
  529166
  530110
  531540
  532341
  532629
  532888
  536438
  536569
  539786
  540346
  544834
  545819
  548264
  553296
  554444
  554445
  567143
  569793
  570174
  576616
  578406
  582050
  582935
  598622
  602617
  603298
  605499
  605557
  606769
  610290
  614715
  630870
  637145
  645293
  646938
  653972
  668528
  675515
  693383
  759472
  788252
  808077
  808757
  809272
  815789
]
2.45 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc chubby"
]
1.95 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc chubby"
]
1.57 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc 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.