GET https://search.jues.net/search/embeds/10?q=russian%20riding

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.84 ms
(88.51%)
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
  53305
  80663
  197736
  233274
  233617
  322760
  366052
  382297
  382799
  386255
  388180
  388290
  391545
  391557
  391567
  391819
  396064
  398784
  404121
  419253
  423799
  423837
  424236
  426821
  427110
  432488
  432516
  432545
  432759
  433363
  433767
  433976
  434242
  436836
  437723
  439281
  441584
  441691
  456319
  456495
  459021
  460598
  461814
  462731
  463806
  466496
  469688
  470680
  473618
  475621
  477903
  477933
  479081
  479123
  479296
  479370
  479378
  481023
  481192
  481430
  482078
  482095
  485409
  485924
  486423
  487316
  488191
  491536
  492202
  496623
  498247
  499390
  501390
  503809
  504262
  504721
  507715
  508104
  508610
  509145
  509751
  511873
  512650
  518882
  520872
  535915
  538233
  546223
  549901
  549943
  552860
  556443
  558638
  558808
  561006
  561709
  570322
  570595
  570751
  571652
  571918
  572129
  573636
  573818
  573954
  576728
  592277
  598986
  655608
  794000
  794293
  794391
  795721
  797718
  803613
  804002
  804039
  804726
  806764
  809350
]
12.67 ms
(6.64%)
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
  794000
  794293
  794391
  795721
  797718
  803613
  804002
  804039
  804726
  806764
  809350
  382799
  197736
  391819
  386255
  538233
  432759
  441691
  466496
  479378
  496623
  509751
  518882
  558808
  561006
  573818
  570595
  572129
  570751
  571652
  571918
  382297
  388290
  391545
  404121
  432545
  462731
  53305
  391557
  391567
  459021
  463806
  479123
  479296
  396064
  398784
  424236
  437723
  477933
  233274
  419253
  423799
  426821
  434242
  436836
  503809
  509145
  511873
  485409
  487316
  504262
  504721
  486423
  499390
  498247
  512650
  535915
  233617
  433976
  592277
  549901
  549943
  432488
  423837
  469688
  479081
  481023
  475621
  485924
  488191
  507715
  482095
  492202
  556443
  573954
  552860
  570322
  655608
  546223
  558638
  561709
  573636
  576728
  598986
  80663
  366052
  432516
  439281
  441584
  473618
  477903
  433363
  433767
  456495
  479370
  322760
  388180
  481430
  482078
  461814
  470680
  427110
  456319
  460598
  481192
  491536
  501390
  508104
  508610
  520872
]
2.81 ms
(1.47%)
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
  53305
  80663
  197736
  233274
  233617
  322760
  366052
  382297
  382799
  386255
  388180
  388290
  391545
  391557
  391567
  391819
  396064
  398784
  404121
  419253
  423799
  423837
  424236
  426821
  427110
  432488
  432516
  432545
  432759
  433363
  433767
  433976
  434242
  436836
  437723
  439281
  441584
  441691
  456319
  456495
  459021
  460598
  461814
  462731
  463806
  466496
  469688
  470680
  473618
  475621
  477903
  477933
  479081
  479123
  479296
  479370
  479378
  481023
  481192
  481430
  482078
  482095
  485409
  485924
  486423
  487316
  488191
  491536
  492202
  496623
  498247
  499390
  501390
  503809
  504262
  504721
  507715
  508104
  508610
  509145
  509751
  511873
  512650
  518882
  520872
  535915
  538233
  546223
  549901
  549943
  552860
  556443
  558638
  558808
  561006
  561709
  570322
  570595
  570751
  571652
  571918
  572129
  573636
  573818
  573954
  576728
  592277
  598986
  655608
  794000
  794293
  794391
  795721
  797718
  803613
  804002
  804039
  804726
  806764
  809350
]
1.70 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск riding"
]
1.66 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск riding"
]
1.56 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian riding"
]

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.