Query Metrics
7
Database Queries
7
Different statements
185.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.97 ms (84.82%) |
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 233353 388557 389351 391472 391477 391583 392601 392602 396758 400813 401952 406648 406882 411340 420652 422246 422299 422824 423979 429945 436393 443692 443951 444131 446958 447098 447485 451498 453606 454129 457510 458152 462019 462170 462546 462737 464185 464668 465964 466306 466677 466929 468888 470183 470381 470642 473761 475543 475882 477007 477176 479044 479046 479053 479055 479083 480857 485695 486363 486894 486915 487048 489084 489874 490885 490893 491907 491975 492234 494386 494402 506077 506419 506659 508568 509439 511879 516258 521528 524368 526734 527978 531707 533125 533743 534631 535593 541727 543584 543762 546716 554235 559059 560400 561885 562963 563038 563104 564363 572765 576391 577834 595443 595516 596657 597498 597601 598033 598452 598753 600279 605742 613871 617115 663254 676825 678915 681782 761949 791445 ] |
||||||||||||||||||||||||||||||
|
18.19 ms (9.83%) |
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 470642 462019 475882 489084 489874 524368 511879 559059 563104 577834 389351 392601 392602 470183 233353 462737 479046 494386 596657 466677 531707 663254 676825 595443 597601 791445 761949 451498 466306 477007 487048 516258 411340 533125 541727 543584 572765 678915 388557 458152 401952 447485 457510 420652 443692 462546 464668 526734 486363 491975 454129 561885 563038 562963 598033 473761 477176 391472 391583 422299 479044 406882 491907 494402 490893 465964 506077 521528 681782 598452 597498 613871 479083 422246 396758 617115 546716 598753 391477 480857 422824 453606 406648 447098 470381 443951 508568 506419 527978 479053 535593 533743 576391 595516 605742 468888 462170 429945 600279 436393 554235 560400 400813 423979 446958 490885 492234 486915 485695 534631 564363 464185 466929 444131 479055 486894 509439 475543 506659 543762 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.74%) |
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 233353 388557 389351 391472 391477 391583 392601 392602 396758 400813 401952 406648 406882 411340 420652 422246 422299 422824 423979 429945 436393 443692 443951 444131 446958 447098 447485 451498 453606 454129 457510 458152 462019 462170 462546 462737 464185 464668 465964 466306 466677 466929 468888 470183 470381 470642 473761 475543 475882 477007 477176 479044 479046 479053 479055 479083 480857 485695 486363 486894 486915 487048 489084 489874 490885 490893 491907 491975 492234 494386 494402 506077 506419 506659 508568 509439 511879 516258 521528 524368 526734 527978 531707 533125 533743 534631 535593 541727 543584 543762 546716 554235 559059 560400 561885 562963 563038 563104 564363 572765 576391 577834 595443 595516 596657 597498 597601 598033 598452 598753 600279 605742 613871 617115 663254 676825 678915 681782 761949 791445 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot russian"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot русск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot русск"
]
|
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.