Query Metrics
7
Database Queries
7
Different statements
157.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.37 ms (85.85%) |
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 3671 395430 400713 427813 440840 440932 451744 459937 460081 460112 460841 463872 469308 469706 470136 488520 494412 494541 494959 499396 504181 505248 505285 538407 542445 547180 555161 555369 557722 557726 568372 572355 574940 578226 579137 584017 585391 588072 595314 601871 604635 604724 607279 607472 615451 624759 626331 630876 632845 636464 639375 647253 648483 652999 664222 670234 670257 672526 674197 678334 679685 680588 686590 697327 697718 698228 698473 709764 711577 712561 717298 719124 721042 721128 726314 726967 728427 731135 732669 733074 736838 737065 738022 739986 740508 741832 745360 763062 764522 768939 769344 772746 776151 778068 778447 778514 779961 786831 787799 789279 791065 793571 794993 795143 796048 798856 800303 801399 802210 802602 802867 805354 811410 811435 811528 811764 812373 812822 813316 ] |
||||||||||||||||||||||||||||||
|
12.88 ms (8.17%) |
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 698473 709764 712561 686590 697718 664222 678334 585391 588072 595314 607472 630876 778068 732669 463872 494412 499396 557726 670257 680588 726314 794993 504181 789279 400713 427813 572355 584017 674197 578226 775358 778514 812373 776151 779961 786831 812822 736838 738022 769344 733074 728427 740508 737065 717298 719124 800303 488520 679685 647253 3671 460112 542445 697327 555161 805354 811435 802867 772746 802210 811764 768939 731135 741832 787799 793571 798856 801399 811528 395430 469706 494541 505248 538407 568372 652999 670234 632845 607279 615451 624759 604724 440932 460841 557722 648483 601871 639375 636464 813316 795143 796048 745360 726967 604635 811410 469308 440840 451744 505285 494959 459937 460081 470136 555369 547180 579137 711577 721128 698228 672526 721042 574940 626331 778447 791065 802602 764522 763062 739986 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.97%) |
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 3671 395430 400713 427813 440840 440932 451744 459937 460081 460112 460841 463872 469308 469706 470136 488520 494412 494541 494959 499396 504181 505248 505285 538407 542445 547180 555161 555369 557722 557726 568372 572355 574940 578226 579137 584017 585391 588072 595314 601871 604635 604724 607279 607472 615451 624759 626331 630876 632845 636464 639375 647253 648483 652999 664222 670234 670257 672526 674197 678334 679685 680588 686590 697327 697718 698228 698473 709764 711577 712561 717298 719124 721042 721128 726314 726967 728427 731135 732669 733074 736838 737065 738022 739986 740508 741832 745360 763062 764522 768939 769344 772746 776151 778068 778447 778514 779961 786831 787799 789279 791065 793571 794993 795143 796048 798856 800303 801399 802210 802602 802867 805354 811410 811435 811528 811764 812373 812822 813316 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facial homemade"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"facial домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"facial домашн любительск"
]
|
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.