Query Metrics
7
Database Queries
7
Different statements
145.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.86 ms (85.91%) |
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 400362 402980 403291 405802 410235 433751 441336 445671 446218 448886 449279 454472 454491 458647 465223 473827 481755 487216 494553 498604 498872 499719 500743 502752 514972 525561 526590 527461 530298 539961 547741 555631 569476 571753 580218 582678 584576 584609 585842 588072 589931 589945 589953 589958 589986 590100 591157 598315 598382 602080 602626 621092 623755 624145 629117 632140 634309 635572 636066 643541 645528 662499 673868 675310 675355 680753 682741 690961 693679 705136 708194 708643 709037 709065 709179 709182 712744 718803 729660 741545 744697 745469 762451 765413 766572 776266 776289 782756 783896 786856 788388 790171 791637 794279 795248 795697 796086 797906 799382 800496 801626 806865 807364 808514 809011 809264 809370 809638 811442 811820 812296 812587 813116 813467 817978 824647 827701 827825 ] |
||||||||||||||||||||||||||||||
|
11.30 ms (7.78%) |
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 673868 634309 708643 824647 827701 445671 454491 458647 526590 539961 487216 708194 712744 693679 589953 598382 621092 776289 781127 799382 800496 813116 782756 791637 795248 795697 796086 797906 801626 808514 812296 723709 786856 790171 809011 809264 809370 811442 811820 812587 729660 766572 765413 762451 629117 718803 783896 788388 806865 807364 809638 433751 446218 448886 473827 514972 827825 481755 498872 499719 530298 571753 584609 580218 662499 675355 680753 690961 709065 675310 705136 709037 709179 682741 588072 589945 589958 589986 623755 643541 602626 624145 632140 589931 591157 636066 794279 745469 602080 635572 502752 498604 403291 547741 741545 402980 449279 527461 494553 500743 582678 645528 709182 555631 584576 585842 598315 590100 776266 813467 525561 744697 569476 400362 405802 441336 410235 817978 454472 465223 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.69%) |
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 400362 402980 403291 405802 410235 433751 441336 445671 446218 448886 449279 454472 454491 458647 465223 473827 481755 487216 494553 498604 498872 499719 500743 502752 514972 525561 526590 527461 530298 539961 547741 555631 569476 571753 580218 582678 584576 584609 585842 588072 589931 589945 589953 589958 589986 590100 591157 598315 598382 602080 602626 621092 623755 624145 629117 632140 634309 635572 636066 643541 645528 662499 673868 675310 675355 680753 682741 690961 693679 705136 708194 708643 709037 709065 709179 709182 712744 718803 729660 741545 744697 745469 762451 765413 766572 776266 776289 782756 783896 786856 788388 790171 791637 794279 795248 795697 796086 797906 799382 800496 801626 806865 807364 808514 809011 809264 809370 809638 811442 811820 812296 812587 813116 813467 817978 824647 827701 827825 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade perfect"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск perfect"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск perfect"
]
|
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.