Query Metrics
7
Database Queries
7
Different statements
268.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
232.80 ms (86.68%) |
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 108925 256821 304572 383112 398230 409667 421352 437864 443090 447573 448031 448696 451246 458766 473392 475646 477038 477491 479684 479816 487774 489309 493418 497691 507824 508541 511053 511254 515364 517425 520495 521775 524094 524198 526943 527285 527677 529632 531360 531403 532942 534114 534425 536914 540944 541570 542137 542142 542524 543842 544439 545117 545395 546854 550536 552709 562052 564293 574763 577371 578328 579457 579673 584331 588929 589042 590169 590411 601862 602444 605208 613180 622025 631616 633755 638885 639782 650145 650476 656905 658802 665958 674043 680252 686335 687347 690684 705451 710233 713196 717859 718987 719573 721521 722520 726946 738487 744266 745128 745918 746364 752700 753244 757905 764280 765721 769885 781300 782653 784398 785584 788800 796509 796872 800097 800538 803509 809015 813206 823484 ] |
||||||||||||||||||||||||||||||
|
20.26 ms (7.54%) |
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 526943 534114 534425 542137 564293 542142 545395 717859 674043 633755 796509 800538 765721 781300 784398 726946 745918 719573 458766 475646 527285 108925 536914 520495 497691 531360 574763 562052 550536 601862 602444 638885 515364 524094 521775 531403 544439 546854 690684 639782 782653 757905 788800 517425 507824 256821 823484 527677 529632 650145 687347 713196 718987 722520 710233 656905 721521 588929 622025 800097 769885 785584 813206 753244 796872 304572 511053 543842 532942 542524 541570 650476 631616 752700 398230 479684 545117 447573 451246 493418 686335 540944 613180 473392 443090 421352 487774 511254 577371 590411 448696 437864 479816 489309 508541 477491 383112 584331 552709 578328 579457 705451 658802 665958 680252 579673 605208 590169 589042 803509 738487 746364 744266 745128 764280 809015 477038 409667 448031 524198 ] |
||||||||||||||||||||||||||||||
|
8.81 ms (3.28%) |
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 108925 256821 304572 383112 398230 409667 421352 437864 443090 447573 448031 448696 451246 458766 473392 475646 477038 477491 479684 479816 487774 489309 493418 497691 507824 508541 511053 511254 515364 517425 520495 521775 524094 524198 526943 527285 527677 529632 531360 531403 532942 534114 534425 536914 540944 541570 542137 542142 542524 543842 544439 545117 545395 546854 550536 552709 562052 564293 574763 577371 578328 579457 579673 584331 588929 589042 590169 590411 601862 602444 605208 613180 622025 631616 633755 638885 639782 650145 650476 656905 658802 665958 674043 680252 686335 687347 690684 705451 710233 713196 717859 718987 719573 721521 722520 726946 738487 744266 745128 745918 746364 752700 753244 757905 764280 765721 769885 781300 782653 784398 785584 788800 796509 796872 800097 800538 803509 809015 813206 823484 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд член"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд член"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo dick"
]
|
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.