Query Metrics
7
Database Queries
7
Different statements
370.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.07 ms (58.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг секс"
]
|
||||||||||||||||||||||||||||||
|
129.99 ms (35.10%) |
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 428517 534529 540115 540149 540570 541863 541865 545993 547414 547506 549177 550560 550650 552606 552820 552822 553317 554850 555216 555732 556231 558732 561027 565277 573520 574385 577052 584087 588389 597235 598499 601830 614675 614819 615391 618129 623714 626547 628374 628383 628747 629575 630866 631196 631202 633511 634115 634218 634769 634801 635171 636450 636707 637003 637093 639334 639774 639818 641778 645019 648854 666525 666880 667944 670402 670442 671800 673039 674975 674983 675000 675523 676088 676636 678053 680143 696606 702163 707974 709298 710452 710895 714374 718581 719693 721958 722966 723643 733022 736265 738309 743470 745188 747137 747436 748964 748974 749143 752594 752736 758448 761223 762173 762222 762225 765517 766368 770662 789114 790356 790370 798877 799435 799476 799947 800495 800632 800913 804235 810076 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (4.14%) |
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 678053 648854 674975 637093 676088 577052 733022 766368 738309 541863 645019 631202 628374 597235 550650 680143 561027 762225 748964 547506 667944 636707 614819 618129 723643 541865 558732 800632 718581 552606 710452 629575 800913 722966 710895 584087 545993 670442 552820 800495 540570 634801 565277 674983 676636 702163 631196 634115 639818 634769 534529 554850 588389 799476 789114 743470 666525 635171 675523 630866 556231 707974 636450 628747 623714 810076 748974 752736 762173 770662 758448 641778 626547 799435 749143 428517 555732 721958 547414 573520 747137 761223 709298 804235 552822 550560 790356 765517 745188 747436 540115 574385 719693 598499 633511 614675 798877 540149 553317 555216 670402 671800 673039 601830 615391 790370 736265 762222 696606 628383 637003 666880 675000 639334 634218 639774 549177 714374 752594 799947 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.73%) |
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 428517 534529 540115 540149 540570 541863 541865 545993 547414 547506 549177 550560 550650 552606 552820 552822 553317 554850 555216 555732 556231 558732 561027 565277 573520 574385 577052 584087 588389 597235 598499 601830 614675 614819 615391 618129 623714 626547 628374 628383 628747 629575 630866 631196 631202 633511 634115 634218 634769 634801 635171 636450 636707 637003 637093 639334 639774 639818 641778 645019 648854 666525 666880 667944 670402 670442 671800 673039 674975 674983 675000 675523 676088 676636 678053 680143 696606 702163 707974 709298 710452 710895 714374 718581 719693 721958 722966 723643 733022 736265 738309 743470 745188 747137 747436 748964 748974 749143 752594 752736 758448 761223 762173 762222 762225 765517 766368 770662 789114 790356 790370 798877 799435 799476 799947 800495 800632 800913 804235 810076 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss in sex"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.