Query Metrics
7
Database Queries
7
Different statements
173.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.40 ms (85.48%) |
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 187919 391468 425532 432804 451220 452880 469559 489848 497665 515994 519760 531815 534097 547425 551256 553122 557262 563937 564399 566739 568013 579589 584106 602034 613518 628619 629169 630039 630089 635339 639037 640060 643612 652966 655241 656631 657185 661967 662171 663738 668099 669294 679646 683316 695348 695479 696117 697456 699415 701079 711235 711328 712788 714964 715761 715877 719968 720067 720080 723197 723271 723591 725156 728321 728609 731552 733265 736208 740248 742713 742852 744022 750125 750308 756089 757312 761077 762982 765334 765692 767055 767061 768760 776040 777029 780665 781564 781587 783197 783707 788170 788554 789633 790517 791092 793228 794859 795685 796117 796131 800380 800937 803446 804900 805651 816185 816595 817246 817270 820171 821089 821694 822108 822206 822619 825571 827218 827219 827325 827487 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (7.75%) |
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 765692 767055 613518 629169 630039 630089 635339 640060 699415 701079 714964 723271 776040 777029 780665 783707 788554 789633 793228 804900 805651 547425 679646 712788 800937 757312 452880 451220 519760 696117 720080 656631 432804 568013 669294 697456 715761 719968 683316 720067 628619 639037 643612 781587 794859 796131 725156 742852 762982 736208 767061 742713 765334 731552 750125 602034 723197 783197 796117 489848 657185 728609 652966 695479 711235 695348 795685 733265 744022 750308 790517 803446 515994 497665 564399 551256 553122 469559 661967 711328 655241 662171 663738 668099 781564 791092 800380 728321 740248 761077 768760 756089 715877 788170 187919 391468 425532 817246 723591 816185 817270 822108 827219 827325 827487 816595 820171 821694 821089 822206 822619 825571 827218 534097 531815 557262 563937 566739 579589 584106 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.97%) |
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 187919 391468 425532 432804 451220 452880 469559 489848 497665 515994 519760 531815 534097 547425 551256 553122 557262 563937 564399 566739 568013 579589 584106 602034 613518 628619 629169 630039 630089 635339 639037 640060 643612 652966 655241 656631 657185 661967 662171 663738 668099 669294 679646 683316 695348 695479 696117 697456 699415 701079 711235 711328 712788 714964 715761 715877 719968 720067 720080 723197 723271 723591 725156 728321 728609 731552 733265 736208 740248 742713 742852 744022 750125 750308 756089 757312 761077 762982 765334 765692 767055 767061 768760 776040 777029 780665 781564 781587 783197 783707 788170 788554 789633 790517 791092 793228 794859 795685 796117 796131 800380 800937 803446 804900 805651 816185 816595 817246 817270 820171 821089 821694 822108 822206 822619 825571 827218 827219 827325 827487 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal close-up"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал close up"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал close up"
]
|
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.