GET https://search.jues.net/search/embeds/3?q=compilation%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.63 ms
(84.35%)
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
  388567
  400732
  418215
  434401
  438035
  444197
  444243
  444594
  453366
  460937
  479926
  480043
  483030
  491171
  491741
  499964
  501482
  505379
  506156
  514048
  516489
  516501
  519324
  521697
  523286
  540253
  556886
  556901
  558226
  561166
  565013
  565676
  590493
  592009
  593181
  598139
  615386
  619901
  621289
  621665
  628596
  629540
  633480
  646980
  648079
  652273
  660454
  666439
  666447
  668530
  675821
  675839
  691479
  696455
  699494
  699518
  702311
  705101
  707175
  708194
  709764
  709914
  710905
  718891
  718919
  719207
  721042
  724797
  725187
  731062
  732156
  735911
  736106
  738812
  738818
  740231
  740815
  740961
  741515
  742072
  745949
  746587
  749405
  750666
  751252
  751702
  755191
  757576
  758237
  759675
  760568
  761645
  761834
  761913
  769296
  772827
  777567
  777639
  778619
  779015
  779089
  780683
  781146
  782137
  786570
  790523
  793613
  795062
  795979
  798856
  805733
  807464
  807845
  809583
  809634
  809638
  810736
  818763
  823817
  823911
]
15.27 ms
(9.50%)
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
  480043
  558226
  699518
  708194
  710905
  718891
  718919
  691479
  660454
  561166
  628596
  621289
  777567
  777639
  779015
  809634
  780683
  782137
  786570
  793613
  732156
  769296
  772827
  795062
  809583
  735911
  750666
  724797
  731062
  745949
  740231
  740961
  741515
  749405
  725187
  740815
  758237
  760568
  761834
  633480
  779089
  781146
  807845
  809638
  514048
  646980
  590493
  592009
  444594
  491171
  506156
  823911
  818763
  823817
  444197
  444243
  388567
  523286
  400732
  483030
  556886
  648079
  652273
  709764
  705101
  666439
  666447
  675839
  707175
  709914
  556901
  615386
  619901
  593181
  795979
  810736
  736106
  805733
  742072
  761913
  751702
  738818
  746587
  751252
  755191
  757576
  759675
  738812
  761645
  629540
  702311
  778619
  790523
  798856
  807464
  438035
  519324
  501482
  521697
  565676
  460937
  479926
  418215
  499964
  516489
  516501
  491741
  505379
  565013
  453366
  434401
  540253
  696455
  699494
  668530
  719207
  675821
  721042
  621665
  598139
]
2.96 ms
(1.84%)
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
  388567
  400732
  418215
  434401
  438035
  444197
  444243
  444594
  453366
  460937
  479926
  480043
  483030
  491171
  491741
  499964
  501482
  505379
  506156
  514048
  516489
  516501
  519324
  521697
  523286
  540253
  556886
  556901
  558226
  561166
  565013
  565676
  590493
  592009
  593181
  598139
  615386
  619901
  621289
  621665
  628596
  629540
  633480
  646980
  648079
  652273
  660454
  666439
  666447
  668530
  675821
  675839
  691479
  696455
  699494
  699518
  702311
  705101
  707175
  708194
  709764
  709914
  710905
  718891
  718919
  719207
  721042
  724797
  725187
  731062
  732156
  735911
  736106
  738812
  738818
  740231
  740815
  740961
  741515
  742072
  745949
  746587
  749405
  750666
  751252
  751702
  755191
  757576
  758237
  759675
  760568
  761645
  761834
  761913
  769296
  772827
  777567
  777639
  778619
  779015
  779089
  780683
  781146
  782137
  786570
  790523
  793613
  795062
  795979
  798856
  805733
  807464
  807845
  809583
  809634
  809638
  810736
  818763
  823817
  823911
]
1.98 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк русск"
]
1.89 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation russian"
]
1.62 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк русск"
]
1.44 ms
(0.90%)
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.