Query Metrics
7
Database Queries
7
Different statements
210.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.04 ms (88.32%) |
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 84837 336085 382769 387857 389935 389976 391772 391931 395769 399201 415894 418575 438051 441222 453225 454533 460774 465495 465798 468159 469214 473471 478023 488203 492677 499013 501904 503728 504233 504351 506277 506488 507191 513937 515668 519601 526527 536513 538991 542980 543678 545491 549707 550495 552847 553166 554243 557781 559090 559970 565734 566627 567782 571828 576761 579353 582654 587104 587966 588267 588480 597738 599829 601076 608363 611347 611474 613288 614578 614688 615251 615922 617471 618082 631252 634341 639661 642995 668467 670939 672354 678906 680675 683300 696287 697682 701248 712212 714580 721859 721942 721945 726767 727322 727367 731315 736384 736707 737998 744135 749025 753710 754434 755578 782179 787092 791490 793590 799734 799915 804440 809883 810322 811902 811907 818337 818750 819296 820761 825925 ] |
||||||||||||||||||||||||||||||
|
14.64 ms (6.95%) |
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 542980 550495 553166 678906 721942 721945 576761 588480 599829 601076 793590 726767 731315 712212 721859 336085 399201 536513 519601 672354 587966 587104 618082 631252 811902 799734 727367 736384 744135 753710 810322 453225 571828 460774 819296 818337 608363 515668 395769 389935 507191 566627 545491 557781 680675 668467 634341 714580 468159 499013 597738 504351 526527 506277 543678 697682 799915 737998 727322 84837 391931 438051 820761 582654 614688 615251 615922 642995 791490 809883 811907 736707 754434 755578 701248 804440 382769 391772 415894 473471 501904 825925 818750 670939 696287 559970 613288 614578 617471 787092 749025 387857 441222 454533 465495 469214 478023 503728 538991 506488 554243 567782 683300 549707 552847 559090 565734 611474 611347 639661 588267 782179 465798 418575 504233 492677 513937 579353 488203 389976 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.20%) |
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 84837 336085 382769 387857 389935 389976 391772 391931 395769 399201 415894 418575 438051 441222 453225 454533 460774 465495 465798 468159 469214 473471 478023 488203 492677 499013 501904 503728 504233 504351 506277 506488 507191 513937 515668 519601 526527 536513 538991 542980 543678 545491 549707 550495 552847 553166 554243 557781 559090 559970 565734 566627 567782 571828 576761 579353 582654 587104 587966 588267 588480 597738 599829 601076 608363 611347 611474 613288 614578 614688 615251 615922 617471 618082 631252 634341 639661 642995 668467 670939 672354 678906 680675 683300 696287 697682 701248 712212 714580 721859 721942 721945 726767 727322 727367 731315 736384 736707 737998 744135 749025 753710 754434 755578 782179 787092 791490 793590 799734 799915 804440 809883 810322 811902 811907 818337 818750 819296 820761 825925 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"душ камера"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван камер"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.78%) |
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.