Query Metrics
7
Database Queries
7
Different statements
169.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.30 ms (85.91%) |
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 41903 357457 397912 402950 405705 413687 416142 418697 419130 421732 423802 442117 442971 447160 447985 447987 451022 452325 455574 465497 474265 477118 478643 480450 492049 497906 513455 515490 518185 519368 519816 521182 521338 523273 531824 532451 539470 543648 546836 546964 547511 548460 549221 554803 556341 563706 564755 569572 571137 575180 575601 576221 576920 578349 579128 587303 588077 588379 589615 603362 623078 630828 634605 637901 644918 651829 652766 657505 665973 670357 672275 692094 700900 701763 708923 713505 714562 717516 717535 719957 720631 722264 725115 725642 726917 727510 727573 731862 734380 736249 736726 743965 744689 749245 761347 762763 774144 779193 782087 782351 783369 789374 791802 794759 800542 801455 805099 805524 810085 813485 813644 813646 814433 814962 816596 817211 821486 824096 825038 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (8.53%) |
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 652766 722264 657505 665973 708923 717516 749245 725115 725642 779193 402950 421732 416142 413687 451022 455574 465497 569572 575180 717535 579128 477118 423802 478643 518185 523273 513455 589615 644918 532451 447987 782087 521182 539470 719957 588379 714562 397912 824096 816596 563706 720631 774144 813485 731862 814962 587303 791802 813644 814433 817211 821486 825038 531824 546836 547511 692094 701763 651829 700900 630828 634605 801455 734380 743671 743965 805099 810085 727510 727573 726917 736726 744689 637901 783369 789374 442117 713505 405705 480450 497906 418697 447160 515490 519816 549221 556341 575601 546964 576920 603362 588077 419130 452325 519368 357457 447985 548460 543648 670357 782351 805524 761347 41903 442971 474265 521338 492049 571137 578349 554803 564755 672275 576221 623078 794759 762763 800542 736249 813646 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.58%) |
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 41903 357457 397912 402950 405705 413687 416142 418697 419130 421732 423802 442117 442971 447160 447985 447987 451022 452325 455574 465497 474265 477118 478643 480450 492049 497906 513455 515490 518185 519368 519816 521182 521338 523273 531824 532451 539470 543648 546836 546964 547511 548460 549221 554803 556341 563706 564755 569572 571137 575180 575601 576221 576920 578349 579128 587303 588077 588379 589615 603362 623078 630828 634605 637901 644918 651829 652766 657505 665973 670357 672275 692094 700900 701763 708923 713505 714562 717516 717535 719957 720631 722264 725115 725642 726917 727510 727573 731862 734380 736249 736726 743965 744689 749245 761347 762763 774144 779193 782087 782351 783369 789374 791802 794759 800542 801455 805099 805524 810085 813485 813644 813646 814433 814962 816596 817211 821486 824096 825038 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass gape"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.