Query Metrics
7
Database Queries
7
Different statements
178.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.96 ms (86.30%) |
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 364718 411300 411425 420520 428021 443878 447376 449691 455370 455732 455809 456280 456843 456873 457019 457043 457057 457697 457715 457718 457739 461958 465420 465423 468926 468947 468948 469632 471172 472038 474072 474158 477763 477855 478106 488213 488234 488235 488848 489779 494657 494663 494682 494866 495173 495499 497599 503041 503907 506571 507152 507769 510718 510730 513162 516692 519366 520173 520298 522217 523136 527043 527887 528681 534335 534344 534667 534841 535451 537617 537783 541144 541907 545732 548382 550477 550506 552282 553331 553454 556375 558104 558108 558449 567854 568483 580925 584691 585475 594944 594947 599666 605654 613355 620808 632808 634329 636528 637517 672369 673574 689697 692108 708297 714027 714341 721954 721968 729593 736548 738951 761142 774345 785540 789009 792760 794625 805225 810638 823617 ] |
||||||||||||||||||||||||||||||
|
15.30 ms (8.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 692108 594944 792760 785540 465420 497599 823617 522217 584691 541907 689697 585475 594947 599666 789009 774345 721954 810638 634329 548382 495173 527887 456280 488848 506571 568483 541144 708297 580925 553331 516692 736548 738951 489779 729593 503041 447376 457019 468948 474158 456843 457739 537783 510718 468947 488213 443878 457718 465423 494663 534667 545732 714027 567854 605654 794625 474072 469632 507152 488235 428021 468926 477855 534841 520298 527043 535451 488234 550506 553454 714341 632808 620808 613355 761142 636528 461958 534344 513162 550477 411300 471172 528681 552282 637517 411425 558108 556375 523136 672369 805225 494682 537617 478106 534335 364718 449691 477763 510730 673574 495499 457715 558104 507769 456873 455809 457043 558449 721968 420520 457697 455370 455732 494657 494866 520173 457057 472038 503907 519366 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.45%) |
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 364718 411300 411425 420520 428021 443878 447376 449691 455370 455732 455809 456280 456843 456873 457019 457043 457057 457697 457715 457718 457739 461958 465420 465423 468926 468947 468948 469632 471172 472038 474072 474158 477763 477855 478106 488213 488234 488235 488848 489779 494657 494663 494682 494866 495173 495499 497599 503041 503907 506571 507152 507769 510718 510730 513162 516692 519366 520173 520298 522217 523136 527043 527887 528681 534335 534344 534667 534841 535451 537617 537783 541144 541907 545732 548382 550477 550506 552282 553331 553454 556375 558104 558108 558449 567854 568483 580925 584691 585475 594944 594947 599666 605654 613355 620808 632808 634329 636528 637517 672369 673574 689697 692108 708297 714027 714341 721954 721968 729593 736548 738951 761142 774345 785540 789009 792760 794625 805225 810638 823617 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden public bath"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт на bath улиц"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт на bath улиц"
]
|
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.