Query Metrics
7
Database Queries
7
Different statements
599.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.34 ms (35.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие межрасов"
]
|
||||||||||||||||||||||||||||||
|
205.38 ms (34.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big interracial"
]
|
||||||||||||||||||||||||||||||
|
160.18 ms (26.72%) |
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 15317 31975 70186 92397 130641 161996 336938 382422 385229 395185 495407 530319 530819 531699 531811 532186 532278 533251 534211 534649 535839 535908 535930 537836 538106 538241 542328 543904 544312 547076 550654 550656 551552 556176 558782 563730 580572 584213 586933 589629 590137 633940 633962 634191 639334 639775 642412 645453 645972 646124 646290 646606 648906 649119 649919 650012 651262 651485 651657 653722 653846 654662 654701 655055 655979 662039 662060 665004 665361 676116 682232 685657 687192 690760 690761 700674 701038 702332 715251 716494 716895 719969 725488 726193 733556 733586 734689 746470 749043 752512 752809 755549 762250 765462 771582 773870 777031 785660 788488 795482 795562 796416 797383 797385 801511 801515 802470 804671 807970 808081 816071 817110 817852 820405 821619 822712 823289 823537 823538 828756 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (2.07%) |
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 822712 823537 823538 828756 532278 538241 531699 534649 544312 558782 551552 682232 719969 646290 648906 649919 650012 651262 653722 662039 665004 687192 716494 716895 590137 642412 633940 639775 589629 633962 777031 797383 802470 804671 785660 795562 801515 725488 796416 801511 808081 726193 734689 762250 765462 733556 749043 752512 752809 773870 771582 634191 702332 788488 795482 807970 385229 586933 639334 665361 676116 797385 733586 746470 755549 130641 161996 395185 336938 382422 70186 92397 31975 15317 816071 820405 817110 823289 817852 821619 531811 535839 535930 538106 532186 495407 530319 530819 534211 537836 533251 535908 580572 584213 542328 543904 550654 556176 563730 547076 550656 645453 646124 646606 651485 654662 654701 655055 655979 662060 685657 690760 690761 700674 701038 715251 645972 649119 651657 653846 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (0.48%) |
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 15317 31975 70186 92397 130641 161996 336938 382422 385229 395185 495407 530319 530819 531699 531811 532186 532278 533251 534211 534649 535839 535908 535930 537836 538106 538241 542328 543904 544312 547076 550654 550656 551552 556176 558782 563730 580572 584213 586933 589629 590137 633940 633962 634191 639334 639775 642412 645453 645972 646124 646290 646606 648906 649119 649919 650012 651262 651485 651657 653722 653846 654662 654701 655055 655979 662039 662060 665004 665361 676116 682232 685657 687192 690760 690761 700674 701038 702332 715251 716494 716895 719969 725488 726193 733556 733586 734689 746470 749043 752512 752809 755549 762250 765462 771582 773870 777031 785660 788488 795482 795562 796416 797383 797385 801511 801515 802470 804671 807970 808081 816071 817110 817852 820405 821619 822712 823289 823537 823538 828756 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.24%) |
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.