Query Metrics
7
Database Queries
7
Different statements
151.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.11 ms (84.11%) |
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 386735 401925 421762 432235 441933 441971 445051 453993 456005 457551 458293 461775 493034 493156 496123 505389 508706 512190 514323 517545 523281 533390 535515 544044 544613 546420 554846 557098 557735 560044 562462 563736 564704 567305 569019 571761 574178 577446 581314 584252 587962 589660 591913 598017 608083 610055 610166 610958 610974 619230 622529 623544 630449 630664 635391 635688 641369 644785 645518 648167 666068 677586 680253 683330 684970 689860 693767 694373 697207 699543 703226 705200 708051 710384 712318 715362 717104 724467 725408 726941 730312 731009 732200 732933 735871 737278 738463 742791 745262 750646 758097 759327 766307 769506 769562 778492 793223 794433 795811 802150 802340 802570 803789 804602 806035 814922 815419 815810 819346 819390 819410 820420 822026 823425 823977 824459 824562 824826 824967 ] |
||||||||||||||||||||||||||||||
|
13.29 ms (8.79%) |
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 742791 766307 715362 508706 517545 557735 562462 610055 724467 735871 610166 630664 421762 824967 815419 512190 546420 554846 677586 689860 705200 680253 645518 693767 699543 708051 598017 630449 641369 750646 794433 806035 738463 732200 769506 635688 703226 803789 445051 453993 456005 458293 386735 441933 533390 822026 819346 815810 535515 544613 574178 557098 577446 694373 717104 648167 587962 589660 591913 622529 793223 730312 731009 744533 759327 623544 635391 401925 523281 457551 725408 493156 496123 814922 819410 824459 493034 564704 567305 560044 683330 666068 684970 697207 610974 778492 804602 732933 745262 608083 710384 795811 802570 514323 824826 610958 432235 441971 819390 461775 505389 544044 563736 571761 569019 584252 712318 581314 619230 644785 802150 802340 737278 726941 758097 769562 823977 824562 820420 823425 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.05%) |
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 386735 401925 421762 432235 441933 441971 445051 453993 456005 457551 458293 461775 493034 493156 496123 505389 508706 512190 514323 517545 523281 533390 535515 544044 544613 546420 554846 557098 557735 560044 562462 563736 564704 567305 569019 571761 574178 577446 581314 584252 587962 589660 591913 598017 608083 610055 610166 610958 610974 619230 622529 623544 630449 630664 635391 635688 641369 644785 645518 648167 666068 677586 680253 683330 684970 689860 693767 694373 697207 699543 703226 705200 708051 710384 712318 715362 717104 724467 725408 726941 730312 731009 732200 732933 735871 737278 738463 742791 745262 750646 758097 759327 766307 769506 769562 778492 793223 794433 795811 802150 802340 802570 803789 804602 806035 814922 815419 815810 819346 819390 819410 820420 822026 823425 823977 824459 824562 824826 824967 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy inside"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая inside"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая inside"
]
|
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.