Query Metrics
7
Database Queries
7
Different statements
189.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.47 ms (86.99%) |
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 73052 410295 411867 433963 435880 441907 455570 462712 463784 463824 487008 494865 506904 514731 516718 533934 534475 534622 537780 541428 542911 544959 552408 552502 562747 565016 567588 568259 573274 577019 578731 579344 584053 585284 586107 591527 603310 604639 609506 610374 614844 623157 624204 629733 631625 632843 636487 636488 639236 642979 644129 661375 672217 675444 680819 681237 681359 692751 695477 695543 696484 703021 706624 709217 709912 715286 716103 738058 738375 738481 743490 743991 744035 745469 750454 750951 751528 752495 755489 755496 757199 758791 760067 767351 772650 773724 776141 778529 779297 782457 782539 782571 782999 783204 785466 785883 786662 786912 787851 790648 791020 797048 797077 797082 797825 798805 802255 804198 804652 804696 806623 807050 807190 807569 808144 808411 809606 811802 817226 827723 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (7.39%) |
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 584053 463824 696484 494865 537780 675444 680819 516718 579344 624204 410295 533934 552408 552502 681237 716103 573274 623157 776141 785883 797825 411867 433963 435880 441907 455570 514731 463784 534622 542911 672217 692751 604639 752495 809606 487008 603310 791020 506904 738058 73052 817226 827723 462712 534475 541428 565016 577019 544959 562747 661375 695543 715286 709912 681359 695477 567588 568259 578731 585284 586107 591527 631625 632843 642979 644129 610374 629733 636488 639236 609506 636487 778529 779297 782999 786662 786912 787851 802255 807569 785466 797082 804198 804652 743490 750951 758791 772650 782539 783204 790648 797048 797077 798805 804696 806623 807050 807190 808144 808411 811802 767351 738375 745469 750454 755496 757199 738481 743991 744035 751528 755489 760067 773724 614844 703021 706624 709217 782457 782571 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.42%) |
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 73052 410295 411867 433963 435880 441907 455570 462712 463784 463824 487008 494865 506904 514731 516718 533934 534475 534622 537780 541428 542911 544959 552408 552502 562747 565016 567588 568259 573274 577019 578731 579344 584053 585284 586107 591527 603310 604639 609506 610374 614844 623157 624204 629733 631625 632843 636487 636488 639236 642979 644129 661375 672217 675444 680819 681237 681359 692751 695477 695543 696484 703021 706624 709217 709912 715286 716103 738058 738375 738481 743490 743991 744035 745469 750454 750951 751528 752495 755489 755496 757199 758791 760067 767351 772650 773724 776141 778529 779297 782457 782539 782571 782999 783204 785466 785883 786662 786912 787851 790648 791020 797048 797077 797082 797825 798805 802255 804198 804652 804696 806623 807050 807190 807569 808144 808411 809606 811802 817226 827723 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties pussy solo"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел pussy соло"
]
|
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.