Query Metrics
7
Database Queries
7
Different statements
196.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.05 ms (87.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 79765 382724 384063 385974 388765 391062 395901 396312 398576 411715 418316 427179 443178 462709 470302 485691 495144 501442 504764 504770 506211 515201 518852 520750 542934 545959 554265 559705 560414 566001 569668 570056 575685 577118 578071 578461 579740 581206 588581 610089 619147 619417 619430 623346 623350 625567 630528 630834 641006 657777 663396 663434 663473 663501 663936 665416 670486 685355 685612 687929 691205 693217 704722 714851 716613 717368 717445 720462 721685 722099 722332 725138 726082 726876 727000 727804 730931 731080 731111 733181 733570 736866 741476 741602 742174 743933 744930 748392 750782 754356 755794 757927 759409 761007 770011 771594 779913 782279 784600 785876 790158 794126 794829 794974 796123 797216 798992 800000 803076 803252 807183 807331 807333 808131 817385 824023 825054 825158 825835 827942 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (7.48%) |
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 784600 790158 754356 641006 395901 625567 736866 725138 384063 578461 687929 663473 501442 663501 462709 485691 800000 398576 630834 619147 807333 733570 755794 743933 748392 579740 663936 569668 663396 717368 559705 619430 782279 504764 721685 691205 794126 727000 730931 726082 761007 560414 797216 396312 623350 418316 657777 720462 779913 443178 520750 385974 827942 504770 578071 722099 722332 566001 798992 807331 727804 771594 796123 716613 663434 825835 825158 817385 824023 685355 685612 670486 693217 704722 717445 610089 759409 757927 470302 506211 518852 575685 554265 577118 588581 623346 794829 807183 742174 665416 785876 803076 731080 731111 388765 382724 495144 542934 570056 515201 79765 391062 427179 411715 825054 581206 714851 545959 619417 630528 794974 803252 733181 808131 741476 750782 770011 726876 741602 744930 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.43%) |
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 79765 382724 384063 385974 388765 391062 395901 396312 398576 411715 418316 427179 443178 462709 470302 485691 495144 501442 504764 504770 506211 515201 518852 520750 542934 545959 554265 559705 560414 566001 569668 570056 575685 577118 578071 578461 579740 581206 588581 610089 619147 619417 619430 623346 623350 625567 630528 630834 641006 657777 663396 663434 663473 663501 663936 665416 670486 685355 685612 687929 691205 693217 704722 714851 716613 717368 717445 720462 721685 722099 722332 725138 726082 726876 727000 727804 730931 731080 731111 733181 733570 736866 741476 741602 742174 743933 744930 748392 750782 754356 755794 757927 759409 761007 770011 771594 779913 782279 784600 785876 790158 794126 794829 794974 796123 797216 798992 800000 803076 803252 807183 807331 807333 808131 817385 824023 825054 825158 825835 827942 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young wife"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young жен"
]
|
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.