Query Metrics
7
Database Queries
7
Different statements
399.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.88 ms (51.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
170.21 ms (42.64%) |
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 37365 96462 304428 311005 378272 497903 529317 530078 530593 530838 531530 534055 534056 534989 535545 536597 538035 538789 539162 540521 540530 543869 544682 558784 561443 563281 564270 567207 580322 585383 591635 592225 593220 595151 597615 604611 604992 609891 615083 615335 626382 627634 629735 631003 633595 633900 633918 634616 637870 639645 641437 641631 642624 645605 646173 647515 647520 647702 648857 652419 653793 653812 654977 656562 656622 658192 660057 662559 667392 673468 673924 681290 690711 696094 697587 701158 708589 708813 711255 716158 716904 717150 719842 720205 724590 727282 732563 732624 733583 734231 734471 737724 739721 739877 741436 746545 747988 750238 750239 754229 759269 759689 761000 767176 770898 775424 781546 786203 798423 801512 803727 804176 807045 807135 808469 812091 817941 821486 827913 828539 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (3.79%) |
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 827913 828539 531530 534055 535545 530593 534056 534989 538035 540530 536597 538789 540521 544682 563281 561443 580322 543869 564270 567207 646173 647702 658192 660057 673924 708589 711255 645605 652419 653793 667392 716904 720205 647515 647520 653812 654977 656562 656622 673468 719842 558784 592225 609891 615335 633595 642624 585383 597615 615083 627634 637870 641631 593220 629735 631003 604992 633900 633918 634616 639645 775424 804176 781546 732563 732624 733583 737724 750238 750239 767176 770898 798423 803727 808469 812091 734231 761000 734471 739721 746545 754229 739877 759689 741436 747988 626382 641437 697587 701158 716158 801512 807045 807135 37365 681290 786203 530078 717150 662559 591635 724590 708813 530838 497903 648857 727282 604611 311005 378272 821486 817941 539162 690711 696094 595151 759269 304428 529317 96462 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.60%) |
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 37365 96462 304428 311005 378272 497903 529317 530078 530593 530838 531530 534055 534056 534989 535545 536597 538035 538789 539162 540521 540530 543869 544682 558784 561443 563281 564270 567207 580322 585383 591635 592225 593220 595151 597615 604611 604992 609891 615083 615335 626382 627634 629735 631003 633595 633900 633918 634616 637870 639645 641437 641631 642624 645605 646173 647515 647520 647702 648857 652419 653793 653812 654977 656562 656622 658192 660057 662559 667392 673468 673924 681290 690711 696094 697587 701158 708589 708813 711255 716158 716904 717150 719842 720205 724590 727282 732563 732624 733583 734231 734471 737724 739721 739877 741436 746545 747988 750238 750239 754229 759269 759689 761000 767176 770898 775424 781546 786203 798423 801512 803727 804176 807045 807135 808469 812091 817941 821486 827913 828539 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass interracial"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.34%) |
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.