Query Metrics
7
Database Queries
7
Different statements
217.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.11 ms (87.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 26026 155175 396389 398229 398999 401769 403984 413124 419201 419616 419650 419969 421783 425288 425843 428116 439425 444233 444236 445665 447002 448031 448896 450671 452356 453028 453386 453443 454015 454384 455065 456938 457639 458446 459634 460281 462813 464687 467986 469342 479707 492460 496020 530600 532397 534731 537341 538147 548454 553130 561346 565124 567672 576468 584336 586175 592700 604837 605492 607683 612243 615020 616652 623425 634326 639436 641267 642076 642851 643455 653047 654945 662894 668705 669957 680484 693848 695477 697543 712334 714211 715600 715816 716534 716754 716773 725713 732625 735895 735911 744374 745323 745979 749871 750873 761257 768258 769354 769533 771761 778383 778815 779383 779973 781102 783327 789848 791405 796595 796612 799382 799528 808379 809744 811919 813749 821761 824340 825560 826989 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (7.83%) |
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 778383 778815 811919 769354 789848 799528 808379 735911 745979 769533 725713 732625 735895 768258 715600 779383 781102 403984 419616 425843 450671 530600 428116 460281 680484 453028 492460 464687 447002 454384 479707 534731 654945 669957 641267 604837 639436 642851 643455 586175 634326 615020 444236 26026 398229 398999 413124 813749 821761 825560 445665 455065 459634 452356 453443 453386 454015 538147 532397 565124 567672 592700 616652 642076 607683 779973 799382 809744 796612 783327 796595 761257 745323 771761 744374 749871 716754 456938 425288 457639 715816 419969 401769 537341 576468 668705 612243 750873 623425 791405 396389 467986 448896 439425 448031 561346 584336 605492 155175 419201 421783 444233 419650 826989 824340 458446 496020 462813 469342 548454 653047 712334 714211 662894 693848 695477 697543 716534 716773 553130 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.06%) |
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 26026 155175 396389 398229 398999 401769 403984 413124 419201 419616 419650 419969 421783 425288 425843 428116 439425 444233 444236 445665 447002 448031 448896 450671 452356 453028 453386 453443 454015 454384 455065 456938 457639 458446 459634 460281 462813 464687 467986 469342 479707 492460 496020 530600 532397 534731 537341 538147 548454 553130 561346 565124 567672 576468 584336 586175 592700 604837 605492 607683 612243 615020 616652 623425 634326 639436 641267 642076 642851 643455 653047 654945 662894 668705 669957 680484 693848 695477 697543 712334 714211 715600 715816 716534 716754 716773 725713 732625 735895 735911 744374 745323 745979 749871 750873 761257 768258 769354 769533 771761 778383 778815 779383 779973 781102 783327 789848 791405 796595 796612 799382 799528 808379 809744 811919 813749 821761 824340 825560 826989 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge boobs homemade"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные boobs домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные boobs домашн любительск"
]
|
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.