GET https://search.jues.net/search/embeds/8?q=hot%20ass%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.87 ms
(79.79%)
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
  11718
  188655
  365735
  384275
  385343
  392843
  395862
  402458
  402659
  403725
  414710
  415177
  425861
  427246
  428045
  432542
  433946
  435747
  436393
  437668
  444470
  445531
  448661
  449358
  453471
  454092
  454836
  456056
  459072
  459496
  461133
  463687
  464202
  464210
  467992
  468398
  468559
  468706
  468899
  469020
  473134
  474044
  476975
  477007
  480017
  482338
  489299
  491026
  493258
  500789
  509824
  510881
  512878
  513371
  514768
  516693
  518619
  519573
  521764
  525588
  527759
  527882
  530850
  537887
  538638
  564416
  566939
  569217
  571031
  581916
  595458
  596391
  603792
  609900
  613183
  618858
  619975
  620398
  621081
  621759
  625171
  636553
  637492
  644244
  652913
  665930
  677400
  699631
  707840
  710308
  710531
  720273
  721088
  726663
  727668
  731681
  745478
  749462
  750325
  755921
  757467
  758587
  761598
  761717
  776126
  778393
  784158
  791048
  800533
  801896
  802314
  809512
  810899
  811850
  812054
  817446
  818581
  823519
  824130
  824791
]
22.69 ms
(14.27%)
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
  595458
  621759
  810899
  809512
  432542
  433946
  459072
  415177
  437668
  444470
  456056
  527759
  493258
  513371
  519573
  525588
  510881
  518619
  491026
  509824
  414710
  188655
  621081
  812054
  500789
  530850
  699631
  619975
  776126
  800533
  761598
  750325
  721088
  824791
  448661
  445531
  461133
  566939
  392843
  707840
  514768
  435747
  817446
  824130
  823519
  512878
  527882
  538638
  521764
  564416
  571031
  652913
  665930
  677400
  710308
  720273
  618858
  636553
  637492
  596391
  613183
  802314
  755921
  726663
  731681
  761717
  758587
  745478
  749462
  757467
  778393
  811850
  468899
  474044
  463687
  468559
  427246
  395862
  402458
  425861
  453471
  482338
  476975
  454092
  464202
  537887
  581916
  436393
  449358
  402659
  468398
  468706
  473134
  603792
  727668
  11718
  459496
  477007
  384275
  480017
  467992
  403725
  644244
  625171
  784158
  791048
  428045
  620398
  516693
  469020
  454836
  464210
  489299
  385343
  365735
  818581
  569217
  609900
  801896
  710531
]
2.63 ms
(1.66%)
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
  11718
  188655
  365735
  384275
  385343
  392843
  395862
  402458
  402659
  403725
  414710
  415177
  425861
  427246
  428045
  432542
  433946
  435747
  436393
  437668
  444470
  445531
  448661
  449358
  453471
  454092
  454836
  456056
  459072
  459496
  461133
  463687
  464202
  464210
  467992
  468398
  468559
  468706
  468899
  469020
  473134
  474044
  476975
  477007
  480017
  482338
  489299
  491026
  493258
  500789
  509824
  510881
  512878
  513371
  514768
  516693
  518619
  519573
  521764
  525588
  527759
  527882
  530850
  537887
  538638
  564416
  566939
  569217
  571031
  581916
  595458
  596391
  603792
  609900
  613183
  618858
  619975
  620398
  621081
  621759
  625171
  636553
  637492
  644244
  652913
  665930
  677400
  699631
  707840
  710308
  710531
  720273
  721088
  726663
  727668
  731681
  745478
  749462
  750325
  755921
  757467
  758587
  761598
  761717
  776126
  778393
  784158
  791048
  800533
  801896
  802314
  809512
  810899
  811850
  812054
  817446
  818581
  823519
  824130
  824791
]
2.05 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot ass anal"
]
1.76 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot жоп анал"
]
1.53 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot жоп анал"
]
1.47 ms
(0.92%)
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.