Query Metrics
7
Database Queries
7
Different statements
163.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.98 ms (87.49%) |
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 382712 397153 397888 398431 414760 418484 420220 430392 447683 465187 466040 493873 500712 501678 521802 523715 543819 548517 548632 548787 549326 549802 550444 550610 551204 553722 558987 559099 562240 564086 568324 570354 570465 570492 570652 570860 571555 571631 571899 572093 572128 572465 572480 573026 573077 573294 573632 573685 573698 573969 574816 575503 576293 576387 580361 583591 586585 587255 595402 595432 595465 595717 597239 597802 598617 598726 599513 600605 603587 608426 612093 620611 622111 623209 637743 648837 651126 664433 674216 674789 678557 679050 679383 684360 685889 694925 696125 698045 715083 716374 721791 721796 722535 722882 723603 726901 736055 745012 750090 753259 753435 755458 758036 760455 770489 771870 785922 807495 807510 810930 814488 817344 819272 819374 820610 821960 823448 823476 827418 ] |
||||||||||||||||||||||||||||||
|
11.80 ms (7.22%) |
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 595402 595432 597802 696125 770489 758036 500712 501678 564086 580361 571899 600605 608426 745012 623209 785922 570492 698045 397153 398431 694925 771870 418484 521802 551204 572465 573632 572093 573969 574816 562240 722882 679383 570652 571631 598617 586585 753435 715083 722535 414760 684360 549802 583591 736055 753259 568324 648837 597239 822927 827418 760455 575503 576387 573077 576293 548632 550444 550610 559099 570860 573026 664433 685889 572128 573294 420220 570354 572480 553722 558987 674216 571555 573685 598726 599513 750090 651126 674789 721796 603587 587255 466040 523715 814488 723603 819272 570465 678557 679050 721791 620611 622111 595717 807495 807510 382712 810930 820610 817344 465187 447683 716374 595465 819374 821960 823448 823476 612093 726901 755458 637743 493873 397888 430392 543819 548517 549326 573698 548787 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.43%) |
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 382712 397153 397888 398431 414760 418484 420220 430392 447683 465187 466040 493873 500712 501678 521802 523715 543819 548517 548632 548787 549326 549802 550444 550610 551204 553722 558987 559099 562240 564086 568324 570354 570465 570492 570652 570860 571555 571631 571899 572093 572128 572465 572480 573026 573077 573294 573632 573685 573698 573969 574816 575503 576293 576387 580361 583591 586585 587255 595402 595432 595465 595717 597239 597802 598617 598726 599513 600605 603587 608426 612093 620611 622111 623209 637743 648837 651126 664433 674216 674789 678557 679050 679383 684360 685889 694925 696125 698045 715083 716374 721791 721796 722535 722882 723603 726901 736055 745012 750090 753259 753435 755458 758036 760455 770489 771870 785922 807495 807510 810930 814488 817344 819272 819374 820610 821960 823448 823476 827418 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small pussy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая pussy секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.85%) |
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.