Query Metrics
7
Database Queries
7
Different statements
170.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.58 ms (87.23%) |
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 20948 252068 382251 382354 384871 386065 386227 391328 392645 393157 409454 420012 420594 436392 436476 443650 444580 448763 457321 462276 463488 469106 470347 470817 472094 474040 474283 484253 487650 493141 497600 504676 507897 510497 516163 518211 519657 522293 522766 527352 527665 529277 532276 534475 535214 541091 543405 543598 544032 545882 546572 550125 552716 553761 559741 560099 560802 561606 563969 568961 576746 581910 586363 589837 596512 599357 602215 605408 606640 606933 608681 618061 618201 618952 620051 626143 627871 652779 656197 657817 658542 661331 667919 691578 698001 710253 714050 715002 719277 719315 719644 719935 721953 724424 725512 729458 730418 730720 735820 744099 745980 746159 746468 763141 765959 769013 772296 774793 779867 784205 785451 787317 789080 789230 801370 802641 803214 804309 806929 814297 ] |
||||||||||||||||||||||||||||||
|
12.84 ms (7.54%) |
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 789230 725512 730418 730720 746468 729458 484253 544032 661331 606933 560802 448763 470817 493141 552716 576746 802641 386065 382354 436392 462276 721953 606640 774793 487650 719277 532276 581910 698001 714050 618061 784205 785451 744099 386227 599357 596512 789080 608681 602215 522293 657817 715002 384871 746159 545882 529277 527665 652779 546572 765959 814297 527352 534475 543405 691578 656197 605408 618201 589837 803214 801370 772296 787317 420012 472094 561606 550125 510497 553761 626143 393157 719315 763141 469106 497600 543598 568961 391328 518211 719644 658542 719935 586363 620051 627871 392645 535214 667919 444580 618952 560099 409454 779867 507897 504676 463488 710253 724424 382251 474283 252068 436476 522766 559741 457321 519657 20948 443650 541091 563969 745980 804309 735820 769013 806929 474040 470347 420594 516163 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.61%) |
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 20948 252068 382251 382354 384871 386065 386227 391328 392645 393157 409454 420012 420594 436392 436476 443650 444580 448763 457321 462276 463488 469106 470347 470817 472094 474040 474283 484253 487650 493141 497600 504676 507897 510497 516163 518211 519657 522293 522766 527352 527665 529277 532276 534475 535214 541091 543405 543598 544032 545882 546572 550125 552716 553761 559741 560099 560802 561606 563969 568961 576746 581910 586363 589837 596512 599357 602215 605408 606640 606933 608681 618061 618201 618952 620051 626143 627871 652779 656197 657817 658542 661331 667919 691578 698001 710253 714050 715002 719277 719315 719644 719935 721953 724424 725512 729458 730418 730720 735820 744099 745980 746159 746468 763141 765959 769013 772296 774793 779867 784205 785451 787317 789080 789230 801370 802641 803214 804309 806929 814297 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public park"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц парк природ"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.