Query Metrics
7
Database Queries
7
Different statements
146.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.74 ms (85.65%) |
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 178567 229566 381941 383484 385908 390832 391175 393087 396540 399015 399386 401252 405048 406308 408508 409723 410657 416137 417482 417884 420363 425320 430290 430380 433516 433580 433883 457494 458125 458573 463845 467632 482727 484863 492484 494617 506143 510820 512984 517929 523497 525545 525938 530486 532621 533339 533353 537670 540405 545359 549302 555783 558304 558440 565161 567343 570162 579329 585754 587303 600252 600360 601040 602970 605595 616652 621413 630533 633934 634474 635172 639061 650336 654596 682516 693955 696574 705683 712281 716255 717509 719827 720388 720889 722495 723726 728424 735538 737847 740616 740637 742137 744469 745025 745037 750911 797415 801524 802689 803190 805729 808076 808458 811826 814104 814856 815789 815956 817109 817208 819110 822189 822277 822460 822559 823563 823813 824900 826232 ] |
||||||||||||||||||||||||||||||
|
11.95 ms (8.14%) |
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 399015 401252 417884 819110 822189 822277 822559 814104 822460 817109 817208 823563 824900 823813 458573 517929 525545 579329 549302 573937 545359 705683 696574 719827 722495 585754 616652 639061 587303 635172 602970 801524 805729 797415 742137 745025 745037 740637 744469 717509 808458 390832 391175 178567 229566 383484 600252 630533 600360 811826 494617 533353 458125 512984 533339 570162 605595 430290 433883 492484 654596 634474 633934 712281 558440 385908 393087 408508 409723 420363 430380 433516 815956 826232 457494 463845 510820 532621 523497 558304 555783 682516 650336 716255 720388 720889 621413 723726 735538 750911 802689 808076 728424 737847 740616 803190 381941 399386 416137 396540 405048 484863 525938 406308 410657 482727 530486 506143 537670 540405 567343 565161 601040 425320 467632 417482 693955 433580 814856 815789 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.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 178567 229566 381941 383484 385908 390832 391175 393087 396540 399015 399386 401252 405048 406308 408508 409723 410657 416137 417482 417884 420363 425320 430290 430380 433516 433580 433883 457494 458125 458573 463845 467632 482727 484863 492484 494617 506143 510820 512984 517929 523497 525545 525938 530486 532621 533339 533353 537670 540405 545359 549302 555783 558304 558440 565161 567343 570162 579329 585754 587303 600252 600360 601040 602970 605595 616652 621413 630533 633934 634474 635172 639061 650336 654596 682516 693955 696574 705683 712281 716255 717509 719827 720388 720889 722495 723726 728424 735538 737847 740616 740637 742137 744469 745025 745037 750911 797415 801524 802689 803190 805729 808076 808458 811826 814104 814856 815789 815956 817109 817208 819110 822189 822277 822460 822559 823563 823813 824900 826232 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc лиза 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.