Query Metrics
7
Database Queries
7
Different statements
202.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.58 ms (90.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 149622 185402 229024 383058 383480 390278 390730 393848 401871 402596 426775 426894 427542 435701 437551 441742 449168 451001 453859 456856 483781 490147 490168 509955 510029 511176 521265 529164 531036 536195 539750 545774 554340 554375 560136 564371 583110 584200 587052 592054 593671 608232 610142 610246 610249 610260 610390 611356 612684 614004 615710 621105 623756 623957 625008 640159 641654 643505 644188 644489 644491 644512 645297 651969 662851 665934 677158 687111 689576 689846 694336 697489 697894 698747 700805 702063 702652 709123 710359 716346 724929 725586 726539 729843 734188 735417 735684 738897 738947 742897 744477 744478 744480 747641 749526 758747 758812 759045 759772 762873 773156 773163 773177 773183 773190 773739 775599 785707 785716 786559 792535 792931 795298 796820 802686 804084 806361 810789 811662 814494 ] |
||||||||||||||||||||||||||||||
|
10.92 ms (5.39%) |
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 644491 734188 625008 623756 702652 490168 615710 545774 490147 390278 698747 709123 610260 644489 644512 786559 621105 441742 644188 725586 796820 773739 612684 689576 608232 640159 401871 427542 806361 804084 185402 426775 449168 554375 611356 564371 694336 742897 773177 785716 738947 775599 651969 665934 677158 687111 610246 623957 697489 536195 614004 773156 773163 744477 747641 749526 814494 456856 529164 592054 510029 792931 758747 792535 762873 738897 759045 697894 402596 539750 521265 645297 583110 710359 383058 531036 662851 426894 744480 435701 593671 773190 229024 554340 149622 390730 453859 716346 610249 641654 785707 724929 759772 735417 773183 758812 509955 689846 702063 643505 587052 610142 437551 393848 383480 451001 560136 584200 802686 744478 795298 810789 811662 726539 729843 735684 483781 511176 610390 700805 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.32%) |
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 149622 185402 229024 383058 383480 390278 390730 393848 401871 402596 426775 426894 427542 435701 437551 441742 449168 451001 453859 456856 483781 490147 490168 509955 510029 511176 521265 529164 531036 536195 539750 545774 554340 554375 560136 564371 583110 584200 587052 592054 593671 608232 610142 610246 610249 610260 610390 611356 612684 614004 615710 621105 623756 623957 625008 640159 641654 643505 644188 644489 644491 644512 645297 651969 662851 665934 677158 687111 689576 689846 694336 697489 697894 698747 700805 702063 702652 709123 710359 716346 724929 725586 726539 729843 734188 735417 735684 738897 738947 742897 744477 744478 744480 747641 749526 758747 758812 759045 759772 762873 773156 773163 773177 773183 773190 773739 775599 785707 785716 786559 792535 792931 795298 796820 802686 804084 806361 810789 811662 814494 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage amateur"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж любительск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж любительск"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.66%) |
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.