Query Metrics
7
Database Queries
7
Different statements
402.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.10 ms (53.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секретарш жоп"
]
|
||||||||||||||||||||||||||||||
|
162.16 ms (40.31%) |
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 182221 191690 265967 288045 324395 387477 388853 389832 394704 395668 395940 414183 429501 456944 493021 493023 508996 515603 517050 521223 528674 531878 548012 549878 557606 559602 563168 563204 563237 565970 584484 585521 586410 588230 589137 589149 592428 592472 594890 594930 595446 596261 600824 600871 601247 601257 601264 601304 604307 606322 611844 612188 617044 627212 637110 637869 645849 655550 664548 667631 668008 670493 678836 678842 680649 688095 699669 700842 701890 708897 710074 711617 714170 715477 716204 716612 716909 717007 718871 721771 723460 723733 725160 736844 741057 741084 741606 744208 746048 746062 746089 750767 755330 756497 758358 759951 760764 760773 760877 762020 766265 770100 782702 789517 791314 794513 799598 799925 803383 814462 815152 815167 815399 815657 815676 815980 816055 816579 819606 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (3.62%) |
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 592472 601247 589149 594890 760877 714170 716909 493021 414183 517050 604307 725160 741084 515603 584484 548012 191690 395668 288045 265967 388853 389832 429501 815399 815657 816055 814462 815676 815167 815980 816579 819606 456944 531878 521223 508996 528674 563237 565970 559602 645849 667631 678836 678842 680649 710074 701890 708897 716204 717007 664548 666803 670493 688095 700842 711617 723460 586410 588230 606322 637869 594930 601257 617044 637110 596261 600871 601264 600824 611844 612188 627212 791314 799598 803383 789517 794513 744208 746062 759951 736844 750767 762020 766265 770100 723733 746089 756497 760764 746048 755330 758358 760773 715477 718871 721771 782702 182221 394704 585521 387477 549878 699669 668008 592428 601304 799925 741606 741057 716612 395940 324395 815152 493023 563168 563204 655550 557606 589137 595446 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (0.87%) |
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 182221 191690 265967 288045 324395 387477 388853 389832 394704 395668 395940 414183 429501 456944 493021 493023 508996 515603 517050 521223 528674 531878 548012 549878 557606 559602 563168 563204 563237 565970 584484 585521 586410 588230 589137 589149 592428 592472 594890 594930 595446 596261 600824 600871 601247 601257 601264 601304 604307 606322 611844 612188 617044 627212 637110 637869 645849 655550 664548 667631 668008 670493 678836 678842 680649 688095 699669 700842 701890 708897 710074 711617 714170 715477 716204 716612 716909 717007 718871 721771 723460 723733 725160 736844 741057 741084 741606 744208 746048 746062 746089 750767 755330 756497 758358 759951 760764 760773 760877 762020 766265 770100 782702 789517 791314 794513 799598 799925 803383 814462 815152 815167 815399 815657 815676 815980 816055 816579 819606 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office ass"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.