GET https://search.jues.net/search/embeds/4?q=interracial%20compilation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.53 ms
(79.56%)
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
  14225
  33459
  80360
  81412
  81641
  209664
  337190
  382468
  386596
  387777
  387937
  388519
  389700
  391428
  397503
  405468
  411118
  417998
  421260
  422734
  423708
  425773
  425829
  427241
  429768
  437511
  443945
  447640
  448813
  449018
  449353
  451262
  453737
  454540
  455847
  457373
  458907
  459254
  461714
  463798
  463825
  464658
  465070
  467601
  469616
  472286
  473831
  474546
  476195
  476828
  478110
  478603
  483756
  484411
  488894
  488897
  491270
  492535
  493203
  497725
  498551
  522140
  522846
  525725
  527428
  527452
  531603
  531698
  535878
  540537
  542578
  543224
  545621
  545829
  545857
  554358
  554770
  565242
  571015
  585960
  593075
  602984
  604061
  604516
  605499
  605548
  605581
  606501
  606693
  610620
  616337
  616341
  626792
  627601
  629868
  632137
  633171
  636539
  637207
  641330
  644453
  671374
  673472
  683237
  690884
  694553
  696241
  697589
  697912
  700824
  732858
  737303
  742443
  763396
  769400
  788262
  796094
  805112
  805164
  817131
]
21.71 ms
(13.76%)
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
  497725
  473831
  337190
  80360
  81412
  388519
  457373
  571015
  671374
  696241
  616337
  593075
  626792
  742443
  732858
  763396
  632137
  81641
  411118
  469616
  498551
  33459
  474546
  465070
  472286
  525725
  527428
  476195
  554358
  606501
  604061
  585960
  451262
  483756
  492535
  605499
  788262
  391428
  423708
  422734
  478110
  453737
  493203
  454540
  484411
  522140
  542578
  769400
  443945
  478603
  455847
  386596
  461714
  425773
  488897
  522846
  527452
  14225
  387777
  397503
  421260
  417998
  449018
  449353
  540537
  531698
  531603
  697589
  700824
  606693
  604516
  637207
  629868
  627601
  488894
  437511
  429768
  476828
  448813
  554770
  545621
  683237
  545829
  602984
  605548
  389700
  425829
  458907
  491270
  817131
  535878
  464658
  467601
  543224
  545857
  565242
  690884
  694553
  673472
  697912
  633171
  610620
  636539
  605581
  616341
  805112
  805164
  796094
  737303
  641330
  644453
  382468
  459254
  209664
  387937
  405468
  427241
  463798
  447640
  463825
]
3.11 ms
(1.97%)
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
  14225
  33459
  80360
  81412
  81641
  209664
  337190
  382468
  386596
  387777
  387937
  388519
  389700
  391428
  397503
  405468
  411118
  417998
  421260
  422734
  423708
  425773
  425829
  427241
  429768
  437511
  443945
  447640
  448813
  449018
  449353
  451262
  453737
  454540
  455847
  457373
  458907
  459254
  461714
  463798
  463825
  464658
  465070
  467601
  469616
  472286
  473831
  474546
  476195
  476828
  478110
  478603
  483756
  484411
  488894
  488897
  491270
  492535
  493203
  497725
  498551
  522140
  522846
  525725
  527428
  527452
  531603
  531698
  535878
  540537
  542578
  543224
  545621
  545829
  545857
  554358
  554770
  565242
  571015
  585960
  593075
  602984
  604061
  604516
  605499
  605548
  605581
  606501
  606693
  610620
  616337
  616341
  626792
  627601
  629868
  632137
  633171
  636539
  637207
  641330
  644453
  671374
  673472
  683237
  690884
  694553
  696241
  697589
  697912
  700824
  732858
  737303
  742443
  763396
  769400
  788262
  796094
  805112
  805164
  817131
]
1.93 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов подборк"
]
1.89 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial compilation"
]
1.85 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.12%)
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.