Query Metrics
7
Database Queries
7
Different statements
195.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.85 ms (84.70%) |
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 382083 385197 386535 399015 406764 411768 415735 420301 425773 426604 430142 435703 453235 457154 468047 468470 468475 469579 469582 470317 472579 474647 484790 485165 486161 491275 495367 496302 499894 501589 503051 504546 508647 510205 510674 512683 517741 518177 521741 522790 523281 525637 527220 528173 530492 530623 530851 531170 531183 532783 532988 534627 534650 535816 536287 536309 536618 536739 537671 537885 543894 544694 544793 568058 569162 579329 596643 597253 600346 600429 602970 604483 605338 619392 622682 631192 631193 632594 633798 634202 634207 634528 634556 637103 639731 640728 643112 646451 646935 647308 647638 648871 666575 673570 673767 674984 676101 678125 679728 679744 680122 683052 694100 705720 712887 714830 716065 716910 718930 720117 722187 727699 740637 745385 756001 761004 772476 802375 810674 ] |
||||||||||||||||||||||||||||||
|
20.53 ms (10.48%) |
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 406764 415735 430142 420301 426604 486161 527220 469582 385197 470317 474647 386535 485165 495367 532783 534650 536287 537671 525637 532988 531170 531183 530623 679744 673570 674984 666575 678125 680122 568058 640728 634202 596643 600346 600429 631192 761004 622682 435703 499894 501589 468470 399015 468047 472579 531192 536739 536309 528173 535816 544694 569162 579329 543894 673767 683052 716910 718930 647308 694100 712887 716065 722187 544793 602970 810674 745385 756001 772476 727699 740637 634528 705720 714830 720117 802375 457154 523281 634556 605338 503051 534627 536618 537885 530492 530851 676101 679728 646451 646935 647638 648871 604483 632594 633798 637103 597253 634207 643112 631193 639731 382083 411768 453235 510205 510674 469579 619392 425773 496302 504546 491275 521741 468475 484790 517741 512683 518177 508647 522790 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.39%) |
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 382083 385197 386535 399015 406764 411768 415735 420301 425773 426604 430142 435703 453235 457154 468047 468470 468475 469579 469582 470317 472579 474647 484790 485165 486161 491275 495367 496302 499894 501589 503051 504546 508647 510205 510674 512683 517741 518177 521741 522790 523281 525637 527220 528173 530492 530623 530851 531170 531183 532783 532988 534627 534650 535816 536287 536309 536618 536739 537671 537885 543894 544694 544793 568058 569162 579329 596643 597253 600346 600429 602970 604483 605338 619392 622682 631192 631193 632594 633798 634202 634207 634528 634556 637103 639731 640728 643112 646451 646935 647308 647638 648871 666575 673570 673767 674984 676101 678125 679728 679744 680122 683052 694100 705720 712887 714830 716065 716910 718930 720117 722187 727699 740637 745385 756001 761004 772476 802375 810674 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting interracial"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.