Query Metrics
7
Database Queries
7
Different statements
154.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.11 ms (83.76%) |
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 293121 305556 418569 427418 431603 440526 441424 444647 453595 457713 457721 459252 464570 468683 470721 487316 490157 490158 492042 492816 495487 504175 504767 505786 509884 517256 519321 522248 527782 528679 534366 535176 543705 549495 550658 553186 568180 568276 573787 580413 583652 590309 591281 598028 600374 600881 603707 605060 609572 612586 615001 615612 616913 618719 620189 621775 626285 636190 642807 651759 652722 670733 678453 679472 680649 687331 693301 695843 696794 696817 697153 697996 700209 701605 703422 703793 705443 709721 713766 715158 715787 721811 721946 723144 724306 733230 733832 734630 735627 736535 737508 739901 740981 741567 743037 745315 745535 749940 751772 754232 754875 755578 766484 767998 771602 776042 782128 784104 785667 788592 794676 796178 796621 800154 805125 810711 813453 818203 820380 825428 ] |
||||||||||||||||||||||||||||||
|
13.08 ms (8.49%) |
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 693301 696817 703422 703793 679472 695843 697153 701605 721811 651759 670733 678453 696794 697996 705443 713766 598028 636190 642807 600374 618719 621775 626285 600881 605060 616913 591281 609572 615612 813453 620189 700209 709721 468683 492042 505786 487316 431603 464570 687331 615001 612586 767998 755578 743037 754875 441424 825428 820380 818203 522248 549495 580413 543705 573787 715158 652722 715787 583652 603707 794676 810711 785667 788592 796621 800154 733230 737508 754232 766484 733832 740981 741567 745315 749940 724306 735627 745535 771602 739901 776042 782128 796178 517256 293121 470721 568180 680649 723144 805125 734630 751772 784104 736535 721946 305556 490158 444647 418569 504767 534366 509884 568276 504175 457713 457721 553186 490157 519321 495487 527782 440526 453595 492816 459252 427418 590309 535176 528679 550658 ] |
||||||||||||||||||||||||||||||
|
3.86 ms (2.50%) |
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 293121 305556 418569 427418 431603 440526 441424 444647 453595 457713 457721 459252 464570 468683 470721 487316 490157 490158 492042 492816 495487 504175 504767 505786 509884 517256 519321 522248 527782 528679 534366 535176 543705 549495 550658 553186 568180 568276 573787 580413 583652 590309 591281 598028 600374 600881 603707 605060 609572 612586 615001 615612 616913 618719 620189 621775 626285 636190 642807 651759 652722 670733 678453 679472 680649 687331 693301 695843 696794 696817 697153 697996 700209 701605 703422 703793 705443 709721 713766 715158 715787 721811 721946 723144 724306 733230 733832 734630 735627 736535 737508 739901 740981 741567 743037 745315 745535 749940 751772 754232 754875 755578 766484 767998 771602 776042 782128 784104 785667 788592 794676 796178 796621 800154 805125 810711 813453 818203 820380 825428 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"реально скрытые камер…"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск скрыт камер"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
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.