Query Metrics
7
Database Queries
7
Different statements
174.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.10 ms (86.17%) |
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 394235 395723 405946 417461 422048 423736 423978 426917 427591 428963 430320 438872 440701 441525 441622 442754 445639 448532 456964 458475 458946 461106 461174 472009 474112 482906 482951 482952 489226 490339 495844 496686 499720 502454 502736 502865 504195 506954 507827 510491 510930 518479 520921 521364 521377 521973 521988 521990 523069 523955 527077 527973 529223 540731 544021 547709 547913 547917 552988 557267 574964 578126 587258 590071 591070 595806 598466 601170 607153 609709 610047 610666 620938 623504 625492 625503 627690 628671 632308 646999 649202 663441 664957 668133 668944 691724 705139 707688 712281 714855 715407 723819 724027 729091 733671 734277 734401 737188 740173 741756 743564 750904 752170 753077 756295 759608 761634 771442 777633 779289 784358 786578 796244 797078 802723 803651 804807 804902 809976 814987 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (8.17%) |
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 649202 610666 448532 527973 423736 814987 461106 521364 499720 523955 587258 784358 472009 502736 521973 490339 510930 474112 507827 523069 664957 595806 632308 445639 521988 506954 504195 547917 574964 715407 625492 590071 777633 759608 756295 804807 520921 557267 527077 438872 458946 482951 518479 496686 544021 547709 547913 663441 737188 417461 430320 394235 423978 426917 502454 529223 540731 609709 591070 521990 440701 441622 495844 461174 578126 707688 598466 712281 428963 442754 458475 482906 510491 456964 521377 601170 625503 786578 723819 729091 714855 502865 552988 646999 668944 779289 809976 733671 796244 734277 427591 691724 610047 797078 741756 752170 753077 743564 750904 623504 422048 489226 482952 705139 668133 607153 734401 627690 441525 628671 620938 724027 761634 804902 740173 771442 803651 802723 405946 395723 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.73%) |
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 394235 395723 405946 417461 422048 423736 423978 426917 427591 428963 430320 438872 440701 441525 441622 442754 445639 448532 456964 458475 458946 461106 461174 472009 474112 482906 482951 482952 489226 490339 495844 496686 499720 502454 502736 502865 504195 506954 507827 510491 510930 518479 520921 521364 521377 521973 521988 521990 523069 523955 527077 527973 529223 540731 544021 547709 547913 547917 552988 557267 574964 578126 587258 590071 591070 595806 598466 601170 607153 609709 610047 610666 620938 623504 625492 625503 627690 628671 632308 646999 649202 663441 664957 668133 668944 691724 705139 707688 712281 714855 715407 723819 724027 729091 733671 734277 734401 737188 740173 741756 743564 750904 752170 753077 756295 759608 761634 771442 777633 779289 784358 786578 796244 797078 802723 803651 804807 804902 809976 814987 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные couple секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные couple секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural couple fuck"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.86%) |
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.