Query Metrics
7
Database Queries
7
Different statements
177.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.90 ms (86.18%) |
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 386345 398613 421323 429321 429529 433697 448315 463047 478863 481994 496859 504672 504770 510673 513190 514767 516310 521902 539049 541882 549148 550720 561409 562779 565177 566293 566624 567628 568051 573792 578838 580829 583616 585728 586320 588124 610275 617294 617319 618504 622334 626274 631390 632984 645370 651957 654124 663292 672161 676527 676554 678017 678986 680823 681663 684208 687238 687579 689229 693794 696106 697129 697650 698039 699436 700303 701392 703350 706612 709326 710586 713054 714290 714344 720035 725580 726790 726862 727251 727650 728694 730481 730931 734740 735806 736684 736693 739268 741949 744320 744462 746142 747651 748682 751531 755727 758197 763749 763964 771742 774882 775771 778329 779939 783679 784762 787040 787149 794712 798121 803711 807425 811117 817305 819340 824224 824346 825283 825689 825708 ] |
||||||||||||||||||||||||||||||
|
14.60 ms (8.23%) |
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 567628 478863 496859 398613 421323 429321 817305 825689 573792 580829 583616 654124 672161 687238 698039 684208 696106 676527 697650 706612 562779 617294 617319 622334 618504 725580 748682 730931 739268 746142 755727 758197 735806 763964 700303 539049 566624 386345 825708 819340 824224 825283 549148 561409 568051 566293 663292 720035 678017 681663 689229 699436 714344 676554 680823 703350 713054 714290 626274 586320 588124 631390 775771 778329 783679 794712 798121 811117 784762 787149 803711 726790 726862 728694 734740 736684 730481 741949 747651 727251 771742 697129 701392 709326 787040 516310 824346 514767 550720 693794 710586 645370 678986 585728 610275 807425 779939 763749 744462 774882 433697 513190 504672 504770 541882 651957 736693 744320 751531 510673 521902 448315 463047 578838 429529 565177 687579 727650 632984 481994 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.57%) |
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 386345 398613 421323 429321 429529 433697 448315 463047 478863 481994 496859 504672 504770 510673 513190 514767 516310 521902 539049 541882 549148 550720 561409 562779 565177 566293 566624 567628 568051 573792 578838 580829 583616 585728 586320 588124 610275 617294 617319 618504 622334 626274 631390 632984 645370 651957 654124 663292 672161 676527 676554 678017 678986 680823 681663 684208 687238 687579 689229 693794 696106 697129 697650 698039 699436 700303 701392 703350 706612 709326 710586 713054 714290 714344 720035 725580 726790 726862 727251 727650 728694 730481 730931 734740 735806 736684 736693 739268 741949 744320 744462 746142 747651 748682 751531 755727 758197 763749 763964 771742 774882 775771 778329 779939 783679 784762 787040 787149 794712 798121 803711 807425 811117 817305 819340 824224 824346 825283 825689 825708 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big girl sleeping"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие девушк спящ"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.98%) |
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.