Query Metrics
7
Database Queries
7
Different statements
177.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.52 ms (83.26%) |
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 13258 130089 131497 157194 187717 191398 312264 382502 385970 386746 386813 391070 394514 395661 396723 399628 399688 400847 401144 402673 404706 406086 407809 408238 409016 409573 410088 415151 416697 421571 422353 424013 424234 424259 425993 427202 428889 435747 440745 443168 444437 444524 444610 445468 447516 448542 450818 451877 457441 458438 458930 462005 463743 463842 464132 466025 467592 467960 468462 470167 472525 475088 476323 478408 482314 485084 485870 488746 491612 496565 497005 505132 506863 508750 514833 517069 523834 523835 523838 523867 526527 526828 535828 537912 538567 540366 549027 559166 559737 563175 587185 590620 593343 601599 604674 614738 617422 634209 634794 638565 673142 706611 708422 709942 755845 756242 759706 769990 770901 797768 801899 815179 815487 815616 816502 816576 817781 818165 819534 821577 ] |
||||||||||||||||||||||||||||||
|
18.73 ms (10.57%) |
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 409573 517069 523835 549027 505132 617422 614738 396723 815616 816576 819534 815179 815487 816502 540366 535828 638565 801899 755845 759706 709942 424234 467960 634794 422353 538567 402673 391070 400847 818165 458930 191398 443168 410088 448542 590620 157194 424013 428889 466025 464132 386746 427202 408238 416697 425993 444524 440745 463743 478408 450818 472525 482314 488746 497005 537912 604674 770901 406086 462005 470167 475088 382502 444610 131497 415151 13258 468462 523867 485870 491612 523838 485084 523834 526527 476323 395661 467592 563175 424259 457441 506863 526828 821577 797768 394514 312264 399628 404706 435747 444437 817781 445468 508750 559737 706611 673142 708422 601599 634209 769990 756242 401144 421571 130089 409016 514833 587185 593343 463842 451877 386813 187717 407809 447516 458438 496565 559166 385970 399688 ] |
||||||||||||||||||||||||||||||
|
2.76 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 13258 130089 131497 157194 187717 191398 312264 382502 385970 386746 386813 391070 394514 395661 396723 399628 399688 400847 401144 402673 404706 406086 407809 408238 409016 409573 410088 415151 416697 421571 422353 424013 424234 424259 425993 427202 428889 435747 440745 443168 444437 444524 444610 445468 447516 448542 450818 451877 457441 458438 458930 462005 463743 463842 464132 466025 467592 467960 468462 470167 472525 475088 476323 478408 482314 485084 485870 488746 491612 496565 497005 505132 506863 508750 514833 517069 523834 523835 523838 523867 526527 526828 535828 537912 538567 540366 549027 559166 559737 563175 587185 590620 593343 601599 604674 614738 617422 634209 634794 638565 673142 706611 708422 709942 755845 756242 759706 769990 770901 797768 801899 815179 815487 815616 816502 816576 817781 818165 819534 821577 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde anal milf"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая анал milf"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
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.