Query Metrics
7
Database Queries
7
Different statements
150.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.96 ms (83.24%) |
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 154694 155232 206144 383290 396088 401733 401816 409060 410980 418078 418558 426470 428874 430508 431794 444731 454814 469833 471185 474876 479818 488017 493838 498525 501703 502832 502894 505024 507181 509643 511302 513022 513893 515418 521267 526985 530050 530053 530752 530796 531544 531724 531888 534354 535372 535543 536557 536559 537319 538076 541376 550324 552881 553430 562797 563927 566164 571194 571826 574375 575899 576533 577718 580866 582595 583199 584425 587445 590512 595524 596133 607638 609877 620755 629281 639819 641807 646435 651290 663263 665210 666658 667498 668834 671008 694894 700990 701875 708517 709764 716246 718701 719203 727920 729538 732161 733398 736289 742360 744774 750881 751722 752627 764160 767454 770237 770964 774333 775903 778384 779464 787130 788154 797637 801147 801475 803458 804192 807373 807991 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (9.67%) |
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 770237 770964 620755 779464 807373 807991 154694 155232 428874 474876 426470 401816 493838 479818 530050 530796 530053 383290 535372 668834 596133 401733 418558 454814 538076 577718 563927 576533 709764 639819 775903 729538 764160 767454 733398 732161 727920 752627 778384 431794 444731 536557 537319 501703 507181 513022 526985 531544 471185 553430 566164 580866 700990 550324 641807 590512 587445 430508 410980 469833 509643 502894 206144 418078 488017 515418 531888 513893 530752 531724 541376 574375 584425 562797 571194 651290 671008 701875 719203 663263 694894 718701 575899 607638 609877 595524 797637 801147 801475 736289 787130 803458 744774 742360 774333 751722 750881 629281 788154 804192 396088 409060 505024 498525 511302 521267 536559 502832 534354 535543 571826 583199 582595 552881 666658 716246 646435 665210 667498 708517 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.10%) |
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 154694 155232 206144 383290 396088 401733 401816 409060 410980 418078 418558 426470 428874 430508 431794 444731 454814 469833 471185 474876 479818 488017 493838 498525 501703 502832 502894 505024 507181 509643 511302 513022 513893 515418 521267 526985 530050 530053 530752 530796 531544 531724 531888 534354 535372 535543 536557 536559 537319 538076 541376 550324 552881 553430 562797 563927 566164 571194 571826 574375 575899 576533 577718 580866 582595 583199 584425 587445 590512 595524 596133 607638 609877 620755 629281 639819 641807 646435 651290 663263 665210 666658 667498 668834 671008 694894 700990 701875 708517 709764 716246 718701 719203 727920 729538 732161 733398 736289 742360 744774 750881 751722 752627 764160 767454 770237 770964 774333 775903 778384 779464 787130 788154 797637 801147 801475 803458 804192 807373 807991 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.12%) |
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.