Query Metrics
7
Database Queries
7
Different statements
198.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.36 ms (85.16%) |
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 124519 389782 391632 398638 401069 404766 405272 425775 463002 463606 465487 495218 506429 512885 521576 521989 546861 550415 554778 556327 558134 560924 561699 561704 562358 563887 564705 565156 565653 566272 566538 566960 568676 569065 571653 572771 572885 575144 576095 577362 581485 581797 584419 584644 586406 590596 590632 590910 596627 597208 597572 597975 598702 598785 599290 599317 599552 599827 600531 601430 601454 601677 602446 602734 603047 605089 605913 606009 606762 608336 608407 608416 608560 608737 609259 609892 610869 611251 612698 615590 615623 615703 616089 616350 617056 617597 618923 620001 620086 620546 621091 621489 621804 622375 622932 626892 632304 636154 636231 651929 652931 653325 661528 700629 718580 722217 729865 731155 738341 744414 746642 751237 752239 754710 759833 762762 764920 765936 788834 797113 ] |
||||||||||||||||||||||||||||||
|
19.76 ms (9.94%) |
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 738341 744414 764920 729865 746642 751237 752239 754710 759833 762762 731155 765936 700629 718580 722217 788834 797113 124519 391632 389782 398638 401069 560924 566272 572771 572885 577362 581485 556327 558134 561699 563887 564705 565156 565653 568676 575144 576095 584419 550415 554778 561704 562358 584644 651929 652931 653325 661528 546861 566538 566960 569065 571653 581797 600531 601454 601677 605913 608737 620001 626892 590596 590632 590910 598702 599827 601430 603047 605089 609892 611251 612698 615590 616089 618923 620086 621489 622375 622932 636154 586406 597572 597975 598785 599290 599317 599552 606762 608560 610869 615623 616350 617056 620546 632304 596627 597208 602446 606009 608336 608407 602734 608416 609259 615703 617597 621091 621804 636231 404766 425775 465487 405272 463002 463606 506429 521576 495218 512885 521989 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.39%) |
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 124519 389782 391632 398638 401069 404766 405272 425775 463002 463606 465487 495218 506429 512885 521576 521989 546861 550415 554778 556327 558134 560924 561699 561704 562358 563887 564705 565156 565653 566272 566538 566960 568676 569065 571653 572771 572885 575144 576095 577362 581485 581797 584419 584644 586406 590596 590632 590910 596627 597208 597572 597975 598702 598785 599290 599317 599552 599827 600531 601430 601454 601677 602446 602734 603047 605089 605913 606009 606762 608336 608407 608416 608560 608737 609259 609892 610869 611251 612698 615590 615623 615703 616089 616350 617056 617597 618923 620001 620086 620546 621091 621489 621804 622375 622932 626892 632304 636154 636231 651929 652931 653325 661528 700629 718580 722217 729865 731155 738341 744414 746642 751237 752239 754710 759833 762762 764920 765936 788834 797113 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"баб"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.75%) |
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.