Query Metrics
7
Database Queries
7
Different statements
145.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.21 ms (82.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 474188 490034 511422 519252 519266 538862 538931 540446 542464 542487 543733 544257 544272 544311 547840 548504 550036 550220 557108 563099 563125 564543 565123 565345 566685 567995 568269 573321 574201 574282 576122 576622 579110 581329 583837 586850 592391 592449 592493 592539 599871 604121 606663 609208 609566 614321 614354 614989 620175 621703 622954 624360 624754 626556 626558 629286 629311 629902 641747 642401 643033 644255 644287 644368 644953 648209 649933 651205 651603 651681 652958 652991 653577 670067 671237 672717 672852 674131 677738 681791 685255 687192 690823 690850 690931 691509 691521 692214 692222 692331 693060 693985 694110 694112 694124 695204 695242 695921 695950 697301 699383 699698 701458 704525 716786 718489 722142 730272 735931 737482 740296 740557 742138 742803 744566 745314 746581 776726 785339 785485 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (10.16%) |
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 548504 557108 564543 574201 579110 604121 629311 592493 599871 606663 621703 622954 624360 642401 644255 626558 586850 592449 776726 785485 737482 740557 746581 730272 742803 744566 629286 629902 718489 644953 538862 538931 565123 567995 573321 542487 544257 550036 566685 574282 547840 653577 685255 694112 695242 695950 699383 699698 651603 651681 652958 671237 677738 681791 691509 692222 694110 694124 695204 695921 697301 716786 722142 648209 649933 651205 652991 670067 672717 672852 674131 687192 690823 690850 690931 691521 692214 692331 693060 693985 565345 568269 576122 581329 592539 609208 624754 592391 614321 614989 620175 626556 643033 609566 614354 641747 644287 644368 740296 742138 745314 735931 701458 785339 490034 519266 544311 563125 583837 563099 576622 704525 550220 474188 511422 519252 542464 540446 543733 544272 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.81%) |
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 474188 490034 511422 519252 519266 538862 538931 540446 542464 542487 543733 544257 544272 544311 547840 548504 550036 550220 557108 563099 563125 564543 565123 565345 566685 567995 568269 573321 574201 574282 576122 576622 579110 581329 583837 586850 592391 592449 592493 592539 599871 604121 606663 609208 609566 614321 614354 614989 620175 621703 622954 624360 624754 626556 626558 629286 629311 629902 641747 642401 643033 644255 644287 644368 644953 648209 649933 651205 651603 651681 652958 652991 653577 670067 671237 672717 672852 674131 677738 681791 685255 687192 690823 690850 690931 691509 691521 692214 692222 692331 693060 693985 694110 694112 694124 695204 695242 695921 695950 697301 699383 699698 701458 704525 716786 718489 722142 730272 735931 737482 740296 740557 742138 742803 744566 745314 746581 776726 785339 785485 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ретро длинные"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр длинные"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.03%) |
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.