Query Metrics
7
Database Queries
7
Different statements
163.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.17 ms (85.09%) |
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 391819 393140 422010 444064 473390 496203 496918 512695 514109 516144 522055 531597 538705 539643 541013 541054 544613 550965 551662 557681 560305 563249 563751 566742 584346 585944 588136 589657 592002 603449 605678 606334 607545 612169 616021 616632 627265 627378 630727 633577 635590 638168 638751 640367 642992 647788 653099 656283 656873 657142 662114 664517 669305 700162 707534 708061 708983 709937 710503 713058 720547 724487 728778 729862 733010 733433 734247 734445 737363 738587 738860 739740 742346 742696 748620 748636 750110 752295 753659 759017 759814 761335 763966 765842 767546 767695 767756 769688 770086 771070 771367 773361 773385 778153 778492 779415 781286 781370 781625 782082 783038 786602 791607 791736 791748 793085 793259 793297 793523 793913 794710 794728 797395 797716 803742 803903 804795 814121 824874 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (8.27%) |
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 753659 770086 728778 748636 804795 814121 563751 793297 803742 773385 794710 803903 738587 729862 733433 773406 797716 522055 720547 496918 496203 662114 708061 653099 700162 647788 657142 606334 607545 616021 778153 710503 713058 422010 612169 638168 781625 767546 767695 791748 759017 759814 763966 773361 779415 786602 791607 516144 393140 824874 514109 473390 793259 734247 797395 771070 737363 742346 782082 793523 391819 563249 584346 656283 664517 669305 708983 588136 605678 640367 585944 627265 635590 642992 531597 630727 539643 550965 633577 794728 733010 739740 765842 724487 771367 752295 769688 761335 767756 444064 512695 603449 783038 793913 781370 778492 709937 638751 544613 541054 560305 656873 589657 616632 592002 707534 551662 627378 538705 541013 566742 557681 781286 791736 734445 748620 738860 750110 742696 793085 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.99%) |
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 391819 393140 422010 444064 473390 496203 496918 512695 514109 516144 522055 531597 538705 539643 541013 541054 544613 550965 551662 557681 560305 563249 563751 566742 584346 585944 588136 589657 592002 603449 605678 606334 607545 612169 616021 616632 627265 627378 630727 633577 635590 638168 638751 640367 642992 647788 653099 656283 656873 657142 662114 664517 669305 700162 707534 708061 708983 709937 710503 713058 720547 724487 728778 729862 733010 733433 734247 734445 737363 738587 738860 739740 742346 742696 748620 748636 750110 752295 753659 759017 759814 761335 763966 765842 767546 767695 767756 769688 770086 771070 771367 773361 773385 778153 778492 779415 781286 781370 781625 782082 783038 786602 791607 791736 791748 793085 793259 793297 793523 793913 794710 794728 797395 797716 803742 803903 804795 814121 824874 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fast homemade"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fast домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fast домашн любительск"
]
|
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.