Query Metrics
7
Database Queries
7
Different statements
208.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.12 ms (89.70%) |
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 6679 120432 187723 187847 229361 231299 236472 325983 384570 386276 396507 398885 399066 403229 408586 416783 420624 423459 437189 451255 462108 474724 475317 478498 560696 585094 590360 590506 612832 617730 618845 623176 645283 647957 665658 665678 668996 671609 671729 674327 676976 680137 680204 685005 687431 694324 694345 699400 712714 715707 718934 722782 723266 725176 726273 727811 728348 732443 732450 739857 740604 742161 742431 747139 751094 751622 753445 760913 762187 763516 764868 765441 765456 765507 766839 766883 768351 769045 769750 769768 769822 769924 773878 776265 776281 777134 777139 781609 786014 786051 787486 790203 793749 794852 797558 798986 799272 800001 800554 800589 802510 802552 803494 804308 805212 805848 805996 809845 813553 814110 814527 814982 817009 817257 820071 821016 822619 823331 827257 827464 ] |
||||||||||||||||||||||||||||||
|
12.45 ms (5.97%) |
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 822619 766839 665658 802510 777134 423459 827464 820071 794852 777139 398885 475317 674327 722782 187723 769768 814527 786051 763516 408586 325983 769822 671729 742431 776265 560696 236472 817257 694324 612832 797558 725176 790203 120432 800554 665678 590360 590506 799272 798986 742161 732443 768351 617730 803494 403229 437189 6679 727811 715707 229361 766883 680137 728348 805212 231299 814110 804308 699400 668996 723266 753445 765441 760913 764868 740604 416783 739857 773878 451255 694345 787486 386276 399066 687431 618845 793749 809845 747139 751094 384570 187847 814982 821016 823331 827257 817009 478498 712714 718934 647957 776281 786014 769045 726273 751622 396507 474724 420624 645283 685005 769924 813553 805996 800001 462108 765456 769750 585094 671609 623176 781609 800589 805848 732450 765507 762187 802552 676976 680204 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.17%) |
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 6679 120432 187723 187847 229361 231299 236472 325983 384570 386276 396507 398885 399066 403229 408586 416783 420624 423459 437189 451255 462108 474724 475317 478498 560696 585094 590360 590506 612832 617730 618845 623176 645283 647957 665658 665678 668996 671609 671729 674327 676976 680137 680204 685005 687431 694324 694345 699400 712714 715707 718934 722782 723266 725176 726273 727811 728348 732443 732450 739857 740604 742161 742431 747139 751094 751622 753445 760913 762187 763516 764868 765441 765456 765507 766839 766883 768351 769045 769750 769768 769822 769924 773878 776265 776281 777134 777139 781609 786014 786051 787486 790203 793749 794852 797558 798986 799272 800001 800554 800589 802510 802552 803494 804308 805212 805848 805996 809845 813553 814110 814527 814982 817009 817257 820071 821016 822619 823331 827257 827464 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal рыжих"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.72%) |
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.