Query Metrics
7
Database Queries
7
Different statements
383.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
360.05 ms (93.93%) |
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 395450 403948 418562 435602 458552 470621 470659 482770 492296 495889 504028 508102 509365 509949 510309 513809 514346 530197 530208 533152 534102 534901 535865 536009 536132 536824 537417 537990 538619 540561 545159 547529 550274 550303 553443 554072 555725 556239 557587 558094 559311 561016 567613 567617 572978 573134 573454 576252 577128 583346 587117 587523 588035 588096 588328 589277 589307 592142 592306 593798 594063 594412 596603 596818 600331 600699 601986 602269 604563 604687 612152 616138 617387 618334 627493 627495 628569 636483 639528 642951 644008 653051 661920 663155 665332 668140 670557 671256 672774 677534 683078 684693 686384 690726 691171 698238 700476 707415 710827 712948 715862 716153 729856 735777 739787 740058 744777 745486 745789 748395 749753 752458 770365 782455 782555 784168 787054 794272 795368 799774 ] |
||||||||||||||||||||||||||||||
|
13.02 ms (3.40%) |
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 612152 698238 707415 470621 537990 716153 587523 715862 710827 593798 787054 729856 745789 735777 748395 784168 403948 739787 617387 592142 588096 418562 567613 795368 782455 794272 770365 749753 594063 712948 513809 576252 663155 573454 596818 604563 594412 509365 534102 537417 538619 540561 508102 530197 530208 536824 534901 536132 558094 583346 557587 683078 665332 671256 677534 690726 653051 670557 567617 572978 589307 592306 596603 636483 587117 589277 600699 628569 600331 627493 642951 644008 604687 616138 627495 639528 514346 504028 495889 618334 691171 588328 510309 533152 547529 559311 550274 668140 395450 492296 470659 509949 536009 556239 561016 545159 554072 577128 588035 740058 744777 799774 745486 752458 782555 550303 555725 482770 553443 601986 700476 535865 602269 573134 661920 684693 672774 686384 435602 458552 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (0.84%) |
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 395450 403948 418562 435602 458552 470621 470659 482770 492296 495889 504028 508102 509365 509949 510309 513809 514346 530197 530208 533152 534102 534901 535865 536009 536132 536824 537417 537990 538619 540561 545159 547529 550274 550303 553443 554072 555725 556239 557587 558094 559311 561016 567613 567617 572978 573134 573454 576252 577128 583346 587117 587523 588035 588096 588328 589277 589307 592142 592306 593798 594063 594412 596603 596818 600331 600699 601986 602269 604563 604687 612152 616138 617387 618334 627493 627495 628569 636483 639528 642951 644008 653051 661920 663155 665332 668140 670557 671256 672774 677534 683078 684693 686384 690726 691171 698238 700476 707415 710827 712948 715862 716153 729856 735777 739787 740058 744777 745486 745789 748395 749753 752458 770365 782455 782555 784168 787054 794272 795368 799774 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mobile"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск телефон"
]
|
||||||||||||||||||||||||||||||
|
1.31 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.