Query Metrics
7
Database Queries
7
Different statements
143.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.06 ms (83.13%) |
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 78976 401537 428111 446537 462061 465252 473823 473854 483495 485470 485854 486005 492567 494215 495020 499648 503989 505298 505587 508257 511319 511328 512876 524036 526589 528562 528603 535254 536745 536756 540711 541347 545154 550809 557712 559290 570882 578801 580302 582163 583288 584428 584438 592219 594552 600904 603374 606667 606784 606804 606875 607378 615045 615416 618268 619277 620568 624425 625092 627126 628228 628582 629622 630152 631073 635201 635734 636646 637249 641422 643645 650916 656217 663808 671462 671694 699970 699988 700013 704097 704122 705030 705117 705372 705481 705487 705502 705871 708397 714373 714525 714584 714824 715154 716726 717387 717437 718018 718887 725189 725533 725551 733583 741061 742578 746693 751269 752178 762757 768656 780941 787262 788437 792696 792728 795820 804020 808304 808309 811929 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (10.07%) |
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 725533 808304 536745 485854 582163 717387 671462 808309 787262 725551 768656 580302 550809 716726 788437 78976 446537 473823 505298 528603 494215 401537 545154 704122 656217 700013 699970 705487 714525 718887 635734 615045 628228 619277 592219 600904 630152 699988 705117 705871 804020 505587 584438 483495 524036 714824 570882 606875 733583 741061 792728 742578 627126 780941 584428 624425 618268 625092 540711 536756 462061 583288 718018 795820 811929 746693 752178 792696 473854 465252 503989 526589 511328 559290 628582 495020 541347 557712 650916 671694 705372 708397 714584 705030 714373 705481 705502 606667 606784 606804 620568 631073 637249 603374 615416 629622 641422 594552 607378 636646 663808 643645 635201 428111 485470 492567 512876 511319 508257 528562 486005 578801 535254 499648 717437 704097 715154 725189 751269 762757 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.78%) |
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 78976 401537 428111 446537 462061 465252 473823 473854 483495 485470 485854 486005 492567 494215 495020 499648 503989 505298 505587 508257 511319 511328 512876 524036 526589 528562 528603 535254 536745 536756 540711 541347 545154 550809 557712 559290 570882 578801 580302 582163 583288 584428 584438 592219 594552 600904 603374 606667 606784 606804 606875 607378 615045 615416 618268 619277 620568 624425 625092 627126 628228 628582 629622 630152 631073 635201 635734 636646 637249 641422 643645 650916 656217 663808 671462 671694 699970 699988 700013 704097 704122 705030 705117 705372 705481 705487 705502 705871 708397 714373 714525 714584 714824 715154 716726 717387 717437 718018 718887 725189 725533 725551 733583 741061 742578 746693 751269 752178 762757 768656 780941 787262 788437 792696 792728 795820 804020 808304 808309 811929 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pregnant"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск беремен"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.11%) |
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.