Query Metrics
7
Database Queries
7
Different statements
142.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.13 ms (81.99%) |
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 270601 404368 404383 404804 410318 411119 416351 416522 418840 422550 422584 429189 445531 446547 447435 447452 448847 451175 451620 459651 461745 463873 464168 464185 465144 468012 470829 472147 475483 478025 478480 481816 485514 492994 500726 510622 512966 515892 522274 522832 530494 533538 535427 536546 536616 537670 537893 542975 543772 545393 559942 560442 562327 564001 565162 567779 578630 579290 588818 590777 598135 598753 600123 604227 607215 620174 620452 623200 623204 626542 634187 640732 644291 647333 647848 647891 648560 648794 650722 652904 659448 661570 668137 680182 689006 692047 704205 707819 722519 725133 731354 740928 741213 742833 747335 752631 752700 755334 762941 766368 766611 766874 770279 771355 771601 804638 807532 813082 816653 823818 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.93%) |
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 590777 766611 807532 692047 598135 650722 725133 742833 816653 652904 707819 752631 429189 731354 747335 823818 762941 722519 620452 620174 644291 410318 755334 411119 740928 771601 770279 766368 659448 418840 804638 598753 741213 578630 648794 626542 771355 600123 447435 535427 270601 623200 464185 647848 607215 522274 640732 623204 446547 475483 530494 404383 562327 465144 478480 604227 451175 463873 579290 661570 766874 404804 485514 647891 481816 565162 416522 445531 537893 512966 492994 588818 459651 422550 813082 422584 472147 510622 536546 564001 560442 536616 448847 416351 542975 404368 500726 668137 461745 522832 680182 647333 689006 451620 515892 478025 447452 468012 634187 533538 567779 559942 752700 704205 470829 464168 545393 537670 648560 543772 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.44%) |
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 270601 404368 404383 404804 410318 411119 416351 416522 418840 422550 422584 429189 445531 446547 447435 447452 448847 451175 451620 459651 461745 463873 464168 464185 465144 468012 470829 472147 475483 478025 478480 481816 485514 492994 500726 510622 512966 515892 522274 522832 530494 533538 535427 536546 536616 537670 537893 542975 543772 545393 559942 560442 562327 564001 565162 567779 578630 579290 588818 590777 598135 598753 600123 604227 607215 620174 620452 623200 623204 626542 634187 640732 644291 647333 647848 647891 648560 648794 650722 652904 659448 661570 668137 680182 689006 692047 704205 707819 722519 725133 731354 740928 741213 742833 747335 752631 752700 755334 762941 766368 766611 766874 770279 771355 771601 804638 807532 813082 816653 823818 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"super anal teen"
]
|
||||||||||||||||||||||||||||||
|
2.27 ms (1.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"super анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"super анал teen"
]
|
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.