GET https://search.jues.net/search/embeds/4?q=%D0%B4%D0%B5%D0%BB%D0%B8%D1%82%D1%81%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.37 ms
(87.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
  91891
  97571
  213273
  385285
  391722
  391833
  404247
  409725
  412603
  431487
  457631
  477784
  490193
  495379
  509155
  516627
  530032
  539700
  547228
  547972
  557049
  568340
  571836
  579793
  588023
  590907
  604589
  604679
  605626
  616470
  616555
  616916
  618753
  619275
  620453
  620563
  622323
  623322
  623987
  628293
  633832
  634271
  635636
  635842
  636510
  644331
  652617
  653612
  661262
  666782
  667323
  669628
  673048
  674733
  677143
  679037
  679040
  699428
  701139
  702299
  703059
  703432
  704231
  710263
  710492
  711643
  711956
  719057
  725122
  731805
  732805
  732819
  733324
  735855
  736693
  738653
  742188
  742691
  745250
  745378
  745723
  747269
  748219
  750454
  755447
  756877
  760017
  762382
  771959
  773352
  773966
  777813
  784979
  785381
  788281
  788859
  788884
  789541
  792337
  793337
  793630
  793915
  794509
  795173
  796148
  796964
  797440
  800709
  800730
  801473
  802823
  803776
  805339
  805565
  805959
  809580
  809689
  810718
  813420
  814440
]
12.94 ms
(6.82%)
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
  622323
  616916
  623322
  623987
  635842
  618753
  636510
  777813
  788884
  793915
  802823
  788859
  800730
  801473
  805959
  813420
  793630
  795173
  796148
  805565
  745378
  725122
  732819
  735855
  747269
  750454
  742188
  755447
  762382
  733324
  748219
  604589
  635636
  699428
  701139
  703059
  797440
  800709
  809580
  809689
  810718
  391833
  404247
  457631
  509155
  391722
  91891
  814440
  477784
  516627
  530032
  539700
  547972
  571836
  579793
  568340
  652617
  653612
  666782
  673048
  702299
  710492
  667323
  669628
  677143
  679037
  703432
  704231
  711956
  661262
  674733
  679040
  710263
  719057
  547228
  557049
  588023
  620563
  633832
  590907
  616555
  616470
  628293
  605626
  620453
  634271
  793337
  803776
  792337
  794509
  805339
  756877
  760017
  771959
  773966
  784979
  785381
  736693
  745250
  738653
  745723
  773352
  731805
  742691
  732805
  604679
  619275
  644331
  711643
  788281
  789541
  796964
  495379
  490193
  385285
  213273
  97571
  409725
  412603
  431487
]
3.09 ms
(1.63%)
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
  91891
  97571
  213273
  385285
  391722
  391833
  404247
  409725
  412603
  431487
  457631
  477784
  490193
  495379
  509155
  516627
  530032
  539700
  547228
  547972
  557049
  568340
  571836
  579793
  588023
  590907
  604589
  604679
  605626
  616470
  616555
  616916
  618753
  619275
  620453
  620563
  622323
  623322
  623987
  628293
  633832
  634271
  635636
  635842
  636510
  644331
  652617
  653612
  661262
  666782
  667323
  669628
  673048
  674733
  677143
  679037
  679040
  699428
  701139
  702299
  703059
  703432
  704231
  710263
  710492
  711643
  711956
  719057
  725122
  731805
  732805
  732819
  733324
  735855
  736693
  738653
  742188
  742691
  745250
  745378
  745723
  747269
  748219
  750454
  755447
  756877
  760017
  762382
  771959
  773352
  773966
  777813
  784979
  785381
  788281
  788859
  788884
  789541
  792337
  793337
  793630
  793915
  794509
  795173
  796148
  796964
  797440
  800709
  800730
  801473
  802823
  803776
  805339
  805565
  805959
  809580
  809689
  810718
  813420
  814440
]
2.28 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дел"
]
1.77 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дел"
]
1.68 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.