Query Metrics
7
Database Queries
7
Different statements
185.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.28 ms (83.31%) |
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 393585 393724 406018 421271 424259 440569 442973 445672 452677 454635 473869 473920 493464 503127 507512 508838 509678 509983 510396 514125 519576 521931 523402 524777 525050 528459 530020 530486 530630 530696 531104 531115 531165 531182 531215 532245 532751 532754 532772 532812 532995 533369 533373 533773 534028 534985 535048 536293 536402 536689 537654 537661 537670 537863 537911 540398 540400 540405 542583 544825 551275 560834 565153 565245 577903 579194 582697 584759 584907 587311 593882 599835 600200 600249 600271 600289 600312 601535 618381 628399 629045 630526 631163 631195 632277 633718 634115 634193 634543 635215 635224 636308 636320 637729 638298 639748 639783 639810 640763 640784 640813 643112 644373 644916 646771 646896 648220 648254 648499 648853 650330 651148 651631 666899 696582 719333 720072 732878 788136 805146 ] |
||||||||||||||||||||||||||||||
|
19.35 ms (10.45%) |
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 535048 509678 531115 540400 531104 534985 536293 537911 551275 542583 560834 579194 584759 646896 666899 648499 720072 577903 582697 631195 600200 644373 593882 640763 640784 643112 732878 805146 424259 442973 452677 393724 514125 528459 644916 519576 532812 599835 406018 473869 454635 530486 531215 532754 503127 508838 531165 537654 530630 532772 534028 524777 536689 537670 540405 648220 646771 719333 650330 618381 600312 628399 630526 632277 639748 788136 601535 631163 393585 421271 473920 493464 509983 536402 532995 540398 530020 537661 533373 523402 533773 544825 696582 651631 648254 648853 651148 587311 633718 634193 629045 635224 639783 639810 600249 600289 634543 637729 600271 440569 507512 521931 525050 445672 532751 510396 530696 531182 532245 537863 533369 565153 584907 565245 634115 638298 640813 636320 635215 636308 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (2.28%) |
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 393585 393724 406018 421271 424259 440569 442973 445672 452677 454635 473869 473920 493464 503127 507512 508838 509678 509983 510396 514125 519576 521931 523402 524777 525050 528459 530020 530486 530630 530696 531104 531115 531165 531182 531215 532245 532751 532754 532772 532812 532995 533369 533373 533773 534028 534985 535048 536293 536402 536689 537654 537661 537670 537863 537911 540398 540400 540405 542583 544825 551275 560834 565153 565245 577903 579194 582697 584759 584907 587311 593882 599835 600200 600249 600271 600289 600312 601535 618381 628399 629045 630526 631163 631195 632277 633718 634115 634193 634543 635215 635224 636308 636320 637729 638298 639748 639783 639810 640763 640784 640813 643112 644373 644916 646771 646896 648220 648254 648499 648853 650330 651148 651631 666899 696582 719333 720072 732878 788136 805146 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep pussy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep pussy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep pussy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.