Query Metrics
7
Database Queries
7
Different statements
190.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.69 ms (86.09%) |
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 7240 7727 12594 45799 91254 304679 334299 365865 367962 383563 384289 388004 389406 390899 391356 391485 391518 393298 396349 397014 398263 415637 417847 417849 425648 425997 426994 428046 428057 428109 435645 439749 443968 443975 444144 444177 447981 448095 451540 453214 457821 459407 459418 459602 459959 469335 470193 472007 474559 478848 481262 481751 482362 485984 487396 495308 500693 501679 504785 505113 506207 508741 511478 521451 525714 528254 529260 532587 543296 544442 551588 551723 561692 586657 587529 589708 592198 597878 599674 610972 633541 640349 655070 656360 662454 667286 667291 679863 684920 690703 695158 704983 705788 717077 720645 733480 733530 742642 744851 750859 755111 769474 773105 774708 779419 780903 782908 784078 785285 789149 791114 794724 794850 796714 797348 800390 810040 810154 812055 824370 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (7.94%) |
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 459407 391356 459959 415637 459602 443975 428046 444144 453214 521451 487396 511478 304679 425648 444177 417849 824370 501679 481262 543296 667286 667291 695158 551723 592198 640349 599674 812055 794850 742642 769474 779419 7727 417847 365865 391518 447981 443968 470193 91254 383563 334299 7240 390899 529260 544442 551588 655070 690703 704983 705788 656360 684920 717077 586657 796714 782908 789149 797348 810040 755111 785285 744851 750859 733530 633541 784078 791114 794724 800390 391485 397014 495308 500693 469335 474559 589708 426994 439749 528254 393298 45799 389406 396349 435645 457821 504785 505113 561692 679863 587529 597878 774708 508741 506207 12594 459418 532587 610972 780903 810154 773105 482362 451540 388004 525714 398263 425997 428057 485984 472007 481751 662454 733480 720645 448095 428109 478848 367962 384289 ] |
||||||||||||||||||||||||||||||
|
3.86 ms (2.03%) |
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 7240 7727 12594 45799 91254 304679 334299 365865 367962 383563 384289 388004 389406 390899 391356 391485 391518 393298 396349 397014 398263 415637 417847 417849 425648 425997 426994 428046 428057 428109 435645 439749 443968 443975 444144 444177 447981 448095 451540 453214 457821 459407 459418 459602 459959 469335 470193 472007 474559 478848 481262 481751 482362 485984 487396 495308 500693 501679 504785 505113 506207 508741 511478 521451 525714 528254 529260 532587 543296 544442 551588 551723 561692 586657 587529 589708 592198 597878 599674 610972 633541 640349 655070 656360 662454 667286 667291 679863 684920 690703 695158 704983 705788 717077 720645 733480 733530 742642 744851 750859 755111 769474 773105 774708 779419 780903 782908 784078 785285 789149 791114 794724 794850 796714 797348 800390 810040 810154 812055 824370 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рак груди"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак сиськ"
]
|
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.