Query Metrics
7
Database Queries
7
Different statements
133.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.72 ms (86.88%) |
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 478767 487205 489644 491131 493677 493945 498162 507853 514444 517758 523464 525299 530174 530236 530314 530396 530964 531555 531672 532828 534043 535152 535355 536367 536950 537815 537973 539230 541900 543534 543930 546434 546653 552732 554464 555725 558783 564607 565291 565297 566738 567772 567943 567953 570687 574964 579071 588075 588189 588214 589264 592104 592864 593505 596930 597702 599356 602549 604112 612661 612895 618345 621433 621642 627684 636576 645749 647081 648201 649780 656508 668604 668815 679628 682714 684293 684533 688842 691182 695014 696149 699433 701266 712092 718611 719748 726296 728163 729121 730532 735192 736704 743790 746656 748110 748847 749648 753235 753432 759111 760233 763448 768079 768572 784612 787384 794537 795340 803978 806718 817582 818547 818762 823629 823853 824333 824619 824698 824933 825895 ] |
||||||||||||||||||||||||||||||
|
7.98 ms (5.99%) |
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 636576 596930 602549 825895 818762 823853 824619 817582 824933 818547 823629 824333 824698 531555 531672 530174 530314 530964 532828 535355 570687 541900 558783 543930 546653 684293 699433 712092 718611 649780 656508 668815 566738 592104 597702 599356 618345 588189 593505 612895 627684 748110 726296 728163 753235 753432 735192 759111 763448 730532 743790 746656 748847 768079 803978 567953 567943 648201 679628 696149 719748 682714 688842 588214 589264 612661 621642 588075 592864 794537 736704 787384 806718 729121 749648 768572 760233 604112 795340 537815 487205 514444 555725 564607 701266 691182 668604 684533 695014 621433 784612 498162 493677 489644 491131 507853 523464 535152 539230 534043 536367 536950 525299 530236 517758 530396 537973 478767 493945 554464 565297 567772 543534 546434 552732 574964 579071 565291 645749 647081 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.76%) |
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 478767 487205 489644 491131 493677 493945 498162 507853 514444 517758 523464 525299 530174 530236 530314 530396 530964 531555 531672 532828 534043 535152 535355 536367 536950 537815 537973 539230 541900 543534 543930 546434 546653 552732 554464 555725 558783 564607 565291 565297 566738 567772 567943 567953 570687 574964 579071 588075 588189 588214 589264 592104 592864 593505 596930 597702 599356 602549 604112 612661 612895 618345 621433 621642 627684 636576 645749 647081 648201 649780 656508 668604 668815 679628 682714 684293 684533 688842 691182 695014 696149 699433 701266 712092 718611 719748 726296 728163 729121 730532 735192 736704 743790 746656 748110 748847 749648 753235 753432 759111 760233 763448 768079 768572 784612 787384 794537 795340 803978 806718 817582 818547 818762 823629 823853 824333 824619 824698 824933 825895 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"реальний с"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.12%) |
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.