Query Metrics
7
Database Queries
7
Different statements
174.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.28 ms (88.08%) |
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 11175 79601 419275 438109 450118 459771 489715 497797 510348 526595 526853 530216 542183 543188 549518 553679 555067 558336 565328 566240 582121 604848 616783 620750 626489 627218 627617 630507 632886 634615 636171 639116 649771 658863 663739 663767 666417 666661 667979 675450 676695 692679 695780 714149 715746 717757 719773 721650 726722 731112 742591 744417 746708 758409 762090 762499 763701 764615 764960 764961 765007 765029 767393 771359 772371 774013 774058 775731 777693 777846 777905 778054 778554 778743 778796 779045 779165 779321 780905 781441 781533 781571 782568 782695 782895 783515 785025 786688 788066 790848 791699 793791 794264 794608 794740 796013 796103 799863 802007 802012 802804 802944 803417 803870 804510 804884 804926 805152 809233 810565 813901 814276 817547 818100 820075 821126 823849 827109 ] |
||||||||||||||||||||||||||||||
|
11.34 ms (6.52%) |
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 802944 510348 742591 419275 813901 827109 459771 802804 794740 762499 790848 799863 804510 746708 774013 771359 714149 526595 582121 780905 818100 821126 823849 542183 663739 675450 627218 604848 779045 778796 779321 786688 793791 802007 803870 781571 796013 744417 762090 764537 763701 764615 620715 778554 779165 782695 782568 649771 530216 555067 717757 715746 803417 765007 767393 79601 814276 658863 676695 777905 791699 758409 438109 817547 820075 553679 566240 663767 667979 636171 639116 616783 632886 783515 794608 810565 764961 781441 781533 782895 804926 809233 731112 764960 765029 775731 785025 794264 802012 719773 721650 772371 543188 549518 666661 692679 695780 627617 777693 778054 778743 788066 804884 726722 774058 620750 796103 634615 626489 805152 450118 489715 526853 630507 777846 11175 497797 558336 565328 666417 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.48%) |
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 11175 79601 419275 438109 450118 459771 489715 497797 510348 526595 526853 530216 542183 543188 549518 553679 555067 558336 565328 566240 582121 604848 616783 620750 626489 627218 627617 630507 632886 634615 636171 639116 649771 658863 663739 663767 666417 666661 667979 675450 676695 692679 695780 714149 715746 717757 719773 721650 726722 731112 742591 744417 746708 758409 762090 762499 763701 764615 764960 764961 765007 765029 767393 771359 772371 774013 774058 775731 777693 777846 777905 778054 778554 778743 778796 779045 779165 779321 780905 781441 781533 781571 782568 782695 782895 783515 785025 786688 788066 790848 791699 793791 794264 794608 794740 796013 796103 799863 802007 802012 802804 802944 803417 803870 804510 804884 804926 805152 809233 810565 813901 814276 817547 818100 820075 821126 823849 827109 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mouth pov"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mouth пов"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mouth пов"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.85%) |
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.