Query Metrics
7
Database Queries
7
Different statements
222.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.10 ms (88.84%) |
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 396268 397325 401599 417427 421448 424679 435207 441110 448078 455227 456333 459532 459703 466327 471935 474953 482615 486012 487422 499066 499900 505575 507441 507780 508522 509066 510557 514149 515371 517018 517620 522934 525576 525869 527786 531264 533056 533118 533430 534853 534928 535076 546252 547848 550768 550935 574803 574805 575469 575482 575596 588220 590505 593003 593087 593742 596612 599049 601500 637486 648125 660608 665922 669637 677919 677920 680611 683012 686271 687021 692524 695882 697494 698021 700895 704955 710200 722993 723019 724789 728482 730363 733230 738009 739871 740484 742875 745227 746993 752502 754424 755237 757182 760696 763276 765356 767069 769119 772216 782762 784724 788093 790819 793724 795945 796727 796968 797215 798704 803194 805334 808997 809808 809827 817126 817750 818841 825516 827433 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (6.60%) |
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 745227 757182 767069 527786 760696 740484 593742 474953 697494 825516 487422 509066 546252 698021 796727 754424 728482 755237 765356 763276 505575 808997 471935 441110 424679 593003 456333 396268 397325 817126 531264 710200 793724 752502 550935 499066 798704 764783 746993 486012 525869 687021 593087 590505 817750 517620 723019 772216 788093 769119 507441 534853 648125 677919 574803 533056 665922 680611 692524 660608 596612 599049 510557 459703 818841 827433 482615 533430 517018 782762 795945 730363 809827 534928 700895 686271 704955 535076 459532 522934 499900 525576 547848 695882 677920 796968 733230 742875 739871 588220 790819 401599 466327 722993 803194 805334 738009 784724 448078 809808 507780 515371 724789 669637 417427 508522 514149 550768 421448 435207 533118 575596 683012 637486 601500 797215 575482 574805 575469 455227 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (1.56%) |
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 396268 397325 401599 417427 421448 424679 435207 441110 448078 455227 456333 459532 459703 466327 471935 474953 482615 486012 487422 499066 499900 505575 507441 507780 508522 509066 510557 514149 515371 517018 517620 522934 525576 525869 527786 531264 533056 533118 533430 534853 534928 535076 546252 547848 550768 550935 574803 574805 575469 575482 575596 588220 590505 593003 593087 593742 596612 599049 601500 637486 648125 660608 665922 669637 677919 677920 680611 683012 686271 687021 692524 695882 697494 698021 700895 704955 710200 722993 723019 724789 728482 730363 733230 738009 739871 740484 742875 745227 746993 752502 754424 755237 757182 760696 763276 765356 767069 769119 772216 782762 784724 788093 790819 793724 795945 796727 796968 797215 798704 803194 805334 808997 809808 809827 817126 817750 818841 825516 827433 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur bondage sex"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск бдсм секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.65%) |
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.