Query Metrics
7
Database Queries
7
Different statements
197.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.36 ms (85.85%) |
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 588915 590792 613943 615409 616517 617573 619698 621126 622548 622568 625935 626501 628921 629639 630403 630419 634335 635604 636893 637210 637375 638480 641522 644205 724923 725020 725240 726313 727500 728898 730128 731151 731593 733124 733196 733944 734295 734439 734448 734623 734759 734813 736333 737268 737891 741143 741503 741673 742822 744159 746199 746433 747260 747510 748275 757712 758008 760264 760266 760621 760888 762580 762774 765059 765429 766260 767734 767867 767870 767921 769089 772354 772376 773351 773798 774654 775658 776018 776067 778475 778476 780240 780974 781093 781110 781537 782684 784129 785090 785320 785672 786855 787229 787970 790934 792249 792348 793068 795796 796393 796398 796458 797198 797212 797886 797932 799758 799887 800333 801478 801770 802329 803402 803608 803782 804035 804040 804709 812313 ] |
||||||||||||||||||||||||||||||
|
12.28 ms (6.23%) |
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 634335 635604 637210 637375 590792 615409 616517 617573 619698 621126 622548 622568 625935 628921 630403 638480 588915 613943 626501 629639 630419 636893 641522 644205 775658 776067 778213 778475 778476 780240 781093 781537 782684 784129 786855 787229 787970 790934 792249 792348 797198 797886 799758 800333 802329 804040 774654 776018 780974 781110 785672 796393 797932 799887 803608 803782 804035 804709 812313 734448 734759 734813 736333 737891 741143 741503 746199 746433 758008 760264 760621 760888 762580 762774 766260 769089 772354 785090 785320 793068 795796 796398 796458 797212 801478 801770 803402 724923 725020 725240 727500 731593 733124 742822 744159 747510 748275 760266 765429 767734 767870 772376 773798 726313 730128 731151 733196 734295 734623 741673 747260 757712 765059 767867 767921 773351 728898 733944 734439 737268 ] |
||||||||||||||||||||||||||||||
|
8.22 ms (4.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"крупны"
]
|
||||||||||||||||||||||||||||||
|
2.41 ms (1.22%) |
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 588915 590792 613943 615409 616517 617573 619698 621126 622548 622568 625935 626501 628921 629639 630403 630419 634335 635604 636893 637210 637375 638480 641522 644205 724923 725020 725240 726313 727500 728898 730128 731151 731593 733124 733196 733944 734295 734439 734448 734623 734759 734813 736333 737268 737891 741143 741503 741673 742822 744159 746199 746433 747260 747510 748275 757712 758008 760264 760266 760621 760888 762580 762774 765059 765429 766260 767734 767867 767870 767921 769089 772354 772376 773351 773798 774654 775658 776018 776067 778475 778476 780240 780974 781093 781110 781537 782684 784129 785090 785320 785672 786855 787229 787970 790934 792249 792348 793068 795796 796393 796398 796458 797198 797212 797886 797932 799758 799887 800333 801478 801770 802329 803402 803608 803782 804035 804040 804709 812313 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крупныйпла"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"крупныйпла"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.