Query Metrics
7
Database Queries
7
Different statements
204.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.36 ms (84.80%) |
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 384223 386568 387270 391644 391697 396267 397065 397128 398261 400019 408824 410590 410623 413577 414256 418197 418707 421138 421594 422503 423482 424628 426348 426360 428998 429185 429247 429260 433883 437118 439333 439345 439365 442564 445986 446674 447308 450385 451616 471372 471801 471990 472594 474809 478887 479277 480137 481757 486221 487241 488010 488236 488443 491485 493262 504405 504454 505528 505638 507404 508828 509616 511574 515476 516883 519562 520177 520409 521442 523163 525453 530063 532248 544524 553077 553122 557900 558562 558878 559601 560833 561621 566967 568419 569318 572168 573629 575154 576097 577899 579174 581095 581462 583685 584168 586689 589212 598552 599777 603040 610350 614053 620458 667045 719573 739866 743067 744033 755630 756078 760428 760920 761464 761567 791445 798401 809311 809718 810939 821745 ] |
||||||||||||||||||||||||||||||
|
20.75 ms (10.15%) |
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 586689 598552 599777 603040 610350 614053 589212 798401 809718 743067 744033 756078 760428 760920 761464 791445 810939 755630 761567 739866 620458 719573 809311 397128 408824 410590 413577 421138 428998 439345 446674 447308 414256 429260 442564 480137 396267 418197 424628 426360 439333 439365 471372 384223 391697 397065 400019 426348 429185 481757 515476 523163 504405 507404 508828 525453 486221 487241 488443 491485 520177 584168 581095 386568 391644 387270 398261 410623 418707 423482 433883 437118 421594 422503 429247 821745 445986 474809 479277 488010 451616 471990 478887 450385 471801 472594 493262 516883 520409 509616 505528 505638 519562 521442 504454 511574 530063 532248 488236 544524 557900 559601 566967 568419 573629 553077 561621 569318 572168 575154 577899 579174 581462 583685 553122 558562 558878 560833 576097 667045 ] |
||||||||||||||||||||||||||||||
|
4.51 ms (2.20%) |
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 384223 386568 387270 391644 391697 396267 397065 397128 398261 400019 408824 410590 410623 413577 414256 418197 418707 421138 421594 422503 423482 424628 426348 426360 428998 429185 429247 429260 433883 437118 439333 439345 439365 442564 445986 446674 447308 450385 451616 471372 471801 471990 472594 474809 478887 479277 480137 481757 486221 487241 488010 488236 488443 491485 493262 504405 504454 505528 505638 507404 508828 509616 511574 515476 516883 519562 520177 520409 521442 523163 525453 530063 532248 544524 553077 553122 557900 558562 558878 559601 560833 561621 566967 568419 569318 572168 573629 575154 576097 577899 579174 581095 581462 583685 584168 586689 589212 598552 599777 603040 610350 614053 620458 667045 719573 739866 743067 744033 755630 756078 760428 760920 761464 761567 791445 798401 809311 809718 810939 821745 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tight skinny"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tight худые"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tight худые"
]
|
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.