Query Metrics
7
Database Queries
7
Different statements
163.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.31 ms (84.73%) |
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 391571 391667 417067 424099 427143 443135 448412 456527 460581 461847 462262 472020 482832 485862 485921 486365 494030 500019 500038 509240 509829 533679 543640 543648 543689 543717 543759 545908 546653 546661 555808 562194 562492 562747 565333 566866 568684 575560 587895 595355 600197 605875 605961 610835 623385 624514 627691 644861 650290 662213 664514 667130 667147 670005 685106 687859 689170 694660 701665 702306 708182 712951 712953 714571 714588 715148 716033 721580 721582 721598 721608 723021 725754 726757 730819 731670 736260 736275 737037 741710 742386 745072 745662 747600 749797 749861 751581 752172 752708 758319 761650 761680 762277 762969 764097 764163 764580 767998 777206 777618 778143 780778 782037 784183 786216 788056 791507 791710 791913 792317 793930 796954 799883 801463 809604 809637 828440 828456 828556 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (9.68%) |
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 828440 828456 828556 546653 627691 782037 725754 767998 777618 667130 689170 687859 391667 443135 417067 427143 424099 644861 456527 461847 472020 482832 448412 485862 500019 509240 533679 500038 509829 460581 462262 485921 486365 494030 545908 566866 543648 543717 543759 562492 562747 543640 543689 546661 555808 565333 568684 575560 650290 664514 721580 667147 712953 721598 721608 662213 670005 685106 694660 712951 716033 562194 605875 595355 610835 624514 587895 600197 605961 777206 780778 786216 790453 791913 792317 799883 791507 801463 730819 741710 747600 752708 758319 761650 762277 788056 809637 726757 736260 736275 749797 761680 737037 742386 745072 745662 752172 764097 764580 749861 751581 762969 731670 764163 623385 701665 702306 708182 714571 714588 715148 721582 723021 778143 784183 791710 793930 796954 809604 391571 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.30%) |
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 391571 391667 417067 424099 427143 443135 448412 456527 460581 461847 462262 472020 482832 485862 485921 486365 494030 500019 500038 509240 509829 533679 543640 543648 543689 543717 543759 545908 546653 546661 555808 562194 562492 562747 565333 566866 568684 575560 587895 595355 600197 605875 605961 610835 623385 624514 627691 644861 650290 662213 664514 667130 667147 670005 685106 687859 689170 694660 701665 702306 708182 712951 712953 714571 714588 715148 716033 721580 721582 721598 721608 723021 725754 726757 730819 731670 736260 736275 737037 741710 742386 745072 745662 747600 749797 749861 751581 752172 752708 758319 761650 761680 762277 762969 764097 764163 764580 767998 777206 777618 778143 780778 782037 784183 786216 788056 791507 791710 791913 792317 793930 796954 799883 801463 809604 809637 828440 828456 828556 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"руский жена порна"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен порн"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.89%) |
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.