GET https://search.jues.net/search/embeds/3?q=%D1%83%D0%BF%D1%80%D1%83%D0%B3%D0%B8%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
188.60 ms
(90.27%)
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
  6965
  31305
  53386
  66348
  76649
  81709
  91345
  114536
  186782
  188028
  276780
  291314
  312730
  314894
  332765
  383791
  384779
  385788
  386626
  386893
  387492
  390259
  390395
  394589
  395457
  397638
  398853
  400322
  400382
  401727
  402021
  402142
  403872
  405458
  405701
  411161
  413116
  414711
  414734
  417600
  417808
  418060
  420109
  420782
  421718
  422337
  424026
  424057
  426103
  427408
  427448
  428927
  429220
  429546
  429825
  432285
  433433
  436632
  437856
  439788
  441823
  442620
  444057
  446341
  446478
  451699
  453588
  453665
  454644
  454766
  454780
  455271
  455796
  456096
  456194
  456654
  456997
  458127
  458134
  460895
  461955
  464655
  465424
  466057
  468028
  468290
  469228
  469668
  470101
  470694
  471086
  471477
  471543
  475359
  477567
  478354
  478984
  480692
  481052
  483779
  487541
  489728
  493445
  494571
  498645
  500738
  504077
  505259
  505636
  505651
  508940
  510309
  510606
  516539
  516570
  548693
  572799
  592114
  681342
  712608
]
11.54 ms
(5.52%)
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
  461955
  470694
  475359
  433433
  460895
  478354
  516539
  494571
  505651
  508940
  483779
  500738
  386626
  383791
  188028
  394589
  291314
  312730
  66348
  76649
  31305
  53386
  386893
  397638
  400322
  398853
  402021
  403872
  421718
  426103
  422337
  444057
  413116
  417808
  420782
  427448
  414711
  417600
  424057
  429220
  442620
  454644
  455796
  456194
  456997
  464655
  477567
  480692
  446341
  455271
  456096
  458127
  468028
  471086
  478984
  487541
  489728
  446478
  458134
  469668
  471477
  481052
  493445
  498645
  504077
  505259
  505636
  516570
  510606
  510309
  465424
  468290
  469228
  470101
  572799
  548693
  681342
  712608
  592114
  91345
  385788
  390259
  390395
  400382
  401727
  414734
  420109
  424026
  427408
  436632
  439788
  441823
  451699
  453588
  453665
  454780
  456654
  276780
  6965
  332765
  387492
  395457
  405458
  405701
  411161
  418060
  428927
  429546
  429825
  432285
  466057
  81709
  114536
  186782
  314894
  384779
  402142
  437856
  454766
  471543
]
2.36 ms
(1.13%)
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
  6965
  31305
  53386
  66348
  76649
  81709
  91345
  114536
  186782
  188028
  276780
  291314
  312730
  314894
  332765
  383791
  384779
  385788
  386626
  386893
  387492
  390259
  390395
  394589
  395457
  397638
  398853
  400322
  400382
  401727
  402021
  402142
  403872
  405458
  405701
  411161
  413116
  414711
  414734
  417600
  417808
  418060
  420109
  420782
  421718
  422337
  424026
  424057
  426103
  427408
  427448
  428927
  429220
  429546
  429825
  432285
  433433
  436632
  437856
  439788
  441823
  442620
  444057
  446341
  446478
  451699
  453588
  453665
  454644
  454766
  454780
  455271
  455796
  456096
  456194
  456654
  456997
  458127
  458134
  460895
  461955
  464655
  465424
  466057
  468028
  468290
  469228
  469668
  470101
  470694
  471086
  471477
  471543
  475359
  477567
  478354
  478984
  480692
  481052
  483779
  487541
  489728
  493445
  494571
  498645
  500738
  504077
  505259
  505636
  505651
  508940
  510309
  510606
  516539
  516570
  548693
  572799
  592114
  681342
  712608
]
1.78 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "упругие"
]
1.76 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "упругие"
]
1.58 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(0.62%)
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.