Query Metrics
7
Database Queries
7
Different statements
147.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.59 ms (83.00%) |
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 29902 72889 73070 89769 187918 251476 260158 305499 318318 322037 381901 382720 384492 387200 401508 401624 402260 410905 412071 420257 425865 427623 447145 450179 452177 454704 458815 461367 480467 481905 493486 494665 508444 510368 515980 519511 519633 527047 527516 530674 531887 533599 534576 534585 535949 537640 538925 540161 554620 556043 559192 563100 563826 565989 569762 574263 576494 596537 604911 613152 638445 641461 642045 645837 649291 660688 674141 678910 681085 692188 697513 707233 717377 720515 726516 727513 729640 730936 731668 733385 734386 736572 739577 739623 739863 747094 748979 748997 765545 765822 765836 766417 768502 773241 774029 774994 777314 777581 780649 788572 788697 794674 798255 799394 800338 800922 801364 802682 804608 806180 807216 810830 813783 814386 814744 815830 822606 826971 827080 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (9.90%) |
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 533599 515980 384492 420257 519633 559192 681085 733385 305499 815830 826971 556043 717377 645837 674141 660688 720515 563100 569762 641461 642045 765545 730936 736572 768502 739623 806180 73070 381901 412071 89769 251476 318318 401624 401508 530674 531887 527516 527047 563826 565989 554620 707233 678910 574263 576494 777581 788697 794674 801364 777314 780649 788572 800922 734386 798255 766417 727513 729640 765822 731668 773241 697513 410905 508444 810830 807216 452177 450179 765836 187918 494665 613152 774994 510368 447145 461367 387200 822606 538925 540161 519511 493486 662096 638445 739577 799394 425865 427623 813783 814744 454704 535949 649291 692188 596537 604911 800338 804608 726516 748997 802682 748979 739863 747094 774029 72889 458815 322037 260158 382720 29902 402260 827080 814386 480467 534576 534585 537640 481905 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.21%) |
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 29902 72889 73070 89769 187918 251476 260158 305499 318318 322037 381901 382720 384492 387200 401508 401624 402260 410905 412071 420257 425865 427623 447145 450179 452177 454704 458815 461367 480467 481905 493486 494665 508444 510368 515980 519511 519633 527047 527516 530674 531887 533599 534576 534585 535949 537640 538925 540161 554620 556043 559192 563100 563826 565989 569762 574263 576494 596537 604911 613152 638445 641461 642045 645837 649291 660688 674141 678910 681085 692188 697513 707233 717377 720515 726516 727513 729640 730936 731668 733385 734386 736572 739577 739623 739863 747094 748979 748997 765545 765822 765836 766417 768502 773241 774029 774994 777314 777581 780649 788572 788697 794674 798255 799394 800338 800922 801364 802682 804608 806180 807216 810830 813783 814386 814744 815830 822606 826971 827080 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs мастурбац"
]
|
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.