Query Metrics
7
Database Queries
7
Different statements
361.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.46 ms (56.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
134.70 ms (37.28%) |
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 7271 46409 117755 188079 188499 203497 285702 308542 373842 383951 385677 387039 397312 397319 398388 401109 401122 401124 406406 406596 409048 414105 414218 414938 420800 421146 424523 428889 464921 468749 493508 506501 509672 531533 548162 550549 583276 586006 592332 597553 597995 600358 604650 605167 610806 615129 615690 615789 632108 633115 634536 638605 651636 662090 662204 664781 671389 679114 679147 696227 704220 707738 720827 722578 722869 725144 727780 727839 731874 733902 736802 742831 743282 744704 750187 750710 753638 755937 758959 760966 764284 766703 767125 767198 769733 770284 774950 777059 777562 777888 778038 778842 778937 782410 783609 785981 786327 788820 788954 797869 800303 800683 803669 803919 804757 805310 816241 816887 818727 818793 821109 821128 821588 822168 823092 823341 824864 824915 824938 827491 ] |
||||||||||||||||||||||||||||||
|
13.28 ms (3.67%) |
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 597553 778937 774950 777562 777888 727839 758959 742831 767198 778842 401124 696227 725144 383951 188499 308542 7271 638605 424523 679114 285702 744704 414938 464921 468749 769733 600358 406406 767125 117755 610806 788820 797869 373842 398388 401122 823092 821109 531533 550549 583276 704220 707738 651636 662090 662204 604650 605167 597995 586006 615789 777059 778038 783609 788954 750710 755937 803669 727780 750187 764284 731874 743282 753638 615129 632108 800303 46409 414105 803919 786327 406596 720827 615690 804757 733902 824915 818727 671389 664781 736802 506501 634536 203497 592332 509672 387039 421146 818793 679147 722578 633115 401109 409048 397319 493508 420800 428889 188079 822168 548162 722869 414218 385677 397312 816241 824938 823341 827491 816887 824864 821128 821588 805310 785981 800683 760966 770284 782410 766703 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.78%) |
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 7271 46409 117755 188079 188499 203497 285702 308542 373842 383951 385677 387039 397312 397319 398388 401109 401122 401124 406406 406596 409048 414105 414218 414938 420800 421146 424523 428889 464921 468749 493508 506501 509672 531533 548162 550549 583276 586006 592332 597553 597995 600358 604650 605167 610806 615129 615690 615789 632108 633115 634536 638605 651636 662090 662204 664781 671389 679114 679147 696227 704220 707738 720827 722578 722869 725144 727780 727839 731874 733902 736802 742831 743282 744704 750187 750710 753638 755937 758959 760966 764284 766703 767125 767198 769733 770284 774950 777059 777562 777888 778038 778842 778937 782410 783609 785981 786327 788820 788954 797869 800303 800683 803669 803919 804757 805310 816241 816887 818727 818793 821109 821128 821588 822168 823092 823341 824864 824915 824938 827491 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat anal"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.42%) |
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.