Query Metrics
7
Database Queries
7
Different statements
191.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.07 ms (86.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 338338 410664 414739 420108 457388 474093 481606 485751 494280 494732 494975 496296 499188 501518 503786 508272 517635 519207 522602 523198 526103 526353 530250 533274 534488 534964 536458 536503 537380 539546 544580 546335 547581 552044 552299 553237 554751 555460 555546 555578 555667 556645 557912 559674 560467 560560 563831 564667 565029 565370 565380 567009 567618 568081 570094 571836 573062 575557 577166 577849 579775 581041 584774 587529 588216 588398 589106 590185 590740 590852 591134 591946 595985 598294 599461 601463 604917 606424 607353 610252 612302 613663 613937 615944 619322 620349 622625 623105 623304 626773 628678 628719 631401 639958 643624 644037 646186 646233 650691 654228 655667 658489 660545 663038 680102 681443 681507 689084 691151 691699 725201 737657 744233 753238 755138 773870 786008 792165 ] |
||||||||||||||||||||||||||||||
|
16.00 ms (8.35%) |
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 691151 591946 628719 494280 533274 534488 503786 571836 546335 547581 655667 570094 643624 601463 623304 474093 536458 523198 499188 555578 567009 590740 573062 567618 575557 606424 615944 481606 544580 565029 650691 654228 623105 755138 631401 660545 568081 485751 536503 556645 646233 588398 587529 526353 604917 681443 526103 508272 501518 584774 557912 689084 620349 619322 579775 628678 639958 773870 338338 494975 581041 646186 613663 658489 663038 691699 588216 610252 778252 786008 725201 792165 737657 744233 753238 410664 530250 577166 595985 457388 519207 555667 599461 494732 522602 517635 534964 564667 552299 554751 559674 563831 680102 560467 565370 565380 598294 626773 613937 607353 612302 622625 420108 537380 555460 644037 414739 496296 539546 555546 577849 560560 555656 681507 552044 553237 589106 591134 590852 590185 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.71%) |
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 338338 410664 414739 420108 457388 474093 481606 485751 494280 494732 494975 496296 499188 501518 503786 508272 517635 519207 522602 523198 526103 526353 530250 533274 534488 534964 536458 536503 537380 539546 544580 546335 547581 552044 552299 553237 554751 555460 555546 555578 555667 556645 557912 559674 560467 560560 563831 564667 565029 565370 565380 567009 567618 568081 570094 571836 573062 575557 577166 577849 579775 581041 584774 587529 588216 588398 589106 590185 590740 590852 591134 591946 595985 598294 599461 601463 604917 606424 607353 610252 612302 613663 613937 615944 619322 620349 622625 623105 623304 626773 628678 628719 631401 639958 643624 644037 646186 646233 650691 654228 655667 658489 660545 663038 680102 681443 681507 689084 691151 691699 725201 737657 744233 753238 755138 773870 786008 792165 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пизда ебут"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.86%) |
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.