Query Metrics
7
Database Queries
7
Different statements
164.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.91 ms (85.73%) |
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 388857 393550 398848 410299 410321 462450 489286 505829 517288 523354 531655 541718 545990 547404 548973 548994 552621 554186 554827 557462 558082 560637 560937 563947 565552 568944 572705 581248 583528 594074 595423 597560 598474 604216 620044 622965 623195 623716 624161 625992 627122 631938 639950 641714 643462 647084 648512 648560 652188 652614 652904 653533 653544 654430 655069 656085 656090 656322 657142 657291 659419 666819 668449 672797 675041 678415 690251 691351 691611 696297 701486 703193 713300 720748 720793 721322 722617 725167 728404 728676 730623 739794 740710 743849 744689 748535 751665 753485 754195 754228 764835 766802 766806 766863 766883 769833 770287 770435 774652 775453 776937 776945 777082 777211 777318 778900 781105 786761 787550 788552 791181 793335 793440 795119 804320 805722 812362 813635 814490 814998 ] |
||||||||||||||||||||||||||||||
|
13.90 ms (8.46%) |
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 489286 517288 652614 721322 560937 583528 793440 730623 751665 805722 739794 744689 766802 770287 769833 778900 781105 393550 410321 701486 766883 753485 623716 648560 653544 659419 594074 620044 622965 523354 398848 554186 653533 656085 657291 675041 690251 696297 655069 656090 720748 563947 631938 623195 624161 643462 597560 787550 804320 754195 728404 764835 728676 748535 766806 770435 754228 766863 777082 793335 795119 656322 505829 666819 462450 703193 388857 410299 814490 813635 814998 531655 541718 547404 548973 548994 558082 565552 572705 581248 552621 557462 568944 647084 648512 668449 691611 652904 691351 713300 720793 652188 654430 657142 672797 678415 722617 545990 554827 560637 598474 604216 641714 625992 639950 595423 627122 774652 776937 777211 777318 786761 788552 775453 776945 791181 812362 725167 740710 743849 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.51%) |
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 388857 393550 398848 410299 410321 462450 489286 505829 517288 523354 531655 541718 545990 547404 548973 548994 552621 554186 554827 557462 558082 560637 560937 563947 565552 568944 572705 581248 583528 594074 595423 597560 598474 604216 620044 622965 623195 623716 624161 625992 627122 631938 639950 641714 643462 647084 648512 648560 652188 652614 652904 653533 653544 654430 655069 656085 656090 656322 657142 657291 659419 666819 668449 672797 675041 678415 690251 691351 691611 696297 701486 703193 713300 720748 720793 721322 722617 725167 728404 728676 730623 739794 740710 743849 744689 748535 751665 753485 754195 754228 764835 766802 766806 766863 766883 769833 770287 770435 774652 775453 776937 776945 777082 777211 777318 778900 781105 786761 787550 788552 791181 793335 793440 795119 804320 805722 812362 813635 814490 814998 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18-19-let anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 19 let лет анал"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 19 let лет анал"
]
|
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.