GET https://search.jues.net/search/embeds/7?q=latina%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.28 ms
(86.29%)
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
  382140
  382186
  386531
  389813
  403928
  413161
  416791
  419220
  428300
  428653
  429188
  429266
  430709
  431504
  444337
  444414
  450321
  453548
  454092
  454605
  458390
  463810
  468369
  470412
  472536
  473166
  475465
  479779
  481591
  482195
  484532
  486288
  487359
  488811
  491749
  492247
  492275
  493269
  494438
  499860
  508942
  510241
  512471
  513894
  513910
  514105
  515123
  517180
  518465
  523654
  524596
  527686
  528324
  530850
  552252
  554275
  561451
  565678
  566138
  573941
  579761
  580221
  580225
  584990
  585366
  586244
  595803
  599637
  602548
  602636
  602967
  606649
  607704
  617360
  618525
  621343
  623250
  628758
  630909
  634515
  638040
  639774
  642525
  643960
  649789
  662633
  676313
  684096
  703472
  703494
  703642
  709260
  721187
  732074
  733317
  764869
  776611
  778393
  784275
  785624
  786526
  788828
  793042
  797075
  797439
  801234
  801668
  807599
  811005
  811062
  813520
  813881
  814313
  814781
  814878
  815159
  816803
  818119
  821365
]
17.02 ms
(8.43%)
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
  638040
  643960
  776611
  778393
  785624
  788828
  793042
  801668
  419220
  428300
  429188
  444414
  486288
  492275
  618525
  709260
  813881
  649789
  470412
  482195
  444337
  508942
  488811
  389813
  403928
  429266
  814313
  818119
  815159
  821365
  487359
  492247
  463810
  473166
  484532
  454605
  517180
  518465
  527686
  528324
  494438
  499860
  530850
  524596
  472536
  552252
  579761
  561451
  580221
  662633
  676313
  703642
  721187
  684096
  703494
  554275
  565678
  580225
  602548
  617360
  585366
  602636
  642525
  586244
  595803
  599637
  602967
  607704
  623250
  628758
  606649
  621343
  634515
  807599
  811062
  784275
  801234
  813520
  732074
  764869
  733317
  630909
  703472
  786526
  797439
  811005
  468369
  386531
  416791
  491749
  639774
  584990
  573941
  430709
  512471
  523654
  824638
  797075
  382140
  382186
  413161
  428653
  431504
  816803
  814781
  814878
  450321
  458390
  453548
  454092
  475465
  479779
  493269
  510241
  513910
  515123
  513894
  514105
  481591
  566138
]
3.25 ms
(1.61%)
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
  382140
  382186
  386531
  389813
  403928
  413161
  416791
  419220
  428300
  428653
  429188
  429266
  430709
  431504
  444337
  444414
  450321
  453548
  454092
  454605
  458390
  463810
  468369
  470412
  472536
  473166
  475465
  479779
  481591
  482195
  484532
  486288
  487359
  488811
  491749
  492247
  492275
  493269
  494438
  499860
  508942
  510241
  512471
  513894
  513910
  514105
  515123
  517180
  518465
  523654
  524596
  527686
  528324
  530850
  552252
  554275
  561451
  565678
  566138
  573941
  579761
  580221
  580225
  584990
  585366
  586244
  595803
  599637
  602548
  602636
  602967
  606649
  607704
  617360
  618525
  621343
  623250
  628758
  630909
  634515
  638040
  639774
  642525
  643960
  649789
  662633
  676313
  684096
  703472
  703494
  703642
  709260
  721187
  732074
  733317
  764869
  776611
  778393
  784275
  785624
  786526
  788828
  793042
  797075
  797439
  801234
  801668
  807599
  811005
  811062
  813520
  813881
  814313
  814781
  814878
  815159
  816803
  818119
  821365
]
2.03 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina hot"
]
1.88 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская hot"
]
1.76 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская hot"
]

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.