GET https://search.jues.net/search/embeds/5?q=%D0%BB%D0%B5%D1%82%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.48 ms
(84.67%)
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
  7088
  392206
  393032
  396564
  397575
  398308
  400102
  400955
  401949
  402080
  402261
  413199
  414310
  417776
  419661
  422467
  423063
  423359
  424546
  426124
  427159
  429015
  429123
  429220
  434016
  435372
  437557
  437800
  446489
  446600
  447287
  453860
  454347
  454899
  455439
  458750
  461461
  461525
  461691
  475754
  475765
  487150
  487646
  493242
  495885
  499411
  512658
  529080
  530594
  538451
  538798
  562325
  563576
  603463
  624709
  643879
  677060
  680147
  703281
  721756
  728759
  729705
  730432
  730676
  731931
  732401
  735092
  735743
  737763
  739567
  740281
  741320
  742075
  742193
  744882
  746932
  748649
  749751
  750344
  751376
  754264
  755130
  755553
  755853
  756488
  757585
  760288
  761861
  762015
  764406
  766517
  772831
  773029
  773277
  777127
  779926
  780808
  782440
  785171
  785242
  787941
  789003
  790535
  791325
  791748
  794079
  795611
  797049
  797473
  797573
  802522
  802632
  804197
  804853
  804941
  807924
  810234
  812478
  814091
]
14.72 ms
(8.63%)
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
  779926
  785171
  791325
  794079
  797573
  782440
  787941
  797049
  802522
  807924
  729705
  730676
  742075
  744882
  750344
  751376
  766517
  790535
  791748
  797473
  810234
  731931
  732401
  735743
  740281
  749751
  755853
  757585
  761861
  762015
  773277
  735092
  737763
  748649
  754264
  755553
  760288
  764406
  739567
  742193
  772831
  773029
  728759
  730432
  741320
  746932
  755130
  756488
  603463
  624709
  643879
  703281
  706529
  721756
  777127
  780808
  785242
  789003
  795611
  802632
  804197
  804853
  804941
  812478
  413199
  461525
  398308
  426124
  434016
  455439
  7088
  392206
  402261
  454347
  458750
  427159
  453860
  512658
  495885
  396564
  422467
  563576
  677060
  680147
  562325
  429123
  446489
  447287
  461461
  446600
  487150
  493242
  393032
  397575
  400102
  401949
  400955
  402080
  423359
  429015
  414310
  424546
  435372
  437800
  423063
  417776
  419661
  429220
  437557
  814091
  454899
  461691
  475765
  487646
  475754
  529080
  499411
  530594
  538451
  538798
]
3.75 ms
(2.19%)
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
  7088
  392206
  393032
  396564
  397575
  398308
  400102
  400955
  401949
  402080
  402261
  413199
  414310
  417776
  419661
  422467
  423063
  423359
  424546
  426124
  427159
  429015
  429123
  429220
  434016
  435372
  437557
  437800
  446489
  446600
  447287
  453860
  454347
  454899
  455439
  458750
  461461
  461525
  461691
  475754
  475765
  487150
  487646
  493242
  495885
  499411
  512658
  529080
  530594
  538451
  538798
  562325
  563576
  603463
  624709
  643879
  677060
  680147
  703281
  721756
  728759
  729705
  730432
  730676
  731931
  732401
  735092
  735743
  737763
  739567
  740281
  741320
  742075
  742193
  744882
  746932
  748649
  749751
  750344
  751376
  754264
  755130
  755553
  755853
  756488
  757585
  760288
  761861
  762015
  764406
  766517
  772831
  773029
  773277
  777127
  779926
  780808
  782440
  785171
  785242
  787941
  789003
  790535
  791325
  791748
  794079
  795611
  797049
  797473
  797573
  802522
  802632
  804197
  804853
  804941
  807924
  810234
  812478
  814091
]
2.26 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лет"
]
1.96 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лет"
]
1.94 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лето"
]
1.54 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.