Query Metrics
7
Database Queries
7
Different statements
689.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
451.12 ms (65.44%) |
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 248347 340567 352189 382361 385390 387760 391915 392107 398073 398089 401861 402631 408885 410310 413673 415876 420140 420299 423812 444395 446016 449377 452948 454767 455915 465647 467584 475502 475504 480255 485661 493443 499872 499930 521238 526653 529599 529634 529713 529714 530402 530425 530698 531839 532634 536182 540945 547475 561019 574391 580069 584183 584425 586113 590370 594143 595213 600915 607706 619026 624399 628104 628105 628110 639024 660369 660380 660394 660417 666854 669016 670356 670360 671002 671008 671020 671038 672315 672944 672952 697236 717644 718701 718772 745111 749090 749672 751609 752656 752669 752679 752799 757225 758330 772210 772617 781879 795404 795420 796333 796647 796650 796703 796988 797341 798473 800444 800657 801495 803534 803547 803771 804639 806432 807571 807597 809046 811331 812467 824630 ] |
||||||||||||||||||||||||||||||
|
213.75 ms (31.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf дилд соло"
]
|
||||||||||||||||||||||||||||||
|
15.95 ms (2.31%) |
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 619026 595213 781879 811331 800657 801495 803547 803771 796988 697236 812467 408885 499930 529713 529714 540945 671002 660394 669016 671020 590370 600915 628104 745111 752669 758330 749672 752656 385390 521238 455915 607706 340567 420140 493443 628110 807571 757225 800444 392107 824630 444395 531839 584183 401861 398073 420299 449377 452948 717644 798473 809046 807597 772210 772617 752799 423812 806432 804639 398089 402631 413673 410310 415876 454767 480255 485661 446016 467584 475502 532634 529634 530698 530402 536182 475504 547475 584425 561019 574391 660380 660417 672944 718772 660369 670356 670360 671008 672315 672952 666854 671038 718701 580069 639024 628105 624399 586113 594143 795404 796650 796703 795420 796333 796647 803534 749090 797341 752679 751609 248347 352189 465647 526653 499872 391915 382361 387760 529599 530425 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.38%) |
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 248347 340567 352189 382361 385390 387760 391915 392107 398073 398089 401861 402631 408885 410310 413673 415876 420140 420299 423812 444395 446016 449377 452948 454767 455915 465647 467584 475502 475504 480255 485661 493443 499872 499930 521238 526653 529599 529634 529713 529714 530402 530425 530698 531839 532634 536182 540945 547475 561019 574391 580069 584183 584425 586113 590370 594143 595213 600915 607706 619026 624399 628104 628105 628110 639024 660369 660380 660394 660417 666854 669016 670356 670360 671002 671008 671020 671038 672315 672944 672952 697236 717644 718701 718772 745111 749090 749672 751609 752656 752669 752679 752799 757225 758330 772210 772617 781879 795404 795420 796333 796647 796650 796703 796988 797341 798473 800444 800657 801495 803534 803547 803771 804639 806432 807571 807597 809046 811331 812467 824630 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf dildo solo"
]
|
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.