Query Metrics
7
Database Queries
7
Different statements
166.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.11 ms (85.10%) |
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 401597 408532 424006 432724 452492 479618 486622 498161 501680 503016 503254 505986 506097 506604 510526 511901 513909 516734 522815 523122 525432 525681 528946 528998 529069 530494 533146 534459 534984 534996 541782 552068 552770 559798 560565 562237 566032 568683 569838 571048 574089 574853 579515 583614 590584 594289 596323 598805 600476 601907 603009 605310 605898 606031 612222 613765 619064 621883 624177 624179 629499 631167 631597 633813 633935 637044 639904 641677 643516 657817 657834 661687 662498 663176 663842 666819 671816 672984 679653 679816 680149 680785 684725 703700 706596 709710 711328 716414 722258 722594 722632 727665 727812 729815 731837 731874 732559 735371 744214 745550 747648 747897 751915 754003 757740 757896 762995 766706 777337 777553 779735 784622 788083 798693 799681 800517 803848 807527 808255 809211 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (9.82%) |
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 600476 747648 727665 486622 631167 612222 523122 525681 528946 528998 529069 534996 571048 583614 679653 566032 605310 513909 530494 679816 596323 534984 603009 637044 631597 525432 727812 722632 729815 666819 663176 808255 731874 722594 598805 809211 552068 516734 722258 807527 671816 732559 684725 657834 606031 639904 629499 541782 661687 803848 735371 747897 703700 779735 590584 633935 754003 680149 663842 621883 784622 762995 788083 751915 624179 711328 643516 777553 777337 799681 757740 424006 401597 579515 534459 662498 706596 408532 716414 560565 568683 522815 479618 680785 641677 624177 798693 709710 605898 506604 506097 533146 562237 613765 800517 745550 731837 498161 601907 569838 574853 574089 559798 672984 619064 766706 432724 510526 501680 511901 657817 633813 594289 503254 503016 505986 552770 757896 452492 744214 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.39%) |
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 401597 408532 424006 432724 452492 479618 486622 498161 501680 503016 503254 505986 506097 506604 510526 511901 513909 516734 522815 523122 525432 525681 528946 528998 529069 530494 533146 534459 534984 534996 541782 552068 552770 559798 560565 562237 566032 568683 569838 571048 574089 574853 579515 583614 590584 594289 596323 598805 600476 601907 603009 605310 605898 606031 612222 613765 619064 621883 624177 624179 629499 631167 631597 633813 633935 637044 639904 641677 643516 657817 657834 661687 662498 663176 663842 666819 671816 672984 679653 679816 680149 680785 684725 703700 706596 709710 711328 716414 722258 722594 722632 727665 727812 729815 731837 731874 732559 735371 744214 745550 747648 747897 751915 754003 757740 757896 762995 766706 777337 777553 779735 784622 788083 798693 799681 800517 803848 807527 808255 809211 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"первая порно"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"перв порн"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.79%) |
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.