Query Metrics
7
Database Queries
7
Different statements
152.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.53 ms (83.45%) |
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 386577 420622 420695 429242 429290 445573 445665 449353 456444 457301 464410 464419 469593 472725 480424 486586 494447 510139 512092 512311 523281 523497 528173 530474 531389 531914 533196 533241 533523 534740 535074 536366 540435 540441 543149 548802 556086 557269 558777 559494 561245 564334 575954 576560 577070 581252 583172 585543 586320 589198 592271 592292 596210 596484 597723 601740 606524 606864 606887 606926 609361 615023 615291 615846 619388 619505 621967 622585 624262 629419 633427 634528 635490 636419 636579 644980 653832 664380 669224 674068 674312 711639 713127 719875 727577 737305 744682 752878 756106 761547 763857 764309 764748 769702 769888 769981 776310 779232 784250 784394 784455 784510 788928 788992 789015 795575 796426 803926 804657 809243 810426 812876 813121 819743 822231 823475 825915 827827 827850 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (9.84%) |
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 622585 596210 633427 586320 813121 769981 784455 796426 803926 769702 744682 761547 764748 606524 615291 528173 420695 540441 494447 635490 420622 644980 823475 827827 464419 533523 535074 557269 543149 664380 674068 669224 624262 592292 592271 606887 609361 636419 784394 810426 779232 788992 764309 752878 737305 727577 756106 763857 770445 619388 619505 629419 713127 653832 486586 719875 576560 615846 809243 776310 825915 819743 822231 827850 445665 464410 531389 512092 480424 577070 558777 559494 581252 548802 556086 575954 674312 606864 615023 621967 589198 596484 597723 585543 606926 784250 784510 804657 769888 788928 795575 601740 634528 789015 386577 523281 711639 636579 472725 457301 533241 469593 512311 530474 510139 533196 564334 812876 429290 429242 445573 449353 456444 540435 531914 536366 523497 534740 583172 561245 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.77%) |
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 386577 420622 420695 429242 429290 445573 445665 449353 456444 457301 464410 464419 469593 472725 480424 486586 494447 510139 512092 512311 523281 523497 528173 530474 531389 531914 533196 533241 533523 534740 535074 536366 540435 540441 543149 548802 556086 557269 558777 559494 561245 564334 575954 576560 577070 581252 583172 585543 586320 589198 592271 592292 596210 596484 597723 601740 606524 606864 606887 606926 609361 615023 615291 615846 619388 619505 621967 622585 624262 629419 633427 634528 635490 636419 636579 644980 653832 664380 669224 674068 674312 711639 713127 719875 727577 737305 744682 752878 756106 761547 763857 764309 764748 769702 769888 769981 776310 779232 784250 784394 784455 784510 788928 788992 789015 795575 796426 803926 804657 809243 810426 812876 813121 819743 822231 823475 825915 827827 827850 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov bbc"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов bbc"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов bbc"
]
|
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.