GET https://search.jues.net/search/embeds/4?q=%D0%B1%D0%B5%D0%BB%D1%8B%D0%B9

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.03 ms
(83.17%)
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
  391448
  392801
  393845
  395598
  396086
  396154
  396673
  398477
  400167
  401468
  404032
  404399
  404730
  405324
  413495
  415257
  419151
  419807
  427702
  427776
  429473
  433940
  438349
  438838
  442508
  443229
  444959
  445082
  445841
  446239
  446328
  446673
  446727
  446967
  447441
  447511
  447638
  447675
  447738
  447910
  449092
  450330
  451145
  451831
  453934
  454461
  454591
  454645
  454875
  456263
  456382
  456507
  456941
  456982
  457565
  459261
  459404
  459711
  459826
  460453
  461760
  462696
  462911
  463379
  464601
  465093
  466033
  467373
  467804
  469102
  469112
  469410
  469493
  470118
  471002
  471582
  472222
  472263
  472295
  472322
  472525
  472530
  473239
  474682
  475025
  475061
  475225
  475256
  475467
  475720
  476567
  478140
  478409
  478655
  479271
  480395
  482723
  483389
  483578
  483579
  487297
  492183
  492470
  499871
  502302
  506876
  510608
  510809
  511338
  515263
  517915
  524204
  524783
  529333
  542651
  558359
  563839
  586584
  680923
]
17.35 ms
(11.18%)
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
  482723
  451831
  454875
  456982
  469102
  470118
  472222
  472263
  492183
  446673
  447738
  449092
  453934
  454645
  456507
  459711
  459826
  464601
  466033
  475720
  492470
  445841
  446328
  446967
  450330
  451145
  454591
  459261
  462696
  462911
  465093
  472295
  472525
  472530
  478655
  483578
  487297
  502302
  524783
  499871
  511338
  515263
  517915
  524204
  527201
  510608
  529333
  506876
  510809
  461760
  469493
  472322
  474682
  475061
  475256
  475467
  483389
  483579
  563839
  542651
  680923
  558359
  586584
  391448
  396154
  404399
  427776
  438349
  446239
  446727
  447675
  456382
  456941
  463379
  473239
  475025
  475225
  478409
  393845
  396673
  398477
  400167
  401468
  405324
  419807
  442508
  443229
  444959
  447511
  447910
  459404
  469112
  471002
  478140
  479271
  392801
  395598
  415257
  419151
  429473
  457565
  467373
  467804
  469410
  471582
  476567
  480395
  396086
  404032
  404730
  413495
  427702
  433940
  438838
  445082
  447441
  447638
  454461
  456263
  460453
]
2.54 ms
(1.64%)
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
  391448
  392801
  393845
  395598
  396086
  396154
  396673
  398477
  400167
  401468
  404032
  404399
  404730
  405324
  413495
  415257
  419151
  419807
  427702
  427776
  429473
  433940
  438349
  438838
  442508
  443229
  444959
  445082
  445841
  446239
  446328
  446673
  446727
  446967
  447441
  447511
  447638
  447675
  447738
  447910
  449092
  450330
  451145
  451831
  453934
  454461
  454591
  454645
  454875
  456263
  456382
  456507
  456941
  456982
  457565
  459261
  459404
  459711
  459826
  460453
  461760
  462696
  462911
  463379
  464601
  465093
  466033
  467373
  467804
  469102
  469112
  469410
  469493
  470118
  471002
  471582
  472222
  472263
  472295
  472322
  472525
  472530
  473239
  474682
  475025
  475061
  475225
  475256
  475467
  475720
  476567
  478140
  478409
  478655
  479271
  480395
  482723
  483389
  483578
  483579
  487297
  492183
  492470
  499871
  502302
  506876
  510608
  510809
  511338
  515263
  517915
  524204
  524783
  529333
  542651
  558359
  563839
  586584
  680923
]
1.87 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "белый"
]
1.60 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "белый"
]
1.51 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.81%)
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.