Query Metrics
7
Database Queries
7
Different statements
184.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.14 ms (86.66%) |
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 69940 385591 385830 388784 395839 396777 398184 401824 403770 403958 404353 406047 417564 417693 418699 421373 422335 434793 436480 443866 447521 448794 450547 452622 455625 455735 456476 458339 460430 460709 466828 474579 494671 500194 505785 508268 512289 512334 512599 523703 525994 526658 535574 552996 552998 553633 562014 562387 564361 573794 574881 574930 575141 578554 580651 583471 584329 585721 592522 592643 595239 595708 596488 600094 600709 605426 606908 610339 612089 620235 626845 626949 629906 636540 652689 662637 682259 691414 692604 692636 693341 693361 697649 699520 700540 702939 704910 729344 737110 741059 744842 748527 749725 750867 751817 758742 759650 762468 764486 764923 769308 771829 774716 778413 779425 787945 791063 792214 795547 795554 797574 798361 801953 806760 809521 811782 815853 815999 821473 822825 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (7.67%) |
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 562387 778413 779425 792214 798361 751817 764923 612089 699520 592643 436480 762468 764486 401824 508268 592522 822825 395839 406047 697649 452622 396777 552998 769308 744842 422335 443866 693341 750867 398184 815853 815999 448794 584329 595239 795547 795554 585721 69940 821473 535574 466828 583471 682259 691414 662637 692604 578554 620235 605426 626845 774716 811782 748527 749725 629906 418699 526658 595708 458339 791063 600094 806760 741059 787945 456476 553633 692636 626949 403958 421373 552996 525994 455735 450547 447521 512289 403770 573794 700540 455625 417564 494671 564361 460430 385591 417693 505785 512599 797574 404353 574930 474579 460709 434793 574881 758742 500194 385830 809521 729344 388784 652689 523703 562014 702939 704910 801953 759650 693361 606908 610339 771829 512334 575141 580651 600709 596488 737110 636540 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.08%) |
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 69940 385591 385830 388784 395839 396777 398184 401824 403770 403958 404353 406047 417564 417693 418699 421373 422335 434793 436480 443866 447521 448794 450547 452622 455625 455735 456476 458339 460430 460709 466828 474579 494671 500194 505785 508268 512289 512334 512599 523703 525994 526658 535574 552996 552998 553633 562014 562387 564361 573794 574881 574930 575141 578554 580651 583471 584329 585721 592522 592643 595239 595708 596488 600094 600709 605426 606908 610339 612089 620235 626845 626949 629906 636540 652689 662637 682259 691414 692604 692636 693341 693361 697649 699520 700540 702939 704910 729344 737110 741059 744842 748527 749725 750867 751817 758742 759650 762468 764486 764923 769308 771829 774716 778413 779425 787945 791063 792214 795547 795554 797574 798361 801953 806760 809521 811782 815853 815999 821473 822825 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best deep throat"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best глубокийминет минет оральн секс"
]
|
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.