Query Metrics
7
Database Queries
7
Different statements
188.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.33 ms (86.59%) |
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 340613 383500 397568 401193 401628 402648 404738 408880 413432 416695 419461 419633 419833 419834 439868 446798 447381 447734 448481 448551 450683 452840 452847 452897 453147 453619 454641 454741 457807 467110 469741 473038 475814 482731 483479 483741 484953 494302 494808 495170 495559 499931 499934 499936 502770 505370 507955 508564 510354 515548 519646 527921 541845 558324 568262 568302 568303 571166 580230 596610 597051 597190 597482 597983 598044 598457 598503 598746 600125 602255 626597 629047 630039 632920 648455 649517 660578 683297 700257 702910 703668 706520 711000 730221 738483 739320 740909 742470 742715 749134 749380 750522 750956 751415 752556 756138 756830 757263 758518 758583 758821 767745 773146 780382 783190 783707 783740 783948 786530 790134 792064 792445 800143 803124 804646 804900 807616 807642 810923 813195 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (7.90%) |
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 730221 751415 756138 758518 758583 783190 783740 786530 790134 792445 800143 807616 749380 750522 750956 757263 767745 742715 758821 739320 773146 740909 742470 749134 752556 756830 630039 702910 703668 706520 711000 780382 783707 783948 792064 803124 804900 807642 810923 813195 401193 510354 439868 416695 483479 683297 632920 597190 602255 452897 484953 419834 419833 448481 452840 446798 457807 541845 568262 648455 660578 597051 598746 597983 598044 340613 383500 447381 453619 483741 494302 495170 519646 505370 507955 804646 450683 499931 626597 629047 413432 495559 397568 402648 404738 408880 419461 419633 448551 454641 469741 447734 467110 475814 452847 453147 473038 482731 494808 499934 499936 502770 515548 508564 527921 558324 568303 580230 568302 649517 700257 571166 598457 598503 600125 597482 596610 738483 401628 454741 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.50%) |
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 340613 383500 397568 401193 401628 402648 404738 408880 413432 416695 419461 419633 419833 419834 439868 446798 447381 447734 448481 448551 450683 452840 452847 452897 453147 453619 454641 454741 457807 467110 469741 473038 475814 482731 483479 483741 484953 494302 494808 495170 495559 499931 499934 499936 502770 505370 507955 508564 510354 515548 519646 527921 541845 558324 568262 568302 568303 571166 580230 596610 597051 597190 597482 597983 598044 598457 598503 598746 600125 602255 626597 629047 630039 632920 648455 649517 660578 683297 700257 702910 703668 706520 711000 730221 738483 739320 740909 742470 742715 749134 749380 750522 750956 751415 752556 756138 756830 757263 758518 758583 758821 767745 773146 780382 783190 783707 783740 783948 786530 790134 792064 792445 800143 803124 804646 804900 807616 807642 810923 813195 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen webcam solo"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen вебкамер соло"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen вебкамер соло"
]
|
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.