Query Metrics
7
Database Queries
7
Different statements
186.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.71 ms (85.61%) |
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 146694 398878 410328 444405 460884 463416 474933 478077 481193 485315 490592 507317 508360 511133 511446 518425 524112 525848 527451 530777 534507 537035 538027 539735 544199 548708 552785 556868 557105 562977 563170 564254 564531 564945 565679 569546 571126 571754 573615 574781 575409 576516 577580 579848 581805 585163 590398 593768 593769 598209 599098 599466 600645 601232 601688 602435 602966 604011 604697 607750 609225 613288 615408 615518 617122 617271 619896 621351 621465 624340 624960 625185 631376 636506 639119 644050 644904 653244 653844 654562 656792 658418 659182 668387 673156 679671 684406 684769 684817 684906 697412 712660 712669 717103 720278 738949 762404 762408 764098 764758 766217 768072 771675 773316 775133 777130 780784 782176 785822 790467 791274 791286 791720 795357 796098 799682 800183 813498 814219 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (8.41%) |
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 511133 518425 557105 571126 577580 564531 684769 563170 564945 574781 576516 600645 617122 599466 585163 593768 602435 617271 780784 474933 398878 444405 508360 525848 490592 507317 524112 410328 697412 673156 684406 598209 613288 782176 791286 791720 764098 565679 564254 659182 573615 485315 644904 463416 511446 537035 539735 460884 544199 569546 684906 654562 562977 579848 581805 590398 593769 601232 639119 604011 621351 644050 601688 607750 146694 481193 534507 552785 556868 712669 711163 636506 785822 796098 799682 791274 764758 766217 813498 738949 762404 762408 768072 771675 773316 615518 717103 775133 790467 795357 800183 656792 658418 653244 548708 571754 602966 621465 624340 625185 609225 527451 530777 538027 814219 478077 575409 712660 653844 668387 720278 679671 684817 604697 615408 599098 624960 619896 631376 777130 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (2.26%) |
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 146694 398878 410328 444405 460884 463416 474933 478077 481193 485315 490592 507317 508360 511133 511446 518425 524112 525848 527451 530777 534507 537035 538027 539735 544199 548708 552785 556868 557105 562977 563170 564254 564531 564945 565679 569546 571126 571754 573615 574781 575409 576516 577580 579848 581805 585163 590398 593768 593769 598209 599098 599466 600645 601232 601688 602435 602966 604011 604697 607750 609225 613288 615408 615518 617122 617271 619896 621351 621465 624340 624960 625185 631376 636506 639119 644050 644904 653244 653844 654562 656792 658418 659182 668387 673156 679671 684406 684769 684817 684906 697412 712660 712669 717103 720278 738949 762404 762408 764098 764758 766217 768072 771675 773316 775133 777130 780784 782176 785822 790467 791274 791286 791720 795357 796098 799682 800183 813498 814219 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"не"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"не с тем"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
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.