Query Metrics
7
Database Queries
7
Different statements
219.43 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.51 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.93 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс в отели"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.76 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 324916 404608 517479 399747 541134 553831 695415 592962 630016 751508 411883 446898 472581 583336 592735 468788 429652 496993 482030 525819 652498 773267 735750 4349 13954 424757 518904 581484 779804 801540 796968 784081 750140 768822 771716 799387 460703 479418 8619 504465 594760 3727 559907 701221 708718 775508 778784 499743 489102 722678 680542 684503 714845 547101 588483 595142 792191 795492 801537 797682 772758 504210 443025 395404 545494 391062 417452 482522 504898 491643 508407 358778 418564 474435 521257 521770 552662 444241 492816 689169 396605 507158 805056 636351 785679 718456 580881 668012 772000 554614 418575 473752 540668 802757 812785 799874 476633 426272 697221 707608 657458 798762 732984 467174 545453 641463 472073 515586 444650 511129 695773 718786 595478 761895 773429 771490 397759 12792 443579 452532 ] |
||||||||||||||||||||||||||||||
| 4 | 3.35 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 3727 4349 8619 12792 13954 324916 358778 391062 395404 396605 397759 399747 404608 411883 417452 418564 418575 424757 426272 429652 443025 443579 444241 444650 446898 452532 460703 467174 468788 472073 472581 473752 474435 476633 479418 482030 482522 489102 491643 492816 496993 499743 504210 504465 504898 507158 508407 511129 515586 517479 518904 521257 521770 525819 540668 541134 545453 545494 547101 552662 553831 554614 559907 580881 581484 583336 588483 592735 592962 594760 595142 595478 630016 636351 641463 652498 657458 668012 680542 684503 689169 695415 695773 697221 701221 707608 708718 714845 718456 718786 722678 732984 735750 750140 751508 761895 768822 771490 771716 772000 772758 773267 775508 778784 779804 784081 785679 792191 795492 796968 797682 798762 799387 799874 801537 801540 802757 805056 812785 ] |
||||||||||||||||||||||||||||||
| 5 | 192.28 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 3727 4349 8619 12792 13954 324916 358778 391062 395404 396605 397759 399747 404608 411883 417452 418564 418575 424757 426272 429652 443025 443579 444241 444650 446898 452532 460703 467174 468788 472073 472581 473752 474435 476633 479418 482030 482522 489102 491643 492816 496993 499743 504210 504465 504898 507158 508407 511129 515586 517479 518904 521257 521770 525819 540668 541134 545453 545494 547101 552662 553831 554614 559907 580881 581484 583336 588483 592735 592962 594760 595142 595478 630016 636351 641463 652498 657458 668012 680542 684503 689169 695415 695773 697221 701221 707608 708718 714845 718456 718786 722678 732984 735750 750140 751508 761895 768822 771490 771716 772000 772758 773267 775508 778784 779804 784081 785679 792191 795492 796968 797682 798762 799387 799874 801537 801540 802757 805056 812785 ] |
||||||||||||||||||||||||||||||
| 6 | 1.82 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в отел"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.78 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.