Query Metrics
7
Database Queries
7
Different statements
215.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.90 ms (87.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 395574 428062 461735 461933 482335 496076 510879 511572 512718 514802 516957 523554 531655 533301 534087 537667 541708 541718 550345 553757 558082 559996 560987 564391 565552 566873 567684 604361 606767 609343 610851 624360 646289 652927 654906 660414 661936 665745 668102 668449 669074 670727 671704 675612 683242 686558 689359 691511 691611 691738 694083 697600 701396 715020 715552 715627 716086 719245 719300 720206 720224 720982 721390 721726 736830 742458 746160 747709 752987 754584 756301 756535 761528 765597 766768 766797 768358 773734 777021 787567 788557 788912 789205 790496 790531 794366 804325 804590 808152 814390 814490 814570 814998 815266 817215 818959 819020 820197 820565 820572 820855 821110 821121 821136 821319 821434 821437 822686 823490 823740 824425 824679 826242 826674 827221 827359 828539 828760 ] |
||||||||||||||||||||||||||||||
|
17.78 ms (8.26%) |
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 826674 826242 817215 819020 827221 818959 820855 821121 815266 820197 821110 822686 823740 824425 824679 827359 828539 665745 683242 691511 691738 715552 652927 720224 721726 701396 715020 624360 794366 746160 766768 787567 788912 790531 804590 808152 752987 742458 744999 747709 754584 761528 765597 766797 773734 606767 719245 721975 777021 788557 804325 566873 604361 790496 756535 669074 720206 821136 828760 533301 646289 720982 610851 789205 697600 510879 736830 768358 756301 559996 609343 395574 428062 814490 821319 823490 814570 820565 814390 820572 814998 821434 821437 482335 514802 534087 537667 496076 512718 516957 523554 531655 511572 461735 461933 541718 558082 560987 565552 541708 550345 553757 564391 567684 654906 660414 661936 668102 668449 670727 671704 675612 686558 689359 691611 694083 715627 716086 719300 721390 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.33%) |
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 395574 428062 461735 461933 482335 496076 510879 511572 512718 514802 516957 523554 531655 533301 534087 537667 541708 541718 550345 553757 558082 559996 560987 564391 565552 566873 567684 604361 606767 609343 610851 624360 646289 652927 654906 660414 661936 665745 668102 668449 669074 670727 671704 675612 683242 686558 689359 691511 691611 691738 694083 697600 701396 715020 715552 715627 716086 719245 719300 720206 720224 720982 721390 721726 736830 742458 746160 747709 752987 754584 756301 756535 761528 765597 766768 766797 768358 773734 777021 787567 788557 788912 789205 790496 790531 794366 804325 804590 808152 814390 814490 814570 814998 815266 817215 818959 819020 820197 820565 820572 820855 821110 821121 821136 821319 821434 821437 822686 823490 823740 824425 824679 826242 826674 827221 827359 828539 828760 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long hair anal"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные hair анал"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные hair анал"
]
|
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.