Query Metrics
7
Database Queries
7
Different statements
144.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.98 ms (84.44%) |
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 439855 494861 497507 499902 500538 500916 501477 504810 506769 509679 510882 513826 513975 516043 517114 519388 519865 519872 520820 522387 522433 522784 523279 527072 527463 527928 530646 533333 539331 539372 553227 555479 557102 557361 557735 558574 559300 562966 563633 565033 566337 572235 576520 576776 577147 578290 578599 579947 580597 582944 584005 585787 586574 586897 586981 587899 587950 588082 589647 590941 591315 591550 591735 591928 591940 591966 592580 593609 593824 595358 597110 597666 599339 600540 602016 602526 603615 604238 605381 605391 608414 610085 612235 612237 612254 613921 615908 616005 619040 620117 621186 621375 623972 626165 627674 630670 631119 631245 632198 647027 654165 656158 660030 662152 664241 664497 666188 667344 680400 690281 692124 716969 727782 730359 742747 747964 749150 761137 771918 775724 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (9.57%) |
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 591315 591735 600540 619040 626165 588082 595358 597110 612254 615908 632198 513975 520820 555479 660030 716969 666188 557735 563633 591940 630670 775724 730359 742747 749150 761137 566337 572235 680400 579947 623972 558574 587899 621186 533333 519872 539331 539372 497507 565033 576776 578290 562966 654165 604238 605381 439855 580597 592580 499902 500538 500916 501477 516043 519388 523279 519865 504810 522433 557102 557361 553227 576520 578599 582944 664241 647027 656158 662152 690281 577147 585787 593609 593824 589647 590941 591928 597666 605391 610085 616005 620117 599339 613921 631119 586574 586897 591550 608414 612237 627674 603615 621375 513826 587950 631245 727782 771918 494861 506769 667344 664497 602016 612235 692124 559300 586981 747964 510882 584005 591966 602526 522784 517114 527463 522387 527072 527928 509679 530646 ] |
||||||||||||||||||||||||||||||
|
2.26 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 439855 494861 497507 499902 500538 500916 501477 504810 506769 509679 510882 513826 513975 516043 517114 519388 519865 519872 520820 522387 522433 522784 523279 527072 527463 527928 530646 533333 539331 539372 553227 555479 557102 557361 557735 558574 559300 562966 563633 565033 566337 572235 576520 576776 577147 578290 578599 579947 580597 582944 584005 585787 586574 586897 586981 587899 587950 588082 589647 590941 591315 591550 591735 591928 591940 591966 592580 593609 593824 595358 597110 597666 599339 600540 602016 602526 603615 604238 605381 605391 608414 610085 612235 612237 612254 613921 615908 616005 619040 620117 621186 621375 623972 626165 627674 630670 631119 631245 632198 647027 654165 656158 660030 662152 664241 664497 666188 667344 680400 690281 692124 716969 727782 730359 742747 747964 749150 761137 771918 775724 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с кримпаем"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.93%) |
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.