Query Metrics
7
Database Queries
7
Different statements
383.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
356.47 ms (92.93%) |
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 96968 97107 198191 382845 385925 385949 388004 392872 392881 393039 396990 400569 402969 404035 404117 405777 406881 411213 411962 413898 415928 420468 426959 436825 438032 438828 446103 452067 456366 457803 462544 471662 473098 476513 479296 480625 482493 483893 485903 485912 491287 495473 496317 500095 501906 504660 505857 510415 515976 518247 522402 527543 533729 533867 539099 547581 551207 551601 553610 553674 555686 556869 560171 560273 560859 562359 566763 567582 585070 585917 596950 603048 614331 617089 619647 623037 624790 627844 628669 629575 637176 639413 661291 663724 667897 677934 682763 697150 698880 708227 709052 711320 715121 720732 722029 728300 736489 739350 750692 765952 768008 769585 770242 771647 779073 783531 787620 788795 789080 792351 792750 798293 798636 802585 802641 811350 812890 822599 ] |
||||||||||||||||||||||||||||||
|
17.25 ms (4.50%) |
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 802641 500095 510415 739350 515976 96968 555686 617089 420468 97107 533729 663724 682763 556869 637176 603048 596950 614331 629575 788795 771647 728300 715121 462544 388004 798636 392872 822599 471662 562359 661291 627844 642929 436825 402969 501906 382845 426959 553610 567582 599432 628669 802585 783531 787620 812890 198191 400569 415928 483893 456366 518247 527543 560171 560273 560859 677934 708227 623037 585917 792750 792351 789080 769585 770242 768008 624790 711320 720732 385949 446103 485912 411962 482493 480625 491287 496317 539099 551207 551601 547581 566763 667897 697150 698880 411213 505857 585070 485903 765952 404117 479296 457803 438032 392881 393039 406881 533867 709052 736489 405777 438828 553674 619647 798293 811350 750692 779073 473098 504660 495473 385925 396990 404035 413898 452067 522402 476513 722029 639413 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.73%) |
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 96968 97107 198191 382845 385925 385949 388004 392872 392881 393039 396990 400569 402969 404035 404117 405777 406881 411213 411962 413898 415928 420468 426959 436825 438032 438828 446103 452067 456366 457803 462544 471662 473098 476513 479296 480625 482493 483893 485903 485912 491287 495473 496317 500095 501906 504660 505857 510415 515976 518247 522402 527543 533729 533867 539099 547581 551207 551601 553610 553674 555686 556869 560171 560273 560859 562359 566763 567582 585070 585917 596950 603048 614331 617089 619647 623037 624790 627844 628669 629575 637176 639413 661291 663724 667897 677934 682763 697150 698880 708227 709052 711320 715121 720732 722029 728300 736489 739350 750692 765952 768008 769585 770242 771647 779073 783531 787620 788795 789080 792351 792750 798293 798636 802585 802641 811350 812890 822599 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck outdoor"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс outdoor"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс outdoor"
]
|
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.