Query Metrics
7
Database Queries
7
Different statements
152.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.90 ms (82.47%) |
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 392075 397094 397701 515311 516981 521659 530107 534799 534892 535680 539528 564677 573195 574957 583642 585761 594576 596542 596558 597905 613715 618184 618399 623123 633058 641331 641549 643801 655201 683426 693350 693700 694347 696293 699121 700635 707465 707726 719401 724493 727550 728633 729907 730400 730596 734318 735591 737509 738654 744163 744406 745534 746113 747416 749946 750136 750347 750962 752789 754536 754863 755611 759671 760219 762299 762781 762974 764286 764505 764581 766090 771139 773462 773569 775407 779147 781030 782716 783674 783853 784056 784173 786556 789121 790121 790561 791207 791832 792647 793071 793554 793556 794410 794580 794626 795086 796910 800170 801032 801945 802292 803638 804289 804810 808289 810135 811184 814560 817016 817403 818676 819792 821805 823158 825035 825082 825111 827438 828361 828463 ] |
||||||||||||||||||||||||||||||
|
15.67 ms (10.27%) |
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 539528 779147 738654 771139 773462 800170 810135 515311 535680 521659 564677 655201 707726 683426 693350 694347 699121 693700 696293 700635 585761 597905 613715 618184 594576 596542 596558 641331 641549 643801 775407 728633 762299 783853 707465 534892 397094 819792 825111 828361 794626 790121 793554 796910 766090 792647 801945 759671 764286 746113 784173 801032 804289 821805 827438 814560 818676 825035 825082 573195 719401 623123 782716 803638 729907 749946 755611 760219 789121 791832 793556 794580 802292 727550 730400 737509 744406 773569 762781 764505 730596 744163 750347 752789 754863 762974 735591 750136 754536 786556 794410 574957 795086 392075 817403 817016 823158 828463 534799 781030 791207 804810 808289 747416 790561 793071 811184 750962 745534 734318 764581 783674 784056 397701 633058 724493 618399 530107 516981 583642 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.61%) |
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 392075 397094 397701 515311 516981 521659 530107 534799 534892 535680 539528 564677 573195 574957 583642 585761 594576 596542 596558 597905 613715 618184 618399 623123 633058 641331 641549 643801 655201 683426 693350 693700 694347 696293 699121 700635 707465 707726 719401 724493 727550 728633 729907 730400 730596 734318 735591 737509 738654 744163 744406 745534 746113 747416 749946 750136 750347 750962 752789 754536 754863 755611 759671 760219 762299 762781 762974 764286 764505 764581 766090 771139 773462 773569 775407 779147 781030 782716 783674 783853 784056 784173 786556 789121 790121 790561 791207 791832 792647 793071 793554 793556 794410 794580 794626 795086 796910 800170 801032 801945 802292 803638 804289 804810 808289 810135 811184 814560 817016 817403 818676 819792 821805 823158 825035 825082 825111 827438 828361 828463 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur love"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск love"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск love"
]
|
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.