Query Metrics
7
Database Queries
7
Different statements
198.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.47 ms (85.75%) |
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 78926 305336 306089 385285 385744 391089 391634 391893 391898 391904 391938 392109 392178 394586 397895 397899 412603 413643 417067 417844 443838 450213 453612 469137 470505 470579 470600 470634 470637 470654 473321 508723 517584 531606 533690 534074 534132 536959 537405 540122 543360 543381 543384 544739 544748 545052 545102 545431 545766 547947 547988 560368 563659 566451 575233 577437 583446 584018 584605 585269 587860 589200 591165 591167 600955 603544 603578 603600 610811 618193 618236 619168 622101 622125 622183 622819 623221 623346 631329 632851 633537 635794 645048 649094 649291 651259 651310 651433 653343 653435 653612 653617 653758 653830 653866 653903 653952 654689 661889 668059 677081 681740 692438 695777 698086 698104 710274 717607 720877 721988 729216 732666 732690 733202 735078 745548 745896 745906 745917 747560 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (8.53%) |
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 623221 391904 745917 563659 547988 622125 603578 391898 654689 710274 603600 622183 540122 619168 583446 745896 745906 397895 470637 584605 653612 698104 391089 392109 78926 661889 651259 651310 544739 545766 610811 747560 732666 631329 417067 531606 545431 720877 584018 585269 632851 534132 534074 536959 653343 653758 618236 600955 729216 560368 391634 453612 543381 668059 622101 544748 692438 537405 545102 618193 651433 645048 653866 653903 721988 413643 417844 732690 603544 633537 698086 577437 469137 470505 470600 392178 587860 470654 443838 450213 547947 397899 391893 591167 681740 473321 306089 735078 543360 745548 653617 733202 575233 385285 305336 508723 677081 653435 566451 622819 385744 391938 589200 470579 533690 653952 394586 517584 543384 653830 649094 412603 591165 717607 635794 545052 695777 623346 649291 470634 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.65%) |
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 78926 305336 306089 385285 385744 391089 391634 391893 391898 391904 391938 392109 392178 394586 397895 397899 412603 413643 417067 417844 443838 450213 453612 469137 470505 470579 470600 470634 470637 470654 473321 508723 517584 531606 533690 534074 534132 536959 537405 540122 543360 543381 543384 544739 544748 545052 545102 545431 545766 547947 547988 560368 563659 566451 575233 577437 583446 584018 584605 585269 587860 589200 591165 591167 600955 603544 603578 603600 610811 618193 618236 619168 622101 622125 622183 622819 623221 623346 631329 632851 633537 635794 645048 649094 649291 651259 651310 651433 653343 653435 653612 653617 653758 653830 653866 653903 653952 654689 661889 668059 677081 681740 692438 695777 698086 698104 710274 717607 720877 721988 729216 732666 732690 733202 735078 745548 745896 745906 745917 747560 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife swinger мжм"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен свингер мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.83%) |
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.