Query Metrics
7
Database Queries
7
Different statements
185.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.43 ms (87.65%) |
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 383441 391676 391950 392043 397464 401382 421600 423322 426561 426797 456077 459444 460112 463239 473699 475507 475633 477194 486508 492348 500310 505705 513549 517758 541931 545599 557269 566971 568847 578573 581745 583827 584462 587523 588958 593996 594873 595553 600011 603945 607573 609543 624645 627629 628482 639184 643460 649055 651805 653848 663739 668662 669890 669905 693403 695690 699245 703976 705019 707221 707376 709148 713872 717947 719266 722592 723879 728373 731479 732858 734971 735420 737926 740032 743208 748061 748706 748906 749508 752011 765636 767504 770062 770838 771045 773855 774734 775560 777926 777956 777972 784227 784722 784724 785155 786044 786050 787627 788498 789095 789743 791836 792415 792537 793836 793956 796540 797899 805239 806466 809922 810740 812875 813571 813686 815256 815949 817946 817992 821553 ] |
||||||||||||||||||||||||||||||
|
13.36 ms (7.21%) |
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 797899 810740 728373 773855 784724 791836 743208 401382 583827 734971 748706 500310 517758 663739 653848 669890 707221 609543 594873 603945 777956 789095 748061 707376 392043 815949 557269 607573 723879 391950 784227 786050 821553 765636 788498 600011 813571 813686 817992 593996 627629 805239 785155 793836 752011 737926 777972 749508 459444 578573 699245 668662 669905 717947 643460 587523 624645 789743 767504 475507 475633 545599 541931 581745 649055 595553 806466 777926 786044 771045 748906 784722 787627 815256 566971 695690 713872 628482 732858 735420 397464 486508 492348 460112 584462 651805 812875 793956 740032 731479 423322 383441 426561 693403 421600 639184 391676 426797 513549 505705 456077 463239 705019 703976 709148 588958 775560 792415 809922 770062 770838 817946 568847 719266 722592 792537 796540 774734 473699 477194 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.56%) |
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 383441 391676 391950 392043 397464 401382 421600 423322 426561 426797 456077 459444 460112 463239 473699 475507 475633 477194 486508 492348 500310 505705 513549 517758 541931 545599 557269 566971 568847 578573 581745 583827 584462 587523 588958 593996 594873 595553 600011 603945 607573 609543 624645 627629 628482 639184 643460 649055 651805 653848 663739 668662 669890 669905 693403 695690 699245 703976 705019 707221 707376 709148 713872 717947 719266 722592 723879 728373 731479 732858 734971 735420 737926 740032 743208 748061 748706 748906 749508 752011 765636 767504 770062 770838 771045 773855 774734 775560 777926 777956 777972 784227 784722 784724 785155 786044 786050 787627 788498 789095 789743 791836 792415 792537 793836 793956 796540 797899 805239 806466 809922 810740 812875 813571 813686 815256 815949 817946 817992 821553 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"baby girl"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"baby девушк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"baby девушк"
]
|
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.