Query Metrics
7
Database Queries
7
Different statements
162.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.24 ms (86.79%) |
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 417733 421116 478642 478767 483792 493052 531377 533395 539613 541045 571947 588893 593589 599032 599614 605523 607153 613440 615184 616379 617388 619241 621548 622841 624816 625776 625935 625958 625978 626755 631059 631280 632295 632532 632930 637726 638439 641153 645884 646999 652552 652750 656576 662040 668034 668111 669239 674131 678711 679352 680370 681791 681961 694565 695467 698352 703291 704169 705726 707148 710355 711878 712458 716359 716992 717122 718614 718868 719280 720026 721091 722052 722058 722253 723963 726818 727451 728354 729038 729226 729789 730641 731075 731123 731197 735413 736131 736436 738732 739459 740145 742208 743875 745078 746166 746491 747982 751963 756263 756709 757713 761728 764623 779289 810856 813667 814762 814763 815174 815729 815973 816359 816544 817203 817704 819872 819949 822305 825581 825714 ] |
||||||||||||||||||||||||||||||
|
11.54 ms (7.09%) |
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 707148 720026 721091 645884 652552 656576 662040 681791 704169 712458 718614 719280 652750 668111 674131 678711 679352 680370 695467 711878 716359 571947 615184 616379 625776 593589 599032 625958 605523 619241 624816 625935 637726 599614 625978 626755 632532 638439 731123 742208 746491 728354 729038 756709 731075 743875 764623 738732 747982 751963 761728 736131 622841 631059 631280 632930 703291 710355 716992 717122 722052 421116 822305 825714 483792 493052 478642 539613 533395 478767 668034 722253 588893 617388 632295 739459 735413 613440 698352 417733 646999 681961 810856 816544 541045 718868 694565 757713 730641 740145 736436 726818 756263 813667 815174 814762 817704 814763 815729 815973 816359 531377 669239 705726 641153 607153 621548 779289 729789 723963 727451 731197 722058 729226 746166 745078 819872 819949 825581 817203 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.72%) |
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 417733 421116 478642 478767 483792 493052 531377 533395 539613 541045 571947 588893 593589 599032 599614 605523 607153 613440 615184 616379 617388 619241 621548 622841 624816 625776 625935 625958 625978 626755 631059 631280 632295 632532 632930 637726 638439 641153 645884 646999 652552 652750 656576 662040 668034 668111 669239 674131 678711 679352 680370 681791 681961 694565 695467 698352 703291 704169 705726 707148 710355 711878 712458 716359 716992 717122 718614 718868 719280 720026 721091 722052 722058 722253 723963 726818 727451 728354 729038 729226 729789 730641 731075 731123 731197 735413 736131 736436 738732 739459 740145 742208 743875 745078 746166 746491 747982 751963 756263 756709 757713 761728 764623 779289 810856 813667 814762 814763 815174 815729 815973 816359 816544 817203 817704 819872 819949 822305 825581 825714 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big cock"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большие cock"
]
|
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.