Query Metrics
7
Database Queries
7
Different statements
163.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.83 ms (84.10%) |
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 233298 381959 400719 418258 421618 424164 427035 428188 429957 432412 433636 433787 433878 435880 435882 437710 438450 438659 439268 439271 440715 441405 441517 441589 441755 448080 449114 456125 459021 459109 459203 460891 463328 465448 467791 470591 471346 471693 472054 473277 474273 479182 479293 481212 485846 486461 487443 489319 490741 494158 495335 496733 497480 503470 511693 511811 512553 513486 516304 521644 521806 521837 527981 528639 539403 541040 551808 557004 557478 562757 564955 569573 579210 579426 579615 581918 582522 584108 595455 597087 612487 612521 631257 650104 669246 685213 686531 688741 688847 689829 700119 707721 709501 712361 719741 723909 723973 729449 733644 737813 743658 756520 757732 762247 766070 780735 781005 790253 791660 792461 792725 793309 795657 795712 799684 799891 803232 803850 804032 806606 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (8.90%) |
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 579426 584108 597087 439271 418258 435880 439268 459203 471346 435882 449114 428188 471693 479182 437710 511693 521837 459109 541040 799891 421618 441755 424164 481212 467791 485846 562757 557004 569573 579615 463328 473277 433636 441517 456125 459021 465448 432412 433787 440715 441405 448080 460891 479293 433878 472054 487443 521644 527981 495335 512553 539403 551808 513486 494158 381959 762247 743658 650104 803232 427035 757732 712361 438450 486461 438659 686531 685213 689829 780735 790253 733644 707721 795657 688741 688847 793309 781005 766070 400719 429957 470591 709501 557478 595455 723909 233298 503470 564955 490741 497480 528639 791660 631257 581918 612487 612521 792461 795712 723973 804032 737813 792725 579210 496733 516304 521806 719741 806606 729449 700119 489319 582522 799684 803850 756520 669246 441589 474273 511811 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.05%) |
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 233298 381959 400719 418258 421618 424164 427035 428188 429957 432412 433636 433787 433878 435880 435882 437710 438450 438659 439268 439271 440715 441405 441517 441589 441755 448080 449114 456125 459021 459109 459203 460891 463328 465448 467791 470591 471346 471693 472054 473277 474273 479182 479293 481212 485846 486461 487443 489319 490741 494158 495335 496733 497480 503470 511693 511811 512553 513486 516304 521644 521806 521837 527981 528639 539403 541040 551808 557004 557478 562757 564955 569573 579210 579426 579615 581918 582522 584108 595455 597087 612487 612521 631257 650104 669246 685213 686531 688741 688847 689829 700119 707721 709501 712361 719741 723909 723973 729449 733644 737813 743658 756520 757732 762247 766070 780735 781005 790253 791660 792461 792725 793309 795657 795712 799684 799891 803232 803850 804032 806606 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодая измена русска…"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк жен русск"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"молодая девушк жен русск"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
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.