Query Metrics
7
Database Queries
7
Different statements
137.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.49 ms (83.82%) |
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 365865 391150 424160 435647 449691 453591 456185 457194 467209 469410 470632 471849 472652 472695 478106 478617 484159 485450 487176 489792 490150 490169 491052 492668 495188 499720 504424 511872 512997 522420 523465 524313 530742 531282 534370 536513 541144 543530 549655 555683 558996 560150 560699 562590 563475 563814 579723 591058 593493 594871 594973 598384 599687 604151 605907 607144 611410 611766 612041 612052 613096 613178 614419 617665 618065 643126 671693 673121 673138 673531 673572 689682 694228 706642 707239 707584 709612 710498 711362 713612 717355 721860 721899 725441 725477 725939 726750 726912 732973 733530 736783 738564 745996 746040 746165 751169 758158 758339 759451 763182 765922 769448 781462 788026 788678 788700 789214 789216 789711 793998 795021 798926 803563 804086 811803 814538 814552 814613 814615 820014 ] |
||||||||||||||||||||||||||||||
|
12.69 ms (9.21%) |
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 745996 765922 612041 618065 706642 707584 711362 721860 721899 781462 788678 793998 453591 457194 472695 814538 814552 820014 814613 814615 536513 504424 522420 490169 560150 562590 579723 713612 717355 673531 671693 689682 694228 558996 594871 598384 607144 611766 593493 611410 594973 605907 612052 789216 803563 759451 789214 811803 726912 751169 758339 725939 726750 732973 733530 613096 613178 617665 707239 710498 788700 795021 798926 484159 456185 534370 530742 543530 541144 673572 435647 492668 487176 495188 472652 563475 673121 673138 604151 643126 789711 469410 511872 491052 523465 391150 499720 512997 563814 470632 485450 489792 531282 449691 467209 490150 478106 524313 549655 555683 709612 560699 591058 599687 614419 725477 769448 788026 804086 725441 736783 738564 746040 746165 758158 763182 471849 478617 365865 424160 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (2.06%) |
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 365865 391150 424160 435647 449691 453591 456185 457194 467209 469410 470632 471849 472652 472695 478106 478617 484159 485450 487176 489792 490150 490169 491052 492668 495188 499720 504424 511872 512997 522420 523465 524313 530742 531282 534370 536513 541144 543530 549655 555683 558996 560150 560699 562590 563475 563814 579723 591058 593493 594871 594973 598384 599687 604151 605907 607144 611410 611766 612041 612052 613096 613178 614419 617665 618065 643126 671693 673121 673138 673531 673572 689682 694228 706642 707239 707584 709612 710498 711362 713612 717355 721860 721899 725441 725477 725939 726750 726912 732973 733530 736783 738564 745996 746040 746165 751169 758158 758339 759451 763182 765922 769448 781462 788026 788678 788700 789214 789216 789711 793998 795021 798926 803563 804086 811803 814538 814552 814613 814615 820014 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother hidden"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.06%) |
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.