Query Metrics
7
Database Queries
7
Different statements
406.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.93 ms (51.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
172.47 ms (42.47%) |
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 78637 100449 142598 210661 383227 391897 398995 403243 410911 426365 470600 476437 479067 530828 531860 532659 532670 533054 533646 533689 534907 535789 538141 538883 539018 540122 542513 543757 543943 544746 544879 544956 545014 546544 551524 563387 576512 583958 585583 586562 588116 593075 603658 603690 604698 606772 617692 618260 622116 622166 622179 622322 630668 630712 631986 632405 633049 635780 635840 635859 635863 635872 639075 640233 641865 649627 649639 650642 650815 650825 651313 651318 651422 652122 653154 653603 653615 653628 653634 653780 653807 653880 654256 654293 671501 685521 691616 692463 693794 694128 696167 696992 698109 698129 699430 699488 702302 702684 703211 705409 708060 708919 714080 714404 716172 717062 718742 718964 721932 721982 723971 725096 731032 733076 733577 734388 761504 762268 775130 787686 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (4.06%) |
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 635859 717062 721932 721982 775130 142598 210661 650825 698109 476437 698129 787686 692463 479067 693794 699430 654256 708919 635872 540122 649639 652122 653634 671501 694128 702302 708060 714080 714404 649627 651313 653154 653628 699488 651318 653603 653615 653780 653880 654293 691616 696167 630668 639075 622179 640233 641865 586562 603658 622116 630712 633049 635780 635840 635863 603690 631986 617692 618260 622166 632405 696992 702684 705409 531860 533689 535789 530828 538141 533054 539018 546544 685521 703211 653807 650642 545014 604698 606772 593075 733076 398995 410911 563387 470600 383227 100449 391897 78637 403243 426365 534907 532659 538883 533646 532670 542513 543943 544879 551524 543757 544746 544956 576512 650815 718742 718964 651422 716172 583958 588116 622322 585583 723971 734388 761504 762268 725096 731032 733577 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (0.77%) |
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 78637 100449 142598 210661 383227 391897 398995 403243 410911 426365 470600 476437 479067 530828 531860 532659 532670 533054 533646 533689 534907 535789 538141 538883 539018 540122 542513 543757 543943 544746 544879 544956 545014 546544 551524 563387 576512 583958 585583 586562 588116 593075 603658 603690 604698 606772 617692 618260 622116 622166 622179 622322 630668 630712 631986 632405 633049 635780 635840 635859 635863 635872 639075 640233 641865 649627 649639 650642 650815 650825 651313 651318 651422 652122 653154 653603 653615 653628 653634 653780 653807 653880 654256 654293 671501 685521 691616 692463 693794 694128 696167 696992 698109 698129 699430 699488 702302 702684 703211 705409 708060 708919 714080 714404 716172 717062 718742 718964 721932 721982 723971 725096 731032 733076 733577 734388 761504 762268 775130 787686 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swinger amateurs"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер любительск"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.33%) |
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.