Query Metrics
7
Database Queries
7
Different statements
198.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.40 ms (86.69%) |
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 73413 106347 165669 184943 185353 185401 270386 322773 381769 382436 383660 387777 389122 390329 390804 391036 401361 401489 402602 409867 435701 448357 464616 481652 493219 494392 500689 503994 506795 507133 510041 510045 516032 525768 549583 550956 551316 551358 558383 560102 563715 565941 574158 580644 583110 584726 584735 593481 593671 599327 599543 600596 600628 604497 605875 607286 608071 608595 610257 611356 615004 621105 622028 626152 634842 636515 641663 643426 643443 644093 647643 651941 653241 654065 661130 662711 662757 662978 662982 663695 664795 665166 666331 669085 670133 676118 676976 677376 682654 687138 702063 708023 708768 710285 738897 742993 744468 748752 753784 768115 771380 772007 773766 782408 782420 784270 793591 797909 799316 799522 803595 804084 804671 805398 813951 814793 816818 825312 826902 828714 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (8.83%) |
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 494392 744468 710285 805398 782408 516032 669085 773766 621105 448357 584726 816818 493219 661130 702063 500689 662757 662982 670133 804084 402602 676118 813951 662978 604497 605875 643443 782420 641663 435701 401361 784270 664795 563715 708023 599543 608071 382436 803595 793591 481652 550956 682654 565941 611356 510045 634842 636515 574158 381769 322773 73413 507133 593671 654065 662711 738897 503994 525768 600628 644093 797909 409867 665166 771380 643426 185353 622028 768115 165669 184943 825312 584735 389122 663695 799316 580644 799522 185401 387777 390804 593481 560102 647643 666331 676976 814793 551316 626152 804671 772007 390329 742993 464616 828714 753784 401489 506795 510041 551358 748752 383660 558383 708768 391036 270386 610257 106347 599327 608595 615004 549583 826902 651941 653241 687138 677376 583110 600596 607286 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.26%) |
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 73413 106347 165669 184943 185353 185401 270386 322773 381769 382436 383660 387777 389122 390329 390804 391036 401361 401489 402602 409867 435701 448357 464616 481652 493219 494392 500689 503994 506795 507133 510041 510045 516032 525768 549583 550956 551316 551358 558383 560102 563715 565941 574158 580644 583110 584726 584735 593481 593671 599327 599543 600596 600628 604497 605875 607286 608071 608595 610257 611356 615004 621105 622028 626152 634842 636515 641663 643426 643443 644093 647643 651941 653241 654065 661130 662711 662757 662978 662982 663695 664795 665166 666331 669085 670133 676118 676976 677376 682654 687138 702063 708023 708768 710285 738897 742993 744468 748752 753784 768115 771380 772007 773766 782408 782420 784270 793591 797909 799316 799522 803595 804084 804671 805398 813951 814793 816818 825312 826902 828714 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big tits"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.