Query Metrics
7
Database Queries
7
Different statements
178.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.60 ms (86.19%) |
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 2926 91254 150488 188390 288368 327523 382511 383563 384128 384463 385383 385741 386345 386900 387672 387785 388222 391472 391597 395889 396439 397529 401388 409949 410781 410993 412018 413737 416399 417306 421257 421303 428049 428071 428799 432530 433715 434178 435934 437325 437338 442050 442117 444116 446435 454237 461322 464298 464942 465607 466841 466875 466881 466933 467823 478450 479092 483723 485970 490452 492635 494626 503116 509433 522948 528161 544184 547256 552814 558006 567609 587805 619606 627731 663371 663469 664284 664295 665260 665374 665489 666094 666121 667542 667640 667682 667754 668185 668188 714180 719915 731154 731262 732939 733038 734740 748360 753108 758289 771480 775581 776655 781803 781805 781842 781879 781897 781903 781906 782423 798642 802621 804951 808003 810104 812390 813791 813796 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (8.00%) |
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 444116 435934 417306 466875 503116 434178 509433 150488 327523 396439 413737 466881 483723 391597 384128 395889 387785 416399 421303 428071 437338 442117 446435 461322 464298 464942 465607 466841 544184 547256 558006 552814 567609 432530 466933 467823 433715 437325 478450 391472 428799 409949 410781 428049 454237 479092 421257 528161 485970 490452 492635 522948 385741 386345 91254 383563 384463 385383 188390 288368 382511 2926 388222 387672 397529 401388 442050 410993 813791 813796 494626 663371 663469 666121 667269 667754 668188 719915 666094 666827 667640 668185 714180 664284 664295 665260 665374 665489 667542 667682 619606 627731 587805 781803 781805 781879 781903 810104 812390 776655 804951 808003 731262 753108 781842 781897 782423 802621 734740 732939 733038 731154 748360 758289 771480 775581 781906 798642 412018 386900 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.54%) |
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 2926 91254 150488 188390 288368 327523 382511 383563 384128 384463 385383 385741 386345 386900 387672 387785 388222 391472 391597 395889 396439 397529 401388 409949 410781 410993 412018 413737 416399 417306 421257 421303 428049 428071 428799 432530 433715 434178 435934 437325 437338 442050 442117 444116 446435 454237 461322 464298 464942 465607 466841 466875 466881 466933 467823 478450 479092 483723 485970 490452 492635 494626 503116 509433 522948 528161 544184 547256 552814 558006 567609 587805 619606 627731 663371 663469 664284 664295 665260 665374 665489 666094 666121 667542 667640 667682 667754 668185 668188 714180 719915 731154 731262 732939 733038 734740 748360 753108 758289 771480 775581 776655 781803 781805 781842 781879 781897 781903 781906 782423 798642 802621 804951 808003 810104 812390 813791 813796 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышка с натуральными …"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.99%) |
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.