Query Metrics
7
Database Queries
7
Different statements
556.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
417.91 ms (75.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"случайная"
]
|
||||||||||||||||||||||||||||||
|
116.64 ms (20.96%) |
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 97689 511424 511425 511615 515302 529689 534182 534719 535144 538805 540062 552386 552900 557009 559423 560518 566700 592646 595513 596372 602857 606316 617978 620062 621005 625328 626121 627880 627881 628650 629554 632798 637478 644600 644713 645485 646533 647030 649933 654212 667185 670668 674536 676939 682379 700086 701243 702464 705746 709327 710754 710926 714456 715887 718102 718541 720470 720737 725364 726264 728373 730742 733474 737562 738896 742223 744464 745789 745982 747981 749776 751232 753269 753348 753404 753408 753858 753878 753900 757044 757695 757706 758393 759089 759947 761497 761502 771229 771683 773478 775330 776106 777548 779869 780515 781224 783075 784235 785495 788135 788638 788786 789450 790914 793519 794203 794814 796692 797034 797473 800411 801663 802183 802247 802386 803084 803763 804977 807470 810205 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (2.36%) |
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 534182 535144 538805 534719 511425 529689 566700 552386 560518 645485 700086 709327 710926 654212 682379 647030 649933 552900 617978 625328 626121 621005 644600 602857 627881 644713 776106 802247 781224 790914 796692 802183 803084 804977 753878 788135 797034 800411 725364 759089 771229 753858 730742 737562 744464 749776 753408 751232 753900 606316 701243 718541 783075 788638 788786 793519 794814 802386 515302 97689 511424 511615 540062 557009 559423 646533 702464 705746 714456 718102 720737 715887 667185 670668 674536 676939 710754 720470 628650 629554 637478 632798 592646 596372 620062 627880 595513 775330 780515 789450 801663 803763 761497 761502 784235 785495 794203 797473 807470 810205 745789 753269 753404 757706 726264 728373 733474 742223 758393 738896 747981 753348 757695 773478 745982 757044 759947 771683 777548 779869 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (0.63%) |
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 97689 511424 511425 511615 515302 529689 534182 534719 535144 538805 540062 552386 552900 557009 559423 560518 566700 592646 595513 596372 602857 606316 617978 620062 621005 625328 626121 627880 627881 628650 629554 632798 637478 644600 644713 645485 646533 647030 649933 654212 667185 670668 674536 676939 682379 700086 701243 702464 705746 709327 710754 710926 714456 715887 718102 718541 720470 720737 725364 726264 728373 730742 733474 737562 738896 742223 744464 745789 745982 747981 749776 751232 753269 753348 753404 753408 753858 753878 753900 757044 757695 757706 758393 759089 759947 761497 761502 771229 771683 773478 775330 776106 777548 779869 780515 781224 783075 784235 785495 788135 788638 788786 789450 790914 793519 794203 794814 796692 797034 797473 800411 801663 802183 802247 802386 803084 803763 804977 807470 810205 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"случайн"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"случайн"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.30%) |
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.