Query Metrics
7
Database Queries
7
Different statements
146.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.62 ms (84.18%) |
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 392624 419361 463661 481120 487666 507285 513558 522749 531383 541061 543592 544580 545062 554208 555992 558491 568917 571437 577396 583744 585737 588021 603280 614693 618407 619320 629695 630880 635402 637081 641764 643472 644447 645006 650691 653117 672824 689951 703749 710939 715349 715604 716967 718603 718629 720345 722162 723957 724903 725060 725088 725204 725410 728947 729045 730119 734595 735984 737807 738560 739240 744056 746321 746440 746745 746777 747990 747994 748107 750635 752945 753153 758620 762580 765396 768382 768651 775644 780217 781009 781111 781113 782642 782686 785668 786708 787414 787669 787740 789554 791596 791631 791657 791795 792167 792499 793321 795346 795789 795860 796218 796701 797214 797380 800972 801354 801456 802067 808254 813193 813410 817187 819734 819758 819922 824091 824775 825871 826263 826580 ] |
||||||||||||||||||||||||||||||
|
13.30 ms (9.05%) |
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 558491 637081 618407 629695 643472 603280 630880 781009 782642 796218 775644 780217 785668 786708 787414 787740 795789 795860 796701 801456 808254 725060 725088 746321 746745 750635 789554 800972 725204 728947 735984 737807 747990 747994 768651 723957 725410 729045 739240 758620 765396 738560 746777 768382 730119 744056 703749 718603 718629 781111 791795 792499 793321 797214 797380 813193 571437 689951 715349 635402 753153 791657 724903 734595 748107 644447 716967 481120 419361 645006 555992 543592 577396 585737 614693 802067 641764 463661 513558 392624 826580 817187 819734 819758 824091 826263 819922 824775 522749 531383 568917 541061 554208 545062 583744 653117 720345 722162 792167 801354 781113 791596 795346 813410 752945 782686 746440 619320 588021 487666 825871 507285 544580 672824 650691 710939 715604 787669 791631 762580 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.83%) |
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 392624 419361 463661 481120 487666 507285 513558 522749 531383 541061 543592 544580 545062 554208 555992 558491 568917 571437 577396 583744 585737 588021 603280 614693 618407 619320 629695 630880 635402 637081 641764 643472 644447 645006 650691 653117 672824 689951 703749 710939 715349 715604 716967 718603 718629 720345 722162 723957 724903 725060 725088 725204 725410 728947 729045 730119 734595 735984 737807 738560 739240 744056 746321 746440 746745 746777 747990 747994 748107 750635 752945 753153 758620 762580 765396 768382 768651 775644 780217 781009 781111 781113 782642 782686 785668 786708 787414 787669 787740 789554 791596 791631 791657 791795 792167 792499 793321 795346 795789 795860 796218 796701 797214 797380 800972 801354 801456 802067 808254 813193 813410 817187 819734 819758 819922 824091 824775 825871 826263 826580 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina cum"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин cum"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин cum"
]
|
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.