Query Metrics
7
Database Queries
7
Different statements
165.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.13 ms (84.73%) |
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 341802 382681 384117 398651 398869 407683 439365 452567 452914 458867 463751 468697 468712 468750 471769 473183 474599 474670 476718 476725 476900 477055 479010 486192 488909 495437 496049 505387 506066 506067 511270 514879 515065 515968 523761 525052 526273 527386 527926 531303 531787 531869 531888 534441 534533 535277 535962 537971 538879 545222 548460 550890 552329 552603 554831 555389 558098 558247 558519 558717 561012 562706 565134 567673 568381 568477 568485 568525 574646 577678 579210 581582 584291 585080 586668 587951 592384 592396 593599 594267 595435 598539 598651 600248 602233 603772 604356 604815 608662 613494 614923 617681 620647 620920 640975 641190 656173 657112 657505 657543 660441 662022 664166 666898 677147 687583 700306 709688 713885 742351 751563 755821 783056 784849 786879 789849 798705 811709 814394 814423 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (8.60%) |
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 561012 614923 515968 602233 604356 603772 594267 755821 617681 479010 471769 595435 398651 525052 531787 534533 656173 784849 798705 789849 558717 506067 598539 548460 592396 468712 496049 506066 526273 568477 687583 562706 593599 814423 567673 568485 398869 545222 662022 666898 515065 535277 558247 577678 534441 554831 452914 527386 476900 558098 700306 657505 660441 742351 382681 486192 535962 476725 598651 620920 495437 511270 552329 600248 613494 514879 538879 531888 531869 477055 657543 664166 558519 565134 641190 586668 640975 811709 439365 474599 468697 531303 552603 568525 568381 581582 592384 604815 384117 585080 574646 783056 341802 476718 473183 488909 474670 537971 527926 579210 587951 608662 458867 407683 452567 523761 620647 786879 751563 550890 657112 814394 468750 463751 505387 555389 584291 677147 709688 713885 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (2.46%) |
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 341802 382681 384117 398651 398869 407683 439365 452567 452914 458867 463751 468697 468712 468750 471769 473183 474599 474670 476718 476725 476900 477055 479010 486192 488909 495437 496049 505387 506066 506067 511270 514879 515065 515968 523761 525052 526273 527386 527926 531303 531787 531869 531888 534441 534533 535277 535962 537971 538879 545222 548460 550890 552329 552603 554831 555389 558098 558247 558519 558717 561012 562706 565134 567673 568381 568477 568485 568525 574646 577678 579210 581582 584291 585080 586668 587951 592384 592396 593599 594267 595435 598539 598651 600248 602233 603772 604356 604815 608662 613494 614923 617681 620647 620920 640975 641190 656173 657112 657505 657543 660441 662022 664166 666898 677147 687583 700306 709688 713885 742351 751563 755821 783056 784849 786879 789849 798705 811709 814394 814423 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пробка в жопе"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пробк анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пробк анал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
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.