Query Metrics
7
Database Queries
7
Different statements
591.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
423.72 ms (71.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen худые bbc"
]
|
||||||||||||||||||||||||||||||
|
135.78 ms (22.94%) |
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 282010 382190 419403 425351 426417 428353 429805 434001 448445 452018 454802 460706 468433 468487 473735 481147 491270 499817 507666 508156 513358 517184 517844 520775 530501 531247 532360 532645 534842 536590 536638 536653 537660 537916 539232 540217 541081 543471 543858 543917 545305 545341 545393 545608 545698 550667 551223 556037 556505 557676 558432 559389 564596 566703 568556 568589 571246 583960 586587 586596 588285 592034 596616 598546 599912 600026 601595 602647 605374 606508 615717 617410 623198 623205 627808 627809 628091 628117 629951 630297 630522 630540 630764 631212 632595 632614 632641 632649 632979 633446 633775 634778 637008 637093 637121 640813 645993 646007 647355 648816 648837 649514 649525 649556 649578 657296 658082 676087 676641 677307 677783 678127 678141 678504 679016 679029 679032 679314 679810 687158 ] |
||||||||||||||||||||||||||||||
|
23.74 ms (4.01%) |
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 543471 543917 545608 568556 571246 583960 646007 676087 678141 679016 679810 648816 649556 678127 679029 645993 649578 559389 605374 606508 627809 630297 630522 630540 637121 598546 600026 602647 586596 623205 629951 632614 632979 599912 623198 631212 634778 617410 628091 460706 473735 426417 468433 434001 425351 513358 517844 491270 499817 508156 558432 282010 429805 452018 448445 454802 507666 534842 536638 532360 536590 537660 537916 530501 536653 540217 539232 481147 545305 566703 541081 545341 551223 649525 678504 687158 648837 657296 679314 647355 676641 679032 545393 545698 568589 592034 632649 637093 588285 637008 596616 601595 628117 627808 632641 633446 633775 382190 419403 468487 520775 428353 531247 517184 532645 550667 556505 564596 543858 556037 677783 658082 677307 649514 557676 640813 615717 630764 632595 586587 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (0.54%) |
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 282010 382190 419403 425351 426417 428353 429805 434001 448445 452018 454802 460706 468433 468487 473735 481147 491270 499817 507666 508156 513358 517184 517844 520775 530501 531247 532360 532645 534842 536590 536638 536653 537660 537916 539232 540217 541081 543471 543858 543917 545305 545341 545393 545608 545698 550667 551223 556037 556505 557676 558432 559389 564596 566703 568556 568589 571246 583960 586587 586596 588285 592034 596616 598546 599912 600026 601595 602647 605374 606508 615717 617410 623198 623205 627808 627809 628091 628117 629951 630297 630522 630540 630764 631212 632595 632614 632641 632649 632979 633446 633775 634778 637008 637093 637121 640813 645993 646007 647355 648816 648837 649514 649525 649556 649578 657296 658082 676087 676641 677307 677783 678127 678141 678504 679016 679029 679032 679314 679810 687158 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen skinny bbc"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen худые bbc"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.28%) |
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.