Query Metrics
7
Database Queries
7
Different statements
397.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
270.85 ms (68.17%) |
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 541903 553600 567461 553502 577418 462662 453875 157493 459470 475814 818762 825093 570687 541900 546653 701216 585628 741559 773466 396362 418568 486816 559467 691538 694877 694417 438613 317898 478403 455194 516732 519321 495487 527782 537618 566924 553186 568276 573386 600406 625282 751354 761642 476437 440526 470810 453595 453609 504175 490157 828772 828418 569815 693714 692459 708504 630848 619534 728525 754890 426481 545038 615721 509058 519322 429494 428062 443188 418565 453871 506568 752534 752547 453850 403685 453487 453860 485991 442645 495178 509077 504272 550480 553156 553175 553194 625761 804265 459252 466299 427418 473306 517102 494682 506714 492816 511876 528673 387758 397592 818253 824822 823891 825135 827348 818755 828106 828830 474985 533659 545871 701278 722298 744764 730829 733508 765963 768967 731771 748469 ] |
||||||||||||||||||||||||||||||
|
117.08 ms (29.47%) |
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 157493 317898 387758 396362 397592 403685 418565 418568 426481 427418 428062 429494 438613 440526 442645 443188 453487 453595 453609 453850 453860 453871 453875 455194 459252 459470 462662 466299 470810 473306 474985 475814 476437 478403 485991 486816 490157 492816 494682 495178 495487 504175 504272 506568 506714 509058 509077 511876 516732 517102 519321 519322 527782 528673 533659 537618 541900 541903 545038 545871 546653 550480 553156 553175 553186 553194 553502 553600 559467 566924 567461 568276 569815 570687 573386 577418 585628 600406 615721 619534 625282 625761 630848 691538 692459 693714 694417 694877 701216 701278 708504 722298 728525 730829 731771 733508 741559 744764 748469 751354 752534 752547 754890 761642 765963 768967 773466 804265 818253 818755 818762 823891 824822 825093 825135 827348 828106 828418 828772 828830 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.63%) |
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 157493 317898 387758 396362 397592 403685 418565 418568 426481 427418 428062 429494 438613 440526 442645 443188 453487 453595 453609 453850 453860 453871 453875 455194 459252 459470 462662 466299 470810 473306 474985 475814 476437 478403 485991 486816 490157 492816 494682 495178 495487 504175 504272 506568 506714 509058 509077 511876 516732 517102 519321 519322 527782 528673 533659 537618 541900 541903 545038 545871 546653 550480 553156 553175 553186 553194 553502 553600 559467 566924 567461 568276 569815 570687 573386 577418 585628 600406 615721 619534 625282 625761 630848 691538 692459 693714 694417 694877 701216 701278 708504 722298 728525 730829 731771 733508 741559 744764 748469 751354 752534 752547 754890 761642 765963 768967 773466 804265 818253 818755 818762 823891 824822 825093 825135 827348 828106 828418 828772 828830 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam hidden"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.39%) |
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.