Query Metrics
7
Database Queries
7
Different statements
264.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.01 ms (90.66%) |
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 78709 221091 306045 386853 402566 403979 413643 417844 469494 470548 478541 484145 503791 504161 506813 520162 532367 536958 538043 542513 543685 543688 543925 543982 544696 545096 545106 547980 550127 562588 566415 566431 566464 566583 579304 579541 586737 590307 593075 593622 593893 603586 604985 608645 610780 614565 616368 619275 622179 622822 635636 635830 635842 635853 635863 640727 642525 642556 645046 648943 648952 651420 653174 653634 654256 654270 654680 661955 675960 677544 679549 680588 681785 682914 690885 691616 692454 692470 693596 693772 698086 701638 712636 712651 715581 718376 718964 721933 722104 723967 727717 728946 731113 732690 732743 733148 736798 742675 747234 749639 751026 755121 761504 771453 773948 773961 775026 781638 784875 793231 798695 799553 799674 801129 804512 810286 817337 818465 824498 827068 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (5.50%) |
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 413643 417844 732690 484145 736798 579541 715581 470548 698086 773948 728946 721933 723967 536958 543982 804512 221091 799674 614565 635830 680588 773961 503791 682914 799553 784875 781638 691616 761504 306045 544696 543688 718964 545106 579304 608645 732743 747234 543685 586737 538043 692454 635842 520162 566431 566464 681785 675960 642525 810286 733148 403979 506813 562588 653634 593893 749639 504161 654270 712636 661955 827068 817337 550127 648943 677544 648952 653174 654680 701638 622822 635853 775026 798695 755121 543925 712651 640727 824498 818465 731113 693596 771453 610780 718376 593622 742675 751026 547980 566583 679549 692470 654256 593075 622179 635863 604985 801129 793231 386853 645046 635636 693772 603586 532367 542513 690885 616368 545096 651420 722104 78709 619275 469494 566415 590307 642556 727717 478541 402566 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.21%) |
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 78709 221091 306045 386853 402566 403979 413643 417844 469494 470548 478541 484145 503791 504161 506813 520162 532367 536958 538043 542513 543685 543688 543925 543982 544696 545096 545106 547980 550127 562588 566415 566431 566464 566583 579304 579541 586737 590307 593075 593622 593893 603586 604985 608645 610780 614565 616368 619275 622179 622822 635636 635830 635842 635853 635863 640727 642525 642556 645046 648943 648952 651420 653174 653634 654256 654270 654680 661955 675960 677544 679549 680588 681785 682914 690885 691616 692454 692470 693596 693772 698086 701638 712636 712651 715581 718376 718964 721933 722104 723967 727717 728946 731113 732690 732743 733148 736798 742675 747234 749639 751026 755121 761504 771453 773948 773961 775026 781638 784875 793231 798695 799553 799674 801129 804512 810286 817337 818465 824498 827068 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жены втрое"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.61%) |
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.