Query Metrics
7
Database Queries
7
Different statements
193.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.83 ms (87.30%) |
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 4274 83499 388542 392978 397089 397900 398579 400906 404000 418900 424757 425574 426897 428180 432743 438506 440580 440963 441109 441755 443166 446649 450275 456828 457019 457113 457187 457376 458804 459650 461867 463239 464251 474242 474502 475653 487176 490157 499083 505897 515381 518383 520790 521000 522438 531380 541167 552473 565032 577541 577678 584365 585899 607964 610121 610309 616072 627357 629843 644188 658124 674263 693227 693799 695084 708533 712393 715129 716303 718811 720124 721102 721241 721249 721610 723622 724475 727564 727896 728779 731224 741076 741382 743559 751507 751925 757715 757776 762369 763529 765394 768650 770591 771819 773313 773740 776194 777327 784284 788359 788377 795075 797709 797719 803309 806697 809706 812732 813667 813842 813863 814762 814763 815993 818835 819938 823177 824320 824868 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (7.26%) |
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 773313 728779 751925 763529 765394 768650 727564 727896 731224 743559 757715 762369 770591 773740 607964 616072 627357 708533 712393 716303 720124 721610 776194 777327 784284 788359 797709 797719 809706 812732 4274 397900 404000 450275 474242 400906 438506 418900 457187 505897 818835 541167 741382 388542 487176 521000 432743 565032 731666 815993 644188 721102 531380 584365 577678 693227 658124 806697 724475 771819 741076 751507 757776 803309 464251 522438 397089 440580 721249 788377 443166 813667 814762 814763 585899 83499 446649 457113 520790 552473 693799 674263 695084 721241 610121 629843 795075 823177 475653 461867 515381 577541 715129 718811 610309 490157 392978 398579 425574 441755 426897 424757 428180 441109 440963 723622 813842 819938 824320 824868 813863 456828 457019 458804 474502 459650 457376 463239 499083 518383 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.83%) |
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 4274 83499 388542 392978 397089 397900 398579 400906 404000 418900 424757 425574 426897 428180 432743 438506 440580 440963 441109 441755 443166 446649 450275 456828 457019 457113 457187 457376 458804 459650 461867 463239 464251 474242 474502 475653 487176 490157 499083 505897 515381 518383 520790 521000 522438 531380 541167 552473 565032 577541 577678 584365 585899 607964 610121 610309 616072 627357 629843 644188 658124 674263 693227 693799 695084 708533 712393 715129 716303 718811 720124 721102 721241 721249 721610 723622 724475 727564 727896 728779 731224 741076 741382 743559 751507 751925 757715 757776 762369 763529 765394 768650 770591 771819 773313 773740 776194 777327 784284 788359 788377 795075 797709 797719 803309 806697 809706 812732 813667 813842 813863 814762 814763 815993 818835 819938 823177 824320 824868 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife real"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен real"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен real"
]
|
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.