Query Metrics
7
Database Queries
7
Different statements
199.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.22 ms (86.99%) |
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 117844 448275 541061 543246 545248 546070 546165 550186 553228 556949 557821 562605 576989 583314 583546 586165 593978 604367 604444 607965 609569 618547 622296 627491 631093 640361 648122 652757 664723 666045 683046 695757 702362 703587 706024 708051 709679 711686 712772 713148 715574 720564 720655 725063 728388 728932 730343 730604 730859 734554 735934 736714 736738 742702 744149 744153 746887 748263 748266 748279 748282 748283 749046 750293 760511 767350 771915 772425 773747 774122 774667 775650 780331 780376 782372 784958 784962 785571 791532 791861 792715 794421 794439 794991 795012 795104 795341 795876 796472 796844 798585 798755 800054 800131 804030 804761 806803 807003 808209 809907 814394 816774 818752 820161 823867 824091 824155 824621 824727 824775 824845 824926 825027 825059 825439 825775 825914 827034 827391 827687 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (7.55%) |
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 703587 713148 683046 695757 708051 556949 557821 583314 607965 640361 593978 609569 631093 774667 795012 775650 784962 794439 795104 744149 748279 785571 746887 748263 748283 749046 728932 730859 742702 767350 720655 780376 796844 806803 809907 824155 824727 827687 562605 583546 816774 825775 818752 666045 553228 734554 730343 604367 711686 792715 824845 824621 825439 825027 543246 652757 702362 715574 720564 586165 627491 794421 794991 800054 804030 807003 782372 784958 800131 760511 725063 736738 748266 772425 736714 750293 735934 748282 773747 730604 744153 618547 706024 709679 712772 780331 796472 798585 824926 825914 823867 827034 827391 545248 546070 648122 622296 795876 804761 795341 798755 808209 774122 728388 771915 814394 664723 604444 448275 117844 576989 550186 791532 791861 824091 820161 824775 825059 541061 546165 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (1.86%) |
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 117844 448275 541061 543246 545248 546070 546165 550186 553228 556949 557821 562605 576989 583314 583546 586165 593978 604367 604444 607965 609569 618547 622296 627491 631093 640361 648122 652757 664723 666045 683046 695757 702362 703587 706024 708051 709679 711686 712772 713148 715574 720564 720655 725063 728388 728932 730343 730604 730859 734554 735934 736714 736738 742702 744149 744153 746887 748263 748266 748279 748282 748283 749046 750293 760511 767350 771915 772425 773747 774122 774667 775650 780331 780376 782372 784958 784962 785571 791532 791861 792715 794421 794439 794991 795012 795104 795341 795876 796472 796844 798585 798755 800054 800131 804030 804761 806803 807003 808209 809907 814394 816774 818752 820161 823867 824091 824155 824621 824727 824775 824845 824926 825027 825059 825439 825775 825914 827034 827391 827687 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hole"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy дырк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy дырк"
]
|
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.