Query Metrics
7
Database Queries
7
Different statements
174.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.03 ms (86.12%) |
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 460764 465145 470266 505718 512890 524471 529029 530314 530366 531672 532089 532828 539161 543755 549950 553604 566738 570780 589922 599800 600005 618345 627691 643107 646931 654777 655686 655737 658250 659318 664010 664235 664944 668227 669641 671000 672561 675467 675769 681148 681891 684346 687411 687526 689953 692101 696226 701466 705895 707271 707274 709471 711570 717897 719966 722104 726296 727794 729784 732410 734052 735597 735982 739524 745352 749100 751037 756828 759111 760120 765071 771739 772673 777133 780648 780719 781404 788239 789270 790052 792042 798357 804036 806097 808849 809796 811376 815125 815494 816462 817002 818237 818240 818302 818362 818433 818452 818769 818904 820628 822671 823905 824657 824755 825535 826190 826339 826399 826459 826839 828287 828623 828722 ] |
||||||||||||||||||||||||||||||
|
12.75 ms (7.32%) |
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 820628 823905 824755 825034 826459 818362 824605 818237 818433 824205 824945 817002 818904 826399 828287 828091 828101 828722 828623 531672 530314 532089 532828 530366 539161 549950 570780 655686 664010 669641 675769 646931 654777 684346 687526 701466 707274 655737 658250 664944 668227 675467 681891 692101 707271 719966 566738 643107 618345 627691 780719 788239 790052 729784 732410 772673 726296 751037 759111 780648 781404 818240 822671 815125 818452 815494 816462 529029 543755 659318 664235 687411 705895 599800 792042 804036 739524 760120 789270 808849 765071 735597 735982 806097 460764 505718 465145 524471 671000 681148 722104 689953 709471 711570 672561 553604 589922 600005 777133 798357 811376 756828 745352 734052 771739 809796 512890 696226 717897 749100 727794 470266 825535 826189 826190 818302 818769 824657 826339 826839 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens hair"
]
|
||||||||||||||||||||||||||||||
|
2.69 ms (1.55%) |
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 460764 465145 470266 505718 512890 524471 529029 530314 530366 531672 532089 532828 539161 543755 549950 553604 566738 570780 589922 599800 600005 618345 627691 643107 646931 654777 655686 655737 658250 659318 664010 664235 664944 668227 669641 671000 672561 675467 675769 681148 681891 684346 687411 687526 689953 692101 696226 701466 705895 707271 707274 709471 711570 717897 719966 722104 726296 727794 729784 732410 734052 735597 735982 739524 745352 749100 751037 756828 759111 760120 765071 771739 772673 777133 780648 780719 781404 788239 789270 790052 792042 798357 804036 806097 808849 809796 811376 815125 815494 816462 817002 818237 818240 818302 818362 818433 818452 818769 818904 820628 822671 823905 824657 824755 825535 826190 826339 826399 826459 826839 828287 828623 828722 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens hair"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens hair"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
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.