Query Metrics
7
Database Queries
7
Different statements
198.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.40 ms (87.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 3 27757 28396 28397 200033 204849 382540 385301 385702 400645 420734 424153 433013 436392 438102 452962 455676 457725 458889 462299 478223 481557 484002 484253 486083 497054 497654 502805 504132 506575 507033 510412 515825 518239 522372 523958 524084 527246 527583 528680 528909 528976 531154 532351 534365 534366 535214 537290 540233 543598 544564 544610 546756 548227 548602 549631 551601 551797 552768 553330 554965 558450 559262 559741 560538 560746 560763 562364 562454 562618 562713 564239 567686 568782 570764 571077 572600 572891 575615 576742 579123 579495 579516 581007 584429 586997 590329 594505 599357 604775 605218 606518 609580 614264 614350 614377 614382 619012 622893 636633 637176 638517 644198 644901 655268 655541 657817 661492 667919 670835 685479 721968 722014 736457 757830 763744 789078 792997 793214 794924 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (7.67%) |
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 637176 793214 523958 507033 584429 655268 661492 757830 551601 522372 452962 527246 586997 528909 560763 567686 544610 571077 604775 614382 424153 527583 528680 510412 548227 564239 792997 481557 484253 562364 644198 644901 558450 636633 736457 605218 544564 548602 462299 721968 763744 518239 559262 560538 581007 436392 599357 484002 562713 685479 614377 478223 534365 486083 537290 549631 576742 594505 204849 3 638517 400645 528976 551797 562618 562454 614350 515825 540233 552768 657817 609580 497654 531154 504132 554965 655541 619012 385301 28397 572600 794924 560746 553330 622893 497054 568782 590329 200033 385702 579123 570764 438102 667919 535214 722014 579495 543598 546756 606518 614264 420734 457725 382540 455676 559741 789078 502805 579516 670835 575615 433013 27757 28396 506575 534366 458889 524084 532351 572891 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.28%) |
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 3 27757 28396 28397 200033 204849 382540 385301 385702 400645 420734 424153 433013 436392 438102 452962 455676 457725 458889 462299 478223 481557 484002 484253 486083 497054 497654 502805 504132 506575 507033 510412 515825 518239 522372 523958 524084 527246 527583 528680 528909 528976 531154 532351 534365 534366 535214 537290 540233 543598 544564 544610 546756 548227 548602 549631 551601 551797 552768 553330 554965 558450 559262 559741 560538 560746 560763 562364 562454 562618 562713 564239 567686 568782 570764 571077 572600 572891 575615 576742 579123 579495 579516 581007 584429 586997 590329 594505 599357 604775 605218 606518 609580 614264 614350 614377 614382 619012 622893 636633 637176 638517 644198 644901 655268 655541 657817 661492 667919 670835 685479 721968 722014 736457 757830 763744 789078 792997 793214 794924 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс природа"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс природ"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс природ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.