Query Metrics
7
Database Queries
7
Different statements
148.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.15 ms (84.21%) |
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 30841 31028 185456 388709 406128 417171 420520 422418 425141 426218 426889 447976 448652 455021 461208 469720 480268 482662 483465 491136 494866 496444 497836 505618 505706 506711 507133 511349 514852 515025 515823 516044 518629 522291 525209 525744 526193 527122 527735 528493 528679 528893 529189 529906 531718 533824 535855 537780 538990 539360 540403 541422 541910 542058 543577 544339 550911 552716 554701 554717 556616 558448 559509 560316 560896 560927 561438 564621 565443 566184 567055 569466 574072 576800 576917 579426 582822 584310 586170 588242 588973 593561 596243 596766 601177 605658 606989 608058 610132 618276 625326 636413 637241 639637 645297 647147 647813 649470 652494 658469 668703 668780 672356 675171 680604 684398 687814 691178 708901 713167 727634 728839 750706 770486 770755 778480 789802 799085 805075 810916 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (8.72%) |
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 527735 529906 531718 541910 691178 647147 675171 713167 588242 778480 805075 770755 728839 770486 608058 799085 448652 505706 559509 708901 645297 652494 636413 601177 388709 525209 514852 533824 496444 647813 668780 593561 469720 494866 526193 560316 566184 584310 668703 649470 560927 625326 610132 639637 420520 426889 515823 483465 447976 455021 518629 525744 527122 505618 539360 561438 579426 558448 556616 554717 582822 596766 586170 596243 422418 497836 541422 406128 540403 516044 538990 528679 564621 542058 554701 576800 680604 684398 588973 810916 727634 750706 789802 606989 461208 31028 30841 426218 529189 491136 550911 560896 544339 672356 605658 637241 185456 618276 425141 417171 480268 482662 507133 511349 515025 522291 528893 537780 506711 535855 528493 552716 574072 543577 565443 567055 569466 687814 658469 576917 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.82%) |
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 30841 31028 185456 388709 406128 417171 420520 422418 425141 426218 426889 447976 448652 455021 461208 469720 480268 482662 483465 491136 494866 496444 497836 505618 505706 506711 507133 511349 514852 515025 515823 516044 518629 522291 525209 525744 526193 527122 527735 528493 528679 528893 529189 529906 531718 533824 535855 537780 538990 539360 540403 541422 541910 542058 543577 544339 550911 552716 554701 554717 556616 558448 559509 560316 560896 560927 561438 564621 565443 566184 567055 569466 574072 576800 576917 579426 582822 584310 586170 588242 588973 593561 596243 596766 601177 605658 606989 608058 610132 618276 625326 636413 637241 639637 645297 647147 647813 649470 652494 658469 668703 668780 672356 675171 680604 684398 687814 691178 708901 713167 727634 728839 750706 770486 770755 778480 789802 799085 805075 810916 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"виды вагин"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вид вагин"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
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.