GET https://search.jues.net/search/embeds/3?q=%D1%81%D0%BD%D1%8F%D1%82%D1%8C

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
253.54 ms
(90.75%)
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
  7753
  21255
  151180
  157493
  197345
  207775
  310708
  384904
  385380
  391694
  395951
  396331
  401986
  402219
  408701
  413092
  417173
  417203
  417754
  418099
  418869
  419563
  420382
  423676
  425586
  428823
  428850
  434113
  434136
  435658
  443918
  443929
  449352
  449694
  451518
  451855
  453620
  454664
  458003
  458609
  458800
  461475
  462513
  466692
  466892
  469716
  471999
  472087
  472795
  473460
  473809
  474763
  478518
  478937
  479996
  480201
  480275
  486310
  488697
  489288
  498051
  498500
  498907
  500149
  500852
  504559
  507844
  510920
  512343
  514453
  515046
  515512
  518318
  522834
  524473
  528965
  532104
  538521
  552211
  558859
  561703
  562313
  570355
  570367
  570521
  571557
  572125
  573008
  575160
  595981
  602430
  602564
  606106
  609402
  632833
  670908
  670928
  679455
  688153
  690688
  730800
  731019
  740915
  743687
  749359
  751511
  754209
  757439
  760992
  761592
  778541
  781611
  784408
  789810
  800304
  801799
  802857
  805133
  811238
  813583
]
16.13 ms
(5.78%)
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
  805133
  784408
  802857
  731019
  740915
  781611
  801799
  760992
  743687
  749359
  778541
  207775
  395951
  396331
  413092
  417754
  425586
  478937
  479996
  391694
  451518
  500149
  504559
  524473
  528965
  510920
  515512
  384904
  401986
  408701
  443929
  419563
  813583
  449352
  449694
  466692
  471999
  480201
  480275
  469716
  515046
  507844
  538521
  512343
  532104
  558859
  570355
  552211
  570521
  571557
  575160
  561703
  670928
  679455
  688153
  690688
  670908
  562313
  570367
  572125
  573008
  602430
  606106
  602564
  595981
  609402
  800304
  811238
  761592
  730800
  751511
  757439
  754209
  632833
  789810
  434113
  458800
  472795
  385380
  428823
  434136
  473809
  402219
  461475
  462513
  417173
  423676
  478518
  498500
  498907
  514453
  486310
  488697
  522834
  151180
  197345
  157493
  310708
  21255
  7753
  418099
  428850
  435658
  417203
  443918
  418869
  420382
  453620
  454664
  458609
  472087
  474763
  451855
  458003
  466892
  473460
  489288
  518318
  498051
  500852
]
2.83 ms
(1.01%)
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
  7753
  21255
  151180
  157493
  197345
  207775
  310708
  384904
  385380
  391694
  395951
  396331
  401986
  402219
  408701
  413092
  417173
  417203
  417754
  418099
  418869
  419563
  420382
  423676
  425586
  428823
  428850
  434113
  434136
  435658
  443918
  443929
  449352
  449694
  451518
  451855
  453620
  454664
  458003
  458609
  458800
  461475
  462513
  466692
  466892
  469716
  471999
  472087
  472795
  473460
  473809
  474763
  478518
  478937
  479996
  480201
  480275
  486310
  488697
  489288
  498051
  498500
  498907
  500149
  500852
  504559
  507844
  510920
  512343
  514453
  515046
  515512
  518318
  522834
  524473
  528965
  532104
  538521
  552211
  558859
  561703
  562313
  570355
  570367
  570521
  571557
  572125
  573008
  575160
  595981
  602430
  602564
  606106
  609402
  632833
  670908
  670928
  679455
  688153
  690688
  730800
  731019
  740915
  743687
  749359
  751511
  754209
  757439
  760992
  761592
  778541
  781611
  784408
  789810
  800304
  801799
  802857
  805133
  811238
  813583
]
2.36 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "снят"
]
1.69 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "снять"
]
1.44 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.50%)
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.