Query Metrics
7
Database Queries
7
Different statements
173.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.15 ms (86.07%) |
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 97823 384948 388762 396758 397421 398947 400507 401949 412078 415894 419013 421844 421861 422299 424145 426127 426796 427057 427148 435324 439584 439753 443019 443785 444187 444991 446646 450674 452666 454356 455324 457340 459474 459727 461571 461787 463490 463637 464268 465870 465990 466019 466361 466462 467628 470260 470387 470617 473679 473975 478021 483238 484394 484447 485870 494671 497809 499836 501904 504188 504352 506732 507637 508048 511635 513258 516382 520398 523450 526234 526527 541018 545994 550495 552594 559580 569637 573824 596997 597545 609505 624128 649269 653273 655295 669515 688922 703650 703689 704599 711362 714602 714922 736392 736960 737563 744404 754759 760463 766180 766376 768978 769059 774065 782225 782526 782751 786320 787340 791463 793011 796459 797315 799769 802100 804829 805145 818778 823822 825904 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (8.00%) |
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 419013 426127 464268 513258 520398 825904 653273 704599 782526 796459 774065 711362 427148 427057 455324 466361 552594 649269 655295 669515 782225 805145 799769 736392 744404 766376 768978 766180 737563 793011 384948 412078 398947 466462 470387 507637 467628 396758 444991 450674 459727 545994 791463 446646 454356 401949 573824 97823 415894 501904 818778 823822 541018 703689 714922 714602 782751 786320 787340 769059 754759 736960 473975 484447 465990 559580 463637 421844 461571 485870 506732 508048 511635 526234 499836 504188 523450 526527 463490 470617 494671 597545 397421 426796 443019 452666 388762 435324 459474 465870 466019 473679 422299 439584 461787 424145 439753 443785 444187 457340 421861 478021 484394 483238 516382 504352 400507 470260 497809 569637 550495 688922 703650 609505 596997 624128 804829 797315 802100 760463 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.83%) |
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 97823 384948 388762 396758 397421 398947 400507 401949 412078 415894 419013 421844 421861 422299 424145 426127 426796 427057 427148 435324 439584 439753 443019 443785 444187 444991 446646 450674 452666 454356 455324 457340 459474 459727 461571 461787 463490 463637 464268 465870 465990 466019 466361 466462 467628 470260 470387 470617 473679 473975 478021 483238 484394 484447 485870 494671 497809 499836 501904 504188 504352 506732 507637 508048 511635 513258 516382 520398 523450 526234 526527 541018 545994 550495 552594 559580 569637 573824 596997 597545 609505 624128 649269 653273 655295 669515 688922 703650 703689 704599 711362 714602 714922 736392 736960 737563 744404 754759 760463 766180 766376 768978 769059 774065 782225 782526 782751 786320 787340 791463 793011 796459 797315 799769 802100 804829 805145 818778 823822 825904 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское душ"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск ван"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
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.