GET https://search.jues.net/search/embeds/6?q=facial%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
222.34 ms
(33.64%)
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
  403264
  403357
  424297
  425504
  433976
  442563
  443497
  447289
  453022
  453128
  453690
  455604
  456081
  458367
  459942
  461251
  463637
  470099
  478679
  486882
  488088
  488138
  496153
  497604
  499295
  502381
  504351
  505250
  506036
  509627
  512089
  512590
  520553
  524667
  525775
  527467
  534923
  539365
  545005
  555083
  555720
  559644
  560891
  561941
  564076
  565240
  565421
  567932
  569480
  569545
  571392
  574084
  576587
  579678
  581998
  586102
  591426
  593051
  593421
  594024
  594030
  594166
  595883
  596945
  597956
  599956
  602211
  604802
  605437
  606092
  617648
  621226
  621865
  630033
  648519
  662374
  679847
  704952
  708303
  709181
  711561
  711569
  716613
  716660
  717274
  717665
  723131
  724604
  725339
  726882
  728458
  742694
  751715
  756803
  757455
  763279
  763309
  764298
  764675
  775127
  775487
  777322
  781573
  782427
  785238
  785718
  789055
  790320
  792396
  793435
  793581
  796206
  797570
  801341
  803589
  804817
  805739
  806271
  810492
  811993
]
209.87 ms
(31.75%)
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
  403264
  403357
  424297
  425504
  433976
  442563
  443497
  447289
  453022
  453128
  453690
  455604
  456081
  458367
  459942
  461251
  463637
  470099
  478679
  486882
  488088
  488138
  496153
  497604
  499295
  502381
  504351
  505250
  506036
  509627
  512089
  512590
  520553
  524667
  525775
  527467
  534923
  539365
  545005
  555083
  555720
  559644
  560891
  561941
  564076
  565240
  565421
  567932
  569480
  569545
  571392
  574084
  576587
  579678
  581998
  586102
  591426
  593051
  593421
  594024
  594030
  594166
  595883
  596945
  597956
  599956
  602211
  604802
  605437
  606092
  617648
  621226
  621865
  630033
  648519
  662374
  679847
  704952
  708303
  709181
  711561
  711569
  716613
  716660
  717274
  717665
  723131
  724604
  725339
  726882
  728458
  742694
  751715
  756803
  757455
  763279
  763309
  764298
  764675
  775127
  775487
  777322
  781573
  782427
  785238
  785718
  789055
  790320
  792396
  793435
  793581
  796206
  797570
  801341
  803589
  804817
  805739
  806271
  810492
  811993
]
207.82 ms
(31.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
15.09 ms
(2.28%)
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
  711561
  579678
  581998
  602211
  591426
  630033
  781573
  790320
  792396
  797570
  804817
  789055
  793435
  757455
  785238
  793581
  796206
  801341
  725339
  724604
  751715
  764675
  763279
  763309
  764298
  709181
  775127
  782427
  785718
  803589
  810492
  461251
  478679
  459942
  442563
  496153
  509627
  488138
  525775
  527467
  499295
  756803
  512089
  561941
  453128
  555720
  593421
  621226
  621865
  594030
  594166
  604802
  594024
  597956
  425504
  443497
  534923
  576587
  567932
  571392
  679847
  648519
  708303
  565421
  593051
  606092
  617648
  777322
  453690
  520553
  403357
  488088
  453022
  458367
  456081
  486882
  497604
  506036
  512590
  502381
  539365
  545005
  555083
  569480
  564076
  559644
  569545
  662374
  716613
  717274
  723131
  704952
  711569
  716660
  717665
  560891
  565240
  574084
  605437
  599956
  586102
  595883
  596945
  806271
  805739
  728458
  726882
  742694
  775487
  811993
  433976
  463637
  455604
  470099
  403264
  424297
  447289
  524667
  504351
  505250
]
2.23 ms
(0.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "facial домашн любительск"
]
1.96 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facial homemade"
]
1.65 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "facial домашн любительск"
]

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.