Query Metrics
7
Database Queries
7
Different statements
164.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.00 ms (77.84%) |
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 72822 96761 129902 181397 188556 193342 310295 310758 320078 381883 398773 400185 403641 404192 406307 411751 414358 419524 426394 431643 432299 435695 443726 443777 445943 446275 456614 457791 460168 460208 464132 467619 468042 469555 473005 474627 474661 474685 476905 479071 484629 484700 486426 493088 493587 494419 514601 518554 522898 530373 531249 534129 534536 536212 536359 537220 538925 547477 551057 556774 571213 583730 592384 595761 600346 603692 604403 606514 614220 625783 628110 644309 645904 647602 666579 667922 671714 673613 673719 676088 677723 678962 690809 692188 692796 703062 705278 711997 712891 717839 717880 720236 720873 721715 724309 724996 736226 742356 742804 744389 748475 748529 756383 760240 765236 770402 788294 789841 790389 797461 801899 803645 815210 815866 817156 817537 817866 818290 820678 820765 ] |
||||||||||||||||||||||||||||||
|
23.19 ms (14.10%) |
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 419524 411751 467619 474661 474627 474685 484700 514601 556774 486426 536359 530373 676088 712891 188556 400185 403641 406307 432299 435695 431643 414358 445943 457791 469555 518554 494419 522898 468042 493587 603692 600346 625783 443726 460208 464132 531249 592384 628110 724996 736226 770402 476905 446275 456614 678962 443777 484629 571213 595761 193342 310758 398773 820678 460168 537220 479071 547477 788294 790389 797461 756383 724309 742356 748475 606514 721715 72822 404192 473005 493088 129902 181397 310295 320078 381883 426394 817156 818290 815210 817537 817866 820765 815866 534129 534536 538925 536212 583730 551057 647602 690809 705278 711997 717880 666579 673613 677723 717839 720236 645904 667922 671714 673719 692188 692796 614220 644309 604403 801899 803645 744389 789841 760240 742804 748529 765236 703062 720873 96761 ] |
||||||||||||||||||||||||||||||
|
6.97 ms (4.24%) |
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 72822 96761 129902 181397 188556 193342 310295 310758 320078 381883 398773 400185 403641 404192 406307 411751 414358 419524 426394 431643 432299 435695 443726 443777 445943 446275 456614 457791 460168 460208 464132 467619 468042 469555 473005 474627 474661 474685 476905 479071 484629 484700 486426 493088 493587 494419 514601 518554 522898 530373 531249 534129 534536 536212 536359 537220 538925 547477 551057 556774 571213 583730 592384 595761 600346 603692 604403 606514 614220 625783 628110 644309 645904 647602 666579 667922 671714 673613 673719 676088 677723 678962 690809 692188 692796 703062 705278 711997 712891 717839 717880 720236 720873 721715 724309 724996 736226 742356 742804 744389 748475 748529 756383 760240 765236 770402 788294 789841 790389 797461 801899 803645 815210 815866 817156 817537 817866 818290 820678 820765 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature double anal"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature double анал"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature double анал"
]
|
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.