Query Metrics
7
Database Queries
7
Different statements
193.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.48 ms (87.55%) |
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 145624 383153 386215 388185 411729 418161 426298 435355 435607 441926 442709 463295 489207 490594 490632 496466 509762 513450 526563 529393 532616 533299 534515 535346 540185 544915 545047 548418 548421 549040 551515 555988 557025 568738 569564 576471 576880 583083 583164 587126 589467 595641 598368 600590 600650 605741 607526 612211 615766 616660 617880 619648 627679 628022 628633 637197 637901 640361 640660 643000 643326 650531 665039 666680 666706 666716 675615 697229 701416 705053 707470 707481 709759 710639 711197 714359 719781 722149 724719 725651 728958 736017 743268 745629 745991 746065 746126 748118 749455 749493 759701 767516 774661 783348 784645 785012 791857 793524 793821 794401 794937 795812 796397 801841 802311 803136 803821 804435 804630 806801 806827 810861 812116 813707 814272 824320 826435 827017 827393 827501 ] |
||||||||||||||||||||||||||||||
|
14.63 ms (7.56%) |
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 826435 643326 665039 534515 745629 749493 759701 463295 569564 722149 612211 736017 697229 548421 791857 666706 666716 435355 489207 628633 746126 627679 557025 548418 411729 509762 426298 526563 707470 568738 709759 803821 804435 714359 728958 583164 745991 435607 794401 746065 774661 640361 643000 810861 785012 388185 725651 707481 615766 442709 824320 793821 827017 598368 532616 496466 576471 589467 600590 628022 803136 796397 724719 812116 637901 555988 804630 418161 490632 535346 701416 616660 383153 145624 549040 666680 650531 544915 640660 587126 783348 743268 551515 545047 605741 749455 814272 719781 675615 795812 748118 767516 490594 583083 529393 513450 705053 595641 801841 806801 607526 806827 441926 793524 386215 813707 827393 827501 540185 533299 710639 637197 617880 600650 802311 784645 711197 794937 576880 619648 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.59%) |
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 145624 383153 386215 388185 411729 418161 426298 435355 435607 441926 442709 463295 489207 490594 490632 496466 509762 513450 526563 529393 532616 533299 534515 535346 540185 544915 545047 548418 548421 549040 551515 555988 557025 568738 569564 576471 576880 583083 583164 587126 589467 595641 598368 600590 600650 605741 607526 612211 615766 616660 617880 619648 627679 628022 628633 637197 637901 640361 640660 643000 643326 650531 665039 666680 666706 666716 675615 697229 701416 705053 707470 707481 709759 710639 711197 714359 719781 722149 724719 725651 728958 736017 743268 745629 745991 746065 746126 748118 749455 749493 759701 767516 774661 783348 784645 785012 791857 793524 793821 794401 794937 795812 796397 801841 802311 803136 803821 804435 804630 806801 806827 810861 812116 813707 814272 824320 826435 827017 827393 827501 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy wet pussy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая мокрые pussy"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая мокрые pussy"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.68%) |
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.