Query Metrics
7
Database Queries
7
Different statements
268.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.19 ms (92.10%) |
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 388853 396864 413594 418828 448259 465237 473506 478044 490982 513081 529792 532764 532846 533211 533307 534193 534524 542678 556831 558899 559632 559689 564859 565134 570765 572606 579921 579922 584457 585047 586555 587220 590161 591693 595015 598309 605057 605099 617357 618651 620342 624127 635268 645224 645884 660094 662921 662930 673658 674024 674063 674380 674400 674412 674727 681006 681104 681115 682144 682955 687989 688049 696443 706949 707332 708105 709652 709843 710558 710970 711902 715486 716170 717069 717685 717996 718011 723728 724312 726453 727426 732354 741108 741308 747285 751722 756092 758178 759894 760604 761207 761438 762140 762572 766040 769897 772408 780514 784161 789101 790382 791339 796123 799229 800118 800234 802436 804630 804646 807243 807576 807860 808619 811274 811362 812079 812491 814904 819516 821730 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (4.27%) |
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 448259 513081 465237 473506 490982 564859 418828 413594 478044 542678 624127 587220 558899 570765 717996 717069 807243 718011 759894 559689 819516 674412 534524 812079 572606 709652 709843 681104 645884 717685 682955 618651 761207 761438 800234 598309 529792 388853 533307 682144 674024 727426 747285 586555 662921 687989 741108 808619 762572 585047 821730 559632 715486 674063 617357 591693 772408 688049 590161 605057 758178 800118 681115 814904 696443 799229 769897 812491 726453 762140 807576 533211 708105 605099 579921 620342 760604 766040 791339 732354 723728 681006 711902 579922 396864 710558 674727 780514 811274 707332 645224 710970 595015 804646 660094 807860 756092 674380 716170 789101 804630 796123 532764 532846 534193 706949 674400 662930 556831 802436 790382 724312 741308 784161 811362 584457 635268 751722 673658 565134 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.14%) |
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 388853 396864 413594 418828 448259 465237 473506 478044 490982 513081 529792 532764 532846 533211 533307 534193 534524 542678 556831 558899 559632 559689 564859 565134 570765 572606 579921 579922 584457 585047 586555 587220 590161 591693 595015 598309 605057 605099 617357 618651 620342 624127 635268 645224 645884 660094 662921 662930 673658 674024 674063 674380 674400 674412 674727 681006 681104 681115 682144 682955 687989 688049 696443 706949 707332 708105 709652 709843 710558 710970 711902 715486 716170 717069 717685 717996 718011 723728 724312 726453 727426 732354 741108 741308 747285 751722 756092 758178 759894 760604 761207 761438 762140 762572 766040 769897 772408 780514 784161 789101 790382 791339 796123 799229 800118 800234 802436 804630 804646 807243 807576 807860 808619 811274 811362 812079 812491 814904 819516 821730 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love fuck"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love секс"
]
|
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.