Query Metrics
7
Database Queries
7
Different statements
176.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.25 ms (86.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 6997 12118 334950 389332 403229 412957 419839 420266 420475 429482 430573 432707 434012 438397 445718 445759 448060 449318 450762 454241 455579 464306 464619 466163 467880 475390 486565 486800 494584 500331 503121 504614 505750 509794 510826 511249 511903 521201 522494 525671 526757 529180 540948 544992 549292 555984 561638 564461 570966 572737 580344 584062 590724 593043 593069 593531 593915 599052 599670 600281 604250 605058 605207 606768 619752 623512 627063 627674 650028 672878 673791 681304 695177 714170 716909 717940 719176 722820 722916 726713 727923 732292 734254 734364 738830 743117 744151 750469 752154 755635 757231 757973 765584 767957 770176 772419 773438 773470 775068 775770 775828 777079 790893 792612 802655 802723 804502 806167 809466 812132 815196 816925 818157 818858 819978 820163 822295 822492 823167 826380 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (7.65%) |
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 765584 773438 734254 744151 755635 773470 752154 757231 606768 714170 716909 719176 722820 790893 802655 804502 806167 812132 434012 522494 561638 717940 727923 420475 448060 466163 505750 494584 12118 511903 403229 420266 486565 544992 605058 549292 419839 822295 467880 564461 672878 593915 605207 623512 627063 775068 750469 757973 767957 734364 743117 738830 775828 449318 445718 464619 500331 584062 486800 475390 555984 681304 695177 650028 599052 604250 593069 792612 809466 432707 445759 503121 529180 526757 826380 511249 430573 775770 777079 770176 772419 732292 510826 509794 334950 389332 412957 429482 438397 815196 450762 572737 570966 580344 673791 590724 599670 619752 593043 593531 627674 802723 726713 722916 455579 454241 504614 521201 525671 600281 464306 6997 820163 816925 819978 818157 823167 818858 822492 540948 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.54%) |
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 6997 12118 334950 389332 403229 412957 419839 420266 420475 429482 430573 432707 434012 438397 445718 445759 448060 449318 450762 454241 455579 464306 464619 466163 467880 475390 486565 486800 494584 500331 503121 504614 505750 509794 510826 511249 511903 521201 522494 525671 526757 529180 540948 544992 549292 555984 561638 564461 570966 572737 580344 584062 590724 593043 593069 593531 593915 599052 599670 600281 604250 605058 605207 606768 619752 623512 627063 627674 650028 672878 673791 681304 695177 714170 716909 717940 719176 722820 722916 726713 727923 732292 734254 734364 738830 743117 744151 750469 752154 755635 757231 757973 765584 767957 770176 772419 773438 773470 775068 775770 775828 777079 790893 792612 802655 802723 804502 806167 809466 812132 815196 816925 818157 818858 819978 820163 822295 822492 823167 826380 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking ass pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза жоп pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза жоп pussy"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
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.