Query Metrics
7
Database Queries
7
Different statements
163.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.14 ms (86.18%) |
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 33488 34409 61369 88286 108221 118316 238994 318795 385508 387143 388077 389709 399008 399586 401477 405488 407127 419696 425536 453834 454842 459239 460281 461763 476312 479788 480745 486877 489331 505012 511480 516611 516619 516676 522143 530784 532839 533802 535896 536262 536285 536550 536588 536590 536653 540573 549495 552919 565927 569258 581816 588411 588875 591427 595761 612726 624283 626379 650012 663937 665421 666556 666779 667909 676636 678533 679761 682320 683533 691927 698120 707626 711342 711879 712317 723093 730450 737736 738307 738339 739125 741199 742757 744906 745323 753025 756528 762556 764524 772807 774400 776146 776785 781977 786175 787799 793374 793450 793455 793727 794584 796756 797949 800780 803386 805871 807927 810576 811144 815475 817750 818586 818874 820472 823481 825112 826532 827958 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (8.01%) |
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 683533 800780 676636 818874 552919 399008 480745 815475 588411 505012 536285 489331 762556 34409 818586 811144 682320 827958 711342 318795 61369 461763 678533 665421 825112 388077 787799 797949 741199 535896 793455 810576 774400 536653 530784 595761 385508 516619 516676 591427 739125 536590 712317 522143 723093 744906 407127 745323 459239 532839 817750 823481 511480 549495 793374 738307 753025 826532 707626 650012 793450 667909 401477 479788 569258 581816 486877 711879 389709 516611 781977 663937 666779 737736 405488 730450 565927 399586 536550 536588 667269 624283 387143 691927 533802 764524 756528 786175 118316 776785 679761 540573 238994 805871 742757 454842 425536 460281 612726 698120 793727 108221 769219 796756 738339 776146 807927 88286 419696 666556 626379 33488 453834 476312 536262 588875 772807 820472 803386 794584 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.70%) |
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 33488 34409 61369 88286 108221 118316 238994 318795 385508 387143 388077 389709 399008 399586 401477 405488 407127 419696 425536 453834 454842 459239 460281 461763 476312 479788 480745 486877 489331 505012 511480 516611 516619 516676 522143 530784 532839 533802 535896 536262 536285 536550 536588 536590 536653 540573 549495 552919 565927 569258 581816 588411 588875 591427 595761 612726 624283 626379 650012 663937 665421 666556 666779 667909 676636 678533 679761 682320 683533 691927 698120 707626 711342 711879 712317 723093 730450 737736 738307 738339 739125 741199 742757 744906 745323 753025 756528 762556 764524 772807 774400 776146 776785 781977 786175 787799 793374 793450 793455 793727 794584 796756 797949 800780 803386 805871 807927 810576 811144 815475 817750 818586 818874 820472 823481 825112 826532 827958 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge tits blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные сиськ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные сиськ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.