Query Metrics
7
Database Queries
7
Different statements
219.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.40 ms (90.30%) |
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 73413 153490 392687 396988 403467 404273 408262 420178 428488 428603 431504 432613 432644 432692 432736 435245 441157 441320 442128 444406 444558 444836 448176 449169 453174 454401 454536 454976 455981 464201 464395 469294 470403 475629 478333 479779 479787 481844 482223 483731 484532 484970 492365 496771 498077 498630 499860 500442 504083 507512 512961 514912 517049 518950 520670 536724 536855 537107 542508 549243 550337 550672 560869 563082 564254 564258 564899 565687 565790 565907 575656 581597 589436 589599 589647 590930 591727 593003 597753 602260 628681 634770 637401 640136 655927 709257 721187 726494 726504 726519 726538 726696 726710 726713 727031 730961 737181 742891 744370 746167 747234 748889 750776 766694 767184 784488 784528 788209 796090 796099 796109 796129 798509 799767 801514 806722 812336 813391 814701 816115 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (5.58%) |
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 153490 396988 498077 454401 496771 432613 432736 441157 441320 816115 455981 483731 492365 484532 504083 520670 499860 536855 563082 564258 589599 799767 784488 796090 796099 796109 812336 742891 746167 750776 796129 726538 766694 726494 730961 747234 726696 801514 428488 454536 478333 498630 408262 435245 589436 637401 591727 484970 640136 73413 403467 454976 537107 581597 798509 432692 549243 744370 464395 444558 453174 464201 721187 479787 404273 481844 507512 444406 432644 449169 512961 514912 475629 564899 565907 575656 560869 542508 550337 550672 655927 709257 565687 565790 634770 589647 593003 628681 597753 788209 806722 784528 813391 726519 726713 737181 748889 767184 726504 726710 727031 602260 428603 392687 482223 420178 500442 517049 590930 564254 444836 442128 431504 814701 448176 469294 470403 479779 518950 536724 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.16%) |
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 73413 153490 392687 396988 403467 404273 408262 420178 428488 428603 431504 432613 432644 432692 432736 435245 441157 441320 442128 444406 444558 444836 448176 449169 453174 454401 454536 454976 455981 464201 464395 469294 470403 475629 478333 479779 479787 481844 482223 483731 484532 484970 492365 496771 498077 498630 499860 500442 504083 507512 512961 514912 517049 518950 520670 536724 536855 537107 542508 549243 550337 550672 560869 563082 564254 564258 564899 565687 565790 565907 575656 581597 589436 589599 589647 590930 591727 593003 597753 602260 628681 634770 637401 640136 655927 709257 721187 726494 726504 726519 726538 726696 726710 726713 727031 730961 737181 742891 744370 746167 747234 748889 750776 766694 767184 784488 784528 788209 796090 796099 796109 796129 798509 799767 801514 806722 812336 813391 814701 816115 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск mature латинская"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск mature латинская"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur mature latina"
]
|
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.