GET https://search.jues.net/search/embeds/5?q=%D1%82%D1%83%D1%82%20%D0%BE%D0%BD%204%20%D0%BA

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
412.90 ms
(64.89%)
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
  358596
  379604
  382893
  383058
  392534
  401629
  404732
  407797
  429764
  457629
  480740
  484700
  486483
  490304
  511336
  516313
  519905
  522858
  530387
  530788
  530791
  530796
  530805
  532345
  532756
  533593
  534985
  535644
  536262
  536588
  537903
  537908
  537910
  541856
  545608
  546030
  554743
  555291
  557449
  559187
  565243
  575661
  587757
  590411
  590437
  591804
  592533
  596643
  600215
  601150
  601569
  601600
  601641
  603247
  603259
  603680
  604058
  604344
  606763
  622953
  623619
  625412
  628086
  628366
  628392
  628405
  630526
  631171
  631192
  631212
  634185
  637100
  637438
  638391
  640755
  640761
  640763
  641950
  642359
  642751
  643013
  643122
  646432
  647328
  647877
  649595
  649970
  650161
  650175
  650188
  651753
  668534
  670959
  675657
  676097
  677295
  678028
  678073
  678121
  679034
  679773
  679803
  690783
  690899
  703831
  703832
  707322
  713192
  718798
  733870
  755176
  775797
  786552
  790204
  796997
  812320
  814175
  824324
  828255
  828643
]
204.57 ms
(32.15%)
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
  358596
  379604
  382893
  383058
  392534
  401629
  404732
  407797
  429764
  457629
  480740
  484700
  486483
  490304
  511336
  516313
  519905
  522858
  530387
  530788
  530791
  530796
  530805
  532345
  532756
  533593
  534985
  535644
  536262
  536588
  537903
  537908
  537910
  541856
  545608
  546030
  554743
  555291
  557449
  559187
  565243
  575661
  587757
  590411
  590437
  591804
  592533
  596643
  600215
  601150
  601569
  601600
  601641
  603247
  603259
  603680
  604058
  604344
  606763
  622953
  623619
  625412
  628086
  628366
  628392
  628405
  630526
  631171
  631192
  631212
  634185
  637100
  637438
  638391
  640755
  640761
  640763
  641950
  642359
  642751
  643013
  643122
  646432
  647328
  647877
  649595
  649970
  650161
  650175
  650188
  651753
  668534
  670959
  675657
  676097
  677295
  678028
  678073
  678121
  679034
  679773
  679803
  690783
  690899
  703831
  703832
  707322
  713192
  718798
  733870
  755176
  775797
  786552
  790204
  796997
  812320
  814175
  824324
  828255
  828643
]
12.67 ms
(1.99%)
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
  480740
  486483
  650161
  677295
  679773
  690783
  713192
  679803
  707322
  646432
  647328
  675657
  546030
  601569
  640761
  641950
  623619
  637438
  642359
  596643
  643122
  591804
  592533
  601641
  631192
  775797
  812320
  755176
  604344
  643013
  703832
  796997
  358596
  401629
  533593
  382893
  379604
  383058
  392534
  828643
  404732
  407797
  429764
  814175
  457629
  490304
  522858
  537908
  511336
  519905
  530387
  534985
  535644
  530788
  537910
  557449
  565243
  650175
  718798
  678028
  678073
  678121
  679034
  690899
  649595
  670959
  554743
  631171
  634185
  587757
  622953
  600215
  628086
  628392
  640755
  590437
  606763
  640763
  786552
  484700
  516313
  828255
  651753
  603680
  824324
  638391
  790204
  530796
  532345
  532756
  530791
  536262
  536588
  537903
  530805
  575661
  541856
  559187
  545608
  555291
  647877
  649970
  650188
  668534
  703831
  676097
  603259
  590411
  601600
  628405
  601150
  604058
  628366
  642751
  625412
  630526
  631212
  637100
  733870
  603247
]
1.66 ms
(0.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "четыр"
]
1.61 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тут он 4 к"
]
1.24 ms
(0.20%)
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.