Query Metrics
7
Database Queries
7
Different statements
231.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.58 ms (89.75%) |
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 24855 381874 426666 470851 494379 496842 510507 514274 514380 520999 524404 528569 543127 543199 545327 550165 552913 553732 556352 557271 557964 558672 559096 562744 568266 569538 570701 571553 580629 587063 588464 605281 608092 618415 618540 618599 618725 619075 620389 622842 622923 623175 623601 623854 625804 626594 628243 645194 654345 657938 657966 658261 663341 663425 671591 676972 676976 677028 678869 682496 682882 693403 695725 717863 720827 720942 721310 721341 721368 723931 729744 731933 732145 733847 733852 733902 737137 737349 739423 742886 747407 747640 748715 750196 751182 752690 753638 754303 754574 756499 761141 763236 763507 763516 764165 764179 778266 786301 787215 787219 788247 788521 788750 789080 790038 790256 791227 791394 791807 792117 796986 798014 802164 802596 806878 809015 812907 813945 815100 815130 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (5.85%) |
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 732145 747640 752690 763236 737349 742886 764179 729744 733852 737137 748715 753638 754303 754574 747407 751182 761141 763516 608092 623601 717863 720942 721341 788521 790038 791227 791394 809015 812907 381874 426666 24855 813945 815100 815130 470851 496842 520999 510507 514274 514380 524404 528569 494379 543199 545327 556352 557271 557964 569538 553732 558672 580629 543127 559096 570701 571553 663341 663425 671591 645194 654345 676976 678869 682882 693403 720827 721368 657938 657966 658261 676972 677028 682496 695725 721310 550165 552913 562744 568266 605281 618415 618599 619075 620389 623175 628243 618540 618725 622842 622923 587063 588464 623854 625804 626594 786301 788247 790256 792117 802164 778266 787215 788750 723931 733902 739423 756499 787219 789080 791807 796986 798014 802596 806878 731933 733847 750196 763507 764165 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.10%) |
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 24855 381874 426666 470851 494379 496842 510507 514274 514380 520999 524404 528569 543127 543199 545327 550165 552913 553732 556352 557271 557964 558672 559096 562744 568266 569538 570701 571553 580629 587063 588464 605281 608092 618415 618540 618599 618725 619075 620389 622842 622923 623175 623601 623854 625804 626594 628243 645194 654345 657938 657966 658261 663341 663425 671591 676972 676976 677028 678869 682496 682882 693403 695725 717863 720827 720942 721310 721341 721368 723931 729744 731933 732145 733847 733852 733902 737137 737349 739423 742886 747407 747640 748715 750196 751182 752690 753638 754303 754574 756499 761141 763236 763507 763516 764165 764179 778266 786301 787215 787219 788247 788521 788750 789080 790038 790256 791227 791394 791807 792117 796986 798014 802164 802596 806878 809015 812907 813945 815100 815130 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"крошку"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крошк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.65%) |
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.