GET https://search.jues.net/search/embeds/3?q=%D1%85%D1%83%D0%B9%20%D0%B7%D0%B0%20%D1%89%D0%B5%D0%BA%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.99 ms
(82.87%)
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
  24724
  30533
  79962
  213692
  385745
  388630
  389211
  391493
  396567
  398812
  399209
  399717
  408284
  412095
  421569
  422184
  424457
  424923
  426466
  431422
  433699
  439745
  442501
  444073
  444249
  445408
  446800
  448749
  449717
  451988
  452170
  453374
  453469
  453473
  453776
  454961
  457438
  457444
  459988
  460100
  460309
  461424
  465248
  465844
  466046
  467316
  468049
  468825
  469453
  470335
  470375
  470492
  471459
  471897
  473020
  473923
  474091
  475724
  475927
  477727
  480012
  483036
  483223
  485790
  486332
  490172
  491407
  496674
  497264
  497917
  498425
  501548
  506081
  508673
  512320
  512538
  515454
  516748
  517237
  519676
  520248
  522441
  524637
  537257
  538270
  546794
  551313
  554518
  556808
  559132
  561998
  566272
  566566
  567139
  568589
  573759
  578219
  584634
  591056
  591235
  594490
  596627
  597975
  598785
  599290
  601327
  601891
  602672
  605359
  605996
  610303
  611892
  617056
  617117
  624131
  628426
  654315
  657004
  679076
  689013
]
20.74 ms
(11.16%)
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
  453473
  385745
  454961
  468049
  516748
  524637
  424923
  452170
  461424
  459988
  471459
  466046
  519676
  490172
  496674
  485790
  498425
  475724
  439745
  522441
  474091
  473020
  389211
  426466
  457444
  424457
  444073
  422184
  442501
  453469
  477727
  470335
  517237
  491407
  470375
  475927
  520248
  497264
  512320
  399209
  421569
  449717
  457438
  506081
  431422
  465844
  515454
  408284
  445408
  657004
  605359
  537257
  546794
  584634
  601891
  486332
  568589
  473923
  602672
  467316
  399717
  654315
  79962
  512538
  554518
  601327
  551313
  594490
  617117
  559132
  566566
  611892
  213692
  444249
  391493
  465248
  468825
  598785
  599290
  497917
  398812
  573759
  469453
  567139
  679076
  556808
  610303
  617056
  591056
  388630
  597975
  596627
  561998
  566272
  578219
  412095
  483036
  24724
  453374
  460309
  448749
  480012
  460100
  470492
  433699
  446800
  471897
  396567
  451988
  453776
  689013
  30533
  483223
  591235
  624131
  628426
  501548
  605996
  538270
  508673
]
3.99 ms
(2.15%)
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
  24724
  30533
  79962
  213692
  385745
  388630
  389211
  391493
  396567
  398812
  399209
  399717
  408284
  412095
  421569
  422184
  424457
  424923
  426466
  431422
  433699
  439745
  442501
  444073
  444249
  445408
  446800
  448749
  449717
  451988
  452170
  453374
  453469
  453473
  453776
  454961
  457438
  457444
  459988
  460100
  460309
  461424
  465248
  465844
  466046
  467316
  468049
  468825
  469453
  470335
  470375
  470492
  471459
  471897
  473020
  473923
  474091
  475724
  475927
  477727
  480012
  483036
  483223
  485790
  486332
  490172
  491407
  496674
  497264
  497917
  498425
  501548
  506081
  508673
  512320
  512538
  515454
  516748
  517237
  519676
  520248
  522441
  524637
  537257
  538270
  546794
  551313
  554518
  556808
  559132
  561998
  566272
  566566
  567139
  568589
  573759
  578219
  584634
  591056
  591235
  594490
  596627
  597975
  598785
  599290
  601327
  601891
  602672
  605359
  605996
  610303
  611892
  617056
  617117
  624131
  628426
  654315
  657004
  679076
  689013
]
2.15 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хуй за щеку"
]
1.81 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член щек"
]
1.65 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член щек"
]
1.48 ms
(0.80%)
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.