Query Metrics
7
Database Queries
7
Different statements
244.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.05 ms (90.48%) |
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 385838 388004 398714 401563 417284 422096 436392 439630 443534 448698 459449 470265 472341 476849 480759 483330 485730 487802 488896 489610 489652 490059 497654 502208 503986 504282 504703 510611 511543 522306 522584 525514 526780 527340 528887 529515 529607 534127 534573 546760 548266 550483 552403 555139 558210 560037 565622 566729 567854 568743 568783 571082 572213 577485 581383 582523 583177 586424 590329 592106 597841 607873 614205 614209 614280 614377 614386 617772 618101 619012 622889 625382 626146 627881 630450 637173 637924 644020 644101 671494 673177 686540 687614 689166 695795 696529 704582 705727 705786 725573 730043 736468 740539 740768 745557 746073 747500 748134 757044 758421 758950 760934 762228 764341 765827 768773 777286 779620 782784 783530 783665 789106 789911 794784 797862 799006 801696 810348 813271 ] |
||||||||||||||||||||||||||||||
|
11.22 ms (4.59%) |
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 560037 745557 511543 439630 522584 487802 740539 528887 385838 671494 782784 748134 746073 797862 567854 644101 747500 489652 568783 614205 583177 566729 590329 765827 417284 401563 614209 625382 534127 705727 617772 614386 630450 794784 555139 472341 597841 614280 627881 783530 779620 388004 527340 618101 673177 607873 789911 762228 725573 768773 510611 443534 436392 485730 480759 502208 526780 488896 614377 504282 529515 565622 422096 522306 705786 686540 704582 740768 448698 572213 398714 582523 696529 789106 764341 757044 546760 550483 695795 626146 758950 799006 571082 813271 689166 687614 622889 637924 783665 810348 758421 760934 777286 459449 581383 503986 534573 577485 552403 592106 483330 558210 568743 490059 529607 476849 470265 504703 586424 548266 637173 730043 801696 644020 525514 497654 619012 736468 766254 489610 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (1.71%) |
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 385838 388004 398714 401563 417284 422096 436392 439630 443534 448698 459449 470265 472341 476849 480759 483330 485730 487802 488896 489610 489652 490059 497654 502208 503986 504282 504703 510611 511543 522306 522584 525514 526780 527340 528887 529515 529607 534127 534573 546760 548266 550483 552403 555139 558210 560037 565622 566729 567854 568743 568783 571082 572213 577485 581383 582523 583177 586424 590329 592106 597841 607873 614205 614209 614280 614377 614386 617772 618101 619012 622889 625382 626146 627881 630450 637173 637924 644020 644101 671494 673177 686540 687614 689166 695795 696529 704582 705727 705786 725573 730043 736468 740539 740768 745557 746073 747500 748134 757044 758421 758950 760934 762228 764341 765827 768773 777286 779620 782784 783530 783665 789106 789911 794784 797862 799006 801696 810348 813271 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лес секс"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лес природ секс"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 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.