Query Metrics
7
Database Queries
7
Different statements
214.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.20 ms (88.52%) |
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 4306 150798 188403 385805 407871 413283 422335 428048 430815 442084 443906 445620 447134 453491 454184 457431 457585 459446 460768 461938 465763 466559 476796 479856 481166 484827 485755 486578 491228 491639 493179 498447 518942 524755 529828 530750 536571 537882 550560 558028 558736 560426 565194 566219 568054 570722 576180 577039 580585 586395 594814 598700 604673 608015 615698 623968 624470 624837 646868 647882 649932 650339 651610 657556 660427 662209 662389 668529 672192 672910 683517 689673 693239 699482 713193 717724 721549 722172 724245 725141 727924 730315 730637 732256 732810 733880 735031 736271 737164 741548 742316 743829 744937 748213 748245 749874 753458 766596 766773 767118 773224 774176 776154 776320 784219 791567 791602 792670 794830 796956 797191 797721 800502 801483 804639 810416 811883 814232 814470 815054 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (6.90%) |
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 657556 662389 565194 594814 598700 624837 604673 730315 804639 150798 407871 430815 188403 447134 443906 457585 491639 518942 428048 457431 491228 529828 558736 570722 566219 672910 560426 586395 797721 773224 749874 792670 465763 479856 442084 461938 476796 445620 460768 481166 485755 486578 493179 498447 385805 4306 413283 422335 814232 815054 814470 466559 453491 454184 459446 484827 524755 536571 537882 530750 558028 568054 576180 672192 699482 713193 717724 646868 647882 649932 651610 660427 689673 693239 650339 662209 668529 683517 721549 722172 550560 577039 580585 615698 624470 623968 608015 776154 776320 791567 794830 796956 791602 800502 811883 725141 727924 733880 766596 784219 797191 801483 810416 724245 730637 732256 732810 736271 741548 748213 748245 753458 766773 767118 735031 737164 742316 743829 744937 774176 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.36%) |
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 4306 150798 188403 385805 407871 413283 422335 428048 430815 442084 443906 445620 447134 453491 454184 457431 457585 459446 460768 461938 465763 466559 476796 479856 481166 484827 485755 486578 491228 491639 493179 498447 518942 524755 529828 530750 536571 537882 550560 558028 558736 560426 565194 566219 568054 570722 576180 577039 580585 586395 594814 598700 604673 608015 615698 623968 624470 624837 646868 647882 649932 650339 651610 657556 660427 662209 662389 668529 672192 672910 683517 689673 693239 699482 713193 717724 721549 722172 724245 725141 727924 730315 730637 732256 732810 733880 735031 736271 737164 741548 742316 743829 744937 748213 748245 749874 753458 766596 766773 767118 773224 774176 776154 776320 784219 791567 791602 792670 794830 796956 797191 797721 800502 801483 804639 810416 811883 814232 814470 815054 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal tits"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.