Query Metrics
7
Database Queries
7
Different statements
213.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.29 ms (88.83%) |
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 381944 391490 398930 412656 419636 419998 421377 424011 429958 439027 441427 441577 443862 457089 458156 463331 463839 467834 468343 470565 477149 481409 490387 499073 501510 503442 511301 533667 533695 534141 535634 537963 543532 543985 544181 583909 588843 608532 609289 616242 616752 621236 629711 643665 644881 646658 670014 683282 685479 696198 705479 720086 720979 723204 724027 724849 725185 731565 733798 735338 738000 739237 747749 748334 752545 754581 761624 762275 764265 764868 765717 765951 766355 766482 767073 768736 769047 769069 769075 773830 778235 778259 778896 780503 782349 783104 784288 786047 790520 791045 793202 794720 794763 794782 794886 794941 795122 796196 798799 798908 800370 801800 802139 803255 804930 809356 814985 816184 816609 816611 817342 817508 818760 818924 823817 825557 825716 826043 827147 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (6.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 629711 588843 778235 783104 791045 796196 803255 782349 790520 809356 724027 734988 800370 804930 738000 739237 764868 765951 769047 769069 725185 765717 767073 769075 735338 609289 723204 778259 793202 798799 801800 439027 814985 490387 470565 543985 685479 419636 463839 477149 421377 443862 537963 696198 720086 794720 398930 501510 511301 424011 441427 441577 481409 458156 463331 419998 503442 467834 499073 457089 825716 827147 818760 823817 816611 533667 533695 535634 543532 544181 646658 683282 670014 608532 616242 643665 621236 778896 733798 762275 794782 802139 766355 766482 752545 764265 754581 429958 784288 748334 761624 816184 644881 826043 816609 817342 817508 818924 825557 468343 534141 583909 705479 720979 616752 780503 794886 786047 794941 795122 724849 747749 768736 773830 731565 794763 381944 798908 412656 391490 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.08%) |
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 381944 391490 398930 412656 419636 419998 421377 424011 429958 439027 441427 441577 443862 457089 458156 463331 463839 467834 468343 470565 477149 481409 490387 499073 501510 503442 511301 533667 533695 534141 535634 537963 543532 543985 544181 583909 588843 608532 609289 616242 616752 621236 629711 643665 644881 646658 670014 683282 685479 696198 705479 720086 720979 723204 724027 724849 725185 731565 733798 735338 738000 739237 747749 748334 752545 754581 761624 762275 764265 764868 765717 765951 766355 766482 767073 768736 769047 769069 769075 773830 778235 778259 778896 780503 782349 783104 784288 786047 790520 791045 793202 794720 794763 794782 794886 794941 795122 796196 798799 798908 800370 801800 802139 803255 804930 809356 814985 816184 816609 816611 817342 817508 818760 818924 823817 825557 825716 826043 827147 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.67%) |
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.