Query Metrics
7
Database Queries
7
Different statements
167.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.51 ms (85.03%) |
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 382794 383433 395508 398164 418224 419330 428518 429171 429175 430003 430309 432115 435188 435640 436732 439186 439200 443360 445859 446469 447333 447337 447390 449089 449301 450654 450844 453710 453947 454474 456880 457513 458450 459345 460033 462510 462524 463710 464443 469443 470973 477392 477883 477984 478750 478879 479348 480486 485595 492135 493455 495855 510673 511172 522294 526038 528099 529496 545957 546947 548055 549596 552307 561731 563019 563112 563178 563882 565931 568368 570169 574030 576649 579465 584733 585170 603014 614032 620640 623338 641134 663512 670620 671671 674041 681339 682363 683460 687540 693227 698045 703439 704579 709228 717681 717696 722882 724824 727825 741467 745751 759635 763955 780963 785488 789659 789740 794517 797905 799365 800959 801329 802274 807802 812113 815210 818338 823857 824316 824347 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (9.11%) |
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 802274 477984 382794 436732 470973 418224 511172 485595 469443 453710 528099 546947 552307 383433 419330 428518 430003 824347 815210 823857 453947 477392 446469 449089 450654 456880 495855 526038 563178 568368 584733 549596 545957 563112 574030 579465 682363 693227 683460 703439 722882 663512 670620 671671 674041 681339 687540 709228 717696 548055 563019 563882 614032 585170 603014 620640 780963 789659 794517 799365 785488 789740 797905 812113 724824 741467 745751 763955 727825 759635 623338 641134 698045 704579 717681 800959 801329 807802 443360 430309 457513 478879 460033 479348 462510 529496 492135 510673 493455 432115 570169 561731 565931 576649 447337 447333 447390 522294 395508 398164 429175 435188 439186 439200 429171 435640 818338 824316 445859 449301 454474 462524 463710 450844 458450 459345 464443 477883 478750 480486 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.91%) |
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 382794 383433 395508 398164 418224 419330 428518 429171 429175 430003 430309 432115 435188 435640 436732 439186 439200 443360 445859 446469 447333 447337 447390 449089 449301 450654 450844 453710 453947 454474 456880 457513 458450 459345 460033 462510 462524 463710 464443 469443 470973 477392 477883 477984 478750 478879 479348 480486 485595 492135 493455 495855 510673 511172 522294 526038 528099 529496 545957 546947 548055 549596 552307 561731 563019 563112 563178 563882 565931 568368 570169 574030 576649 579465 584733 585170 603014 614032 620640 623338 641134 663512 670620 671671 674041 681339 682363 683460 687540 693227 698045 703439 704579 709228 717681 717696 722882 724824 727825 741467 745751 759635 763955 780963 785488 789659 789740 794517 797905 799365 800959 801329 802274 807802 812113 815210 818338 823857 824316 824347 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy sleep"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy спящ"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy спящ"
]
|
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.