Query Metrics
7
Database Queries
7
Different statements
159.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.75 ms (81.32%) |
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 448924 468010 468586 469595 473216 473541 475660 477581 477587 478301 481615 485279 488751 489424 495066 495647 496802 499789 500600 505504 507296 511368 513882 519171 521412 523860 524534 525248 526853 527198 529198 529405 530024 530382 530832 531106 531187 531436 533557 538023 538360 541661 541919 543456 543844 543860 545382 545615 546201 546800 550315 553494 555509 555789 558027 558217 565038 565153 565172 568347 568502 568561 577409 581320 581712 582012 583507 584740 590155 591618 593373 593835 594899 596054 597227 598118 598249 599414 600880 601324 602935 602939 604483 612335 612439 613463 622714 624142 624221 624832 625244 625526 628126 628383 630193 632006 632314 632563 633423 634212 642766 647355 649838 649893 653870 660710 663789 667646 667695 672713 673965 677784 678522 680183 680193 680709 680859 682909 684343 691221 ] |
||||||||||||||||||||||||||||||
|
19.66 ms (12.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 495066 511368 477581 543456 581712 672713 680709 598249 477587 499789 481615 568561 448924 663789 500600 525248 602935 582012 691221 590155 612439 594899 558027 568347 568502 680859 680193 591618 599414 600880 684343 553494 581320 624142 478301 546800 649838 524534 667695 667646 541919 473216 565038 473541 682909 604483 597227 598118 624221 485279 523860 531436 507296 555509 584740 558217 632314 625244 624832 660710 546201 593835 625526 622714 673965 521412 529405 538023 529198 612335 496802 531106 545615 634212 488751 495647 632006 593373 468586 468010 545382 577409 680183 630193 649893 613463 527198 647355 565172 505504 519171 526853 530832 538360 513882 602939 550315 541661 489424 469595 565153 653870 633423 583507 543860 543844 530024 531187 678522 628383 677784 555789 628126 642766 530382 601324 596054 632563 533557 475660 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.07%) |
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 448924 468010 468586 469595 473216 473541 475660 477581 477587 478301 481615 485279 488751 489424 495066 495647 496802 499789 500600 505504 507296 511368 513882 519171 521412 523860 524534 525248 526853 527198 529198 529405 530024 530382 530832 531106 531187 531436 533557 538023 538360 541661 541919 543456 543844 543860 545382 545615 546201 546800 550315 553494 555509 555789 558027 558217 565038 565153 565172 568347 568502 568561 577409 581320 581712 582012 583507 584740 590155 591618 593373 593835 594899 596054 597227 598118 598249 599414 600880 601324 602935 602939 604483 612335 612439 613463 622714 624142 624221 624832 625244 625526 628126 628383 630193 632006 632314 632563 633423 634212 642766 647355 649838 649893 653870 660710 663789 667646 667695 672713 673965 677784 678522 680183 680193 680709 680859 682909 684343 691221 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на весу её"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на вес"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.94%) |
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.