Query Metrics
7
Database Queries
7
Different statements
377.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.42 ms (54.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss girl"
]
|
||||||||||||||||||||||||||||||
|
149.22 ms (39.57%) |
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 541784 541787 541788 541790 541793 541798 542447 542454 542717 542718 542720 544244 547408 547411 547416 547441 547515 548301 549037 549040 550201 554682 554683 554686 554707 554724 554828 555226 555315 555780 555967 558893 559423 561046 564281 570159 574342 576484 576559 577026 581557 585057 585802 588858 595699 598267 599934 601513 605067 607906 613161 615533 617570 620911 626402 627833 627835 628368 629646 630963 632565 632697 633768 634382 640037 641667 643013 649556 650700 651147 651784 659009 661654 670263 670404 670465 671054 671792 678761 678820 679630 679810 680126 680185 680189 691337 696098 709444 710224 716161 716600 718782 719435 720446 724731 727045 733381 733840 736558 740835 749801 749924 751357 751606 752859 763741 763852 787916 788112 795990 796338 804304 804403 804408 810892 812312 814157 814172 823943 827941 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (3.78%) |
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 651147 680126 628368 814172 542717 574342 558893 752859 541798 542720 549037 554707 564281 541788 544244 554683 559423 719435 651784 661654 634382 630963 796338 804403 804408 812312 626402 804304 814157 670404 679630 670263 554724 598267 736558 632565 541793 547515 555226 547411 541787 548301 716600 547441 554686 585802 629646 620911 795990 733381 724731 740835 576484 542718 541784 561046 576559 670465 696098 554682 607906 627835 640037 787916 751357 617570 716161 632697 641667 749924 633768 542447 601513 679810 605067 680185 733840 555967 550201 570159 599934 595699 763741 643013 718782 585057 547408 549040 554828 678820 678761 810892 763852 627833 671792 827941 659009 671054 720446 649556 680189 823943 541790 577026 542454 547416 581557 555315 709444 650700 691337 710224 555780 588858 613161 615533 788112 751606 727045 749801 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (0.91%) |
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 541784 541787 541788 541790 541793 541798 542447 542454 542717 542718 542720 544244 547408 547411 547416 547441 547515 548301 549037 549040 550201 554682 554683 554686 554707 554724 554828 555226 555315 555780 555967 558893 559423 561046 564281 570159 574342 576484 576559 577026 581557 585057 585802 588858 595699 598267 599934 601513 605067 607906 613161 615533 617570 620911 626402 627833 627835 628368 629646 630963 632565 632697 633768 634382 640037 641667 643013 649556 650700 651147 651784 659009 661654 670263 670404 670465 671054 671792 678761 678820 679630 679810 680126 680185 680189 691337 696098 709444 710224 716161 716600 718782 719435 720446 724731 727045 733381 733840 736558 740835 749801 749924 751357 751606 752859 763741 763852 787916 788112 795990 796338 804304 804403 804408 810892 812312 814157 814172 823943 827941 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг девушк"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.46%) |
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.