GET https://search.jues.net/search/embeds/4?q=mother%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.98 ms
(86.93%)
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
  4205
  188031
  382203
  385661
  390760
  392076
  401374
  413008
  413098
  432700
  435549
  443920
  452995
  458203
  471022
  471130
  472108
  475431
  485283
  485334
  486243
  495211
  499885
  499918
  499924
  513642
  514875
  516458
  519593
  535322
  537371
  538760
  539557
  545042
  550553
  550973
  554983
  554991
  560028
  575336
  589333
  591924
  595166
  596389
  600940
  601872
  605710
  607296
  619684
  624688
  624751
  641386
  647111
  651223
  664217
  669890
  669897
  672734
  692740
  699313
  702375
  702864
  705451
  706905
  711415
  712580
  715797
  734826
  739946
  739967
  741786
  742293
  742297
  742327
  742342
  745462
  745872
  746593
  749129
  752532
  752619
  753666
  756411
  761116
  762994
  765612
  766381
  769122
  776264
  776829
  781299
  782272
  783882
  787521
  790668
  790781
  791075
  794403
  795721
  795731
  797040
  798431
  799197
  800551
  800807
  800825
  802999
  804000
  804536
  804767
  805290
  806822
  807567
  809640
  810149
  810797
  819231
  823584
  825384
  825404
]
13.83 ms
(7.86%)
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
  702375
  711415
  804000
  435549
  401374
  485334
  766381
  452995
  799197
  741786
  756411
  699313
  794403
  499924
  486243
  705451
  607296
  776829
  761116
  715797
  806822
  537371
  624688
  795731
  790781
  413098
  471130
  825384
  825404
  458203
  514875
  550553
  560028
  550973
  651223
  647111
  669890
  672734
  692740
  702864
  664217
  669897
  706905
  619684
  595166
  591924
  641386
  589333
  600940
  601872
  790668
  791075
  797040
  798431
  802999
  804767
  742293
  746593
  769122
  781299
  804536
  805290
  809640
  810149
  810797
  734826
  752532
  753666
  739967
  745872
  795721
  800825
  4205
  382203
  443920
  188031
  413008
  485283
  516458
  596389
  385661
  499918
  783882
  782272
  554983
  745462
  712580
  392076
  432700
  471022
  495211
  513642
  823584
  538760
  539557
  624751
  776264
  800551
  800807
  742327
  749129
  762994
  765612
  742297
  742342
  752619
  787521
  519593
  475431
  499885
  739946
  390760
  819231
  472108
  535322
  545042
  575336
  554991
  605710
  807567
]
3.06 ms
(1.74%)
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
  4205
  188031
  382203
  385661
  390760
  392076
  401374
  413008
  413098
  432700
  435549
  443920
  452995
  458203
  471022
  471130
  472108
  475431
  485283
  485334
  486243
  495211
  499885
  499918
  499924
  513642
  514875
  516458
  519593
  535322
  537371
  538760
  539557
  545042
  550553
  550973
  554983
  554991
  560028
  575336
  589333
  591924
  595166
  596389
  600940
  601872
  605710
  607296
  619684
  624688
  624751
  641386
  647111
  651223
  664217
  669890
  669897
  672734
  692740
  699313
  702375
  702864
  705451
  706905
  711415
  712580
  715797
  734826
  739946
  739967
  741786
  742293
  742297
  742327
  742342
  745462
  745872
  746593
  749129
  752532
  752619
  753666
  756411
  761116
  762994
  765612
  766381
  769122
  776264
  776829
  781299
  782272
  783882
  787521
  790668
  790781
  791075
  794403
  795721
  795731
  797040
  798431
  799197
  800551
  800807
  800825
  802999
  804000
  804536
  804767
  805290
  806822
  807567
  809640
  810149
  810797
  819231
  823584
  825384
  825404
]
1.97 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother dildo"
]
1.51 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин дилд"
]
1.41 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.23 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.