Query Metrics
7
Database Queries
7
Different statements
172.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.77 ms (85.48%) |
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 389347 389492 398237 404072 415518 424762 429540 464567 468003 471009 471028 471038 471072 473768 486096 490587 508103 510921 510945 510946 510947 537463 537786 541034 545740 545742 546708 555022 560049 562984 563290 576484 577987 581381 598087 603525 606097 612511 612621 614222 616381 616569 618217 618456 625209 626169 628568 629695 630102 640361 641300 643943 650531 656567 661511 666051 666078 666674 666680 667113 667402 678983 684752 684783 684792 687103 694619 697177 697303 697331 703748 703749 705032 706391 707515 710229 714359 714366 714569 718633 720183 725616 728952 728955 729043 729045 729880 729932 730318 732193 734318 734741 739969 740326 740912 743236 744801 745991 746282 748526 749487 749567 750511 756620 774310 774663 774665 787285 789568 794410 794535 794597 794626 795113 800661 811942 814302 824479 825250 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (8.37%) |
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 750511 730318 612621 471072 537786 546708 684783 697331 714359 612511 794626 732193 618217 630102 707515 718633 510945 510947 577987 598087 473768 666674 800661 429540 424762 661511 743236 749567 774310 603525 468003 825250 562984 389492 824479 545740 555022 581381 541034 545742 563290 666051 703748 714366 656567 667113 684792 697177 706391 667402 678983 684752 626169 629695 628568 606097 641300 643943 794535 794597 729043 729880 729932 740326 744801 745991 746282 749487 787285 728952 728955 739969 729045 748526 734318 734741 697303 703749 714569 789568 794410 795113 398237 404072 814302 471009 486096 510921 510946 537463 471028 576484 666680 687103 705032 710229 650531 666078 720183 560049 614222 625209 640361 616381 616512 616569 774665 774663 725616 756620 740912 415518 694619 389347 490587 464567 508103 471038 618456 811942 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.97%) |
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 389347 389492 398237 404072 415518 424762 429540 464567 468003 471009 471028 471038 471072 473768 486096 490587 508103 510921 510945 510946 510947 537463 537786 541034 545740 545742 546708 555022 560049 562984 563290 576484 577987 581381 598087 603525 606097 612511 612621 614222 616381 616569 618217 618456 625209 626169 628568 629695 630102 640361 641300 643943 650531 656567 661511 666051 666078 666674 666680 667113 667402 678983 684752 684783 684792 687103 694619 697177 697303 697331 703748 703749 705032 706391 707515 710229 714359 714366 714569 718633 720183 725616 728952 728955 729043 729045 729880 729932 730318 732193 734318 734741 739969 740326 740912 743236 744801 745991 746282 748526 749487 749567 750511 756620 774310 774663 774665 787285 789568 794410 794535 794597 794626 795113 800661 811942 814302 824479 825250 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy girls"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.89%) |
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.