Query Metrics
8
Database Queries
8
Different statements
159.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.02 ms (84.84%) |
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 414594 443837 478679 484093 492457 505726 529236 531992 533268 536944 537682 539380 546052 547092 549716 550687 557877 558775 560238 562936 563762 566372 575621 577419 578758 581187 583323 584083 586253 588433 589521 592864 596442 599234 602363 604837 604929 605174 611284 619881 621364 626243 626772 630846 634677 638148 656138 659984 663755 666084 674387 680328 687942 692840 725301 727984 730361 732800 746215 748846 759899 761101 761307 763526 764321 764518 766113 767600 768200 769176 769537 769616 775274 778592 780613 789478 791449 791498 792244 794957 795193 795195 795468 795609 798811 801920 801939 802257 811424 811680 813771 816745 817739 818257 818919 819864 823465 823897 824359 824637 825245 825352 825918 826203 827615 828121 828232 828235 828240 828253 828439 828563 828582 828593 828617 828720 828802 ] |
||||||||||||||||||||||||||||||
|
11.53 ms (7.24%) |
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 824359 828240 828121 828720 828582 828563 802257 811680 767600 795195 592864 659984 539380 801920 443837 687942 563762 604837 586253 588433 611284 492457 533268 557877 769176 759899 769537 791498 414594 817739 813771 549716 692840 630846 778592 794957 725301 768200 730361 766113 763806 769616 478679 780613 537682 546052 550687 584083 547092 581187 674387 656138 663755 589521 596442 626772 795468 816745 798811 575621 583323 789478 484093 621364 791449 577419 680328 558775 604929 828593 823897 825245 826203 827615 818919 823465 825352 562936 792244 811424 748846 764910 766978 727984 763526 505726 764321 824637 560238 634677 605174 775274 666084 578758 619881 638148 626243 566372 819864 818257 825918 828232 828235 828253 828802 828617 828439 795193 795609 801939 732800 761101 761307 536944 764518 602363 529236 599234 531992 746215 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.93%) |
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 414594 443837 478679 484093 492457 505726 529236 531992 533268 536944 537682 539380 546052 547092 549716 550687 557877 558775 560238 562936 563762 566372 575621 577419 578758 581187 583323 584083 586253 588433 589521 592864 596442 599234 602363 604837 604929 605174 611284 619881 621364 626243 626772 630846 634677 638148 656138 659984 663755 666084 674387 680328 687942 692840 725301 727984 730361 732800 746215 748846 759899 761101 761307 763526 764321 764518 766113 767600 768200 769176 769537 769616 775274 778592 780613 789478 791449 791498 792244 794957 795193 795195 795468 795609 798811 801920 801939 802257 811424 811680 813771 816745 817739 818257 818919 819864 823465 823897 824359 824637 825245 825352 825918 826203 827615 828121 828232 828235 828240 828253 828439 828563 828582 828593 828617 828720 828802 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.61%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01–}\x13[üpv“\x1A"؆E0½"
]
|
||||||||||||||||||||||||||||||
|
2.33 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur milf pov"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск milf пов"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск milf пов"
]
|
||||||||||||||||||||||||||||||
|
1.43 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.