Query Metrics
7
Database Queries
7
Different statements
356.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.31 ms (59.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер куколд"
]
|
||||||||||||||||||||||||||||||
|
119.66 ms (33.54%) |
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 338098 386595 391934 460689 467573 479067 482120 484838 492040 507174 519104 531860 532717 542058 542062 542082 542513 542766 544771 544956 544972 544992 545014 545431 546720 547814 551532 552380 552488 552783 554228 556436 557345 560454 560486 562588 563659 565936 566394 566431 574396 579813 581468 583072 584245 586562 588767 589141 589598 591932 602988 603560 604985 604991 605410 605485 605604 606497 606772 614444 618260 621779 627846 631986 632403 632405 635840 636232 636510 641865 650528 650642 651003 653758 653780 654261 661300 661536 663328 671235 672281 695784 695799 697548 699428 702684 708060 713444 714024 714548 714618 716199 716378 717461 718742 723967 723971 724265 725094 727723 728742 729170 730753 731364 731480 732553 732697 732792 733150 733202 733243 733367 733577 734413 742678 748454 748711 755011 759760 761509 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (4.62%) |
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 606497 729170 761509 733202 733243 713444 519104 552380 552783 560454 584245 661300 482120 492040 560486 552488 566431 544972 650528 651003 671235 557345 581468 588767 632403 604991 748454 755011 732697 603560 627846 727723 531860 532717 479067 542513 566394 544771 544956 562588 695799 708060 718742 650642 653780 654261 714548 545014 606772 641865 586562 614444 635840 604985 605410 631986 723971 725094 733367 728742 733577 734413 732792 733150 742678 618260 632405 697548 702684 716199 542062 551532 547814 556436 338098 542058 542766 545431 579813 653758 661536 672281 695784 714024 717461 663328 716378 589141 602988 605604 636232 605485 636510 723967 730753 731364 759760 724265 748711 699428 714618 386595 467573 460689 546720 554228 563659 583072 565936 591932 589598 621779 732553 391934 507174 731480 484838 544992 574396 542082 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (0.96%) |
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 338098 386595 391934 460689 467573 479067 482120 484838 492040 507174 519104 531860 532717 542058 542062 542082 542513 542766 544771 544956 544972 544992 545014 545431 546720 547814 551532 552380 552488 552783 554228 556436 557345 560454 560486 562588 563659 565936 566394 566431 574396 579813 581468 583072 584245 586562 588767 589141 589598 591932 602988 603560 604985 604991 605410 605485 605604 606497 606772 614444 618260 621779 627846 631986 632403 632405 635840 636232 636510 641865 650528 650642 651003 653758 653780 654261 661300 661536 663328 671235 672281 695784 695799 697548 699428 702684 708060 713444 714024 714548 714618 716199 716378 717461 718742 723967 723971 724265 725094 727723 728742 729170 730753 731364 731480 732553 732697 732792 733150 733202 733243 733367 733577 734413 742678 748454 748711 755011 759760 761509 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swinger cuckold"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.48%) |
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.