Query Metrics
7
Database Queries
7
Different statements
220.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.88 ms (88.66%) |
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 73727 390275 397900 405903 406044 407421 413195 416821 422292 425601 438337 456575 472212 477480 477855 479284 479918 485005 499815 505983 507058 508131 513804 527018 545394 557857 559602 564046 584681 586228 586329 591489 595021 600372 606089 615411 617044 617099 617738 619187 638404 642234 643327 645736 650658 663935 665884 682495 684503 685391 687186 687928 688129 689299 689394 689808 689953 695415 695474 696049 700924 701469 706479 709150 710101 710165 715167 719917 724399 725156 730693 730707 735530 735934 742192 746715 748468 749896 752122 753950 755133 756063 758395 763996 765518 767504 769366 769820 771709 772947 774090 774877 777192 777320 779143 779362 782506 783417 786819 787252 787827 787886 790463 792707 793095 795207 796369 798279 800121 800420 800528 803445 804377 805358 808295 808855 810762 815540 820189 824457 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (6.76%) |
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 787886 800528 790463 725156 783417 795207 735530 617099 406044 617738 564046 682495 803445 413195 559602 688129 689808 689953 685391 782506 758395 804377 709150 695415 695474 615411 591489 787252 800420 798279 730707 792707 756063 730693 769366 710165 777192 507058 663935 808855 763996 755133 796369 438337 527018 584681 696049 719917 684503 643327 810762 765518 774090 772947 742192 724399 746715 777320 390275 508131 397900 710101 557857 701469 600372 805358 786819 485005 513804 706479 700924 650658 689299 586329 586228 617044 595021 800121 752122 749896 787827 815540 687186 665884 619187 753950 748468 774877 499815 422292 820189 479918 472212 779143 779362 808295 735934 771709 456575 715167 769820 416821 405903 689394 606089 793095 477855 477480 545394 687928 642234 767504 638404 73727 407421 425601 824457 479284 505983 645736 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.25%) |
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 73727 390275 397900 405903 406044 407421 413195 416821 422292 425601 438337 456575 472212 477480 477855 479284 479918 485005 499815 505983 507058 508131 513804 527018 545394 557857 559602 564046 584681 586228 586329 591489 595021 600372 606089 615411 617044 617099 617738 619187 638404 642234 643327 645736 650658 663935 665884 682495 684503 685391 687186 687928 688129 689299 689394 689808 689953 695415 695474 696049 700924 701469 706479 709150 710101 710165 715167 719917 724399 725156 730693 730707 735530 735934 742192 746715 748468 749896 752122 753950 755133 756063 758395 763996 765518 767504 769366 769820 771709 772947 774090 774877 777192 777320 779143 779362 782506 783417 786819 787252 787827 787886 790463 792707 793095 795207 796369 798279 800121 800420 800528 803445 804377 805358 808295 808855 810762 815540 820189 824457 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс table"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex on table"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс table"
]
|
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.