Query Metrics
7
Database Queries
7
Different statements
379.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.61 ms (54.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
143.60 ms (37.79%) |
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 382422 394589 395864 398369 400713 421238 427931 429930 431723 434022 435239 447661 447671 449370 466645 478887 480099 483030 492593 494820 500945 508268 514625 517308 529026 534742 536892 540158 540832 541907 545861 552606 556399 556899 556901 559208 559412 559729 561166 565558 567037 568513 569763 570858 570861 577650 579375 581510 582985 585720 586208 590603 593181 594297 594469 615386 621509 621710 622045 625496 625540 626579 629540 629662 636546 649318 651128 652964 672391 679607 682929 689028 702010 709764 709913 716353 718919 719040 721264 724461 729928 730318 731397 732027 733789 736361 738812 743385 743843 746667 747571 747987 749969 755023 757117 757195 761834 762339 775227 775475 776413 777625 778336 779089 792025 793357 793789 795673 800390 800975 806097 807472 808727 810736 814644 814959 820169 823911 828375 828393 ] |
||||||||||||||||||||||||||||||
|
19.79 ms (5.21%) |
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 721264 709913 716353 625496 775475 724461 730318 622045 793789 579375 398369 534742 570858 568513 567037 702010 629662 743385 793357 800390 565558 494820 434022 429930 382422 828375 395864 431723 394589 545861 651128 652964 689028 682929 626579 594469 621509 795673 777625 807472 732027 757117 757195 733789 762339 806097 447661 447671 466645 421238 435239 492593 500945 508268 577650 559729 536892 820169 823911 540158 814644 529026 541907 570861 582985 672391 718919 719040 649318 679607 561166 594297 778336 792025 800975 743843 731397 729928 736361 749969 761834 779089 581510 559412 590603 400713 814959 483030 449370 552606 556899 709764 556901 569763 585720 586208 615386 621710 636546 625540 593181 810736 775227 776413 746667 755023 747571 747987 738812 629540 808727 427931 514625 540832 828393 556399 559208 478887 480099 517308 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.72%) |
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 382422 394589 395864 398369 400713 421238 427931 429930 431723 434022 435239 447661 447671 449370 466645 478887 480099 483030 492593 494820 500945 508268 514625 517308 529026 534742 536892 540158 540832 541907 545861 552606 556399 556899 556901 559208 559412 559729 561166 565558 567037 568513 569763 570858 570861 577650 579375 581510 582985 585720 586208 590603 593181 594297 594469 615386 621509 621710 622045 625496 625540 626579 629540 629662 636546 649318 651128 652964 672391 679607 682929 689028 702010 709764 709913 716353 718919 719040 721264 724461 729928 730318 731397 732027 733789 736361 738812 743385 743843 746667 747571 747987 749969 755023 757117 757195 761834 762339 775227 775475 776413 777625 778336 779089 792025 793357 793789 795673 800390 800975 806097 807472 808727 810736 814644 814959 820169 823911 828375 828393 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny compilation"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые подборк"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.37%) |
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.