Query Metrics
7
Database Queries
7
Different statements
142.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.45 ms (79.34%) |
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 487422 488468 503705 528875 528997 531807 533100 539541 553757 553886 555277 556056 560987 563328 565070 565199 567684 574116 577838 630089 648512 652188 653359 653398 655163 655296 656144 656557 656563 660081 661936 664410 665760 666654 675612 677354 680097 682080 682227 683061 684455 686521 696511 701541 702914 705225 708087 715765 715907 716845 717654 719435 720158 720458 722632 722636 723597 724862 725085 725347 726438 727352 728556 729814 731380 731434 732369 735377 735961 736176 737290 738486 739320 739913 740823 741319 741981 743083 743092 744159 744923 745835 746967 749807 750161 756884 757038 759299 760186 760361 760964 761983 762768 764105 765412 766389 766670 768062 768066 770473 771430 772411 773654 776029 778547 778946 781762 785616 788633 791675 794198 800035 800432 804956 807586 809764 811509 811893 812140 814280 ] |
||||||||||||||||||||||||||||||
|
19.93 ms (13.94%) |
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 776029 778547 785616 800432 727352 732369 736176 740823 741981 743092 756884 760964 764105 770473 771430 781762 791675 794198 807586 811509 811893 731380 735377 743083 744159 760186 762768 766670 768062 724862 725347 726438 729814 731434 739913 744923 745835 746967 765412 766389 773654 738486 739320 760361 772411 725085 728556 735961 737290 741319 749807 750161 757038 759299 761983 768066 630089 717654 720158 778946 788633 800035 804956 809764 812140 723597 814280 487422 488468 528997 531807 539541 503705 528875 533100 563328 565070 574116 555277 560987 577838 553757 553886 556056 565199 567684 648512 656557 661936 675612 683061 705225 708087 719435 720458 722632 653359 653398 655296 656144 656563 665760 666654 677354 682080 686521 696511 701541 702914 715765 715907 716845 722636 652188 655163 660081 664410 680097 682227 684455 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с первым"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (1.60%) |
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 487422 488468 503705 528875 528997 531807 533100 539541 553757 553886 555277 556056 560987 563328 565070 565199 567684 574116 577838 630089 648512 652188 653359 653398 655163 655296 656144 656557 656563 660081 661936 664410 665760 666654 675612 677354 680097 682080 682227 683061 684455 686521 696511 701541 702914 705225 708087 715765 715907 716845 717654 719435 720158 720458 722632 722636 723597 724862 725085 725347 726438 727352 728556 729814 731380 731434 732369 735377 735961 736176 737290 738486 739320 739913 740823 741319 741981 743083 743092 744159 744923 745835 746967 749807 750161 756884 757038 759299 760186 760361 760964 761983 762768 764105 765412 766389 766670 768062 768066 770473 771430 772411 773654 776029 778547 778946 781762 785616 788633 791675 794198 800035 800432 804956 807586 809764 811509 811893 812140 814280 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"перв"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.96%) |
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.