Query Metrics
7
Database Queries
7
Different statements
277.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
249.04 ms (89.63%) |
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 382895 385605 391364 391365 397621 400770 401423 404126 405979 407322 410080 415753 416116 418896 419308 420157 421783 422063 426475 434401 435924 436138 440347 440637 440897 441359 442042 444591 450262 450280 452219 452982 453244 454471 454481 457992 460080 463988 464113 467049 468518 470052 470133 472575 473341 473460 473481 475415 475422 475426 476051 479693 482714 482751 484224 487796 489222 489953 490962 495870 497749 509631 517405 517475 525839 528518 530849 531817 536940 537449 540528 540888 541121 541965 548218 552614 562427 564048 575936 581264 584241 586253 590020 590673 591513 591992 594466 604480 615170 615347 633611 636715 638997 640282 655159 655832 661023 664150 694953 710720 718344 729974 732259 739139 747784 756002 761039 769522 781907 794828 796696 800857 801014 801129 807104 809840 813122 817154 ] |
||||||||||||||||||||||||||||||
|
18.69 ms (6.73%) |
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 710720 548218 636715 809840 732259 794828 800857 801129 747784 781907 801014 416116 441359 415753 482751 473341 484224 537449 464113 729974 436138 470133 525839 385605 421783 450280 472575 490962 530849 531817 718344 655159 661023 575936 586253 756002 604480 468518 442042 454481 564048 615170 590020 422063 497749 391365 401423 405979 426475 434401 817154 452982 470052 540528 475415 479693 664150 584241 594466 633611 739139 769522 807104 495870 761039 382895 397621 404126 440637 407322 444591 419308 540888 453244 475422 452219 489953 450262 457992 467049 473460 536940 509631 541121 552614 581264 541965 562427 655832 694953 591513 591992 615347 638997 590673 640282 796696 813122 762336 618229 400770 473481 476051 410080 454471 463988 435924 460080 489222 517475 418896 517405 391364 420157 440897 440347 482714 475426 487796 528518 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.06%) |
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 382895 385605 391364 391365 397621 400770 401423 404126 405979 407322 410080 415753 416116 418896 419308 420157 421783 422063 426475 434401 435924 436138 440347 440637 440897 441359 442042 444591 450262 450280 452219 452982 453244 454471 454481 457992 460080 463988 464113 467049 468518 470052 470133 472575 473341 473460 473481 475415 475422 475426 476051 479693 482714 482751 484224 487796 489222 489953 490962 495870 497749 509631 517405 517475 525839 528518 530849 531817 536940 537449 540528 540888 541121 541965 548218 552614 562427 564048 575936 581264 584241 586253 590020 590673 591513 591992 594466 604480 615170 615347 633611 636715 638997 640282 655159 655832 661023 664150 694953 710720 718344 729974 732259 739139 747784 756002 761039 769522 781907 794828 796696 800857 801014 801129 807104 809840 813122 817154 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pawg doggy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pawg рак"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pawg рак"
]
|
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.