GET https://search.jues.net/search/embeds/6?q=%D1%89%D0%B5%D0%BA%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.81 ms
(83.95%)
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
  109313
  109381
  191495
  195913
  209335
  210377
  213509
  302688
  383558
  386686
  394420
  394685
  397291
  401786
  402536
  403320
  404899
  409093
  409776
  417703
  419739
  419793
  420084
  421891
  425137
  428317
  429130
  429365
  429947
  430715
  435365
  437274
  438029
  438049
  438919
  443834
  444156
  444546
  446970
  450256
  451506
  453587
  454806
  456070
  456350
  457805
  458459
  458632
  459589
  460194
  461251
  461505
  462500
  462508
  462533
  464512
  464774
  465030
  466039
  468243
  468695
  469593
  469836
  469840
  470102
  470310
  470667
  470708
  471091
  471372
  471832
  471918
  472023
  472371
  472898
  473058
  473118
  473752
  473839
  474451
  475167
  475996
  476018
  476334
  476487
  477968
  478250
  478679
  479550
  480240
  480677
  480856
  480976
  481219
  481251
  481385
  482013
  483278
  483986
  484013
  484852
  486039
  486112
  489118
  490119
  490552
  491391
  493465
  499959
  501835
  503193
  503535
  504898
  508760
  510688
  511522
  511713
  519984
  528158
  528868
]
17.78 ms
(10.10%)
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
  465030
  466039
  468243
  470667
  471091
  473118
  473839
  476487
  479550
  480677
  480856
  482013
  195913
  213509
  394420
  404899
  419793
  425137
  429130
  437274
  451506
  461251
  462500
  462508
  464512
  469836
  470102
  471832
  472898
  475996
  478250
  478679
  480976
  481251
  109381
  191495
  209335
  302688
  383558
  402536
  403320
  409776
  417703
  419739
  420084
  435365
  438029
  438919
  443834
  450256
  454806
  456070
  458632
  459589
  460194
  461505
  462533
  469593
  470310
  471372
  474451
  475167
  476334
  477968
  480240
  109313
  210377
  386686
  394685
  397291
  401786
  421891
  428317
  429947
  438049
  444546
  456350
  458459
  468695
  469840
  470708
  471918
  472371
  473058
  473752
  409093
  429365
  430715
  444156
  446970
  453587
  457805
  464774
  472023
  476018
  481219
  481385
  499959
  501835
  503193
  503535
  504898
  508760
  510688
  511522
  511713
  519984
  528158
  528868
  483278
  483986
  484013
  484852
  486039
  486112
  489118
  490119
  490552
  491391
  493465
]
3.02 ms
(1.71%)
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
  109313
  109381
  191495
  195913
  209335
  210377
  213509
  302688
  383558
  386686
  394420
  394685
  397291
  401786
  402536
  403320
  404899
  409093
  409776
  417703
  419739
  419793
  420084
  421891
  425137
  428317
  429130
  429365
  429947
  430715
  435365
  437274
  438029
  438049
  438919
  443834
  444156
  444546
  446970
  450256
  451506
  453587
  454806
  456070
  456350
  457805
  458459
  458632
  459589
  460194
  461251
  461505
  462500
  462508
  462533
  464512
  464774
  465030
  466039
  468243
  468695
  469593
  469836
  469840
  470102
  470310
  470667
  470708
  471091
  471372
  471832
  471918
  472023
  472371
  472898
  473058
  473118
  473752
  473839
  474451
  475167
  475996
  476018
  476334
  476487
  477968
  478250
  478679
  479550
  480240
  480677
  480856
  480976
  481219
  481251
  481385
  482013
  483278
  483986
  484013
  484852
  486039
  486112
  489118
  490119
  490552
  491391
  493465
  499959
  501835
  503193
  503535
  504898
  508760
  510688
  511522
  511713
  519984
  528158
  528868
]
2.13 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "щеку"
]
1.85 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "щек"
]
1.74 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.