Query Metrics
7
Database Queries
7
Different statements
780.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
422.99 ms (54.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск face"
]
|
||||||||||||||||||||||||||||||
|
210.06 ms (26.90%) |
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 400867 402235 425737 435020 436423 438033 444819 461717 474182 475548 479988 480904 481036 482456 484431 488703 489035 504655 511996 514205 533772 537371 540253 544927 547606 547787 556450 559616 565837 568675 570411 578768 590223 595361 599130 601871 605714 609381 611521 612465 613922 615041 617587 621248 642237 642249 655539 657760 660111 660292 662480 668983 670991 671479 672891 674615 675585 677862 692564 697249 701513 705167 709507 709764 719124 719532 722966 728467 730012 730852 731215 731396 733708 739886 740032 741832 743606 743766 747566 749328 758512 761777 766368 766457 766788 767479 768914 769448 769789 770601 770607 770958 771370 777202 778619 779049 779237 779278 779293 779775 779951 782828 786098 786791 788338 790634 792415 795613 797751 798856 802652 805005 805536 805618 809327 813161 814295 823454 823634 825499 ] |
||||||||||||||||||||||||||||||
|
128.94 ms (16.51%) |
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 400867 402235 425737 435020 436423 438033 444819 461717 474182 475548 479988 480904 481036 482456 484431 488703 489035 504655 511996 514205 533772 537371 540253 544927 547606 547787 556450 559616 565837 568675 570411 578768 590223 595361 599130 601871 605714 609381 611521 612465 613922 615041 617587 621248 642237 642249 655539 657760 660111 660292 662480 668983 670991 671479 672891 674615 675585 677862 692564 697249 701513 705167 709507 709764 719124 719532 722966 728467 730012 730852 731215 731396 733708 739886 740032 741832 743606 743766 747566 749328 758512 761777 766368 766457 766788 767479 768914 769448 769789 770601 770607 770958 771370 777202 778619 779049 779237 779278 779293 779775 779951 782828 786098 786791 788338 790634 792415 795613 797751 798856 802652 805005 805536 805618 809327 813161 814295 823454 823634 825499 ] |
||||||||||||||||||||||||||||||
|
13.88 ms (1.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 814295 556450 578768 655539 672891 697249 709764 719532 662480 670991 677862 705167 709507 657760 668983 692564 642237 621248 605714 615041 777202 779775 782828 790634 792415 813161 730012 731215 731396 740032 761777 766368 766457 767479 786098 728467 730852 758512 769789 770958 741832 743606 747566 768914 749328 766788 771370 617587 642249 719124 722966 778619 779049 779293 779951 797751 798856 805536 809327 475548 444819 480904 400867 402235 461717 481036 511996 537371 488703 514205 436423 595361 425737 435020 438033 489035 823634 823454 825499 474182 479988 484431 533772 504655 540253 482456 544927 547606 568675 547787 559616 565837 660292 675585 674615 701513 660111 671479 570411 590223 601871 609381 611521 599130 612465 613922 779237 805618 779278 786791 788338 795613 805005 743766 769448 770601 802652 770607 733708 739886 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian face"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск face"
]
|
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.