Query Metrics
7
Database Queries
7
Different statements
157.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.27 ms (84.21%) |
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 131726 418111 434355 434361 435549 436885 439130 447608 459403 459731 467584 467636 480255 493861 499872 518595 526082 529740 534545 535294 540945 541507 544001 547743 548157 550857 563312 564285 564289 567561 574391 580130 584183 586113 586745 589526 590788 600941 604444 612091 613559 616062 616454 620957 647111 655242 656801 656888 657527 657567 664091 666856 672289 672315 673942 674535 680809 681388 682397 689571 692972 693392 697236 702357 702375 702376 710404 711624 720448 729666 735132 738473 738827 739119 739408 744047 745927 749090 750306 753202 753207 759198 771038 776034 778449 780151 780274 781297 781298 782104 783743 791132 793255 793914 794097 794178 794286 796071 796288 796333 796992 797341 800318 800825 801495 803770 803771 804000 806819 806826 806839 807111 808969 810957 811331 813817 819644 827287 827296 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (8.92%) |
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 613559 811331 781298 801495 803771 753207 781297 810957 729666 753202 697236 793914 807111 541507 540945 564289 796071 791132 418111 590788 738827 735132 612091 526082 672289 664091 827296 693392 647111 750306 800825 796288 436885 493861 584183 480255 467584 534545 467636 574391 672315 655242 580130 586113 616454 796333 749090 797341 739119 499872 459731 586745 813817 702376 656888 657567 681388 720448 550857 589526 620957 776034 780274 783743 778449 780151 796992 808969 800318 745927 759198 702375 710404 782104 803770 804000 806819 806826 806839 435549 567561 518595 692972 680809 674535 689571 794178 793255 738473 739408 771038 702357 794097 544001 666856 459403 535294 600941 744047 447608 434361 794286 548157 616062 604444 434355 439130 819644 563312 131726 827287 529740 512930 547743 564285 657527 673942 711624 656801 682397 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.85%) |
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 131726 418111 434355 434361 435549 436885 439130 447608 459403 459731 467584 467636 480255 493861 499872 518595 526082 529740 534545 535294 540945 541507 544001 547743 548157 550857 563312 564285 564289 567561 574391 580130 584183 586113 586745 589526 590788 600941 604444 612091 613559 616062 616454 620957 647111 655242 656801 656888 657527 657567 664091 666856 672289 672315 673942 674535 680809 681388 682397 689571 692972 693392 697236 702357 702375 702376 710404 711624 720448 729666 735132 738473 738827 739119 739408 744047 745927 749090 750306 753202 753207 759198 771038 776034 778449 780151 780274 781297 781298 782104 783743 791132 793255 793914 794097 794178 794286 796071 796288 796333 796992 797341 800318 800825 801495 803770 803771 804000 806819 806826 806839 807111 808969 810957 811331 813817 819644 827287 827296 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo my wife"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд my жен"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд my жен"
]
|
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.