Query Metrics
7
Database Queries
7
Different statements
177.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.76 ms (86.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 265677 381863 382898 384162 418069 429518 446171 447029 452854 463973 465431 466934 467089 476692 479867 494546 499391 501374 506057 520179 528608 530924 531051 532423 535159 539564 541847 541855 545349 547766 556471 556971 567718 579396 581873 589444 590084 592584 593325 596033 597645 601049 601553 602258 603385 604426 607533 607782 609644 616258 620647 622160 628518 628537 631321 636444 639282 641252 645928 649300 650264 651648 668694 675444 681355 696480 697473 697543 697718 705424 708698 711651 716000 716241 720545 726946 742063 742351 747771 749999 751310 752221 754731 757496 757521 758279 766270 770169 770190 770226 772547 772549 772584 772644 778151 782079 782135 782152 782541 783008 785396 785552 785967 786470 787342 787469 794727 796845 797000 800799 801545 803104 806928 806955 807424 808319 808979 819223 821808 826498 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (8.28%) |
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 651648 447029 452854 593325 418069 506057 528608 597645 499391 826498 821808 531051 535159 567718 541847 645928 720545 697473 697718 668694 697543 596033 628518 603385 785967 794727 782541 806955 808979 770169 772547 772584 806928 747771 754731 770190 772549 758279 609644 711651 778151 782079 783008 787342 797000 384162 601049 696480 616258 620647 631321 786470 742351 766270 726946 749999 446171 501374 601553 785552 556471 581873 494546 579396 602258 628537 466934 479867 530924 532423 545349 541855 708698 649300 650264 681355 589444 622160 641252 590084 592584 636444 639282 807424 782135 772644 782152 787469 801545 742063 757496 757521 751310 607533 607782 796845 803104 716000 467089 556971 705424 429518 604426 675444 465431 382898 520179 476692 800799 539564 808319 770226 265677 381863 819223 716241 785396 752221 463973 547766 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.46%) |
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 265677 381863 382898 384162 418069 429518 446171 447029 452854 463973 465431 466934 467089 476692 479867 494546 499391 501374 506057 520179 528608 530924 531051 532423 535159 539564 541847 541855 545349 547766 556471 556971 567718 579396 581873 589444 590084 592584 593325 596033 597645 601049 601553 602258 603385 604426 607533 607782 609644 616258 620647 622160 628518 628537 631321 636444 639282 641252 645928 649300 650264 651648 668694 675444 681355 696480 697473 697543 697718 705424 708698 711651 716000 716241 720545 726946 742063 742351 747771 749999 751310 752221 754731 757496 757521 758279 766270 770169 770190 770226 772547 772549 772584 772644 778151 782079 782135 782152 782541 783008 785396 785552 785967 786470 787342 787469 794727 796845 797000 800799 801545 803104 806928 806955 807424 808319 808979 819223 821808 826498 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties solo ass"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
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.