Query Metrics
7
Database Queries
7
Different statements
185.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.07 ms (86.80%) |
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 381849 389351 391577 398931 401589 402700 402730 404377 411328 413258 419518 422382 424293 424441 426926 428904 438023 438055 439663 439729 443723 445759 447434 447597 448047 460736 461963 464727 465895 468910 469681 469885 470159 470169 470656 470712 472003 475219 475589 475803 477005 477936 479215 480912 482053 484147 484437 487026 490904 491922 492969 494587 503121 504732 508121 514000 518133 518346 519410 521532 522203 523687 523908 526048 527031 528081 533750 547733 550218 555984 557646 557943 560644 563004 563413 569552 579200 590514 598176 609141 616978 621228 621335 621770 622832 627744 656988 665658 686825 695850 710524 712295 721381 722596 722880 736345 739384 740012 741503 741950 751222 753581 753809 759548 760514 766260 770427 772653 777136 777205 781670 786346 789294 797592 801271 801591 814990 820314 820662 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (8.22%) |
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 722596 598176 797592 801271 736345 786346 741836 759548 741950 721381 438055 448047 438023 479215 487026 621335 464727 528081 391577 404377 814990 470656 760514 381849 475589 411328 443723 465895 470712 519410 526048 590514 424293 569552 389351 477005 413258 504732 492969 621770 627744 439663 460736 521532 665658 710524 533750 609141 477936 482053 428904 461963 475219 494587 563004 550218 447597 475803 480912 402730 439729 523687 484147 518346 514000 469885 523908 820314 656988 686825 712295 722880 695850 777205 781670 801591 789294 740012 741503 753809 766260 772653 753581 739384 751222 770427 621228 622832 402700 401589 484437 555984 563413 547733 560644 557943 616978 445759 426926 468910 470159 470169 472003 419518 469681 424441 447434 522203 527031 503121 490904 491922 518133 508121 820662 777136 557646 579200 398931 422382 ] |
||||||||||||||||||||||||||||||
|
2.73 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 381849 389351 391577 398931 401589 402700 402730 404377 411328 413258 419518 422382 424293 424441 426926 428904 438023 438055 439663 439729 443723 445759 447434 447597 448047 460736 461963 464727 465895 468910 469681 469885 470159 470169 470656 470712 472003 475219 475589 475803 477005 477936 479215 480912 482053 484147 484437 487026 490904 491922 492969 494587 503121 504732 508121 514000 518133 518346 519410 521532 522203 523687 523908 526048 527031 528081 533750 547733 550218 555984 557646 557943 560644 563004 563413 569552 579200 590514 598176 609141 616978 621228 621335 621770 622832 627744 656988 665658 686825 695850 710524 712295 721381 722596 722880 736345 739384 740012 741503 741950 751222 753581 753809 759548 760514 766260 770427 772653 777136 777205 781670 786346 789294 797592 801271 801591 814990 820314 820662 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass lick russian"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп лиза русск"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.74%) |
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.