Query Metrics
7
Database Queries
7
Different statements
163.92 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.92 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.19 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фистинг дом"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.03 ms |
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 619291 618242 627512 512940 634095 591604 428257 547467 445745 447315 448795 488713 817007 474246 533596 536091 543941 560570 568252 550659 553789 568254 548444 556902 710545 711725 722385 546171 630382 794323 733734 734276 796849 725755 745178 756749 735136 788506 794305 801933 467715 443198 424294 442511 446533 457483 483738 540680 526504 534586 505387 525603 526179 495737 527926 552819 555026 556339 556888 556900 548157 550550 558158 578003 583665 576444 705005 713195 665796 548692 554997 592650 597160 593230 609071 592362 626044 597534 780650 796843 751428 796833 758164 628604 466475 477149 441849 450572 455010 478508 450697 505661 493730 517272 488820 414292 653602 666053 679173 634317 634735 415978 481904 517928 590255 624925 455006 540924 550807 550890 576552 580062 618297 634734 797284 800289 797285 800279 802347 803576 ] |
||||||||||||||||||||||||||||||
| 4 | 2.42 ms |
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 414292 415978 424294 428257 441849 442511 443198 445745 446533 447315 448795 450572 450697 455006 455010 457483 466475 467715 474246 477149 478508 481904 483738 488713 488820 493730 495737 505387 505661 512940 517272 517928 525603 526179 526504 527926 533596 534586 536091 540680 540924 543941 546171 547467 548157 548444 548692 550550 550659 550807 550890 552819 553789 554997 555026 556339 556888 556900 556902 558158 560570 568252 568254 576444 576552 578003 580062 583665 590255 591604 592362 592650 593230 597160 597534 609071 618242 618297 619291 624925 626044 627512 628604 630382 634095 634317 634734 634735 653602 665796 666053 679173 705005 710545 711725 713195 722385 725755 733734 734276 735136 745178 751428 756749 758164 780650 788506 794305 794323 796833 796843 796849 797284 797285 800279 800289 801933 802347 803576 817007 ] |
||||||||||||||||||||||||||||||
| 5 | 139.67 ms |
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 414292 415978 424294 428257 441849 442511 443198 445745 446533 447315 448795 450572 450697 455006 455010 457483 466475 467715 474246 477149 478508 481904 483738 488713 488820 493730 495737 505387 505661 512940 517272 517928 525603 526179 526504 527926 533596 534586 536091 540680 540924 543941 546171 547467 548157 548444 548692 550550 550659 550807 550890 552819 553789 554997 555026 556339 556888 556900 556902 558158 560570 568252 568254 576444 576552 578003 580062 583665 590255 591604 592362 592650 593230 597160 597534 609071 618242 618297 619291 624925 626044 627512 628604 630382 634095 634317 634734 634735 653602 665796 666053 679173 705005 710545 711725 713195 722385 725755 733734 734276 735136 745178 751428 756749 758164 780650 788506 794305 794323 796833 796843 796849 797284 797285 800279 800289 801933 802347 803576 817007 ] |
||||||||||||||||||||||||||||||
| 6 | 2.31 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг домашн любительск"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.39 ms |
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.