Query Metrics
7
Database Queries
7
Different statements
172.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.17 ms (82.50%) |
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 415539 417482 418363 427174 428103 442673 445471 447810 447885 452895 452953 462379 468098 482283 483542 493587 508150 510396 524535 529794 530369 530694 531097 531251 532651 532791 532812 534215 534386 534994 536648 537204 542595 544825 545355 545437 550298 566855 570704 573411 577435 582323 582540 583982 591680 595209 597216 599836 599940 599988 600297 600355 601535 610577 613146 630536 630550 632571 632617 632659 632663 632706 633123 633458 633502 634784 635275 636294 636295 637003 639716 639745 639791 639798 639816 640772 640793 641955 642044 644913 647859 647893 648825 648853 649546 649596 650155 651631 656568 666525 666535 666850 666853 666883 666895 674953 675000 675008 675010 676026 676112 676623 676638 676641 679774 682986 685714 711283 715790 719333 724410 735654 746235 751589 794824 803455 804464 811497 827326 ] |
||||||||||||||||||||||||||||||
|
20.17 ms (11.71%) |
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 566855 582323 656568 674953 666853 676112 719333 648825 666883 676623 685714 610577 632617 599836 613146 600355 640772 811497 601535 632659 633458 804464 417482 715790 735654 452895 483542 537204 531251 524535 531097 532651 544825 550298 666535 649596 651631 676026 711283 647859 648853 676641 582540 636294 640793 633123 636295 632571 632663 418363 682986 415539 644913 447810 452953 510396 534215 532791 570704 666895 676638 649546 630550 639798 600297 639716 803455 634784 588719 595209 746235 428103 530694 532812 675010 650155 675000 679774 583982 642044 637003 639745 632706 445471 827326 639791 794824 534994 666850 675008 545355 597216 630536 633502 724410 530369 635275 599988 427174 462379 573411 577435 534386 493587 639816 751589 482283 599940 508150 542595 447885 468098 641955 442673 536648 666525 591680 545437 529794 647893 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.90%) |
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 415539 417482 418363 427174 428103 442673 445471 447810 447885 452895 452953 462379 468098 482283 483542 493587 508150 510396 524535 529794 530369 530694 531097 531251 532651 532791 532812 534215 534386 534994 536648 537204 542595 544825 545355 545437 550298 566855 570704 573411 577435 582323 582540 583982 591680 595209 597216 599836 599940 599988 600297 600355 601535 610577 613146 630536 630550 632571 632617 632659 632663 632706 633123 633458 633502 634784 635275 636294 636295 637003 639716 639745 639791 639798 639816 640772 640793 641955 642044 644913 647859 647893 648825 648853 649546 649596 650155 651631 656568 666525 666535 666850 666853 666883 666895 674953 675000 675008 675010 676026 676112 676623 676638 676641 679774 682986 685714 711283 715790 719333 724410 735654 746235 751589 794824 803455 804464 811497 827326 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double squirt"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
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.