Query Metrics
7
Database Queries
7
Different statements
398.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
367.79 ms (92.24%) |
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 250457 381835 389729 396316 397861 401005 414953 416876 417438 418224 420060 428884 429291 429353 429492 430215 431481 431511 432703 432716 435732 449501 449853 450857 451815 453197 453703 453776 453783 454863 454989 457976 458009 458167 459049 460551 461095 461901 462073 465276 467379 471075 474369 474984 477065 477788 480511 485635 486008 486542 502702 511172 512062 517909 519782 524280 533939 533998 545659 546119 546127 546713 550216 552757 555176 558001 558272 559524 559791 560608 561942 563196 563428 563887 563890 565158 565177 566327 567689 568122 569559 574417 582801 585942 587989 588677 589281 598688 600854 604101 617304 618761 623147 625594 637400 650453 665342 667560 678766 693396 713853 718547 719279 721580 725584 730934 731464 740129 743809 747481 748892 756614 772775 781721 790365 796148 798680 803461 808603 810102 ] |
||||||||||||||||||||||||||||||
|
20.42 ms (5.12%) |
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 432716 429492 435732 429291 453776 458009 461095 486008 449853 453197 453783 462073 465276 480511 454989 458167 467379 533939 517909 558272 546127 563428 565177 561942 718547 721580 650453 665342 678766 693396 719279 667560 713853 550216 598688 617304 588677 600854 623147 587989 589281 618761 781721 790365 772775 796148 810102 730934 740129 747481 748892 725584 743809 756614 432703 453703 457976 250457 416876 429353 459049 454863 418224 461901 460551 512062 511172 519782 485635 524280 563887 381835 396316 401005 430215 431481 431511 417438 420060 414953 450857 451815 474984 474369 449501 486542 502702 533998 477065 477788 546713 563890 565158 545659 546119 559791 563196 568122 574417 558001 560608 567689 569559 552757 555176 559524 566327 582801 585942 637400 604101 625594 798680 808603 803461 731464 389729 397861 428884 471075 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (0.75%) |
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 250457 381835 389729 396316 397861 401005 414953 416876 417438 418224 420060 428884 429291 429353 429492 430215 431481 431511 432703 432716 435732 449501 449853 450857 451815 453197 453703 453776 453783 454863 454989 457976 458009 458167 459049 460551 461095 461901 462073 465276 467379 471075 474369 474984 477065 477788 480511 485635 486008 486542 502702 511172 512062 517909 519782 524280 533939 533998 545659 546119 546127 546713 550216 552757 555176 558001 558272 559524 559791 560608 561942 563196 563428 563887 563890 565158 565177 566327 567689 568122 569559 574417 582801 585942 587989 588677 589281 598688 600854 604101 617304 618761 623147 625594 637400 650453 665342 667560 678766 693396 713853 718547 719279 721580 725584 730934 731464 740129 743809 747481 748892 756614 772775 781721 790365 796148 798680 803461 808603 810102 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy sleep"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен спящ"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.40%) |
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.