Query Metrics
7
Database Queries
7
Different statements
175.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.27 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 385220 389711 393585 395867 396885 396994 408354 414866 415568 420240 432149 434055 443513 443780 445889 453159 466212 467036 468788 480742 482335 491402 496114 500467 504055 508718 514470 518286 518823 529524 533575 537520 543242 544523 559861 559880 560087 560958 565747 566761 568051 581482 606487 607845 611339 612796 617493 619449 623555 623859 624238 628020 637740 671335 682166 682467 682571 685612 686024 690771 699540 699708 703834 706668 707479 710054 712188 716487 719342 722053 726448 726725 726862 727392 732236 733160 733271 734117 737581 739957 755312 772163 775028 776632 781967 784703 794698 795180 797049 798764 800622 801343 801531 801935 803171 804162 804177 807431 814336 814611 815372 815468 815845 815872 815888 816213 816394 816618 817100 817851 817883 818511 819185 819773 820686 822181 823502 826834 826873 ] |
||||||||||||||||||||||||||||||
|
13.10 ms (7.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 800622 803171 737581 703834 414866 468788 395867 445889 504055 560958 544523 733271 732236 518286 434055 415568 443513 500467 566761 432149 508718 453159 467036 611339 443780 480742 393585 466212 529524 385220 389711 396885 396994 408354 420240 817851 820686 822181 817100 817883 818511 819773 823502 826834 814611 815372 815468 816394 819185 814336 815845 815872 815888 816213 816618 826873 482335 518823 533575 514470 537520 496114 491402 543242 559861 560087 581482 568051 671335 685612 716487 682166 682571 690771 699540 707479 719342 682467 686024 706668 710054 712188 559880 565747 612796 619449 624238 637740 607845 628020 606487 623859 798764 807431 794698 797049 801935 804177 726725 727392 733160 734117 772851 795180 801531 804162 726862 739957 755312 726448 772163 617493 623555 699708 722053 775028 776632 781967 784703 801343 ] |
||||||||||||||||||||||||||||||
|
4.86 ms (2.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy licking hairy"
]
|
||||||||||||||||||||||||||||||
|
3.87 ms (2.21%) |
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 385220 389711 393585 395867 396885 396994 408354 414866 415568 420240 432149 434055 443513 443780 445889 453159 466212 467036 468788 480742 482335 491402 496114 500467 504055 508718 514470 518286 518823 529524 533575 537520 543242 544523 559861 559880 560087 560958 565747 566761 568051 581482 606487 607845 611339 612796 617493 619449 623555 623859 624238 628020 637740 671335 682166 682467 682571 685612 686024 690771 699540 699708 703834 706668 707479 710054 712188 716487 719342 722053 726448 726725 726862 727392 732236 733160 733271 734117 737581 739957 755312 772163 775028 776632 781967 784703 794698 795180 797049 798764 800622 801343 801531 801935 803171 804162 804177 807431 814336 814611 815372 815468 815845 815872 815888 816213 816394 816618 817100 817851 817883 818511 819185 819773 820686 822181 823502 826834 826873 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая лиза волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.83%) |
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.