Query Metrics
7
Database Queries
7
Different statements
361.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.44 ms (57.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл hot"
]
|
||||||||||||||||||||||||||||||
|
129.14 ms (35.74%) |
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 38261 154692 165669 185950 187709 391559 411809 414004 415177 416277 420834 426052 426475 430347 435225 441695 443650 444522 445930 450548 452844 453381 453905 458007 463430 464107 464185 473467 475280 475756 476646 476697 476981 483564 484553 486939 496441 499486 505318 507779 507833 513910 515457 517814 518427 520735 521918 527380 530001 531707 532313 532326 540637 550677 551287 552444 554642 555082 562881 565242 579236 581724 583574 589229 589478 591658 594165 601147 603001 605581 606251 613646 618404 630394 631325 642940 643895 663540 665840 669207 673772 685967 689591 710506 717144 730046 737553 739155 740346 746662 749237 750702 751433 756986 760530 761580 763563 764161 765952 770544 775295 777573 780268 788589 797720 801757 803595 804303 807611 811663 813767 814352 814503 814809 815773 815829 816363 817173 818273 826475 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (4.29%) |
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 154692 435225 475280 603001 552444 391559 165669 416277 483564 450548 513910 669207 414004 441695 476981 415177 813767 826475 463430 507779 550677 579236 665840 606251 613646 591658 589229 589478 775295 803595 737553 788589 811663 756986 765952 730046 750702 746662 763563 642940 710506 717144 780268 801757 601147 551287 187709 426475 814352 814503 815773 453381 475756 527380 532313 555082 583574 554642 565242 581724 663540 685967 673772 689591 562881 630394 618404 594165 605581 777573 804303 740346 807611 761580 760530 764161 739155 749237 751433 770544 631325 797720 420834 521918 484553 473467 505318 458007 464185 530001 643895 185950 38261 426052 430347 443650 411809 444522 814809 815829 816363 817173 818273 452844 476697 445930 453905 464107 476646 486939 499486 515457 531707 532326 496441 520735 507833 517814 518427 540637 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (0.63%) |
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 38261 154692 165669 185950 187709 391559 411809 414004 415177 416277 420834 426052 426475 430347 435225 441695 443650 444522 445930 450548 452844 453381 453905 458007 463430 464107 464185 473467 475280 475756 476646 476697 476981 483564 484553 486939 496441 499486 505318 507779 507833 513910 515457 517814 518427 520735 521918 527380 530001 531707 532313 532326 540637 550677 551287 552444 554642 555082 562881 565242 579236 581724 583574 589229 589478 591658 594165 601147 603001 605581 606251 613646 618404 630394 631325 642940 643895 663540 665840 669207 673772 685967 689591 710506 717144 730046 737553 739155 740346 746662 749237 750702 751433 756986 760530 761580 763563 764161 765952 770544 775295 777573 780268 788589 797720 801757 803595 804303 807611 811663 813767 814352 814503 814809 815773 815829 816363 817173 818273 826475 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"масл hot"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil hot"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.44%) |
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.