Query Metrics
7
Database Queries
7
Different statements
285.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
251.50 ms (88.03%) |
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 87974 89199 382670 391563 397986 403896 408911 414050 415303 416531 416561 416669 416690 416725 420295 421993 423995 427128 432824 432945 432974 443317 444490 446022 446446 448115 449970 462840 467560 470412 471129 475920 476674 477502 483738 486772 499872 500333 505093 514257 516640 524215 527922 529296 529632 529696 531352 531578 531582 531879 531891 534443 535963 540680 545404 545438 576848 592574 600958 602281 607683 616454 619286 619322 626044 634750 640262 642149 653028 687347 735703 738461 738501 738515 739119 739124 739158 740523 744047 745874 749090 749215 749264 750992 751609 752648 752679 752753 753635 758163 760598 766266 766941 770261 770814 782854 784066 784217 784310 785816 785979 788863 788899 789436 792706 793151 795404 795420 796333 796647 796703 798599 799759 804939 806924 811570 811723 813487 827287 827395 ] |
||||||||||||||||||||||||||||||
|
24.39 ms (8.54%) |
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 616454 795404 796703 798599 782854 793151 795420 796333 796647 749090 770814 739119 752679 735703 751609 745874 752648 788863 87974 414050 382670 444490 499872 524215 446446 827287 486772 475920 529296 529696 529632 535963 531582 531879 531891 534443 653028 687347 642149 607683 634750 640262 784217 785816 799759 784310 806924 813487 738501 740523 749215 760598 804939 811723 739124 758163 766941 766266 738461 738515 739158 753635 602281 784066 785979 789436 792706 811570 391563 788899 416531 408911 416690 448115 514257 545438 600958 592574 744047 749264 752753 770261 827395 750992 415303 416561 416725 423995 416669 476674 527922 619286 446022 467560 531352 89199 397986 470412 545404 462840 403896 443317 427128 432945 449970 477502 483738 540680 500333 516640 531578 505093 576848 619322 626044 432824 432974 471129 421993 420295 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.19%) |
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 87974 89199 382670 391563 397986 403896 408911 414050 415303 416531 416561 416669 416690 416725 420295 421993 423995 427128 432824 432945 432974 443317 444490 446022 446446 448115 449970 462840 467560 470412 471129 475920 476674 477502 483738 486772 499872 500333 505093 514257 516640 524215 527922 529296 529632 529696 531352 531578 531582 531879 531891 534443 535963 540680 545404 545438 576848 592574 600958 602281 607683 616454 619286 619322 626044 634750 640262 642149 653028 687347 735703 738461 738501 738515 739119 739124 739158 740523 744047 745874 749090 749215 749264 750992 751609 752648 752679 752753 753635 758163 760598 766266 766941 770261 770814 782854 784066 784217 784310 785816 785979 788863 788899 789436 792706 793151 795404 795420 796333 796647 796703 798599 799759 804939 806924 811570 811723 813487 827287 827395 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam huge dildo"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.