Query Metrics
7
Database Queries
7
Different statements
203.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.57 ms (85.94%) |
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 397106 398504 398544 398989 400467 404181 419275 424649 425360 488576 490739 495162 512811 530570 530607 530821 542431 543258 544258 545255 546557 546563 548798 549218 549386 552386 554127 555781 556538 556682 557805 559260 559317 560890 561523 561556 563764 569818 571364 571376 578722 584233 584664 591890 592127 608236 611256 613150 613383 615471 616060 617679 618348 620989 629130 630572 630711 632092 639990 640879 645842 653135 654680 659424 660490 661759 664564 666659 667377 667447 670512 675182 680619 683468 686265 687391 687934 692734 695695 697725 705786 706407 706692 707447 707555 708081 710218 710380 710947 715842 716621 717927 717972 718241 718830 718872 719280 719751 719823 723186 723590 777542 779582 779822 780026 780324 780427 781032 781549 781612 783438 783724 787229 791465 791519 813607 813632 813981 814216 814668 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (9.05%) |
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 397106 400467 398544 398504 398989 404181 419275 425360 424649 813981 814668 723590 813607 813632 814216 490739 512811 495162 530570 530607 530821 488576 545255 556538 559317 578722 542431 548798 554127 556682 557805 559260 563764 569818 571376 543258 544258 552386 560890 561523 561556 571364 584233 584664 645842 661759 686265 687391 687934 695695 697725 705786 706407 707447 716621 717972 718241 718830 723186 653135 660490 666659 667377 667447 680619 683468 710218 715842 718872 719280 719751 654680 659424 664564 670512 675182 692734 706692 707555 708081 710380 710947 717927 719823 546557 546563 549218 549386 555781 591890 629130 630572 639990 640879 616060 617679 620989 632092 592127 613383 615471 630711 608236 611256 613150 618348 777542 779582 779822 780026 780324 780427 781032 781549 781612 783438 783724 787229 791465 791519 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.27%) |
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 397106 398504 398544 398989 400467 404181 419275 424649 425360 488576 490739 495162 512811 530570 530607 530821 542431 543258 544258 545255 546557 546563 548798 549218 549386 552386 554127 555781 556538 556682 557805 559260 559317 560890 561523 561556 563764 569818 571364 571376 578722 584233 584664 591890 592127 608236 611256 613150 613383 615471 616060 617679 618348 620989 629130 630572 630711 632092 639990 640879 645842 653135 654680 659424 660490 661759 664564 666659 667377 667447 670512 675182 680619 683468 686265 687391 687934 692734 695695 697725 705786 706407 706692 707447 707555 708081 710218 710380 710947 715842 716621 717927 717972 718241 718830 718872 719280 719751 719823 723186 723590 777542 779582 779822 780026 780324 780427 781032 781549 781612 783438 783724 787229 791465 791519 813607 813632 813981 814216 814668 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"только рот"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рот"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.77%) |
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.