Query Metrics
7
Database Queries
7
Different statements
595.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.80 ms (35.73%) |
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 394251 394258 396280 398268 399433 399439 399456 399511 399516 399518 400156 401378 402079 402599 409100 422352 433681 435647 438005 440292 440864 441692 442418 442862 443183 445502 448166 453260 455652 457113 459947 463703 464144 465507 484764 486946 489960 492614 493844 496292 514813 519828 523475 526812 528833 532614 534722 535915 544103 546979 556398 558876 561281 561597 561810 563183 569394 571129 574990 578569 579209 579227 582197 584666 588378 593598 594108 598178 599710 601325 607698 608415 615712 619955 622321 623754 623790 623818 625254 630910 645255 659389 662140 685023 685068 701527 702312 710588 713552 714062 714097 714626 716324 718049 725788 738013 742839 753722 756973 757501 758174 761986 777732 785945 788821 789693 790030 790534 793042 793500 795234 796206 798171 805069 805284 810760 813035 818080 820337 ] |
||||||||||||||||||||||||||||||
|
207.25 ms (34.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step fuck"
]
|
||||||||||||||||||||||||||||||
|
156.04 ms (26.20%) |
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 394251 394258 396280 398268 399433 399439 399456 399511 399516 399518 400156 401378 402079 402599 409100 422352 433681 435647 438005 440292 440864 441692 442418 442862 443183 445502 448166 453260 455652 457113 459947 463703 464144 465507 484764 486946 489960 492614 493844 496292 514813 519828 523475 526812 528833 532614 534722 535915 544103 546979 556398 558876 561281 561597 561810 563183 569394 571129 574990 578569 579209 579227 582197 584666 588378 593598 594108 598178 599710 601325 607698 608415 615712 619955 622321 623754 623790 623818 625254 630910 645255 659389 662140 685023 685068 701527 702312 710588 713552 714062 714097 714626 716324 718049 725788 738013 742839 753722 756973 757501 758174 761986 777732 785945 788821 789693 790030 790534 793042 793500 795234 796206 798171 805069 805284 810760 813035 818080 820337 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (2.50%) |
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 394258 399439 761986 396280 623818 402079 401378 443183 445502 465507 662140 574990 785945 440864 489960 526812 582197 685068 579227 625254 793500 795234 716324 790534 399518 399456 453260 532614 569394 710588 685023 563183 622321 623790 619955 796206 725788 798171 399433 455652 402599 440292 519828 659389 714097 702312 594108 593598 756973 435647 535915 441692 442418 457113 544103 558876 579209 561597 713552 599710 623754 607698 805284 615712 714626 718049 492614 496292 394251 433681 818080 463703 528833 534722 523475 484764 578569 561810 584666 561281 714062 645255 701527 571129 598178 601325 608415 588378 779905 789693 813035 742839 758174 753722 738013 793042 442862 438005 486946 493844 448166 757501 790030 398268 556398 777732 805069 810760 409100 399511 399516 820337 788821 630910 400156 422352 459947 464144 514813 546979 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step секс"
]
|
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.