Query Metrics
7
Database Queries
7
Different statements
451.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.61 ms (49.98%) |
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 20617 51456 151564 152529 191420 274758 327898 384050 387186 396030 400006 402032 437417 453972 561920 590067 590183 595544 596301 597585 598293 605040 606417 612161 612285 616500 629573 631714 658523 666041 684847 703104 703279 706894 708790 709544 710360 713841 716757 721522 722055 726119 726844 727407 727425 728218 728392 729058 730267 731174 734416 735106 736103 739133 739959 740431 741243 742186 743124 748773 749279 749945 752897 753262 753716 756187 756223 758318 759711 760049 760241 760609 761689 764175 770704 770730 771158 774215 775441 775990 776079 776407 777756 777862 779170 779948 782520 783169 784199 786225 786510 786669 789401 789523 791873 794968 796391 796652 797399 797752 800076 800319 800721 801419 801606 801750 801760 802572 802821 802833 802900 803146 804411 806203 807806 808772 809933 809949 810762 813429 ] |
||||||||||||||||||||||||||||||
|
205.30 ms (45.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot pussy"
]
|
||||||||||||||||||||||||||||||
|
13.18 ms (2.92%) |
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 658523 666041 684847 706894 708790 709544 710360 716757 561920 596301 606417 631714 612285 629573 590067 590183 595544 605040 616500 597585 598293 612161 776407 777862 782520 786225 786510 794968 800076 800319 801606 801750 810762 775990 776079 777756 779170 779948 789523 791873 796391 796652 800721 802821 802900 803146 804411 808772 726119 729058 743124 749279 760049 760241 770704 770730 771158 783169 789401 797399 801760 802572 726844 727425 728392 730267 739133 756187 735106 740431 741243 742186 753716 756223 764175 774215 727407 728218 734416 736103 748773 753262 759711 760609 731174 739959 749945 752897 758318 761689 703104 703279 713841 721522 722055 775441 784199 786669 797752 801419 802833 806203 807806 809933 809949 813429 151564 152529 384050 387186 400006 402032 20617 274758 396030 453972 437417 191420 327898 51456 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (0.59%) |
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 20617 51456 151564 152529 191420 274758 327898 384050 387186 396030 400006 402032 437417 453972 561920 590067 590183 595544 596301 597585 598293 605040 606417 612161 612285 616500 629573 631714 658523 666041 684847 703104 703279 706894 708790 709544 710360 713841 716757 721522 722055 726119 726844 727407 727425 728218 728392 729058 730267 731174 734416 735106 736103 739133 739959 740431 741243 742186 743124 748773 749279 749945 752897 753262 753716 756187 756223 758318 759711 760049 760241 760609 761689 764175 770704 770730 771158 774215 775441 775990 776079 776407 777756 777862 779170 779948 782520 783169 784199 786225 786510 786669 789401 789523 791873 794968 796391 796652 797399 797752 800076 800319 800721 801419 801606 801750 801760 802572 802821 802833 802900 803146 804411 806203 807806 808772 809933 809949 810762 813429 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot pussy"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot pussy"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.30%) |
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.