Query Metrics
7
Database Queries
7
Different statements
185.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.07 ms (82.05%) |
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 398426 413373 416098 417889 418596 419061 419758 439543 440824 443112 445471 447896 448832 452977 455217 462113 467868 468754 469738 477483 500929 503405 507376 510395 512928 514709 518108 521738 523027 526887 527405 527755 530272 530624 531097 532651 532676 532847 533697 533978 534215 534312 535358 535620 536288 541832 543868 550124 550203 566774 566855 569309 580035 582323 582540 583913 589543 599836 599976 599994 600355 601613 603286 609085 613146 617976 619703 620794 625696 629828 632571 632617 632659 632663 633780 634487 636295 636303 636321 637044 639745 639802 640800 641455 643380 647859 647885 647939 647994 648853 649596 650155 650476 651631 660397 660410 666586 666853 668534 669706 674986 676623 676632 683261 688108 699397 702677 708195 710868 711283 735546 750701 767726 772472 792576 801960 804464 805914 814031 815017 ] |
||||||||||||||||||||||||||||||
|
21.16 ms (11.42%) |
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 535620 550124 569309 647885 589543 636321 639802 641455 801960 792576 750701 462113 541832 417889 514709 536288 527755 550203 650476 660410 634487 467868 468754 510395 609085 534215 413373 530624 535358 533697 636303 640800 599994 452977 443112 521738 419758 416098 518108 477483 815017 469738 455217 530272 580035 647994 668534 676632 683261 676623 632617 613146 637044 620794 632659 804464 418596 439543 523027 566774 669706 639745 617976 767726 527405 532676 507376 566855 674986 666586 633780 600355 448832 772472 660397 445471 643380 447896 534312 699397 647859 805914 419061 814031 582323 666853 647939 599836 619703 398426 532847 533978 503405 532651 543868 711283 625696 650155 500929 583913 651631 648853 582540 599976 603286 601613 632571 632663 440824 526887 710868 512928 531097 702677 636295 735546 708195 629828 688108 649596 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (2.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
2.89 ms (1.56%) |
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 398426 413373 416098 417889 418596 419061 419758 439543 440824 443112 445471 447896 448832 452977 455217 462113 467868 468754 469738 477483 500929 503405 507376 510395 512928 514709 518108 521738 523027 526887 527405 527755 530272 530624 531097 532651 532676 532847 533697 533978 534215 534312 535358 535620 536288 541832 543868 550124 550203 566774 566855 569309 580035 582323 582540 583913 589543 599836 599976 599994 600355 601613 603286 609085 613146 617976 619703 620794 625696 629828 632571 632617 632659 632663 633780 634487 636295 636303 636321 637044 639745 639802 640800 641455 643380 647859 647885 647939 647994 648853 649596 650155 650476 651631 660397 660410 666586 666853 668534 669706 674986 676623 676632 683261 688108 699397 702677 708195 710868 711283 735546 750701 767726 772472 792576 801960 804464 805914 814031 815017 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big squirt"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.