Query Metrics
7
Database Queries
7
Different statements
159.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.11 ms (81.82%) |
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 411998 415539 418363 418596 419061 419758 423329 430700 434322 440625 440824 445471 447810 447896 448832 455217 463842 469738 476797 502043 503405 510396 512928 512975 513572 523027 524696 531097 531155 532651 532676 532791 532812 532847 533013 533920 533978 537760 537863 541832 543868 546110 547434 550397 555291 560949 564551 566855 578823 580035 580107 582323 582540 583913 583982 591959 597204 599976 600297 600355 601613 603258 613146 614858 619703 620794 623262 625696 632571 632617 632659 632663 633123 635275 636295 637044 639745 645861 647859 647994 648853 649596 650305 651631 666586 666850 666853 666906 668534 674986 676623 676632 678153 683261 688108 699397 702677 711283 716160 735546 736674 748504 752597 752647 758097 765218 770102 770242 777533 789469 794824 803455 804464 808341 815017 815849 818327 824035 827326 ] |
||||||||||||||||||||||||||||||
|
19.44 ms (12.23%) |
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 582323 580035 683261 600355 619703 620794 804464 419758 418596 434322 445471 649596 597204 632571 419061 469738 668534 637044 632659 639745 523027 808341 824035 765218 541832 533978 512928 543868 418363 411998 550397 735546 532847 503405 531097 688108 651631 702677 711283 648853 599976 636295 601613 614858 632663 440824 815017 455217 512975 532676 566855 647994 674986 666853 676632 666586 676623 632617 613146 448832 770242 537863 398426 583913 699397 580107 633123 463842 827326 770102 447810 600297 803455 758097 447896 532651 647859 582540 625696 547434 752647 815849 748504 531155 532812 502043 560949 513572 510396 532791 678153 603258 476797 537760 524696 645861 591959 794824 789469 650305 736674 415539 666906 533920 818327 546110 440625 578823 583982 623262 430700 716160 564551 555291 752597 635275 533013 666850 777533 423329 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.61%) |
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 411998 415539 418363 418596 419061 419758 423329 430700 434322 440625 440824 445471 447810 447896 448832 455217 463842 469738 476797 502043 503405 510396 512928 512975 513572 523027 524696 531097 531155 532651 532676 532791 532812 532847 533013 533920 533978 537760 537863 541832 543868 546110 547434 550397 555291 560949 564551 566855 578823 580035 580107 582323 582540 583913 583982 591959 597204 599976 600297 600355 601613 603258 613146 614858 619703 620794 623262 625696 632571 632617 632659 632663 633123 635275 636295 637044 639745 645861 647859 647994 648853 649596 650305 651631 666586 666850 666853 666906 668534 674986 676623 676632 678153 683261 688108 699397 702677 711283 716160 735546 736674 748504 752597 752647 758097 765218 770102 770242 777533 789469 794824 803455 804464 808341 815017 815849 818327 824035 827326 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal squirt mature"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал сквирт оргазм mature"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал сквирт оргазм mature"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.88%) |
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.