Query Metrics
7
Database Queries
7
Different statements
146.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.09 ms (83.32%) |
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 233657 389150 391087 391512 392111 397080 400487 401491 412827 418320 441780 441845 442088 443920 446522 447022 451499 454185 457240 459633 461629 466245 468343 477538 486209 492009 492293 493681 493775 495059 504038 518912 534044 535775 542986 543668 544878 549102 553241 555267 564294 564301 566767 566980 567994 582479 611171 622670 632026 639355 671858 671883 686158 686721 710362 714611 718119 719929 720888 721959 724123 724523 725205 726843 726887 728266 728517 731100 736784 737906 738000 742631 742740 743934 749891 757388 757488 758003 758128 759556 759571 759931 761084 765334 765616 765792 766220 768394 769035 769131 772740 773271 778215 781590 791624 794767 794863 794915 795297 795680 795722 796054 796119 796157 797194 797238 798801 799917 800582 802151 813944 814718 819425 823731 824613 826731 827632 828165 ] |
||||||||||||||||||||||||||||||
|
13.93 ms (9.50%) |
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 671858 671883 477538 725205 759556 493775 492009 504038 795297 459633 492293 710362 418320 639355 401491 441845 757388 392111 769035 795722 769131 758128 764595 826731 824613 828165 800582 794915 543668 686721 721959 454185 802151 719929 553241 797194 446522 795680 447022 468343 796157 797238 535775 728517 611171 736784 798801 759571 718119 794767 749891 791624 772740 389150 728266 758003 441780 726843 726887 757488 555267 773271 391512 443920 412827 632026 759931 796119 738000 622670 493681 495059 542986 566767 544878 564294 564301 765792 814718 737906 742740 457240 442088 819425 566980 391087 451499 466245 823731 518912 768394 486209 796054 765616 761084 742631 724123 731100 765334 794863 534044 781590 582479 799917 400487 397080 567994 233657 766220 827632 720888 743934 724523 778215 461629 686158 549102 813944 714611 794309 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (2.32%) |
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 233657 389150 391087 391512 392111 397080 400487 401491 412827 418320 441780 441845 442088 443920 446522 447022 451499 454185 457240 459633 461629 466245 468343 477538 486209 492009 492293 493681 493775 495059 504038 518912 534044 535775 542986 543668 544878 549102 553241 555267 564294 564301 566767 566980 567994 582479 611171 622670 632026 639355 671858 671883 686158 686721 710362 714611 718119 719929 720888 721959 724123 724523 725205 726843 726887 728266 728517 731100 736784 737906 738000 742631 742740 743934 749891 757388 757488 758003 758128 759556 759571 759931 761084 765334 765616 765792 766220 768394 769035 769131 772740 773271 778215 781590 791624 794767 794863 794915 795297 795680 795722 796054 796119 796157 797194 797238 798801 799917 800582 802151 813944 814718 819425 823731 824613 826731 827632 828165 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашние жены мамки"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск жен мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
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.