Query Metrics
7
Database Queries
7
Different statements
150.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.19 ms (85.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 194398 229077 387851 388543 390225 391269 396859 400722 400976 411405 411416 414349 418459 422384 423852 428380 428962 429955 432265 432963 433584 433796 440717 444216 454194 454264 454282 454291 455131 456013 460554 461548 462003 462489 466051 470613 470624 473025 476486 479115 479138 479308 479625 479758 483826 491316 493195 498126 499224 506274 508800 510664 518899 525717 533681 535921 539967 542262 545875 546655 546876 566737 573104 595515 597123 597801 598489 600118 603915 623409 644048 655744 658608 662213 663231 670005 672707 683272 685106 692440 694104 695381 712951 713392 714588 715148 716033 718643 719447 721598 721608 722303 723021 725720 728054 730826 735881 736275 737001 737037 739436 741523 745662 747600 749861 752172 758973 760480 768734 779386 783514 786678 795203 796262 804861 825822 825976 826581 828668 ] |
||||||||||||||||||||||||||||||
|
12.44 ms (8.25%) |
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 387851 400976 498126 473025 432963 444216 388543 411416 429955 533681 672707 692440 683272 721598 721608 662213 663231 670005 685106 712951 713392 716033 597801 598489 595515 779386 739436 747600 754183 736275 737037 745662 752172 749861 741523 758973 714588 715148 718643 723021 479308 479138 470613 694104 783514 391269 454264 460554 479625 423852 454291 722303 600118 432265 542262 623409 725720 804861 603915 456013 400722 396859 461548 433796 825822 573104 655744 546655 760480 194398 428380 390225 411405 597123 479758 546876 229077 510664 476486 428962 422384 483826 491316 462003 418459 462489 466051 433584 479115 454282 455131 470624 454194 518899 506274 525717 499224 493195 508800 826581 825976 828668 535921 539967 545875 566737 658608 695381 719447 644048 796262 730826 728054 768734 737001 735881 786678 795203 414349 440717 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.00%) |
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 194398 229077 387851 388543 390225 391269 396859 400722 400976 411405 411416 414349 418459 422384 423852 428380 428962 429955 432265 432963 433584 433796 440717 444216 454194 454264 454282 454291 455131 456013 460554 461548 462003 462489 466051 470613 470624 473025 476486 479115 479138 479308 479625 479758 483826 491316 493195 498126 499224 506274 508800 510664 518899 525717 533681 535921 539967 542262 545875 546655 546876 566737 573104 595515 597123 597801 598489 600118 603915 623409 644048 655744 658608 662213 663231 670005 672707 683272 685106 692440 694104 695381 712951 713392 714588 715148 716033 718643 719447 721598 721608 722303 723021 725720 728054 730826 735881 736275 737001 737037 739436 741523 745662 747600 749861 752172 758973 760480 768734 779386 783514 786678 795203 796262 804861 825822 825976 826581 828668 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие натуральная натуральные русск"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big natural russian"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.82%) |
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.