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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.80 ms
(85.26%)
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
  460903
  473242
  519268
  522915
  525462
  538915
  541292
  541329
  541336
  541602
  541620
  541674
  541725
  541728
  541781
  542190
  542969
  543477
  546621
  547607
  549768
  549771
  549779
  550232
  551916
  554321
  559061
  560080
  560085
  562826
  562828
  563166
  563184
  563225
  563447
  563449
  564661
  566696
  567382
  567385
  567404
  567419
  567424
  567427
  567959
  570394
  572541
  573914
  574291
  576634
  576643
  576652
  576676
  576684
  576696
  576698
  576700
  576711
  576719
  577360
  580258
  580286
  581300
  583387
  584004
  589640
  591294
  592451
  592456
  592477
  603147
  605305
  605345
  606208
  615726
  615740
  615748
  615751
  619076
  619082
  619379
  619401
  619466
  619468
  620164
  621312
  621318
  621976
  622379
  622976
  622978
  623202
  624154
  626546
  628292
  628312
  628314
  644259
  644280
  644380
  648256
  648466
  649604
  652541
  670107
  671735
  674117
  692237
  693872
  694058
  695201
  699707
  699730
  702061
  703833
  704533
  707306
  711903
  727769
  801471
]
18.25 ms
(9.06%)
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
  592477
  606208
  620164
  644259
  615751
  619466
  621976
  626546
  644380
  727769
  699707
  704533
  519268
  693872
  541725
  542190
  563447
  572541
  543477
  560085
  567419
  576698
  541674
  570394
  580258
  584004
  692237
  567427
  644280
  563449
  648256
  619401
  628312
  622379
  615740
  615748
  562828
  541602
  576700
  525462
  576711
  703833
  554321
  567404
  592451
  699730
  652541
  580286
  622976
  622978
  628314
  702061
  801471
  577360
  560080
  538915
  541620
  542969
  574291
  576643
  547607
  564661
  566696
  541781
  546621
  549768
  563184
  563225
  567385
  567959
  576652
  576676
  707306
  648466
  649604
  671735
  694058
  711903
  670107
  695201
  549779
  550232
  563166
  567382
  576719
  619082
  619379
  623202
  628292
  605305
  615726
  619468
  589640
  621318
  624154
  619076
  621312
  473242
  460903
  522915
  576696
  541329
  551916
  559061
  567424
  583387
  674117
  549771
  573914
  576634
  576684
  592456
  603147
  541728
  541292
  541336
  562826
  581300
  605345
  591294
]
3.89 ms
(1.93%)
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
  460903
  473242
  519268
  522915
  525462
  538915
  541292
  541329
  541336
  541602
  541620
  541674
  541725
  541728
  541781
  542190
  542969
  543477
  546621
  547607
  549768
  549771
  549779
  550232
  551916
  554321
  559061
  560080
  560085
  562826
  562828
  563166
  563184
  563225
  563447
  563449
  564661
  566696
  567382
  567385
  567404
  567419
  567424
  567427
  567959
  570394
  572541
  573914
  574291
  576634
  576643
  576652
  576676
  576684
  576696
  576698
  576700
  576711
  576719
  577360
  580258
  580286
  581300
  583387
  584004
  589640
  591294
  592451
  592456
  592477
  603147
  605305
  605345
  606208
  615726
  615740
  615748
  615751
  619076
  619082
  619379
  619401
  619466
  619468
  620164
  621312
  621318
  621976
  622379
  622976
  622978
  623202
  624154
  626546
  628292
  628312
  628314
  644259
  644280
  644380
  648256
  648466
  649604
  652541
  670107
  671735
  674117
  692237
  693872
  694058
  695201
  699707
  699730
  702061
  703833
  704533
  707306
  711903
  727769
  801471
]
2.36 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro big ass"
]
2.00 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр большая большие жоп"
]
1.53 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр большая большие жоп"
]

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.