Query Metrics
7
Database Queries
7
Different statements
158.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.40 ms (83.10%) |
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 24158 367962 383726 400507 412078 416029 420333 421790 421844 423468 427148 436965 440526 442612 442915 456796 459887 459963 464064 465990 470400 472373 472772 476526 477964 481927 485870 500639 504188 507547 511808 516013 517536 517773 526527 526995 530635 530937 531995 547414 548415 552844 553144 554772 555226 559321 564190 566627 569145 570868 575847 577188 580313 581196 584020 585677 593690 599211 604336 613161 618619 622756 625038 629739 634341 640830 641298 663286 668467 668760 678758 678906 680675 689042 710732 713948 714655 720410 721859 721942 721945 723774 724639 729412 731257 736006 738564 742674 744094 745946 747137 748757 751170 752619 753578 753732 754759 758386 765812 768110 768884 769614 775064 779599 788599 788640 793558 793590 797315 801443 802100 802196 802244 804480 804829 811816 811900 818440 818628 819112 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (10.37%) |
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 593690 723774 710732 622756 629739 742674 24158 818440 427148 530937 744094 758386 751170 752619 802244 811816 412078 472772 459887 819112 516013 442612 641298 811900 517536 745946 383726 678758 793558 754759 788640 400507 436965 420333 442915 470400 500639 775064 788599 797315 724639 748757 769614 731257 721859 779599 472373 570868 526995 559321 554772 689042 604336 634341 465990 564190 618619 477964 421844 367962 485870 504188 526527 581196 640830 440526 416029 511808 555226 548415 713948 585677 599211 736006 753732 765812 753578 768110 552844 577188 680675 668467 625038 738564 530635 818628 553144 459963 464064 481927 476526 575847 714655 678906 721942 721945 584020 804829 802100 802196 793590 729412 804480 456796 507547 668760 613161 569145 768884 423468 421790 517773 531995 566627 580313 663286 720410 547414 801443 747137 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.67%) |
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 24158 367962 383726 400507 412078 416029 420333 421790 421844 423468 427148 436965 440526 442612 442915 456796 459887 459963 464064 465990 470400 472373 472772 476526 477964 481927 485870 500639 504188 507547 511808 516013 517536 517773 526527 526995 530635 530937 531995 547414 548415 552844 553144 554772 555226 559321 564190 566627 569145 570868 575847 577188 580313 581196 584020 585677 593690 599211 604336 613161 618619 622756 625038 629739 634341 640830 641298 663286 668467 668760 678758 678906 680675 689042 710732 713948 714655 720410 721859 721942 721945 723774 724639 729412 731257 736006 738564 742674 744094 745946 747137 748757 751170 752619 753578 753732 754759 758386 765812 768110 768884 769614 775064 779599 788599 788640 793558 793590 797315 801443 802100 802196 802244 804480 804829 811816 811900 818440 818628 819112 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur milf bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск milf ван"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск milf ван"
]
|
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.