Query Metrics
7
Database Queries
7
Different statements
183.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.47 ms (84.52%) |
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 7456 111756 122062 389751 390811 397519 400855 466067 468368 468525 469287 473997 518186 529404 530008 530028 530564 531126 532674 533382 533941 535026 537007 540627 542248 544690 544818 545461 548552 555147 558782 561443 563457 563463 565557 579249 584031 592225 592766 598377 607586 613079 615716 617428 620486 624419 629428 630711 632501 632514 637092 638186 641516 641656 641678 642412 643406 647725 648587 650012 651607 653809 660057 665826 674116 676623 681279 681791 705793 713105 716878 717175 719858 724519 726193 732624 733361 737657 738400 738673 744348 745553 747438 757107 757480 759630 761161 766113 766459 768653 773486 773666 773852 774131 774606 796558 796692 796814 797410 804731 806149 806195 810308 810463 820453 821241 821524 821689 822280 822822 822988 823386 823421 823464 823878 823965 826143 826177 828431 828544 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (8.82%) |
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 7456 821524 820453 822280 828544 473997 542248 561443 544818 555147 653809 660057 579249 592225 598377 592766 732624 757107 747438 733361 738673 745553 773486 737657 738400 768653 632514 713105 796814 810308 122062 468525 533382 531126 530028 469287 565557 651607 716878 676623 641678 617428 826177 613079 757480 766113 797410 466067 111756 390811 397519 400855 826143 823464 822822 822988 823386 823421 821241 821689 823878 823965 828431 533941 540627 530008 530564 537007 468368 558782 563457 584031 544690 563463 647725 648587 705793 717175 681791 719858 650012 665826 674116 641656 642412 607586 630711 632501 638186 624419 641516 643406 796558 804731 806195 774606 796692 806149 766459 726193 744348 759630 761161 773852 724519 773666 774131 620486 810463 389751 518186 535026 529404 532674 548552 681279 545461 629428 615716 637092 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (2.04%) |
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 7456 111756 122062 389751 390811 397519 400855 466067 468368 468525 469287 473997 518186 529404 530008 530028 530564 531126 532674 533382 533941 535026 537007 540627 542248 544690 544818 545461 548552 555147 558782 561443 563457 563463 565557 579249 584031 592225 592766 598377 607586 613079 615716 617428 620486 624419 629428 630711 632501 632514 637092 638186 641516 641656 641678 642412 643406 647725 648587 650012 651607 653809 660057 665826 674116 676623 681279 681791 705793 713105 716878 717175 719858 724519 726193 732624 733361 737657 738400 738673 744348 745553 747438 757107 757480 759630 761161 766113 766459 768653 773486 773666 773852 774131 774606 796558 796692 796814 797410 804731 806149 806195 810308 810463 820453 821241 821524 821689 822280 822822 822988 823386 823421 823464 823878 823965 826143 826177 828431 828544 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black and milf"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black milf"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black milf"
]
|
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.