Query Metrics
7
Database Queries
7
Different statements
191.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.67 ms (86.18%) |
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 141512 319102 395136 397680 404316 415702 423480 426841 434561 453716 457418 460739 488130 495138 496464 498056 499786 505460 506436 507193 510027 510209 513823 516222 516367 517125 519713 520191 522498 524607 528813 528823 529903 534253 536796 549744 555993 559936 565716 573391 573758 583674 584172 588418 589685 591400 592935 593032 606731 610179 610197 618476 619920 625980 628044 629766 631334 642935 643072 647645 654683 664555 668131 671492 676424 680745 706537 726528 726550 731134 734952 735013 735126 740665 742404 758663 760648 760982 762514 767465 775145 777258 778546 782815 790888 792524 795322 795904 796925 801304 801532 803749 804246 813722 814850 816150 816686 817189 817771 817809 817826 819403 819921 820161 823647 824587 824614 824657 824756 825089 825826 826260 826265 826393 826481 826542 827544 827713 828417 828664 ] |
||||||||||||||||||||||||||||||
|
16.43 ms (8.60%) |
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 499786 680745 824614 817809 647645 522498 495138 513823 510209 496464 528823 549744 555993 584172 573391 676424 589685 629766 591400 643072 742404 726550 423480 507193 524607 824657 519713 517125 628044 395136 534253 734952 817826 826393 610197 528813 516222 565716 559936 573758 654683 593032 726528 434561 506436 817771 790888 820161 825089 801532 619920 505460 404316 618476 816150 731134 453716 814850 415702 319102 813722 778546 775145 777258 460739 795322 819403 819921 826265 827544 826260 824756 828417 828664 583674 782815 803749 141512 498056 457418 606731 610179 520191 816686 817189 826481 826542 823647 827713 824587 488130 795904 735126 801304 758663 760648 631334 397680 825826 706537 625980 804246 740665 792524 735013 760982 762514 767465 642935 796925 664555 671492 426841 516367 529903 536796 510027 668131 592935 588418 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.37%) |
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 141512 319102 395136 397680 404316 415702 423480 426841 434561 453716 457418 460739 488130 495138 496464 498056 499786 505460 506436 507193 510027 510209 513823 516222 516367 517125 519713 520191 522498 524607 528813 528823 529903 534253 536796 549744 555993 559936 565716 573391 573758 583674 584172 588418 589685 591400 592935 593032 606731 610179 610197 618476 619920 625980 628044 629766 631334 642935 643072 647645 654683 664555 668131 671492 676424 680745 706537 726528 726550 731134 734952 735013 735126 740665 742404 758663 760648 760982 762514 767465 775145 777258 778546 782815 790888 792524 795322 795904 796925 801304 801532 803749 804246 813722 814850 816150 816686 817189 817771 817809 817826 819403 819921 820161 823647 824587 824614 824657 824756 825089 825826 826260 826265 826393 826481 826542 827544 827713 828417 828664 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage for wife"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж жен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
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.