Query Metrics
7
Database Queries
7
Different statements
583.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.41 ms (36.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик milf"
]
|
||||||||||||||||||||||||||||||
|
206.20 ms (35.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
144.84 ms (24.83%) |
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 309604 310725 389209 390083 391114 395653 494165 507031 511033 524286 527776 527913 528080 529703 530092 530411 530412 531047 531917 531992 532082 533624 535739 535820 536090 537077 537162 537558 537565 537697 538834 539591 539594 540118 541007 544330 544353 545154 545923 546550 547689 547871 549298 549342 549404 549897 549959 550159 550518 552056 552569 553144 553146 553191 554454 554919 557152 558430 565121 566680 566683 567889 569768 569940 574285 576120 581718 587170 588655 589136 591299 592510 592992 603301 603390 609111 610041 615420 615990 625231 628358 629903 662606 664604 666409 668438 669867 709970 714331 732164 733487 739186 751359 754565 755221 768436 786598 788403 791804 795728 796952 800160 804131 807088 810458 816659 817079 817094 817633 818362 818405 818628 819149 819225 820172 823771 824120 824587 827554 827662 ] |
||||||||||||||||||||||||||||||
|
12.66 ms (2.17%) |
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 549404 566680 796952 389209 550159 546550 662606 537565 539591 537077 537162 544353 549897 524286 540118 528080 567889 592510 603301 395653 527776 549298 531917 535739 539594 537558 549959 610041 511033 391114 818405 536090 533624 535820 547871 569940 544330 566683 569768 557152 668438 588655 768436 714331 810458 819225 816659 817633 819149 824120 823771 824587 530412 529703 530411 531992 530092 538834 558430 553144 545154 545923 554919 664604 666409 669867 709970 553146 589136 592992 628358 786598 788403 800160 795728 733487 755221 732164 739186 751359 754565 625231 791804 804131 807088 309604 310725 390083 531047 547689 549342 565121 581718 550518 554454 552056 574285 591299 615990 629903 494165 507031 527913 576120 541007 552569 553191 587170 615420 603390 609111 817079 820172 818362 827554 818628 817094 827662 537697 532082 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (0.58%) |
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 309604 310725 389209 390083 391114 395653 494165 507031 511033 524286 527776 527913 528080 529703 530092 530411 530412 531047 531917 531992 532082 533624 535739 535820 536090 537077 537162 537558 537565 537697 538834 539591 539594 540118 541007 544330 544353 545154 545923 546550 547689 547871 549298 549342 549404 549897 549959 550159 550518 552056 552569 553144 553146 553191 554454 554919 557152 558430 565121 566680 566683 567889 569768 569940 574285 576120 581718 587170 588655 589136 591299 592510 592992 603301 603390 609111 610041 615420 615990 625231 628358 629903 662606 664604 666409 668438 669867 709970 714331 732164 733487 739186 751359 754565 755221 768436 786598 788403 791804 795728 796952 800160 804131 807088 810458 816659 817079 817094 817633 818362 818405 818628 819149 819225 820172 823771 824120 824587 827554 827662 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic milf"
]
|
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.