Query Metrics
7
Database Queries
7
Different statements
165.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.64 ms (80.98%) |
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 81065 191189 271756 388688 396088 397299 402169 403703 412220 413472 422426 428104 436523 439446 439450 447830 448843 449146 450779 452388 452429 456707 457008 458639 461984 462362 467068 469988 471478 473650 474813 487575 487950 491175 492115 495280 496124 497766 501699 503082 512631 513704 517132 523272 524395 529542 531308 540647 543507 546870 547031 549142 549508 556553 556766 556936 558318 559312 564688 566358 576117 579664 579849 579877 585838 587575 590057 593381 593382 593669 612467 612951 613837 613848 614045 618104 636116 636449 636462 645265 646435 652010 653330 665740 667909 686284 705226 707698 708450 708894 709292 709819 719837 720074 723155 723432 726907 728741 731037 733534 734521 736425 744494 752876 759653 761459 761949 763378 764923 774534 775009 775013 780936 795483 803258 804210 808095 811906 814111 814675 ] |
||||||||||||||||||||||||||||||
|
20.54 ms (12.45%) |
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 469988 517132 473650 667909 708450 645265 709292 579664 612951 614045 752876 728741 388688 523272 436523 413472 448843 495280 487950 556766 543507 547031 707698 579849 593381 795483 804210 736425 774534 780936 808095 81065 449146 503082 496124 559312 549508 566358 686284 723432 556936 613837 587575 775009 775013 733534 764923 744494 412220 271756 402169 422426 814675 457008 452429 447830 540647 497766 720074 709819 811906 734521 759653 458639 396088 403703 191189 461984 512631 491175 524395 462362 612467 636449 467068 471478 487575 593669 731037 474813 492115 501699 439450 439446 579877 705226 723155 653330 665740 564688 585838 613848 618104 636116 726907 763378 761949 636462 708894 803258 450779 397299 814111 576117 646435 761459 428104 452388 513704 456707 531308 529542 556553 558318 546870 549142 652010 719837 590057 593382 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.67%) |
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 81065 191189 271756 388688 396088 397299 402169 403703 412220 413472 422426 428104 436523 439446 439450 447830 448843 449146 450779 452388 452429 456707 457008 458639 461984 462362 467068 469988 471478 473650 474813 487575 487950 491175 492115 495280 496124 497766 501699 503082 512631 513704 517132 523272 524395 529542 531308 540647 543507 546870 547031 549142 549508 556553 556766 556936 558318 559312 564688 566358 576117 579664 579849 579877 585838 587575 590057 593381 593382 593669 612467 612951 613837 613848 614045 618104 636116 636449 636462 645265 646435 652010 653330 665740 667909 686284 705226 707698 708450 708894 709292 709819 719837 720074 723155 723432 726907 728741 731037 733534 734521 736425 744494 752876 759653 761459 761949 763378 764923 774534 775009 775013 780936 795483 803258 804210 808095 811906 814111 814675 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big load"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие load"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие load"
]
|
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.