GET https://search.jues.net/search/embeds/2?q=dildo%20hairy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.02 ms
(86.24%)
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
  145706
  315244
  340635
  382207
  382813
  383869
  384271
  385690
  391371
  397973
  398112
  401978
  409016
  411009
  414595
  416000
  419292
  419619
  420299
  421257
  426283
  426301
  429860
  429886
  432884
  434349
  440641
  441040
  445950
  448795
  452363
  454793
  465125
  477500
  483522
  483745
  485661
  494293
  495737
  496842
  496999
  499919
  499927
  507243
  525839
  527503
  527536
  529617
  530428
  531347
  539639
  540032
  544912
  553769
  567508
  569315
  574377
  574391
  577038
  590370
  590730
  594143
  594491
  595538
  595591
  595975
  598692
  600144
  606254
  609887
  620957
  622658
  630254
  637347
  649372
  653388
  661424
  666160
  668305
  671094
  672754
  691558
  692722
  709128
  710280
  710878
  717660
  722681
  723877
  725153
  728635
  729069
  730309
  735931
  738468
  738469
  745874
  749493
  749588
  751706
  752755
  761430
  787238
  788529
  790711
  795816
  798759
  800657
  803510
  807827
  808125
  812467
  812540
  816102
  821359
  821964
  822969
  824351
  824531
  824630
]
16.20 ms
(7.80%)
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
  728635
  383869
  434349
  507243
  429860
  429886
  448795
  483522
  630254
  530428
  609887
  752755
  590730
  496842
  499927
  672754
  384271
  790711
  787238
  808125
  738469
  803510
  540032
  661424
  594491
  709128
  397973
  539639
  145706
  821964
  527536
  567508
  653388
  595975
  735931
  717660
  483745
  401978
  432884
  606254
  391371
  419292
  440641
  411009
  398112
  577038
  824351
  816102
  668305
  590370
  382813
  385690
  499919
  666160
  409016
  527503
  315244
  426301
  710280
  710878
  691558
  730309
  821359
  822969
  477500
  494293
  553769
  692722
  544912
  595591
  595538
  637347
  800657
  723877
  788529
  795816
  812467
  452363
  824531
  414595
  485661
  529617
  574377
  574391
  594143
  600144
  745874
  465125
  496999
  569315
  725153
  598692
  420299
  382207
  441040
  454793
  340635
  445950
  416000
  426283
  749588
  531347
  495737
  419619
  421257
  525839
  649372
  620957
  798759
  751706
  761430
  738468
  671094
  722681
  812540
  729069
  749493
  622658
  807827
  824630
]
4.65 ms
(2.24%)
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
  145706
  315244
  340635
  382207
  382813
  383869
  384271
  385690
  391371
  397973
  398112
  401978
  409016
  411009
  414595
  416000
  419292
  419619
  420299
  421257
  426283
  426301
  429860
  429886
  432884
  434349
  440641
  441040
  445950
  448795
  452363
  454793
  465125
  477500
  483522
  483745
  485661
  494293
  495737
  496842
  496999
  499919
  499927
  507243
  525839
  527503
  527536
  529617
  530428
  531347
  539639
  540032
  544912
  553769
  567508
  569315
  574377
  574391
  577038
  590370
  590730
  594143
  594491
  595538
  595591
  595975
  598692
  600144
  606254
  609887
  620957
  622658
  630254
  637347
  649372
  653388
  661424
  666160
  668305
  671094
  672754
  691558
  692722
  709128
  710280
  710878
  717660
  722681
  723877
  725153
  728635
  729069
  730309
  735931
  738468
  738469
  745874
  749493
  749588
  751706
  752755
  761430
  787238
  788529
  790711
  795816
  798759
  800657
  803510
  807827
  808125
  812467
  812540
  816102
  821359
  821964
  822969
  824351
  824531
  824630
]
2.34 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo hairy"
]
2.00 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд волосатая"
]
1.67 ms
(0.80%)
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.