Query Metrics
7
Database Queries
7
Different statements
149.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.55 ms (81.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 65413 100685 382325 383923 384588 385449 385705 387058 389832 390150 398237 410201 410356 415515 417776 418724 425928 428956 429895 429899 429900 436055 449072 452281 452436 452988 452995 457863 462219 464495 466925 467878 477584 478030 487254 497695 528044 529189 530033 530943 532727 545384 548957 552586 565512 577961 581672 585359 588332 588455 588748 591626 591669 595455 598009 598543 604855 606389 617552 619679 619747 623192 623670 627187 629788 631878 642106 642187 644187 646512 650663 664573 670439 678836 688252 689514 689860 704641 717497 722967 738275 739695 740269 740302 744952 749564 754366 754399 754537 754570 762208 766379 768725 768770 770671 772166 778863 781601 784708 786723 787050 788366 790462 790685 791598 792368 802932 803026 804679 805105 809545 810892 811324 811599 812381 812399 812433 817285 819681 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (10.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 664573 548957 585359 591669 617552 595455 604855 792368 788366 803361 744952 766379 772166 786723 768725 768770 739695 390150 436055 487254 467878 429899 429900 418724 478030 497695 528044 532727 530943 545384 577961 619747 631878 619679 429895 452436 385449 385705 383923 384588 100685 382325 65413 389832 387058 398237 425928 410356 415515 410201 428956 417776 819681 817285 449072 452281 452995 457863 466925 462219 464495 477584 452988 530033 529189 565512 552586 581672 650663 670439 678836 689860 722967 646512 704641 688252 689514 717497 606389 623670 644187 588332 588748 598543 623192 629788 642187 588455 591626 598009 642106 778863 787050 790462 791598 809545 811324 811599 812399 812433 781601 784708 790685 802932 805105 810892 812381 803026 804679 738275 754366 754399 740302 749564 754570 754537 740269 762208 770671 627187 ] |
||||||||||||||||||||||||||||||
|
4.70 ms (3.14%) |
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 65413 100685 382325 383923 384588 385449 385705 387058 389832 390150 398237 410201 410356 415515 417776 418724 425928 428956 429895 429899 429900 436055 449072 452281 452436 452988 452995 457863 462219 464495 466925 467878 477584 478030 487254 497695 528044 529189 530033 530943 532727 545384 548957 552586 565512 577961 581672 585359 588332 588455 588748 591626 591669 595455 598009 598543 604855 606389 617552 619679 619747 623192 623670 627187 629788 631878 642106 642187 644187 646512 650663 664573 670439 678836 688252 689514 689860 704641 717497 722967 738275 739695 740269 740302 744952 749564 754366 754399 754537 754570 762208 766379 768725 768770 770671 772166 778863 781601 784708 786723 787050 788366 790462 790685 791598 792368 802932 803026 804679 805105 809545 810892 811324 811599 812381 812399 812433 817285 819681 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation toys"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац toys"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац toys"
]
|
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.