Query Metrics
7
Database Queries
7
Different statements
290.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
272.81 ms (93.92%) |
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 500971 507514 529649 531363 549215 590780 595695 609809 615460 618088 620969 632496 633561 636918 639065 652434 658481 660275 671166 683252 687105 688121 695074 700869 704487 709406 710393 716601 716626 716630 716645 716727 716736 716820 716831 717211 719408 722135 722148 725073 726215 727494 727511 728875 729919 730281 731388 731699 734608 742944 743850 744400 745887 747403 753078 754278 758894 760477 761327 763250 763263 763321 763325 763329 763335 763380 763634 767397 767520 767521 767525 767544 768187 768220 768237 768550 770035 774623 775480 776179 776508 776512 778031 778511 779546 779759 783217 783298 783787 784690 785442 785486 787037 787213 787493 792157 792264 792338 792363 793349 793389 793439 793455 793476 793746 793747 793759 793764 793767 794725 797547 799381 799703 799748 805623 806862 809188 810264 810615 814310 ] |
||||||||||||||||||||||||||||||
|
7.05 ms (2.43%) |
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 730281 767525 763250 704487 778031 660275 636918 794725 799703 507514 793767 753078 745887 728875 763634 710393 793389 793747 683252 716736 615460 620969 776179 793439 806862 784690 747403 783787 742944 763329 758894 763263 775480 783217 783298 810615 549215 716630 709406 688121 785486 787213 726215 734608 763325 768187 774623 793759 500971 799748 767397 768220 763380 763321 725073 719408 779759 792157 792264 768550 754278 761327 731699 716601 595695 793746 814310 529649 700869 590780 779546 792363 793455 760477 743850 687105 716831 716626 716645 633561 809188 727511 767521 792338 716727 717211 805623 770035 652434 658481 695074 671166 632496 776508 787493 799381 776512 793476 729919 767544 793349 767520 727494 744400 763335 609809 722135 793764 531363 618088 785442 787037 778511 797547 810264 731388 768237 716820 722148 639065 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.01%) |
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 500971 507514 529649 531363 549215 590780 595695 609809 615460 618088 620969 632496 633561 636918 639065 652434 658481 660275 671166 683252 687105 688121 695074 700869 704487 709406 710393 716601 716626 716630 716645 716727 716736 716820 716831 717211 719408 722135 722148 725073 726215 727494 727511 728875 729919 730281 731388 731699 734608 742944 743850 744400 745887 747403 753078 754278 758894 760477 761327 763250 763263 763321 763325 763329 763335 763380 763634 767397 767520 767521 767525 767544 768187 768220 768237 768550 770035 774623 775480 776179 776508 776512 778031 778511 779546 779759 783217 783298 783787 784690 785442 785486 787037 787213 787493 792157 792264 792338 792363 793349 793389 793439 793455 793476 793746 793747 793759 793764 793767 794725 797547 799381 799703 799748 805623 806862 809188 810264 810615 814310 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"горло трах"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горл секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.54%) |
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.