Query Metrics
7
Database Queries
7
Different statements
147.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.69 ms (85.40%) |
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 383000 384478 388856 426696 438655 444533 446785 450289 455603 460168 460199 462840 469393 477757 492554 493411 497829 498110 498963 500340 500341 508963 513795 526534 530695 531008 531139 533200 540808 541413 541832 554654 560094 560684 569634 576503 576759 578541 579271 579452 580656 584334 587157 588387 594993 595131 595214 595986 596189 596796 602054 604104 604106 604865 604909 606902 614957 620663 623610 624751 632823 634743 635802 639306 640152 641967 663281 666712 666988 672822 700821 707451 710590 711761 713332 715802 720138 720139 723294 727992 728493 730015 735498 738511 739820 748431 749087 750429 752663 753033 755022 764030 765657 776264 776861 783044 787521 791917 793187 796221 796933 798606 801610 803745 803755 803769 803775 804932 806391 806823 807157 807577 808385 808972 812755 814037 824766 825560 825864 ] |
||||||||||||||||||||||||||||||
|
12.28 ms (8.35%) |
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 493411 580656 584334 596796 713332 444533 500340 498110 500341 455603 824766 540808 825560 531008 707451 723294 595131 624751 606902 776264 783044 804932 796933 803769 735498 764030 715802 787521 533200 513795 560684 569634 579271 604621 595986 426696 526534 825864 446785 614957 749087 801610 384478 530695 460199 554654 700821 666712 576759 588387 641967 587157 803745 803775 807157 730015 739820 748431 765657 604104 639306 720138 776861 806391 806823 808385 383000 604909 803755 604865 620663 541832 492554 469393 508963 498963 640152 623610 388856 450289 497829 531139 462840 541413 666988 663281 672822 595214 635802 604106 791917 753033 738511 752663 634743 477757 438655 814037 460168 560094 576503 578541 579452 710590 632823 594993 596189 808972 793187 798606 807577 728493 755022 727992 750429 602054 711761 720139 796221 812755 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.68%) |
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 383000 384478 388856 426696 438655 444533 446785 450289 455603 460168 460199 462840 469393 477757 492554 493411 497829 498110 498963 500340 500341 508963 513795 526534 530695 531008 531139 533200 540808 541413 541832 554654 560094 560684 569634 576503 576759 578541 579271 579452 580656 584334 587157 588387 594993 595131 595214 595986 596189 596796 602054 604104 604106 604865 604909 606902 614957 620663 623610 624751 632823 634743 635802 639306 640152 641967 663281 666712 666988 672822 700821 707451 710590 711761 713332 715802 720138 720139 723294 727992 728493 730015 735498 738511 739820 748431 749087 750429 752663 753033 755022 764030 765657 776264 776861 783044 787521 791917 793187 796221 796933 798606 801610 803745 803755 803769 803775 804932 806391 806823 807157 807577 808385 808972 812755 814037 824766 825560 825864 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf riding dildo"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf riding дилд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf riding дилд"
]
|
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.