GET https://search.jues.net/search/embeds/7?q=retro%20boobs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.56 ms
(81.49%)
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
  475682
  524951
  538912
  538937
  541589
  541637
  543502
  544249
  544318
  544571
  544586
  544855
  546776
  549764
  549784
  550317
  550320
  551939
  554351
  557511
  558004
  559057
  559066
  561993
  563419
  564467
  566371
  567388
  567932
  571441
  573761
  574265
  576680
  576683
  579304
  581274
  581394
  582342
  586919
  589692
  589817
  590696
  590928
  591641
  591678
  592003
  592390
  592438
  592453
  592486
  592636
  595735
  597031
  606290
  615255
  615565
  617648
  620163
  620170
  621308
  621698
  622364
  622378
  623934
  624789
  638631
  644301
  644314
  644359
  646336
  649091
  649191
  649196
  650853
  651604
  661903
  664157
  670274
  671713
  671739
  671741
  671756
  671757
  671763
  672372
  672742
  677707
  677730
  681782
  683297
  684030
  690822
  690868
  691992
  692315
  692786
  692812
  693030
  694179
  694181
  694374
  696351
  697229
  698457
  699596
  703540
  709624
  716244
  716746
  717862
  717873
  720379
  720726
  721834
  722211
  784247
  784358
  790827
  801322
  817298
]
19.05 ms
(12.46%)
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
  716746
  721834
  790827
  801322
  524951
  621698
  582342
  817298
  475682
  538912
  538937
  543502
  544318
  544571
  544855
  549784
  581274
  541589
  541637
  544586
  550320
  557511
  559057
  563419
  564467
  573761
  576680
  576683
  544249
  551939
  554351
  558004
  559066
  566371
  567388
  567932
  571441
  574265
  581394
  649191
  661903
  664157
  671756
  671763
  672372
  672742
  677707
  690822
  694181
  699596
  717862
  646336
  649196
  650853
  670274
  671739
  690868
  691992
  693030
  694179
  696351
  698457
  709624
  716244
  717873
  720726
  649091
  651604
  671713
  671741
  671757
  677730
  681782
  683297
  684030
  692315
  692786
  692812
  694374
  697229
  703540
  720379
  722211
  546776
  549764
  550317
  561993
  579304
  591641
  592390
  592453
  592486
  595735
  622378
  589817
  590928
  592003
  615565
  622364
  624789
  644359
  591678
  592438
  592636
  615255
  617648
  620170
  621308
  623934
  644314
  586919
  589692
  590696
  597031
  606290
  620163
  638631
  644301
  784247
  784358
]
2.47 ms
(1.62%)
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
  475682
  524951
  538912
  538937
  541589
  541637
  543502
  544249
  544318
  544571
  544586
  544855
  546776
  549764
  549784
  550317
  550320
  551939
  554351
  557511
  558004
  559057
  559066
  561993
  563419
  564467
  566371
  567388
  567932
  571441
  573761
  574265
  576680
  576683
  579304
  581274
  581394
  582342
  586919
  589692
  589817
  590696
  590928
  591641
  591678
  592003
  592390
  592438
  592453
  592486
  592636
  595735
  597031
  606290
  615255
  615565
  617648
  620163
  620170
  621308
  621698
  622364
  622378
  623934
  624789
  638631
  644301
  644314
  644359
  646336
  649091
  649191
  649196
  650853
  651604
  661903
  664157
  670274
  671713
  671739
  671741
  671756
  671757
  671763
  672372
  672742
  677707
  677730
  681782
  683297
  684030
  690822
  690868
  691992
  692315
  692786
  692812
  693030
  694179
  694181
  694374
  696351
  697229
  698457
  699596
  703540
  709624
  716244
  716746
  717862
  717873
  720379
  720726
  721834
  722211
  784247
  784358
  790827
  801322
  817298
]
1.92 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro boobs"
]
1.70 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр boobs"
]
1.58 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр boobs"
]
1.55 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.