Query Metrics
7
Database Queries
7
Different statements
205.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.16 ms (87.47%) |
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 402722 421155 424780 424837 433185 462098 465336 465628 465712 469762 472486 478608 479872 499852 501655 507663 508275 512052 516048 518364 518521 519034 520737 521446 521931 524361 524544 524555 525965 526003 526853 527135 527414 531446 532644 541379 541632 541770 542565 543840 550820 552623 553070 554370 554639 555953 557246 561115 563441 563535 564810 566538 566960 567139 568848 569065 569929 574258 576007 577350 580775 583553 586519 586616 589344 590362 591312 591438 592347 593849 593868 594437 595226 599449 601976 603150 603493 603954 604478 605862 609652 610806 611392 612416 613839 614080 614479 614747 615765 617039 617134 617167 617342 618924 619651 620620 621330 621489 622351 622398 622773 623468 624473 624875 625239 625322 631981 634138 634218 652610 653524 653568 662412 667750 671863 672682 674762 681637 696582 782516 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (8.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 478608 518364 561115 550820 576007 667750 624875 595226 782516 631981 465628 617134 603150 421155 526853 542565 564810 589344 634138 586616 531446 568848 624473 592347 577350 618924 462098 524361 652610 569065 605862 612416 525965 472486 526003 519034 586519 593868 553070 609652 619651 617167 625322 580775 583553 662412 594437 615765 521446 516048 527135 557246 590362 591312 613839 653524 566538 617342 621489 617039 512052 524544 555953 653568 566960 574258 599449 402722 469762 527414 501655 569929 681637 614747 622773 567139 424780 524555 508275 433185 563535 696582 672682 593849 521931 520737 563441 591438 604478 532644 601976 518521 554639 554370 603493 614479 620620 625239 541770 507663 541379 622398 610806 671863 623468 424837 465712 541632 622351 479872 674762 603954 465336 543840 552623 634218 614080 611392 621330 499852 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.16%) |
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 402722 421155 424780 424837 433185 462098 465336 465628 465712 469762 472486 478608 479872 499852 501655 507663 508275 512052 516048 518364 518521 519034 520737 521446 521931 524361 524544 524555 525965 526003 526853 527135 527414 531446 532644 541379 541632 541770 542565 543840 550820 552623 553070 554370 554639 555953 557246 561115 563441 563535 564810 566538 566960 567139 568848 569065 569929 574258 576007 577350 580775 583553 586519 586616 589344 590362 591312 591438 592347 593849 593868 594437 595226 599449 601976 603150 603493 603954 604478 605862 609652 610806 611392 612416 613839 614080 614479 614747 615765 617039 617134 617167 617342 618924 619651 620620 621330 621489 622351 622398 622773 623468 624473 624875 625239 625322 631981 634138 634218 652610 653524 653568 662412 667750 671863 672682 674762 681637 696582 782516 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в рот сверху"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в рот наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.60%) |
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.