GET https://search.jues.net/search/embeds/5?q=body%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.55 ms
(85.83%)
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
  30208
  70123
  107104
  187443
  386761
  390487
  395951
  396762
  397665
  398357
  405812
  414092
  416988
  424521
  426477
  443046
  444447
  445576
  452861
  454701
  454763
  454822
  460573
  472279
  472732
  474307
  476942
  479873
  486222
  486640
  488234
  495335
  499335
  514972
  525561
  528103
  531053
  537273
  539219
  539323
  539538
  541460
  541847
  545327
  573134
  574886
  581048
  582678
  584723
  584849
  589986
  594236
  596033
  598331
  608467
  617869
  621079
  631620
  633190
  636162
  637605
  638840
  648079
  649339
  661743
  661899
  669957
  680029
  687376
  690961
  691343
  697657
  699237
  700820
  708989
  709057
  709065
  709117
  709169
  709179
  714426
  714578
  720092
  724553
  725438
  729644
  735976
  737216
  740258
  742769
  748479
  749430
  754170
  757863
  758494
  770749
  775754
  781022
  781645
  786562
  790512
  790889
  791337
  798805
  799299
  799400
  801718
  804983
  807010
  807364
  808037
  809363
  809794
  814406
  818866
  819223
  820671
  822834
  823316
]
15.05 ms
(8.47%)
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
  809363
  737216
  781645
  791337
  801718
  740258
  758494
  770749
  621079
  786562
  807364
  396762
  454763
  514972
  390487
  820671
  499335
  472279
  648079
  687376
  699237
  636162
  798805
  749430
  754170
  724553
  748479
  405812
  107104
  187443
  30208
  443046
  814406
  823316
  454701
  476942
  539538
  539323
  531053
  460573
  488234
  661899
  680029
  709065
  649339
  661743
  633190
  598331
  775754
  799299
  729644
  742769
  757863
  735976
  764440
  700820
  808037
  444447
  452861
  397665
  426477
  594236
  486640
  528103
  486222
  545327
  631620
  725438
  70123
  819223
  454822
  445576
  479873
  537273
  539219
  472732
  541460
  581048
  582678
  541847
  690961
  714426
  709179
  669957
  709117
  589986
  596033
  637605
  608467
  638840
  799400
  809794
  790889
  617869
  781022
  790512
  804983
  807010
  395951
  474307
  386761
  398357
  414092
  416988
  424521
  525561
  495335
  822834
  818866
  573134
  584723
  584849
  697657
  708989
  709057
  709169
  720092
  691343
  714578
  574886
]
2.95 ms
(1.66%)
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
  30208
  70123
  107104
  187443
  386761
  390487
  395951
  396762
  397665
  398357
  405812
  414092
  416988
  424521
  426477
  443046
  444447
  445576
  452861
  454701
  454763
  454822
  460573
  472279
  472732
  474307
  476942
  479873
  486222
  486640
  488234
  495335
  499335
  514972
  525561
  528103
  531053
  537273
  539219
  539323
  539538
  541460
  541847
  545327
  573134
  574886
  581048
  582678
  584723
  584849
  589986
  594236
  596033
  598331
  608467
  617869
  621079
  631620
  633190
  636162
  637605
  638840
  648079
  649339
  661743
  661899
  669957
  680029
  687376
  690961
  691343
  697657
  699237
  700820
  708989
  709057
  709065
  709117
  709169
  709179
  714426
  714578
  720092
  724553
  725438
  729644
  735976
  737216
  740258
  742769
  748479
  749430
  754170
  757863
  758494
  770749
  775754
  781022
  781645
  786562
  790512
  790889
  791337
  798805
  799299
  799400
  801718
  804983
  807010
  807364
  808037
  809363
  809794
  814406
  818866
  819223
  820671
  822834
  823316
]
2.02 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body big"
]
1.93 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body большие"
]
1.42 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body большие"
]

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.