GET https://search.jues.net/search/embeds/4?q=big%20ass%20babe

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.04 ms
(81.53%)
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
  13803
  30958
  212132
  212914
  213429
  313222
  321858
  384461
  389838
  390899
  406425
  408734
  441660
  445036
  445221
  446704
  507490
  508578
  514976
  522954
  525103
  525305
  534873
  537678
  539205
  539241
  543126
  551052
  556940
  558082
  574991
  578431
  580873
  581834
  584640
  585107
  591597
  605537
  606190
  610923
  611547
  612991
  613784
  622947
  629334
  630259
  636716
  647415
  649507
  651873
  661005
  662872
  665595
  668122
  669604
  671070
  671559
  671779
  680514
  696601
  710645
  711005
  713083
  716118
  716315
  720051
  721831
  732473
  735761
  736714
  739411
  750389
  751106
  757276
  759871
  761174
  761773
  766266
  767120
  767185
  774936
  776774
  778824
  782401
  784434
  785515
  785688
  785755
  787557
  788163
  788337
  791552
  791747
  795537
  796593
  796595
  796612
  796727
  800558
  801012
  807758
  808379
  808388
  808862
  811117
  812090
  817062
  817100
  817961
  820347
  820760
  821180
  821329
  821388
  822551
  822969
  823336
]
19.31 ms
(12.69%)
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
  321858
  389838
  390899
  408734
  820347
  822551
  817062
  817100
  821180
  823336
  815182
  820760
  821329
  821388
  822969
  817961
  539241
  525103
  534873
  507490
  574991
  584640
  558082
  580873
  543126
  662872
  671559
  671779
  680514
  710645
  720051
  647415
  711005
  716315
  668122
  669604
  721831
  551052
  581834
  613784
  591597
  611547
  612991
  629334
  605537
  606190
  636716
  785515
  791552
  776494
  785688
  788337
  796593
  796727
  801012
  807758
  808388
  811117
  812090
  735761
  739411
  761773
  782401
  784434
  788163
  791747
  795537
  751106
  767185
  766525
  767120
  732473
  759871
  761174
  750389
  630259
  713083
  774936
  776774
  778824
  785755
  787557
  800558
  808862
  212132
  313222
  213429
  445036
  13803
  212914
  585107
  537678
  525305
  514976
  556940
  661005
  622947
  796612
  796595
  808379
  766266
  610923
  384461
  539205
  716118
  446704
  30958
  441660
  757276
  522954
  578431
  736714
  445221
  671070
  508578
  651873
  406425
  649507
  665595
  696601
]
2.17 ms
(1.43%)
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
  13803
  30958
  212132
  212914
  213429
  313222
  321858
  384461
  389838
  390899
  406425
  408734
  441660
  445036
  445221
  446704
  507490
  508578
  514976
  522954
  525103
  525305
  534873
  537678
  539205
  539241
  543126
  551052
  556940
  558082
  574991
  578431
  580873
  581834
  584640
  585107
  591597
  605537
  606190
  610923
  611547
  612991
  613784
  622947
  629334
  630259
  636716
  647415
  649507
  651873
  661005
  662872
  665595
  668122
  669604
  671070
  671559
  671779
  680514
  696601
  710645
  711005
  713083
  716118
  716315
  720051
  721831
  732473
  735761
  736714
  739411
  750389
  751106
  757276
  759871
  761174
  761773
  766266
  767120
  767185
  774936
  776774
  778824
  782401
  784434
  785515
  785688
  785755
  787557
  788163
  788337
  791552
  791747
  795537
  796593
  796595
  796612
  796727
  800558
  801012
  807758
  808379
  808388
  808862
  811117
  812090
  817062
  817100
  817961
  820347
  820760
  821180
  821329
  821388
  822551
  822969
  823336
]
1.76 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass babe"
]
1.68 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп babe"
]
1.59 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп babe"
]

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.