Query Metrics
7
Database Queries
7
Different statements
158.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.32 ms (80.99%) |
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 398195 402384 420122 421485 440908 457642 487699 518022 528600 538986 539701 540130 540860 540865 542968 553088 553636 553889 556060 569220 578312 583624 587467 591089 604358 617242 617254 628732 634033 635759 636610 638087 643338 646077 651579 654920 659469 660650 661004 661656 662159 662171 667242 676196 688129 698832 699135 703280 703628 714986 715009 716597 716699 720008 720208 727721 729704 734201 736962 738538 740423 741857 744692 749101 751372 754172 759083 761873 762600 763039 766563 767054 771227 774770 775635 778086 778149 778665 780124 780482 782872 782943 783297 783882 784203 784226 784340 785549 787217 787938 788992 791223 791380 791383 794066 794294 796375 796788 796859 796878 796889 797752 799781 803313 803989 804195 804975 807212 807531 809137 809805 810339 810426 810493 812559 814160 817755 819954 827166 ] |
||||||||||||||||||||||||||||||
|
19.94 ms (12.58%) |
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 784226 791223 794066 794294 796859 804975 810493 791383 796878 759083 784203 803313 810339 734201 766563 729704 767054 763039 751372 776045 780124 782872 796788 804195 807212 807531 421485 457642 540865 540130 542968 553636 583624 651579 659469 660650 688129 703628 667242 703280 646077 654920 661656 662171 676196 698832 699135 553088 634033 636610 643338 591089 604358 635759 754172 518022 716699 628732 398195 420122 817755 819954 827166 553889 569220 661004 720008 720208 716597 578312 638087 810426 775635 778086 778665 780482 787938 788992 727721 784340 803989 812559 741857 744692 749101 771227 740423 736962 761873 617242 617254 783297 783882 797752 809137 528600 402384 538986 587467 556060 738538 440908 814160 540860 487699 539701 662159 715009 774770 778149 796889 799781 791380 796375 809805 782943 762600 714986 785549 787217 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.79%) |
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 398195 402384 420122 421485 440908 457642 487699 518022 528600 538986 539701 540130 540860 540865 542968 553088 553636 553889 556060 569220 578312 583624 587467 591089 604358 617242 617254 628732 634033 635759 636610 638087 643338 646077 651579 654920 659469 660650 661004 661656 662159 662171 667242 676196 688129 698832 699135 703280 703628 714986 715009 716597 716699 720008 720208 727721 729704 734201 736962 738538 740423 741857 744692 749101 751372 754172 759083 761873 762600 763039 766563 767054 771227 774770 775635 778086 778149 778665 780124 780482 782872 782943 783297 783882 784203 784226 784340 785549 787217 787938 788992 791223 791380 791383 794066 794294 796375 796788 796859 796878 796889 797752 799781 803313 803989 804195 804975 807212 807531 809137 809805 810339 810426 810493 812559 814160 817755 819954 827166 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite amateur"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite любительск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite любительск"
]
|
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.