Query Metrics
7
Database Queries
7
Different statements
175.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.43 ms (88.32%) |
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 14711 14940 33401 95990 130060 148793 154516 161358 382788 385908 386024 386477 386956 387295 388774 390669 392797 393087 395989 396570 396723 397648 397781 401115 401509 402153 405504 411118 413999 415714 415739 415872 417825 429198 430770 432105 433516 443237 446345 446351 457494 459323 459325 463845 465474 468475 479703 483573 483576 496279 497806 530557 540528 548575 558304 563279 571015 583948 584214 584576 589187 589966 604494 605022 611918 623965 630194 633609 644309 649863 664260 665204 666582 669054 683593 695939 700831 704179 705702 711375 714663 719243 719817 720806 720889 724536 725041 728738 729937 731276 732345 732771 737171 737554 737734 741307 742163 742439 744668 751571 759842 761116 765810 784740 788194 790963 798399 799646 802601 804597 805607 807541 810709 810996 812113 814026 817365 819223 822559 826177 ] |
||||||||||||||||||||||||||||||
|
11.41 ms (6.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 497806 385908 405504 415714 433516 817365 819223 446351 457494 463845 468475 479703 558304 720806 664260 669054 666582 695939 705702 720889 584576 623965 790963 804597 807541 805607 802601 724536 725041 737171 728738 732345 737734 751571 731276 742439 759842 761116 765810 604494 633609 784740 810996 397648 430770 148793 719243 95990 630194 130060 396723 540528 548575 649863 644309 788194 392797 386477 154516 387295 390669 413999 415872 822559 826177 814026 446345 459323 459325 465474 483573 483576 530557 496279 571015 665204 714663 719817 700831 704179 563279 589966 589187 605022 799646 729937 732771 737554 711375 810709 401115 33401 382788 411118 386024 14940 397781 417825 432105 611918 741307 429198 388774 386956 402153 415739 583948 584214 683593 798399 742163 744668 812113 396570 395989 401509 161358 393087 14711 443237 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.37%) |
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 14711 14940 33401 95990 130060 148793 154516 161358 382788 385908 386024 386477 386956 387295 388774 390669 392797 393087 395989 396570 396723 397648 397781 401115 401509 402153 405504 411118 413999 415714 415739 415872 417825 429198 430770 432105 433516 443237 446345 446351 457494 459323 459325 463845 465474 468475 479703 483573 483576 496279 497806 530557 540528 548575 558304 563279 571015 583948 584214 584576 589187 589966 604494 605022 611918 623965 630194 633609 644309 649863 664260 665204 666582 669054 683593 695939 700831 704179 705702 711375 714663 719243 719817 720806 720889 724536 725041 728738 729937 731276 732345 732771 737171 737554 737734 741307 742163 742439 744668 751571 759842 761116 765810 784740 788194 790963 798399 799646 802601 804597 805607 807541 810709 810996 812113 814026 817365 819223 822559 826177 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black fuck"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black секс"
]
|
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.