Query Metrics
7
Database Queries
7
Different statements
229.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.25 ms (88.41%) |
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 92019 229704 337190 385073 418553 422005 423550 438032 441748 443493 444236 450139 452662 454472 455165 455649 459323 475177 478709 482876 500877 508265 526871 529699 540132 544979 545030 545303 546620 551588 551729 554862 555672 574469 577267 578535 579977 584170 584583 585571 588531 588618 590041 592149 605180 605924 616832 617509 618494 625360 628596 630704 631113 633856 635860 636050 636062 636505 640319 640827 642176 643071 646052 646624 646719 662394 662925 675581 676430 686101 691432 697219 700930 707149 707457 708052 708194 708254 711327 713473 715952 716669 717187 724396 726920 727535 728225 733041 733995 735581 738836 739906 740175 740959 742312 743806 750342 759702 760241 760874 761314 761698 766600 769287 774610 778410 782594 783671 784197 785962 789927 791531 794877 795998 796158 800390 800586 802806 812359 824031 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (6.90%) |
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 691432 707149 716669 577267 584583 592149 625360 636050 640319 588531 630704 631113 618494 633856 636505 789927 800586 794877 750342 760241 784197 726920 733041 739906 760874 724396 740175 769287 738836 761314 635860 697219 713473 778410 785962 791531 802806 812359 455165 508265 422005 454472 545030 642176 616832 766600 795998 735581 733995 743806 759702 92019 686101 590041 443493 700930 782594 727535 475177 455649 482876 418553 450139 540132 551729 584170 554862 646624 717187 585571 728225 761698 441748 438032 444236 526871 544979 551588 742312 800390 452662 385073 229704 337190 423550 824031 478709 459323 500877 529699 555672 578535 546620 574469 579977 646052 646719 708194 708254 711327 675581 707457 708052 662394 662925 676430 715952 545303 628596 605924 640827 643071 636062 588618 605180 617509 796158 774610 783671 740959 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.43%) |
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 92019 229704 337190 385073 418553 422005 423550 438032 441748 443493 444236 450139 452662 454472 455165 455649 459323 475177 478709 482876 500877 508265 526871 529699 540132 544979 545030 545303 546620 551588 551729 554862 555672 574469 577267 578535 579977 584170 584583 585571 588531 588618 590041 592149 605180 605924 616832 617509 618494 625360 628596 630704 631113 633856 635860 636050 636062 636505 640319 640827 642176 643071 646052 646624 646719 662394 662925 675581 676430 686101 691432 697219 700930 707149 707457 708052 708194 708254 711327 713473 715952 716669 717187 724396 726920 727535 728225 733041 733995 735581 738836 739906 740175 740959 742312 743806 750342 759702 760241 760874 761314 761698 766600 769287 774610 778410 782594 783671 784197 785962 789927 791531 794877 795998 796158 800390 800586 802806 812359 824031 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"doggystyle жоп"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggystyle ass"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"doggystyle жоп"
]
|
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.