Query Metrics
7
Database Queries
7
Different statements
187.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.91 ms (85.12%) |
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 42536 154187 387996 424294 441120 441849 442511 443198 445397 445745 446533 448795 450572 450697 451022 457483 459203 460533 461704 466475 467715 468823 468946 469220 477149 481904 482190 483738 488713 488820 493730 495737 505387 510532 510812 517272 517928 525603 526179 526504 527926 534567 534586 536091 540680 540924 543941 546171 547467 548157 548445 550550 550659 550807 550890 552819 553789 554997 555026 556339 556888 556902 556909 558158 560570 562575 568252 568254 576444 576552 576848 578003 578308 584362 585251 590255 592362 593230 597160 609071 610280 618297 619322 626044 628604 630382 634317 634734 634735 653602 665796 666053 679173 704167 704641 705005 710545 713505 722385 725755 733734 734276 735136 745681 752541 758164 780650 792272 792734 794305 794323 796833 796843 796849 797284 800279 800289 802347 803542 803576 ] |
||||||||||||||||||||||||||||||
|
17.29 ms (9.21%) |
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 536091 543941 560570 568252 550659 553789 568254 556902 710545 722385 546171 630382 794323 733734 734276 796849 725755 735136 794305 556909 460533 578308 441120 610280 448795 488713 534567 547467 445745 510532 467715 459203 42536 540924 550807 550890 576552 618297 634734 797284 800289 800279 802347 803576 745681 752541 792272 792734 803542 653602 666053 679173 634317 634735 704167 443198 424294 442511 451022 446533 457483 468823 468946 483738 540680 526504 534586 505387 525603 526179 495737 527926 548445 552819 555026 556339 556888 548157 550550 558158 578003 576444 584362 705005 665796 713505 554997 576848 597160 593230 609071 619322 592362 626044 780650 796843 796833 758164 628604 445397 469220 466475 477149 441849 450572 450697 493730 517272 488820 387996 562575 482190 510812 585251 461704 154187 704641 481904 517928 590255 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.79%) |
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 42536 154187 387996 424294 441120 441849 442511 443198 445397 445745 446533 448795 450572 450697 451022 457483 459203 460533 461704 466475 467715 468823 468946 469220 477149 481904 482190 483738 488713 488820 493730 495737 505387 510532 510812 517272 517928 525603 526179 526504 527926 534567 534586 536091 540680 540924 543941 546171 547467 548157 548445 550550 550659 550807 550890 552819 553789 554997 555026 556339 556888 556902 556909 558158 560570 562575 568252 568254 576444 576552 576848 578003 578308 584362 585251 590255 592362 593230 597160 609071 610280 618297 619322 626044 628604 630382 634317 634734 634735 653602 665796 666053 679173 704167 704641 705005 710545 713505 722385 725755 733734 734276 735136 745681 752541 758164 780650 792272 792734 794305 794323 796833 796843 796849 797284 800279 800289 802347 803542 803576 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг жен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting wife amateur"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
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.