Query Metrics
7
Database Queries
7
Different statements
167.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.91 ms (86.33%) |
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 13370 70131 150396 188699 191398 210576 229160 381874 382693 385608 392909 401085 401790 405698 410251 417046 418382 422103 428383 435940 438055 445658 447909 452067 452400 453659 458208 462270 464570 465428 469146 469153 472095 472678 472698 473282 477752 478642 479368 479942 485235 486197 488911 489361 495302 495623 506083 507015 509459 513202 514448 516385 522547 523972 525062 525963 527533 527550 528132 528243 531576 534111 534651 534885 535862 537621 537636 545420 545965 546732 547309 549452 551089 552760 555706 557935 562929 564281 569003 590795 591234 601990 604626 613797 615509 617089 627667 627668 633708 639632 639895 670712 674355 684408 688140 690932 690965 704948 708915 717900 730023 731294 747503 750524 758533 760910 761880 766475 774100 780130 780886 782129 785885 786595 788844 790944 813836 827874 827875 827878 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (8.05%) |
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 827874 385608 485235 464570 730023 545965 761880 788844 528132 472095 546732 569003 392909 774100 534885 827878 478642 479368 627668 525062 782129 790944 229160 506083 552760 458208 690965 633708 452400 401085 688140 684408 465428 535862 591234 537636 704948 417046 537621 639632 531576 747503 760910 13370 639895 479942 513202 495623 405698 469146 410251 786595 750524 766475 780886 627667 489361 545420 486197 472698 514448 525963 758533 555706 613797 382693 534111 562929 670712 590795 780130 445658 522547 785885 453659 210576 473282 150396 418382 674355 70131 488911 708915 452067 617089 528243 549452 477752 827875 604626 435940 507015 527533 462270 495302 447909 509459 188699 472678 523972 717900 422103 547309 551089 615509 438055 534651 516385 690932 731294 428383 401790 469153 557935 191398 381874 527550 601990 813836 564281 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.61%) |
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 13370 70131 150396 188699 191398 210576 229160 381874 382693 385608 392909 401085 401790 405698 410251 417046 418382 422103 428383 435940 438055 445658 447909 452067 452400 453659 458208 462270 464570 465428 469146 469153 472095 472678 472698 473282 477752 478642 479368 479942 485235 486197 488911 489361 495302 495623 506083 507015 509459 513202 514448 516385 522547 523972 525062 525963 527533 527550 528132 528243 531576 534111 534651 534885 535862 537621 537636 545420 545965 546732 547309 549452 551089 552760 555706 557935 562929 564281 569003 590795 591234 601990 604626 613797 615509 617089 627667 627668 633708 639632 639895 670712 674355 684408 688140 690932 690965 704948 708915 717900 730023 731294 747503 750524 758533 760910 761880 766475 774100 780130 780886 782129 785885 786595 788844 790944 813836 827874 827875 827878 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public homemade"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.88%) |
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.