Query Metrics
7
Database Queries
7
Different statements
193.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.71 ms (84.49%) |
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 404734 416989 419933 443231 447553 447629 454802 454954 463893 466161 468171 468835 470949 481142 482583 487362 493122 499104 510877 515358 516073 516684 519592 529794 529998 530482 530659 532360 532760 532963 533013 533062 533928 536359 536638 536674 536744 537204 539203 544816 545611 549092 554210 555104 557676 569174 573493 582540 584503 591805 598451 598584 599872 599927 600337 601544 602928 606633 612399 617424 620663 626021 628082 628334 630541 631202 632649 635975 637442 639741 639745 639824 640751 641097 641938 641953 641956 641996 642310 646200 647860 651601 651634 656842 666525 668463 668505 671648 672686 674988 676023 676088 677676 678117 678532 689949 701500 707418 713695 715788 716901 719480 723494 725047 729055 730724 736735 738912 739993 742348 744653 751503 751565 751670 760689 761231 768957 785503 805263 805513 ] |
||||||||||||||||||||||||||||||
|
18.63 ms (9.61%) |
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 641097 606633 591805 598584 601544 725047 730724 785503 738912 742348 751670 751503 768957 404734 463893 447553 516684 468171 539203 536744 530659 545611 651601 599927 641953 635975 639745 641996 751565 529794 672686 569174 671648 719480 642310 630541 739993 744653 805513 760689 530482 482583 536674 533062 668463 599872 416989 468835 499104 584503 666525 557676 628082 519592 487362 493122 533013 647860 639741 443231 555104 602928 573493 549092 656842 701500 707418 713695 646200 689949 723494 641938 598451 626021 729055 736735 715788 805263 761231 419933 454954 481142 454802 515358 532760 533928 536359 536638 532360 537204 532963 544816 678117 678532 716901 651634 674988 676088 668505 676023 677676 582540 628334 632649 637442 612399 639824 600337 631202 641956 617424 640751 470949 516073 554210 620663 466161 529998 510877 447629 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.75%) |
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 404734 416989 419933 443231 447553 447629 454802 454954 463893 466161 468171 468835 470949 481142 482583 487362 493122 499104 510877 515358 516073 516684 519592 529794 529998 530482 530659 532360 532760 532963 533013 533062 533928 536359 536638 536674 536744 537204 539203 544816 545611 549092 554210 555104 557676 569174 573493 582540 584503 591805 598451 598584 599872 599927 600337 601544 602928 606633 612399 617424 620663 626021 628082 628334 630541 631202 632649 635975 637442 639741 639745 639824 640751 641097 641938 641953 641956 641996 642310 646200 647860 651601 651634 656842 666525 668463 668505 671648 672686 674988 676023 676088 677676 678117 678532 689949 701500 707418 713695 715788 716901 719480 723494 725047 729055 730724 736735 738912 739993 742348 744653 751503 751565 751670 760689 761231 768957 785503 805263 805513 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal cock"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд анал cock"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал cock"
]
|
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.