Query Metrics
7
Database Queries
7
Different statements
158.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.96 ms (82.55%) |
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 385645 536111 541043 543128 548909 553228 556874 556949 557821 560688 562605 575014 576392 583314 583546 588939 593978 604367 607965 609569 615604 617504 617578 619699 624193 631093 631451 640361 640366 666045 667377 668105 680593 680744 683046 690259 692723 693926 695757 699519 700056 702639 703587 708051 711686 713148 719173 720655 724441 728924 728932 730343 730859 734404 734417 734554 734859 741992 742066 742702 744149 744162 744834 746709 746887 748028 748263 748279 748280 748283 748990 749046 750180 752090 760262 760635 767350 767462 767474 768226 773361 774667 775650 775652 775653 776094 777332 778285 780376 784575 784962 785571 786882 786920 792258 792556 793839 794194 794439 795012 795104 796844 800044 800116 801343 803150 806803 806821 807171 809907 813174 816774 818752 823272 824155 824343 824727 825775 827617 827687 ] |
||||||||||||||||||||||||||||||
|
18.17 ms (11.45%) |
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 778285 786882 793839 760635 588939 385645 560688 728924 823272 827617 556874 575014 576392 548909 702639 700056 668105 680593 680744 719173 615604 640366 617578 775652 775653 777332 794194 800044 806821 776094 784575 792258 800116 734417 741992 742066 744162 748028 748280 748990 750180 760262 767474 786920 792556 813174 724441 744834 752090 767462 768226 734404 734859 746709 773361 617504 631451 801343 803150 807171 543128 693926 536111 667377 824343 699519 690259 692723 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 624193 816774 825775 818752 666045 553228 734554 730343 541043 604367 619699 711686 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.57%) |
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 385645 536111 541043 543128 548909 553228 556874 556949 557821 560688 562605 575014 576392 583314 583546 588939 593978 604367 607965 609569 615604 617504 617578 619699 624193 631093 631451 640361 640366 666045 667377 668105 680593 680744 683046 690259 692723 693926 695757 699519 700056 702639 703587 708051 711686 713148 719173 720655 724441 728924 728932 730343 730859 734404 734417 734554 734859 741992 742066 742702 744149 744162 744834 746709 746887 748028 748263 748279 748280 748283 748990 749046 750180 752090 760262 760635 767350 767462 767474 768226 773361 774667 775650 775652 775653 776094 777332 778285 780376 784575 784962 785571 786882 786920 792258 792556 793839 794194 794439 795012 795104 796844 800044 800116 801343 803150 806803 806821 807171 809907 813174 816774 818752 823272 824155 824343 824727 825775 827617 827687 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк pussy"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.83%) |
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.