Query Metrics
7
Database Queries
7
Different statements
172.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.55 ms (85.67%) |
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 358453 384803 385603 387850 393481 394630 397867 397887 400923 401148 401946 412311 416236 418124 418139 421907 423920 424190 426699 427487 430526 434286 434350 434360 443199 460503 463868 466824 467872 467878 467886 467934 468462 472611 472639 476295 482522 488757 490106 491266 491273 496603 500546 510478 510480 511266 512935 521210 522041 530395 530698 532038 533384 534748 535749 541568 543609 544524 545220 545342 545449 546813 547471 547476 550896 561807 562190 562961 565164 571035 571434 571846 579875 590373 590633 592490 593342 596653 596704 600223 600314 603847 604967 606618 607228 617825 621979 625289 633115 644499 648211 660467 669016 670356 671020 671647 672945 693356 702463 720118 720442 722379 725606 740890 752709 758304 761510 766669 777151 777940 780601 785934 801246 801918 803633 805497 812926 818291 825557 826469 ] |
||||||||||||||||||||||||||||||
|
14.82 ms (8.60%) |
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 424190 467872 826469 825557 463868 562961 571434 467878 511266 546813 672945 801918 803633 740890 521210 593342 758304 604967 592490 600223 693356 812926 418124 590633 426699 434360 397887 443199 467934 387850 482522 579875 427487 490106 535749 491273 472639 488757 590373 571846 510480 510478 434286 561807 625289 596653 607228 416236 818291 648211 671647 644499 400923 801246 752709 777151 491266 621979 633115 720442 780601 466824 543609 401946 761510 401148 394630 358453 423920 500546 460503 384803 545342 547476 565164 669016 606618 617825 702463 385603 496603 600314 785934 541568 670356 547471 393481 412311 766669 545449 660467 550896 596704 725606 603847 722379 397867 476295 430526 434350 512935 544524 805497 468462 421907 534748 671020 467886 562190 571035 418139 532038 522041 530395 545220 720118 777940 472611 533384 530698 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.95%) |
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 358453 384803 385603 387850 393481 394630 397867 397887 400923 401148 401946 412311 416236 418124 418139 421907 423920 424190 426699 427487 430526 434286 434350 434360 443199 460503 463868 466824 467872 467878 467886 467934 468462 472611 472639 476295 482522 488757 490106 491266 491273 496603 500546 510478 510480 511266 512935 521210 522041 530395 530698 532038 533384 534748 535749 541568 543609 544524 545220 545342 545449 546813 547471 547476 550896 561807 562190 562961 565164 571035 571434 571846 579875 590373 590633 592490 593342 596653 596704 600223 600314 603847 604967 606618 607228 617825 621979 625289 633115 644499 648211 660467 669016 670356 671020 671647 672945 693356 702463 720118 720442 722379 725606 740890 752709 758304 761510 766669 777151 777940 780601 785934 801246 801918 803633 805497 812926 818291 825557 826469 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð░ð¢ð░ð╗ ÐàÐâð┤ð¥Ðëð░ð▓ð░ÐÅ ð╝ð░ð╝ð░Ðêð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал худая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал худая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.81%) |
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.