Query Metrics
7
Database Queries
7
Different statements
161.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.60 ms (83.14%) |
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 388772 394136 395937 397065 397248 398204 400592 401081 401317 402240 402244 411184 415053 416969 428470 428539 439365 441397 444841 454633 466612 471346 475317 476084 485502 487724 489881 501535 516692 517416 518907 522190 534748 541772 547400 547477 550896 553722 554531 556418 560630 560903 561703 566889 568893 569894 570576 571357 575723 576225 579045 582303 583679 585552 591608 592402 592450 594164 596039 596648 597241 597499 597815 597969 598580 600223 601643 603040 605129 605333 609052 610300 610350 619552 625546 634509 635117 644021 648560 653216 657177 659161 659414 660364 668370 671020 671597 676924 677340 678903 681404 717066 718658 718663 720686 722527 722603 728384 730802 742473 743385 746978 752105 756822 761464 761567 767315 778347 793982 796950 799007 800390 800531 800536 814657 815495 818531 823759 826849 827601 ] |
||||||||||||||||||||||||||||||
|
16.93 ms (10.46%) |
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 597969 601643 402240 441397 541772 485502 395937 411184 814657 570576 575723 560903 547477 659414 678903 681404 657177 722527 560630 566889 583679 591608 592450 594164 585552 598580 605129 597815 609052 610300 799007 728384 730802 752105 718658 718663 444841 471346 476084 402244 439365 401081 415053 501535 394136 428470 823759 815495 818531 827601 826849 568893 571357 569894 659161 722603 668370 671597 597499 600223 635117 596039 743385 793982 742473 746978 756822 717066 778347 800390 401317 517416 579045 592402 619552 634509 625546 454633 428539 554531 653216 676924 660364 596648 603040 610350 796950 761464 761567 605333 644021 720686 397248 397065 648560 400592 416969 534748 487724 556418 561703 671020 597241 800531 800536 767315 388772 398204 466612 489881 475317 516692 522190 518907 550896 576225 553722 582303 547400 677340 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.73%) |
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 388772 394136 395937 397065 397248 398204 400592 401081 401317 402240 402244 411184 415053 416969 428470 428539 439365 441397 444841 454633 466612 471346 475317 476084 485502 487724 489881 501535 516692 517416 518907 522190 534748 541772 547400 547477 550896 553722 554531 556418 560630 560903 561703 566889 568893 569894 570576 571357 575723 576225 579045 582303 583679 585552 591608 592402 592450 594164 596039 596648 597241 597499 597815 597969 598580 600223 601643 603040 605129 605333 609052 610300 610350 619552 625546 634509 635117 644021 648560 653216 657177 659161 659414 660364 668370 671020 671597 676924 677340 678903 681404 717066 718658 718663 720686 722527 722603 728384 730802 742473 743385 746978 752105 756822 761464 761567 767315 778347 793982 796950 799007 800390 800531 800536 814657 815495 818531 823759 826849 827601 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny ass anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые жоп анал"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.