Query Metrics
7
Database Queries
7
Different statements
161.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.16 ms (83.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 97288 233934 254390 297917 325595 365954 388253 393641 411590 412237 412880 419056 426028 428068 429146 437249 438657 439829 460959 460962 462374 463729 472728 521736 522954 525917 527252 527776 530234 530259 530263 531385 534459 539333 548412 550691 556382 565998 567240 569935 574169 575250 576934 578559 579575 583359 584123 596559 596820 596980 597870 606372 607503 608449 619420 622166 628588 632280 633253 665115 667099 687452 689771 691291 696125 704281 708183 710153 710777 712420 713816 714104 718961 720435 721266 721464 721756 722154 722543 722652 724840 726082 727410 730572 732461 735587 737976 741083 742974 743086 748010 748147 756349 757804 759026 762627 763296 763331 767385 768089 768757 770577 771868 775799 777979 780277 784103 785708 789655 790918 796403 799402 804929 808760 810373 810528 812132 812145 827016 ] |
||||||||||||||||||||||||||||||
|
15.48 ms (9.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 460959 530234 462374 596820 804929 233934 426028 527252 412237 530263 539333 550691 578559 583359 576934 584123 667099 687452 696125 556382 567240 596980 607503 810528 790918 808760 742974 785708 724840 748010 757804 759026 730572 770577 737976 762627 763331 704281 710153 721756 297917 412880 393641 827016 516926 534459 548412 574169 710777 597870 619420 632280 777979 784103 756349 767385 727410 768757 763296 622166 633253 708183 712420 810373 437249 530259 325595 411590 365954 388253 429146 714104 722543 721266 596559 780277 525917 565998 720435 748147 799402 428068 527776 722652 665115 721464 789655 732461 735587 743086 726082 812132 812145 472728 531385 521736 569935 718961 722154 771868 775799 254390 438657 522954 97288 419056 460962 579575 689771 691291 713816 575250 608449 606372 628588 796403 741083 768089 463729 439829 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.82%) |
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 97288 233934 254390 297917 325595 365954 388253 393641 411590 412237 412880 419056 426028 428068 429146 437249 438657 439829 460959 460962 462374 463729 472728 521736 522954 525917 527252 527776 530234 530259 530263 531385 534459 539333 548412 550691 556382 565998 567240 569935 574169 575250 576934 578559 579575 583359 584123 596559 596820 596980 597870 606372 607503 608449 619420 622166 628588 632280 633253 665115 667099 687452 689771 691291 696125 704281 708183 710153 710777 712420 713816 714104 718961 720435 721266 721464 721756 722154 722543 722652 724840 726082 727410 730572 732461 735587 737976 741083 742974 743086 748010 748147 756349 757804 759026 762627 763296 763331 767385 768089 768757 770577 771868 775799 777979 780277 784103 785708 789655 790918 796403 799402 804929 808760 810373 810528 812132 812145 827016 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"небольшой член молодые"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленький член молодые"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
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.