Query Metrics
7
Database Queries
7
Different statements
168.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.92 ms (84.90%) |
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 98190 383448 397904 400883 404084 404404 416925 435698 438011 442596 445340 449219 452908 453520 472298 480541 482975 490816 493972 494720 499120 514180 515658 515688 516227 517553 520939 523148 526884 527500 531282 535313 537411 537417 539376 541406 545820 545909 547751 552937 556788 564859 565425 570933 571940 572764 585479 585507 588323 588326 588339 588340 588354 588362 589142 591330 592056 595131 596732 596894 596928 600750 600795 600808 600814 601166 621390 625631 633674 634569 637763 644598 678834 678838 680625 689469 692654 697382 697736 698614 698616 702063 714558 716231 718339 718739 718764 723661 723952 724818 725509 728601 733039 734202 736071 739258 750071 751352 758420 759972 760677 760764 760882 770671 778210 782068 782553 787109 788508 790408 803383 803425 805123 805348 805350 810646 813404 816132 824200 827361 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (8.97%) |
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 723952 750071 514180 585507 689469 634569 810646 827361 770671 803383 760764 678838 751352 788508 601166 452908 516227 816132 813404 692654 588323 824200 625631 572764 787109 564859 547751 499120 494720 442596 570933 714558 637763 702063 588354 600750 596732 782068 805348 723661 718339 527500 760677 541406 526884 739258 539376 697382 588339 449219 585479 782553 760882 591330 556788 596894 718739 758420 552937 480541 697736 621390 416925 805350 790408 383448 588362 595131 545909 698616 759972 515658 644598 600808 445340 571940 803425 718764 733039 680625 400883 404084 716231 596928 435698 472298 438011 493972 520939 545820 588326 592056 589142 734202 728601 778210 805123 404404 535313 698614 725509 537417 600795 98190 588340 517553 482975 453520 397904 490816 523148 515688 565425 633674 724818 736071 537411 678834 600814 531282 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.87%) |
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 98190 383448 397904 400883 404084 404404 416925 435698 438011 442596 445340 449219 452908 453520 472298 480541 482975 490816 493972 494720 499120 514180 515658 515688 516227 517553 520939 523148 526884 527500 531282 535313 537411 537417 539376 541406 545820 545909 547751 552937 556788 564859 565425 570933 571940 572764 585479 585507 588323 588326 588339 588340 588354 588362 589142 591330 592056 595131 596732 596894 596928 600750 600795 600808 600814 601166 621390 625631 633674 634569 637763 644598 678834 678838 680625 689469 692654 697382 697736 698614 698616 702063 714558 716231 718339 718739 718764 723661 723952 724818 725509 728601 733039 734202 736071 739258 750071 751352 758420 759972 760677 760764 760882 770671 778210 782068 782553 787109 788508 790408 803383 803425 805123 805348 805350 810646 813404 816132 824200 827361 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office amateur"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш любительск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.85%) |
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.