Query Metrics
7
Database Queries
7
Different statements
220.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.89 ms (89.60%) |
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 123955 213144 271280 366044 382084 386514 398146 400882 401570 425715 457784 475202 484130 485480 490024 505128 506623 519171 519190 520246 533502 533984 536892 545610 573706 573874 574538 577396 581902 593389 603355 604149 616668 619130 622613 626343 629461 630191 644900 650299 652179 653306 659512 660545 668425 668621 670491 671145 671146 672670 676618 683576 684301 692848 695596 701056 702168 704616 705300 713172 719472 720031 721455 721568 722000 722118 730326 733420 733731 734161 734681 736372 742926 746328 747133 753278 753909 754210 754256 758603 758676 766181 767341 767553 770820 774077 774274 775995 776685 777460 778226 778908 779526 780940 781076 781605 783412 784163 784444 786245 789309 791277 793768 796896 799885 802420 807954 809902 810617 814093 814234 816385 818250 823873 826551 827879 827946 828083 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (5.91%) |
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 733731 746328 784163 802420 766181 753909 774274 767341 789309 519171 626343 742926 425715 475202 484130 828083 659512 670491 671146 733420 754210 401570 822697 705300 695596 791277 796896 701056 823873 827879 827946 828391 653306 722000 672670 683576 722118 719472 721568 603355 616668 630191 778908 783412 778226 736372 807954 810617 753278 754256 758676 767553 774077 747133 622613 776685 793768 386514 652179 573874 619130 593389 398146 536892 545610 809902 213144 818250 650299 604149 730326 734681 775995 123955 758603 770820 581902 702168 520246 457784 485480 506623 519190 574538 577396 505128 490024 366044 271280 382084 400882 644900 814093 814234 816385 826551 533502 533984 573706 660545 692848 713172 720031 668621 671145 684301 704616 668425 676618 721455 629461 780940 781076 781605 784444 786245 799885 777460 779526 734161 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.26%) |
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 123955 213144 271280 366044 382084 386514 398146 400882 401570 425715 457784 475202 484130 485480 490024 505128 506623 519171 519190 520246 533502 533984 536892 545610 573706 573874 574538 577396 581902 593389 603355 604149 616668 619130 622613 626343 629461 630191 644900 650299 652179 653306 659512 660545 668425 668621 670491 671145 671146 672670 676618 683576 684301 692848 695596 701056 702168 704616 705300 713172 719472 720031 721455 721568 722000 722118 730326 733420 733731 734161 734681 736372 742926 746328 747133 753278 753909 754210 754256 758603 758676 766181 767341 767553 770820 774077 774274 775995 776685 777460 778226 778908 779526 780940 781076 781605 783412 784163 784444 786245 789309 791277 793768 796896 799885 802420 807954 809902 810617 814093 814234 816385 818250 823873 826551 827879 827946 828083 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck teens"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс teens"
]
|
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.