GET https://search.jues.net/search/embeds/6?q=brunette%20boobs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.09 ms
(82.85%)
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
  3699
  11177
  17216
  34201
  61789
  73218
  105224
  151132
  152655
  178567
  185049
  185332
  191420
  197982
  230399
  310742
  381949
  381999
  382488
  382554
  384556
  384594
  385360
  386545
  387125
  388390
  389976
  398098
  398865
  398911
  398995
  400531
  400619
  401250
  401352
  401451
  403414
  410026
  410963
  412605
  413779
  413870
  416455
  419616
  420919
  426365
  430455
  430943
  453315
  454410
  460707
  467143
  468002
  474953
  476366
  478356
  482590
  490931
  511316
  523146
  524476
  529804
  544974
  545292
  561697
  567383
  567822
  573463
  596830
  598628
  598964
  607444
  618675
  618678
  618712
  622138
  663230
  663427
  664288
  664472
  667644
  675404
  690020
  696497
  697449
  702615
  708701
  712884
  727588
  730757
  731428
  739780
  743788
  749583
  752604
  755989
  756237
  758332
  773463
  775835
  777169
  778745
  788364
  790312
  790671
  792195
  804353
  807393
  808108
  808446
  809297
  809411
  810449
  810578
  814045
  814363
  815369
  821521
  822705
  823521
]
16.64 ms
(10.60%)
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
  381999
  474953
  386545
  105224
  185049
  185332
  191420
  310742
  382488
  73218
  61789
  34201
  3699
  17216
  389976
  387125
  398098
  398995
  430455
  410963
  420919
  426365
  410026
  413779
  814045
  822705
  814363
  815369
  453315
  460707
  482590
  454410
  523146
  468002
  561697
  664472
  675404
  696497
  708701
  712884
  663230
  697449
  598628
  596830
  618712
  622138
  598964
  788364
  809297
  775835
  777169
  778745
  792195
  808446
  809411
  810449
  810578
  730757
  756237
  790671
  731428
  739780
  743788
  755989
  773463
  727588
  758332
  618675
  790312
  804353
  808108
  151132
  152655
  400619
  403414
  430943
  197982
  398865
  401451
  412605
  382554
  384594
  416455
  178567
  230399
  385360
  400531
  401250
  401352
  419616
  476366
  511316
  398911
  823521
  821521
  524476
  529804
  544974
  702615
  618678
  752604
  807393
  749583
  607444
  381949
  384556
  11177
  388390
  413870
  478356
  490931
  467143
  545292
  567383
  567822
  573463
  663427
  667644
  690020
  664288
]
3.21 ms
(2.05%)
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
  3699
  11177
  17216
  34201
  61789
  73218
  105224
  151132
  152655
  178567
  185049
  185332
  191420
  197982
  230399
  310742
  381949
  381999
  382488
  382554
  384556
  384594
  385360
  386545
  387125
  388390
  389976
  398098
  398865
  398911
  398995
  400531
  400619
  401250
  401352
  401451
  403414
  410026
  410963
  412605
  413779
  413870
  416455
  419616
  420919
  426365
  430455
  430943
  453315
  454410
  460707
  467143
  468002
  474953
  476366
  478356
  482590
  490931
  511316
  523146
  524476
  529804
  544974
  545292
  561697
  567383
  567822
  573463
  596830
  598628
  598964
  607444
  618675
  618678
  618712
  622138
  663230
  663427
  664288
  664472
  667644
  675404
  690020
  696497
  697449
  702615
  708701
  712884
  727588
  730757
  731428
  739780
  743788
  749583
  752604
  755989
  756237
  758332
  773463
  775835
  777169
  778745
  788364
  790312
  790671
  792195
  804353
  807393
  808108
  808446
  809297
  809411
  810449
  810578
  814045
  814363
  815369
  821521
  822705
  823521
]
1.88 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette boobs"
]
1.84 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая boobs"
]
1.76 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая boobs"
]
1.58 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.