Query Metrics
7
Database Queries
7
Different statements
192.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.31 ms (87.06%) |
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 388022 397005 400005 400006 402032 410775 417370 424612 440047 458116 462674 468343 470315 479446 483702 489321 492310 496247 507214 530968 536100 537774 540556 540753 546428 547088 548418 553263 556069 558402 559863 560215 565939 569266 573708 579706 589700 591320 612161 616500 628339 630468 650495 650572 651977 662097 664602 668016 669860 670514 671518 671875 679699 683698 684876 690633 693219 698814 701465 703279 704629 705018 706784 709707 709872 710210 713841 714383 722709 726844 728392 729058 730267 734416 735106 740431 743260 744149 748773 752289 752852 760609 763473 770704 770730 771158 776079 777862 778275 779948 780376 782520 782987 783169 786225 786669 787405 791873 793524 794182 794968 796391 800319 800721 801606 803351 809907 810762 813429 815028 819052 819153 824063 824077 824825 827711 827952 827963 827981 828535 ] |
||||||||||||||||||||||||||||||
|
13.81 ms (7.19%) |
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 616500 612161 628339 777862 782520 786225 793524 794968 800319 801606 810762 776079 778275 779948 787405 791873 796391 800721 803351 729058 744149 770704 770730 771158 782987 783169 794182 726844 728392 730267 735106 740431 763473 734416 748773 760609 703279 709872 713841 722709 780376 786669 809907 813429 400006 402032 417370 470315 388022 397005 424612 483702 536100 558402 573708 668016 671518 548418 591320 630468 462674 671875 743260 752852 752289 560215 507214 589700 400005 440047 410775 824077 819052 827711 819153 824063 815028 824825 827981 827952 827963 828535 458116 479446 468343 489321 530968 540556 496247 540753 537774 492310 546428 553263 559863 547088 565939 569266 556069 579706 650495 651977 662097 664602 669860 670514 684876 701465 706784 650572 679699 683698 690633 693219 698814 704629 705018 709707 710210 714383 ] |
||||||||||||||||||||||||||||||
|
4.31 ms (2.24%) |
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 388022 397005 400005 400006 402032 410775 417370 424612 440047 458116 462674 468343 470315 479446 483702 489321 492310 496247 507214 530968 536100 537774 540556 540753 546428 547088 548418 553263 556069 558402 559863 560215 565939 569266 573708 579706 589700 591320 612161 616500 628339 630468 650495 650572 651977 662097 664602 668016 669860 670514 671518 671875 679699 683698 684876 690633 693219 698814 701465 703279 704629 705018 706784 709707 709872 710210 713841 714383 722709 726844 728392 729058 730267 734416 735106 740431 743260 744149 748773 752289 752852 760609 763473 770704 770730 771158 776079 777862 778275 779948 780376 782520 782987 783169 786225 786669 787405 791873 793524 794182 794968 796391 800319 800721 801606 803351 809907 810762 813429 815028 819052 819153 824063 824077 824825 827711 827952 827963 827981 828535 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina hot"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин hot"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин hot"
]
|
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.