Query Metrics
7
Database Queries
7
Different statements
202.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.18 ms (85.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 408339 418577 419352 419454 420804 420904 423783 427122 428249 431960 435594 436937 437874 439428 446529 446790 446796 447600 449956 452640 462681 462840 474880 477081 481952 498226 511273 520641 532221 534550 545404 548201 549740 555023 560352 564961 564984 567770 569050 569223 576201 577531 581873 583425 583468 586407 594208 594606 597750 599354 602147 604104 604106 607509 608535 609685 617047 620055 621287 624298 631697 639326 648648 659344 664384 664579 666988 671233 673923 674177 679142 685818 687318 692187 700478 700965 704907 705630 711480 712153 721640 734823 739117 740556 740919 740929 748431 751045 751627 754589 755022 756045 757416 767430 768914 770515 772044 772584 777651 778304 782737 783316 785462 786912 796794 798151 802897 803755 804081 804159 804427 806140 806695 811234 812515 813215 813227 813597 813899 814445 ] |
||||||||||||||||||||||||||||||
|
21.03 ms (10.39%) |
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 431960 481952 511273 813597 700965 712153 608535 609685 624298 782737 786912 734823 767430 772584 756045 768914 740929 748431 770515 604104 785462 811234 418577 436937 446790 564984 577531 583468 548201 567770 576201 560352 602147 620055 617047 520641 814445 462681 549740 648648 664384 666988 692187 700478 664579 621287 604106 783316 798151 740556 772044 802897 804081 812515 813215 751045 751627 754589 705630 796794 804159 446796 564961 594208 419454 813899 532221 671233 674177 721640 711480 659344 673923 687318 777651 806695 739117 755022 757416 740919 408339 447600 534550 569050 599354 594606 435594 439428 423783 545404 462840 498226 452640 583425 679142 597750 437874 477081 685818 631697 607509 586407 639326 803755 804427 806140 778304 704907 813227 419352 428249 420904 427122 449956 420804 474880 446529 569223 581873 555023 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.28%) |
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 408339 418577 419352 419454 420804 420904 423783 427122 428249 431960 435594 436937 437874 439428 446529 446790 446796 447600 449956 452640 462681 462840 474880 477081 481952 498226 511273 520641 532221 534550 545404 548201 549740 555023 560352 564961 564984 567770 569050 569223 576201 577531 581873 583425 583468 586407 594208 594606 597750 599354 602147 604104 604106 607509 608535 609685 617047 620055 621287 624298 631697 639326 648648 659344 664384 664579 666988 671233 673923 674177 679142 685818 687318 692187 700478 700965 704907 705630 711480 712153 721640 734823 739117 740556 740919 740929 748431 751045 751627 754589 755022 756045 757416 767430 768914 770515 772044 772584 777651 778304 782737 783316 785462 786912 796794 798151 802897 803755 804081 804159 804427 806140 806695 811234 812515 813215 813227 813597 813899 814445 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд toy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo toy"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд toy"
]
|
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.