Query Metrics
7
Database Queries
7
Different statements
348.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.00 ms (59.96%) |
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 73990 130641 212982 233369 358565 383498 387192 394309 401057 401480 415539 429755 450148 453451 454541 459923 460286 460627 470164 474794 482339 488467 490535 497498 498126 498614 511375 522041 531928 532081 534004 535704 537941 539324 540738 550595 554310 564677 567259 577002 592908 595041 596542 597905 599865 599927 600557 603703 612335 613715 613819 618399 626862 635243 641331 645284 648209 656546 668417 673659 677975 680606 681478 693700 705067 714227 715493 715881 716288 726232 726240 726262 733276 738654 743824 746172 752010 753720 754364 755611 765255 765397 765729 771139 771409 771979 775429 777486 789622 793611 794894 796910 798914 800729 802312 802828 804196 804289 805509 811728 813866 814755 815701 816535 816637 817003 817070 817403 817526 818880 822590 823932 825035 825082 825091 826229 826241 828268 828463 828472 ] |
||||||||||||||||||||||||||||||
|
121.18 ms (34.76%) |
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 73990 130641 212982 233369 358565 383498 387192 394309 401057 401480 415539 429755 450148 453451 454541 459923 460286 460627 470164 474794 482339 488467 490535 497498 498126 498614 511375 522041 531928 532081 534004 535704 537941 539324 540738 550595 554310 564677 567259 577002 592908 595041 596542 597905 599865 599927 600557 603703 612335 613715 613819 618399 626862 635243 641331 645284 648209 656546 668417 673659 677975 680606 681478 693700 705067 714227 715493 715881 716288 726232 726240 726262 733276 738654 743824 746172 752010 753720 754364 755611 765255 765397 765729 771139 771409 771979 775429 777486 789622 793611 794894 796910 798914 800729 802312 802828 804196 804289 805509 811728 813866 814755 815701 816535 816637 817003 817070 817403 817526 818880 822590 823932 825035 825082 825091 826229 826241 828268 828463 828472 ] |
||||||||||||||||||||||||||||||
|
11.80 ms (3.39%) |
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 816637 522041 537941 715881 716288 656546 802312 811728 726240 488467 826229 828268 714227 771409 826241 816535 383498 746172 705067 387192 394309 73990 470164 497498 539324 577002 828472 680606 777486 743824 804289 726262 754364 775429 789622 815701 592908 793611 715493 474794 415539 645284 603703 626862 794894 798914 805509 753720 733276 765729 540738 567259 599927 635243 599865 613819 817070 817526 726232 233369 429755 535704 498126 673659 612335 595041 453451 534004 681478 618399 401480 454541 490535 532081 554310 796910 738654 771139 358565 450148 460627 765397 752010 765255 401057 822590 823932 825091 813866 459923 648209 550595 600557 800729 804196 771979 212982 482339 498614 511375 814755 802828 460286 130641 817403 818880 817003 825035 825082 828463 531928 564677 668417 677975 693700 597905 613715 596542 641331 755611 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother in love"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин love"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин love"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.