Query Metrics
7
Database Queries
7
Different statements
152.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.96 ms (82.38%) |
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 386623 390508 398949 423858 442171 455974 456432 458784 460178 466134 484441 485851 497859 498368 502136 506842 506924 510220 516070 517622 518081 522446 524234 527225 527326 528632 535718 541994 543392 546994 554615 561289 561441 562955 564263 566187 571308 572214 573410 573749 573756 574995 575233 577422 577437 579848 580771 581427 582459 583688 585771 587860 589132 589598 591165 591167 593835 595785 596766 598185 599525 603669 609606 613536 614020 614565 615673 623620 625594 636576 637280 642521 650646 653618 662140 662922 670205 675951 700263 710030 713312 717603 719057 719808 735855 736798 738653 739916 742675 742677 743906 745404 748432 751026 753505 755011 755170 756880 758388 761102 761230 762402 766321 766734 779939 781306 788402 790962 793337 796203 799209 800936 800937 802182 808418 811461 811770 812998 813071 813483 ] |
||||||||||||||||||||||||||||||
|
18.80 ms (12.30%) |
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 527326 650646 713312 799209 591167 599525 603669 736798 755011 753505 535718 710030 662140 662922 675951 700263 596766 613536 637280 636576 615673 756880 758388 766321 811461 762402 761230 609606 788402 796203 812998 813071 485851 719057 517622 502136 583688 581427 591165 742675 751026 742677 779939 573410 577422 460178 719808 653618 739916 506842 518081 524234 554615 561441 574995 562955 589132 598185 642521 595785 790962 802182 811770 813483 745404 781306 800936 766734 761102 458784 423858 516070 497859 522446 498368 735855 546994 566187 572214 589598 755170 743906 456432 793337 738653 717603 748432 386623 571308 510220 527225 541994 573749 582459 561289 580771 670205 564263 573756 579848 614020 623620 625594 466134 484441 528632 585771 506924 800937 808418 442171 543392 455974 398949 577437 587860 575233 593835 614565 390508 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.45%) |
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 386623 390508 398949 423858 442171 455974 456432 458784 460178 466134 484441 485851 497859 498368 502136 506842 506924 510220 516070 517622 518081 522446 524234 527225 527326 528632 535718 541994 543392 546994 554615 561289 561441 562955 564263 566187 571308 572214 573410 573749 573756 574995 575233 577422 577437 579848 580771 581427 582459 583688 585771 587860 589132 589598 591165 591167 593835 595785 596766 598185 599525 603669 609606 613536 614020 614565 615673 623620 625594 636576 637280 642521 650646 653618 662140 662922 670205 675951 700263 710030 713312 717603 719057 719808 735855 736798 738653 739916 742675 742677 743906 745404 748432 751026 753505 755011 755170 756880 758388 761102 761230 762402 766321 766734 779939 781306 788402 790962 793337 796203 799209 800936 800937 802182 808418 811461 811770 812998 813071 813483 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"муж делится"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен дел"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.83%) |
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.