Query Metrics
7
Database Queries
7
Different statements
426.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
400.78 ms (93.99%) |
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 437861 483040 494123 507853 514068 526126 530167 530248 541676 541766 541867 542050 544096 544955 545848 547999 548117 548738 549090 549593 550465 550628 550745 552438 552571 552755 553257 555825 556083 557465 557919 557968 558464 558901 559926 560416 560573 561404 561868 562198 562813 563355 563360 563633 563817 564051 564067 564223 564630 565327 565579 565813 565839 566325 566938 566967 567739 567772 568075 569449 571722 572671 573330 574025 574606 574607 574681 577889 581497 582947 583468 584502 587487 587847 589196 590352 590868 591398 592844 594533 594820 596035 599501 603654 607050 615830 617993 623120 623495 627699 637632 641852 647817 657865 663730 667223 668733 674352 674949 687833 689534 697695 699129 713588 714490 721613 725415 727089 732899 735186 745491 745776 750038 789867 798049 810545 814504 817451 826079 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (3.38%) |
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 514068 507853 567772 674352 689534 687833 572671 814504 817451 494123 542050 544096 545848 549090 550465 550745 556083 558901 559926 563360 564051 565327 566967 574606 574681 581497 583468 541867 547999 550628 552438 552571 557968 560416 561868 562813 563355 564630 566325 566938 571722 584502 548117 549593 553257 558464 560573 561404 562198 563817 565579 565813 568075 714490 721613 657865 663730 548738 555825 557465 563633 564067 564223 565839 567739 569449 573330 574607 577889 582947 591398 592844 623495 641852 587487 587847 590352 590868 594820 599501 603654 607050 617993 627699 589196 596035 732899 727089 623120 437861 526126 541676 483040 541766 826079 789867 530167 530248 544955 557919 574025 552755 647817 697695 714962 668733 674949 667223 713588 615830 594533 637632 798049 725415 810545 750038 745776 735186 745491 699129 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (0.87%) |
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 437861 483040 494123 507853 514068 526126 530167 530248 541676 541766 541867 542050 544096 544955 545848 547999 548117 548738 549090 549593 550465 550628 550745 552438 552571 552755 553257 555825 556083 557465 557919 557968 558464 558901 559926 560416 560573 561404 561868 562198 562813 563355 563360 563633 563817 564051 564067 564223 564630 565327 565579 565813 565839 566325 566938 566967 567739 567772 568075 569449 571722 572671 573330 574025 574606 574607 574681 577889 581497 582947 583468 584502 587487 587847 589196 590352 590868 591398 592844 594533 594820 596035 599501 603654 607050 615830 617993 623120 623495 627699 637632 641852 647817 657865 663730 667223 668733 674352 674949 687833 689534 697695 699129 713588 714490 721613 725415 727089 732899 735186 745491 745776 750038 789867 798049 810545 814504 817451 826079 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск маленькая"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade small"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.35%) |
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.