Query Metrics
7
Database Queries
7
Different statements
227.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.77 ms (88.85%) |
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 477494 529660 540659 542206 544321 547086 551068 566555 577609 584664 588141 606809 609570 622042 622973 629659 636506 672385 674270 674585 680285 705411 708862 713945 715364 715493 717113 718025 719400 722178 724034 724280 726016 726428 726456 727409 731430 732578 732598 742984 743807 745050 746312 746461 750770 752512 754705 755394 760186 761303 764313 765145 767428 767446 769834 769950 770531 771667 772822 774105 774147 775010 778787 779767 781510 781828 782787 784864 784919 787193 787415 790680 791017 791540 791673 792762 793169 793251 794613 797220 798864 798921 799979 802010 802301 802452 803954 804741 805097 807322 807609 808698 809203 810172 810488 812213 813307 813603 814032 816181 816745 817368 818280 818987 819016 819943 822590 823826 825183 825462 825641 826303 826434 826749 827115 827319 828006 828136 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (6.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 731430 745050 732598 771667 803954 816181 817368 816745 827115 818987 826434 477494 542206 722178 674270 622973 636506 781201 790680 791540 792762 802452 804741 807322 787415 793169 810172 727409 774105 782787 807609 774147 732578 770531 715493 798921 802010 812213 808698 746461 726456 814032 818280 551068 791017 606809 781510 787193 828006 544321 577609 775010 724280 828136 784919 826303 584664 680285 674585 609570 767446 743807 823826 819016 819943 566555 705411 672385 713945 718025 588141 622042 629659 802301 810488 793251 794613 798864 726016 769834 799979 760186 769950 724034 742984 764313 750770 752512 754705 726428 761303 708862 717113 813307 822590 813603 825641 827319 826749 825183 825462 529660 540659 547086 715364 719400 778787 779767 781828 797220 784864 791673 805097 809203 746312 767428 774240 755394 772822 765145 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (1.74%) |
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 477494 529660 540659 542206 544321 547086 551068 566555 577609 584664 588141 606809 609570 622042 622973 629659 636506 672385 674270 674585 680285 705411 708862 713945 715364 715493 717113 718025 719400 722178 724034 724280 726016 726428 726456 727409 731430 732578 732598 742984 743807 745050 746312 746461 750770 752512 754705 755394 760186 761303 764313 765145 767428 767446 769834 769950 770531 771667 772822 774105 774147 775010 778787 779767 781510 781828 782787 784864 784919 787193 787415 790680 791017 791540 791673 792762 793169 793251 794613 797220 798864 798921 799979 802010 802301 802452 803954 804741 805097 807322 807609 808698 809203 810172 810488 812213 813307 813603 814032 816181 816745 817368 818280 818987 819016 819943 822590 823826 825183 825462 825641 826303 826434 826749 827115 827319 828006 828136 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"glasses handjob"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"очкастая дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.