Query Metrics
7
Database Queries
7
Different statements
399.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
373.40 ms (93.35%) |
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 47606 402088 418440 422805 425469 429124 431523 433350 436776 438364 439617 441536 441626 442441 443004 443107 448224 448576 448992 450172 454777 457045 457282 457684 459248 462331 463663 466376 468836 470504 472094 472119 474826 475232 486862 486863 486875 487749 491894 494496 494544 495682 495847 497160 500186 501033 501228 502841 503693 503702 503863 506436 507797 509009 510293 511543 514020 514744 516324 516713 517565 517769 517790 517831 518596 519341 520059 520701 521971 525985 526586 532351 539147 549699 554847 556502 556655 562106 565077 565720 567425 574243 578795 592421 593275 593618 595751 595754 595863 596069 597015 599030 601027 603623 607919 615729 620057 620757 623150 625378 630639 633818 643079 647305 648685 661286 667647 677020 684704 697006 699611 707280 714927 726589 745042 745493 747236 766616 792488 806804 ] |
||||||||||||||||||||||||||||||
|
17.26 ms (4.32%) |
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 593618 792488 806804 472094 500186 501033 509009 495847 620757 684704 620057 431523 457684 517565 699611 661286 595751 595863 714927 443004 402088 438364 439617 47606 494544 507797 565077 647305 495682 539147 517769 466376 418440 556502 442441 501228 494496 450172 459248 532351 516713 697006 630639 747236 766616 433350 468836 506436 517831 597015 514744 514020 565720 677020 436776 463663 472119 486862 429124 470504 457282 511543 487749 578795 554847 707280 592421 425469 475232 491894 525985 502841 574243 441626 519341 486863 556655 648685 745493 745042 457045 497160 633818 443107 503702 595754 516324 562106 667647 601027 625378 615729 474826 517790 503693 503863 567425 549699 643079 462331 518596 526586 607919 603623 422805 520701 521971 486875 599030 448576 448224 520059 441536 454777 593275 448992 510293 596069 623150 726589 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (0.65%) |
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 47606 402088 418440 422805 425469 429124 431523 433350 436776 438364 439617 441536 441626 442441 443004 443107 448224 448576 448992 450172 454777 457045 457282 457684 459248 462331 463663 466376 468836 470504 472094 472119 474826 475232 486862 486863 486875 487749 491894 494496 494544 495682 495847 497160 500186 501033 501228 502841 503693 503702 503863 506436 507797 509009 510293 511543 514020 514744 516324 516713 517565 517769 517790 517831 518596 519341 520059 520701 521971 525985 526586 532351 539147 549699 554847 556502 556655 562106 565077 565720 567425 574243 578795 592421 593275 593618 595751 595754 595863 596069 597015 599030 601027 603623 607919 615729 620057 620757 623150 625378 630639 633818 643079 647305 648685 661286 667647 677020 684704 697006 699611 707280 714927 726589 745042 745493 747236 766616 792488 806804 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits sucking"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон sucking"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон sucking"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.