Query Metrics
7
Database Queries
7
Different statements
148.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.55 ms (85.25%) |
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 49426 107102 145218 145335 207630 300984 384460 384885 385671 386322 387145 387566 388161 390625 390928 391048 391114 409050 413123 453152 468505 471021 476836 484221 490591 510945 510947 522193 530568 536192 542479 544580 544988 548301 549640 557822 567615 574238 576450 577308 577987 582494 588074 589691 589868 591576 604779 605713 610926 610939 612622 617393 618537 622624 624466 624791 627232 628761 639480 640448 642526 648193 661540 665613 703709 703783 714361 714407 719095 719121 721938 725582 726624 728148 728953 729050 729051 730271 732099 733479 734205 734320 736725 738469 739186 739895 740541 740666 742574 743234 743246 745294 746055 747251 748594 752140 753762 762186 771561 771873 781962 787238 790201 790711 791804 794577 795344 795879 795898 796704 802303 803510 808125 809555 810163 810394 812032 812480 824952 826435 ] |
||||||||||||||||||||||||||||||
|
11.24 ms (7.57%) |
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 612622 624466 628761 618537 642526 589868 604779 605713 588074 589691 591576 610939 624791 627232 639480 640448 794577 795344 802303 812480 781962 790711 795879 795898 796704 810394 729051 734205 734320 736725 740541 742574 787238 808125 809555 810163 728148 729050 730271 732099 752140 762186 726624 733479 739895 747251 748594 725582 728953 738469 739186 743234 743246 753762 771561 771873 740666 745294 746055 610926 617393 622624 703709 703783 714361 714407 719095 719121 721938 790201 791804 803510 812032 388161 413123 453152 484221 510945 510947 577987 391048 476836 824952 826435 391114 385671 386322 384460 384885 207630 145218 145335 107102 300984 49426 387566 387145 390928 390625 409050 490591 468505 471021 522193 530568 536192 577308 582494 542479 544580 549640 557822 567615 574238 576450 544988 548301 648193 661540 665613 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.25%) |
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 49426 107102 145218 145335 207630 300984 384460 384885 385671 386322 387145 387566 388161 390625 390928 391048 391114 409050 413123 453152 468505 471021 476836 484221 490591 510945 510947 522193 530568 536192 542479 544580 544988 548301 549640 557822 567615 574238 576450 577308 577987 582494 588074 589691 589868 591576 604779 605713 610926 610939 612622 617393 618537 622624 624466 624791 627232 628761 639480 640448 642526 648193 661540 665613 703709 703783 714361 714407 719095 719121 721938 725582 726624 728148 728953 729050 729051 730271 732099 733479 734205 734320 736725 738469 739186 739895 740541 740666 742574 743234 743246 745294 746055 747251 748594 752140 753762 762186 771561 771873 781962 787238 790201 790711 791804 794577 795344 795879 795898 796704 802303 803510 808125 809555 810163 810394 812032 812480 824952 826435 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy but"
]
|
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.