GET https://search.jues.net/search/embeds/7?q=%D0%BA%D1%80%D1%83%D0%B3%D0%BB%D0%B0%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
228.35 ms
(89.56%)
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
  65580
  404455
  415942
  419535
  420615
  422732
  423480
  436091
  441768
  449358
  449697
  452261
  453426
  453569
  453764
  453770
  454395
  455149
  455762
  456813
  456829
  458331
  459042
  461737
  464157
  464584
  464918
  467449
  468407
  471413
  474743
  477514
  478076
  478255
  478652
  479637
  480503
  480862
  482690
  482900
  487628
  488131
  490218
  490672
  491322
  493218
  493349
  494074
  495121
  495679
  496780
  499084
  501048
  506073
  506258
  507524
  510043
  510238
  510783
  510881
  511076
  511936
  511951
  512231
  512463
  515450
  515862
  516208
  516742
  516870
  517131
  519085
  519531
  520668
  521429
  522037
  522569
  524578
  524597
  525781
  529170
  529256
  529558
  534702
  537035
  538936
  543181
  543191
  543773
  545889
  552387
  552799
  559191
  559552
  560206
  564064
  565178
  565936
  570048
  571042
  572927
  579940
  579943
  582270
  585216
  586632
  588449
  589129
  589140
  589647
  591242
  591387
  599458
  608497
  625826
  626564
  647027
  669175
  675797
  813067
]
15.64 ms
(6.13%)
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
  499084
  510043
  520668
  537035
  538936
  494074
  495121
  516208
  516742
  519531
  464918
  468407
  480503
  545889
  559191
  570048
  572927
  543773
  552799
  564064
  565178
  543191
  559552
  565936
  571042
  647027
  669175
  675797
  552387
  560206
  579940
  579943
  582270
  586632
  589140
  589647
  591387
  608497
  585216
  589129
  588449
  591242
  599458
  626564
  625826
  813067
  441768
  453426
  453764
  453770
  456829
  458331
  464157
  471413
  420615
  478255
  480862
  404455
  436091
  455149
  455762
  456813
  461737
  464584
  474743
  415942
  419535
  423480
  449358
  459042
  467449
  478652
  449697
  477514
  478076
  510238
  515862
  487628
  488131
  493349
  495679
  496780
  501048
  506073
  511936
  511951
  522037
  525781
  529170
  482900
  491322
  493218
  510783
  510881
  512231
  512463
  521429
  522569
  524578
  524597
  529256
  490672
  506258
  507524
  511076
  515450
  516870
  517131
  519085
  529558
  534702
  65580
  422732
  543181
  482690
  454395
  479637
  490218
  452261
  453569
]
3.05 ms
(1.20%)
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
  65580
  404455
  415942
  419535
  420615
  422732
  423480
  436091
  441768
  449358
  449697
  452261
  453426
  453569
  453764
  453770
  454395
  455149
  455762
  456813
  456829
  458331
  459042
  461737
  464157
  464584
  464918
  467449
  468407
  471413
  474743
  477514
  478076
  478255
  478652
  479637
  480503
  480862
  482690
  482900
  487628
  488131
  490218
  490672
  491322
  493218
  493349
  494074
  495121
  495679
  496780
  499084
  501048
  506073
  506258
  507524
  510043
  510238
  510783
  510881
  511076
  511936
  511951
  512231
  512463
  515450
  515862
  516208
  516742
  516870
  517131
  519085
  519531
  520668
  521429
  522037
  522569
  524578
  524597
  525781
  529170
  529256
  529558
  534702
  537035
  538936
  543181
  543191
  543773
  545889
  552387
  552799
  559191
  559552
  560206
  564064
  565178
  565936
  570048
  571042
  572927
  579940
  579943
  582270
  585216
  586632
  588449
  589129
  589140
  589647
  591242
  591387
  599458
  608497
  625826
  626564
  647027
  669175
  675797
  813067
]
2.92 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кругл"
]
1.74 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кругл"
]
1.59 ms
(0.62%)
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.