Query Metrics
7
Database Queries
7
Different statements
162.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.38 ms (78.92%) |
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 209373 385077 386460 391702 391941 394453 394579 410935 411047 411333 411726 411898 420375 420601 428382 428409 428770 435064 443813 447843 452618 454183 454214 454552 459671 460958 463162 463903 464513 464732 465330 465378 465963 466056 466270 469915 470389 470567 470641 472341 472792 473788 474482 474488 474642 474791 475104 475898 476113 476263 478087 478782 479476 482257 483471 483560 483761 484124 484612 484636 484649 484977 487260 490012 490657 492048 494329 496729 501785 502000 502092 502851 506825 507265 508121 509481 511228 511577 511751 512014 513768 516635 516924 520123 520895 521595 521943 521975 522211 523377 523934 523982 526121 529482 533703 533974 546015 546966 548740 550613 551269 557677 558133 558209 560590 560597 564078 564366 565414 568717 569329 571256 574823 575509 598559 648657 654312 742286 775834 813260 ] |
||||||||||||||||||||||||||||||
|
24.44 ms (15.03%) |
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 463903 474482 506825 529482 209373 509481 560597 526121 558209 478782 483560 511577 447843 470641 501785 487260 484124 411898 460958 475898 548740 813260 394579 490657 648657 452618 470389 472792 466270 502092 511228 391941 546966 516635 394453 476263 565414 454214 482257 435064 411047 428382 512014 520895 507265 464513 474791 521975 520123 511751 502851 551269 775834 523377 484977 575509 472341 483761 571256 564366 492048 496729 522211 598559 516924 574823 385077 568717 411333 420601 443813 410935 484636 550613 569329 478087 476113 508121 465330 502000 513768 533703 470567 428770 420375 521943 523934 490012 533974 654312 428409 557677 742286 391702 411726 484612 521595 558133 474488 386460 523982 469915 463162 475104 454183 459671 466056 484649 483471 454552 464732 473788 474642 465963 494329 465378 479476 546015 564078 560590 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.66%) |
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 209373 385077 386460 391702 391941 394453 394579 410935 411047 411333 411726 411898 420375 420601 428382 428409 428770 435064 443813 447843 452618 454183 454214 454552 459671 460958 463162 463903 464513 464732 465330 465378 465963 466056 466270 469915 470389 470567 470641 472341 472792 473788 474482 474488 474642 474791 475104 475898 476113 476263 478087 478782 479476 482257 483471 483560 483761 484124 484612 484636 484649 484977 487260 490012 490657 492048 494329 496729 501785 502000 502092 502851 506825 507265 508121 509481 511228 511577 511751 512014 513768 516635 516924 520123 520895 521595 521943 521975 522211 523377 523934 523982 526121 529482 533703 533974 546015 546966 548740 550613 551269 557677 558133 558209 560590 560597 564078 564366 565414 568717 569329 571256 574823 575509 598559 648657 654312 742286 775834 813260 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в два члена русское"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в два член русск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в два член русск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
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.