Query Metrics
7
Database Queries
7
Different statements
155.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.29 ms (84.98%) |
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 404739 409317 435245 460722 466263 475649 499382 499898 500346 506212 512793 515904 518332 519439 523419 525335 529573 546716 547111 555389 556817 556990 558709 558837 562190 563516 565784 567287 578058 581143 585964 586196 586323 589746 590291 592535 598795 599209 601260 601872 602128 603085 609816 611245 616809 626890 627218 636371 664660 667165 669934 674391 675397 681293 683036 690100 694141 697765 699323 700753 708960 710540 714476 714487 716218 716550 716760 717748 725401 732725 732912 736039 738094 744618 756304 762500 765036 771556 771947 772672 774904 775476 775551 778800 782413 783399 786831 787313 787386 788477 788880 789649 790664 790759 791988 793653 794108 794955 795191 796565 796657 799037 799127 799146 799353 799996 800200 800237 800863 801319 801320 802767 803461 804514 804619 808424 809752 809867 810149 814861 ] |
||||||||||||||||||||||||||||||
|
12.69 ms (8.15%) |
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 771556 796657 800237 804514 809867 515904 555389 714487 681293 626890 787313 744618 716760 788880 435245 562190 404739 519439 499898 563516 674391 725401 799353 799146 799127 523419 565784 603085 460722 500346 694141 710540 590291 592535 599209 602128 589746 586323 793653 790759 736039 782413 783399 800863 547111 567287 558837 669934 697765 708960 683036 586196 616809 627218 601872 791988 794108 795191 800200 796565 772672 787386 789649 799996 808424 810149 732912 732725 762500 756304 765036 699323 778800 499382 556817 558709 716550 664660 585964 598795 506212 803461 804619 529573 809752 409317 801319 512793 581143 717748 690100 700753 601260 774904 775551 786831 788477 801320 738094 790664 794955 799037 771947 802767 475649 814861 518332 556990 546716 714476 609816 636371 775476 611245 466263 525335 667165 675397 716218 578058 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.99%) |
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 404739 409317 435245 460722 466263 475649 499382 499898 500346 506212 512793 515904 518332 519439 523419 525335 529573 546716 547111 555389 556817 556990 558709 558837 562190 563516 565784 567287 578058 581143 585964 586196 586323 589746 590291 592535 598795 599209 601260 601872 602128 603085 609816 611245 616809 626890 627218 636371 664660 667165 669934 674391 675397 681293 683036 690100 694141 697765 699323 700753 708960 710540 714476 714487 716218 716550 716760 717748 725401 732725 732912 736039 738094 744618 756304 762500 765036 771556 771947 772672 774904 775476 775551 778800 782413 783399 786831 787313 787386 788477 788880 789649 790664 790759 791988 793653 794108 794955 795191 796565 796657 799037 799127 799146 799353 799996 800200 800237 800863 801319 801320 802767 803461 804514 804619 808424 809752 809867 810149 814861 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мама хочет меня"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин хочет"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.10%) |
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.