Query Metrics
7
Database Queries
7
Different statements
152.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.42 ms (82.11%) |
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 391947 398965 398993 426870 452651 455127 462130 470937 471969 476636 482955 483960 485383 485421 485971 495573 500429 506074 509749 520366 536447 537078 544978 548049 556601 558000 571132 590525 599985 600272 600813 619899 621376 628672 631322 640898 644622 650064 650641 658431 659938 666515 695358 700899 714189 719408 725220 725247 725251 725459 725483 725497 725498 725539 731088 731151 735828 735925 735944 736010 736381 739634 739935 741211 741713 741737 741765 742544 742562 742765 744167 744388 744396 744400 744416 744435 745321 745373 746132 747245 749604 762177 787654 790193 792538 794816 795927 795947 795956 795990 799713 800729 800734 800741 800749 803440 807016 807017 819350 819962 823848 824294 825320 825361 825433 825435 825858 825882 826127 826194 826197 826303 826374 826582 826927 827181 827594 827657 827669 827725 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (9.84%) |
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 742544 742562 742765 749604 631322 719408 795956 826127 462130 391947 790193 455127 471969 520366 485383 398965 495573 485421 452651 500429 548049 650064 666515 741737 741713 426870 485971 476636 483960 398993 470937 482955 825361 825435 823848 825320 825433 825858 826374 826582 826927 827181 827594 827725 819962 826197 819350 824294 825882 826194 826303 827657 827669 537078 506074 509749 536447 544978 556601 571132 558000 650641 695358 714189 658431 700899 659938 600272 640898 644622 590525 621376 628672 599985 600813 619899 792538 795990 800729 800741 800749 787654 794816 795947 800734 807016 807017 725247 725251 725459 725483 731088 735925 735944 741211 744167 745373 747245 795927 799713 803440 725220 735828 736381 739634 744396 744416 744435 745321 762177 725497 731151 736010 739935 741765 744388 744400 746132 725498 725539 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (2.80%) |
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 391947 398965 398993 426870 452651 455127 462130 470937 471969 476636 482955 483960 485383 485421 485971 495573 500429 506074 509749 520366 536447 537078 544978 548049 556601 558000 571132 590525 599985 600272 600813 619899 621376 628672 631322 640898 644622 650064 650641 658431 659938 666515 695358 700899 714189 719408 725220 725247 725251 725459 725483 725497 725498 725539 731088 731151 735828 735925 735944 736010 736381 739634 739935 741211 741713 741737 741765 742544 742562 742765 744167 744388 744396 744400 744416 744435 745321 745373 746132 747245 749604 762177 787654 790193 792538 794816 795927 795947 795956 795990 799713 800729 800734 800741 800749 803440 807016 807017 819350 819962 823848 824294 825320 825361 825433 825435 825858 825882 826127 826194 826197 826303 826374 826582 826927 827181 827594 827657 827669 827725 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam chubby russian"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер chubby русск"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер chubby русск"
]
|
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.