GET https://search.jues.net/search/embeds/3?q=%D0%B3%D0%BE%D0%BB%D1%8C%D1%84%D0%B0%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.33 ms
(88.19%)
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
  30783
  143302
  382226
  383496
  384193
  386156
  387544
  389026
  399520
  410304
  424929
  425319
  426361
  426696
  426810
  426917
  427497
  428034
  429009
  429629
  432274
  435811
  441050
  444279
  447325
  447510
  448526
  449400
  450434
  450573
  450657
  454679
  455042
  458810
  458869
  461442
  462026
  462517
  463945
  463952
  464614
  464679
  464791
  467065
  471716
  471774
  472466
  472737
  473886
  479452
  481449
  481598
  482621
  491041
  492414
  499982
  502424
  503958
  509162
  511374
  512762
  514873
  515339
  518360
  521608
  521840
  523082
  523357
  525148
  525180
  525807
  527177
  527565
  527939
  535747
  536847
  537962
  541417
  546055
  546371
  546777
  548565
  552009
  552745
  552990
  553271
  554582
  555797
  560034
  561344
  561880
  562164
  562393
  566342
  567006
  569666
  575554
  581188
  584549
  585308
  585330
  588608
  589756
  595436
  596578
  597583
  600889
  602317
  602593
  604059
  605936
  606652
  607021
  608667
  609639
  618833
  622371
  626138
  685004
  722825
]
13.75 ms
(7.08%)
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
  626138
  585330
  589756
  600889
  618833
  426696
  454679
  458810
  143302
  383496
  384193
  426917
  389026
  410304
  425319
  448526
  458869
  461442
  472466
  479452
  441050
  447325
  447510
  462026
  509162
  525148
  525807
  502424
  503958
  511374
  499982
  491041
  512762
  382226
  30783
  387544
  432274
  482621
  450434
  450573
  455042
  492414
  464614
  464679
  481598
  523082
  535747
  514873
  518360
  521608
  523357
  537962
  527177
  527939
  536847
  515339
  521840
  525180
  527565
  471774
  541417
  546777
  552009
  552990
  553271
  554582
  561344
  575554
  546371
  548565
  552745
  561880
  562164
  562393
  566342
  569666
  581188
  546055
  555797
  567006
  685004
  560034
  584549
  585308
  605936
  608667
  588608
  595436
  602317
  602593
  622371
  597583
  604059
  606652
  609639
  596578
  607021
  722825
  424929
  427497
  429009
  462517
  464791
  481449
  426810
  463952
  467065
  471716
  472737
  386156
  399520
  428034
  444279
  450657
  426361
  449400
  463945
  473886
  429629
  435811
]
2.82 ms
(1.45%)
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
  30783
  143302
  382226
  383496
  384193
  386156
  387544
  389026
  399520
  410304
  424929
  425319
  426361
  426696
  426810
  426917
  427497
  428034
  429009
  429629
  432274
  435811
  441050
  444279
  447325
  447510
  448526
  449400
  450434
  450573
  450657
  454679
  455042
  458810
  458869
  461442
  462026
  462517
  463945
  463952
  464614
  464679
  464791
  467065
  471716
  471774
  472466
  472737
  473886
  479452
  481449
  481598
  482621
  491041
  492414
  499982
  502424
  503958
  509162
  511374
  512762
  514873
  515339
  518360
  521608
  521840
  523082
  523357
  525148
  525180
  525807
  527177
  527565
  527939
  535747
  536847
  537962
  541417
  546055
  546371
  546777
  548565
  552009
  552745
  552990
  553271
  554582
  555797
  560034
  561344
  561880
  562164
  562393
  566342
  567006
  569666
  575554
  581188
  584549
  585308
  585330
  588608
  589756
  595436
  596578
  597583
  600889
  602317
  602593
  604059
  605936
  606652
  607021
  608667
  609639
  618833
  622371
  626138
  685004
  722825
]
1.82 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "гольфах"
]
1.68 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "гольф"
]
1.52 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.69%)
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.