Query Metrics
7
Database Queries
7
Different statements
215.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.66 ms (89.25%) |
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 2258 3826 16679 66162 79720 199188 391427 397766 397941 398524 417452 420824 423804 423880 423904 426094 432513 440701 440852 445383 448547 454299 462022 462599 464763 465374 470689 475861 476377 476599 479042 481389 489178 491334 497788 498218 499018 506727 509532 512118 513836 513975 514118 522087 523150 523168 525234 525280 525661 527594 544079 547874 547987 554796 564928 571130 577594 577603 580168 592808 595639 595658 595682 595715 601080 606102 607574 612414 616765 616810 617385 620940 622257 622313 624965 625279 636111 637419 660094 670750 673517 679847 680746 695059 707689 728902 728908 729265 730806 731913 733143 733468 741818 750904 751732 756570 758742 760851 764486 767943 767952 771791 774927 775612 777605 786465 789560 800186 804406 809592 814376 814582 817383 817711 819899 820370 825775 827099 827189 827199 ] |
||||||||||||||||||||||||||||||
|
13.10 ms (6.07%) |
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 741818 751732 777605 660094 595658 637419 527594 825775 789560 580168 577594 733143 423904 475861 440852 554796 809592 728902 767943 728908 771791 16679 2258 417452 464763 544079 564928 774927 729265 730806 767952 420824 423880 571130 707689 448547 731913 66162 513836 800186 804406 756570 764486 476599 3826 616810 622313 636111 595715 514118 499018 679847 624965 476377 814376 398524 827199 462022 733468 440701 454299 547987 601080 622257 758742 750904 445383 491334 525661 199188 391427 827189 814582 680746 612414 620940 695059 509532 498218 397766 432513 497788 525280 616765 607574 625279 817383 760851 819899 786465 512118 506727 820370 481389 670750 595639 673517 817711 513975 479042 595682 525234 79720 523150 577603 606102 523168 617385 827099 592808 423804 470689 465374 489178 775612 547874 522087 462599 397941 426094 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.36%) |
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 2258 3826 16679 66162 79720 199188 391427 397766 397941 398524 417452 420824 423804 423880 423904 426094 432513 440701 440852 445383 448547 454299 462022 462599 464763 465374 470689 475861 476377 476599 479042 481389 489178 491334 497788 498218 499018 506727 509532 512118 513836 513975 514118 522087 523150 523168 525234 525280 525661 527594 544079 547874 547987 554796 564928 571130 577594 577603 580168 592808 595639 595658 595682 595715 601080 606102 607574 612414 616765 616810 617385 620940 622257 622313 624965 625279 636111 637419 660094 670750 673517 679847 680746 695059 707689 728902 728908 729265 730806 731913 733143 733468 741818 750904 751732 756570 758742 760851 764486 767943 767952 771791 774927 775612 777605 786465 789560 800186 804406 809592 814376 814582 817383 817711 819899 820370 825775 827099 827189 827199 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз mature 69 домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 mature homemade"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз mature 69 домашн любительск"
]
|
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.