Query Metrics
7
Database Queries
7
Different statements
137.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.31 ms (82.69%) |
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 256988 381919 385229 401234 483349 487559 528979 528999 529815 530346 530949 531736 532105 537086 537628 540251 540712 542438 544451 546814 549416 559790 560600 565999 570776 574067 590792 593196 593261 609556 620468 621602 621615 622368 624406 627618 628035 632287 637303 643520 645733 649601 652566 652991 653572 653576 653577 655841 661377 668111 669902 675584 681745 682841 685429 687424 688500 692123 694174 695233 697674 697879 698355 703749 707076 710280 713875 713894 713913 716963 730794 731543 734805 738300 740673 740707 740770 741500 750510 750529 751000 762836 765061 766380 770423 771925 772953 774754 776982 777748 778177 778180 778284 781008 781579 781966 783375 788620 789034 789231 791138 792108 795113 804853 807248 808274 812178 817995 819102 822194 822747 822874 823385 824449 825448 826723 826844 828128 ] |
||||||||||||||||||||||||||||||
|
12.57 ms (9.17%) |
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 771925 703749 781966 795113 256988 822874 826844 822747 487559 537628 574067 645733 681745 669902 695233 713913 652566 653572 697674 698355 549416 622368 778284 781008 774754 762836 772953 781579 789034 734805 765061 628035 808274 819102 530346 537086 540712 697879 770423 824449 530949 528999 624406 593261 632287 778177 792108 731543 807248 730794 766380 740673 822194 817995 825448 528979 540251 559790 661377 694174 716963 710280 652991 653576 700018 627618 621615 590792 621602 777748 812178 740707 741500 738300 751000 776982 778171 381919 385229 687424 778180 740770 649601 593196 544451 637303 783375 789231 791138 788620 750529 750510 804853 401234 826723 823385 828128 483349 529815 531736 532105 542438 565999 570776 653577 655841 688500 713894 675584 685429 692123 713875 668111 682841 707076 546814 560600 643520 609556 620468 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (2.88%) |
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 256988 381919 385229 401234 483349 487559 528979 528999 529815 530346 530949 531736 532105 537086 537628 540251 540712 542438 544451 546814 549416 559790 560600 565999 570776 574067 590792 593196 593261 609556 620468 621602 621615 622368 624406 627618 628035 632287 637303 643520 645733 649601 652566 652991 653572 653576 653577 655841 661377 668111 669902 675584 681745 682841 685429 687424 688500 692123 694174 695233 697674 697879 698355 703749 707076 710280 713875 713894 713913 716963 730794 731543 734805 738300 740673 740707 740770 741500 750510 750529 751000 762836 765061 766380 770423 771925 772953 774754 776982 777748 778177 778180 778284 781008 781579 781966 783375 788620 789034 789231 791138 792108 795113 804853 807248 808274 812178 817995 819102 822194 822747 822874 823385 824449 825448 826723 826844 828128 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video girl"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video девушк"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video девушк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.19%) |
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.