Query Metrics
7
Database Queries
7
Different statements
179.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.37 ms (85.65%) |
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 90718 155257 185109 383924 384881 386735 392622 395703 410577 418084 424023 425921 425958 441784 445395 445767 453585 456214 469101 555372 556013 558512 562514 571004 572689 572920 577930 579840 582346 582861 584237 585167 585586 586034 587731 588430 590934 591319 591455 592571 592875 593035 595035 599729 601313 604043 607075 611167 611230 611417 615730 616000 618916 619108 619127 619593 623551 624148 624239 626931 629111 631871 633665 641649 653327 653548 655827 660689 663382 664827 665123 665128 665271 665742 669430 670513 671578 674090 674713 676586 686648 688105 701325 714524 714822 720306 720701 720985 721006 721408 726703 730320 731801 734824 734825 736022 743893 744601 744627 745322 746156 748171 748989 748999 752538 753257 759782 761181 768123 770280 784874 796805 801305 802503 804337 805257 807610 810643 811154 812105 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (8.32%) |
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 555372 558512 577930 582346 653548 663382 671578 674090 688105 714822 720985 653327 660689 665128 665742 669430 670513 674713 686648 701325 721408 655827 664827 665123 665271 676586 714524 720306 556013 562514 571004 572689 572920 579840 582861 584237 585586 611230 615730 619127 586034 588430 590934 591319 592571 595035 599729 601313 611167 618916 619593 624148 624239 641649 585167 587731 592875 593035 607075 611417 616000 633665 591455 619108 623551 631871 796805 801305 802503 807610 811154 726703 734824 736022 744627 748171 748999 753257 804337 812105 731801 748989 759782 761181 734825 743893 746156 744601 752538 730320 745322 768123 770280 604043 626931 629111 720701 721006 784874 805257 810643 185109 383924 384881 410577 418084 424023 425921 425958 445395 445767 453585 469101 90718 155257 386735 392622 395703 441784 456214 ] |
||||||||||||||||||||||||||||||
|
4.25 ms (2.37%) |
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 90718 155257 185109 383924 384881 386735 392622 395703 410577 418084 424023 425921 425958 441784 445395 445767 453585 456214 469101 555372 556013 558512 562514 571004 572689 572920 577930 579840 582346 582861 584237 585167 585586 586034 587731 588430 590934 591319 591455 592571 592875 593035 595035 599729 601313 604043 607075 611167 611230 611417 615730 616000 618916 619108 619127 619593 623551 624148 624239 626931 629111 631871 633665 641649 653327 653548 655827 660689 663382 664827 665123 665128 665271 665742 669430 670513 671578 674090 674713 676586 686648 688105 701325 714524 714822 720306 720701 720985 721006 721408 726703 730320 731801 734824 734825 736022 743893 744601 744627 745322 746156 748171 748989 748999 752538 753257 759782 761181 768123 770280 784874 796805 801305 802503 804337 805257 807610 810643 811154 812105 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.