Query Metrics
7
Database Queries
7
Different statements
152.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.60 ms (83.77%) |
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 70636 124327 147403 171995 233320 253654 429545 477479 499339 519257 532093 533391 535355 536983 538058 538170 538602 541900 542958 543128 543930 546248 546486 547368 550302 555473 556676 561049 563791 564220 579167 584365 593505 603291 603680 604196 605629 621622 629838 637497 641293 652332 658434 665974 668576 669262 670723 670754 672787 681747 687163 696254 701307 713425 715587 724002 725205 725664 726331 728525 730962 732123 733035 733157 733508 738301 740740 741208 743043 746656 748110 749893 751507 768079 769555 773466 780878 786130 789903 795214 796815 801328 801381 802045 802300 803207 804094 809873 810019 811602 818755 819384 819886 820172 820304 823460 823731 824076 824129 824589 825061 825135 825189 825252 825264 825776 825844 826967 826978 827030 827260 827323 827358 827378 827415 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (10.20%) |
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 535355 541900 543930 593505 748110 746656 768079 823460 819384 820172 827260 824694 780166 773466 786130 538170 804094 538058 477479 550302 233320 827323 733035 665974 605629 733508 556676 672787 728525 820304 825264 826978 827415 819886 824076 824589 825776 825844 795214 780878 801328 533391 542958 543128 561049 563791 579167 701307 546248 547368 604196 803207 725664 749893 725205 738301 732123 823874 827378 825189 825135 652332 147403 70636 253654 823731 824599 826967 827030 789903 810019 724002 740740 743043 733157 796815 171995 809873 741208 730962 769555 536983 538602 668576 696254 641293 726331 629838 687163 681747 670723 621622 584365 751507 124327 802300 802045 429545 546486 603680 811602 801381 519257 825061 827358 823921 818755 825252 824129 532093 499339 555473 564220 670754 658434 669262 713425 715587 603291 637497 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.47%) |
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 70636 124327 147403 171995 233320 253654 429545 477479 499339 519257 532093 533391 535355 536983 538058 538170 538602 541900 542958 543128 543930 546248 546486 547368 550302 555473 556676 561049 563791 564220 579167 584365 593505 603291 603680 604196 605629 621622 629838 637497 641293 652332 658434 665974 668576 669262 670723 670754 672787 681747 687163 696254 701307 713425 715587 724002 725205 725664 726331 728525 730962 732123 733035 733157 733508 738301 740740 741208 743043 746656 748110 749893 751507 768079 769555 773466 780878 786130 789903 795214 796815 801328 801381 802045 802300 803207 804094 809873 810019 811602 818755 819384 819886 820172 820304 823460 823731 824076 824129 824589 825061 825135 825189 825252 825264 825776 825844 826967 826978 827030 827260 827323 827358 827378 827415 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateurs wife"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.36 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.