Query Metrics
7
Database Queries
7
Different statements
189.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.34 ms (86.93%) |
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 396981 413134 425992 449720 453579 459262 464102 465329 472529 473302 474115 480434 490628 497853 504159 508845 511045 512430 512809 513881 519069 520926 521845 522751 526038 526413 527917 530032 530705 532299 534877 538172 539475 539790 540869 547013 547653 549352 550266 552052 553186 555453 555655 556418 557307 557903 564287 566101 566273 567400 572096 574443 576935 577274 577352 577458 583144 583356 583370 583884 584549 584855 585304 586121 588577 590426 591533 592218 594510 594971 595435 596829 599761 599779 599831 600232 603225 603400 605288 606904 609973 615653 617395 618040 618188 619144 629535 634471 645908 646035 646581 647348 651926 652876 654443 654838 655097 656158 663242 663494 668716 670617 672472 673954 674049 680682 684904 690824 710679 726414 752565 762568 762843 765767 768880 772718 808337 811275 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (7.85%) |
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 594510 603225 808337 726414 762843 752565 765767 606904 710679 396981 425992 413134 449720 459262 464102 465329 526413 520926 472529 566101 567400 583370 584855 670617 647348 656158 550266 566273 574443 584549 596829 599761 605288 617395 453579 480434 473302 655097 540869 474115 490628 512809 513881 530032 530705 534877 539790 508845 522751 532299 538172 497853 504159 519069 521845 526038 527917 539475 511045 512430 555453 555655 557903 564287 577274 577352 583144 583884 547653 549352 554879 556418 583356 547013 552052 576935 577458 645908 652876 654838 663494 672472 690824 654443 663242 674049 684904 646035 646581 651926 668716 673954 680682 553186 557307 572096 591533 592218 599779 603400 609973 588577 595435 618040 629535 594971 600232 615653 619144 634471 585304 586121 590426 591806 599831 618188 762568 772718 811275 768880 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.46%) |
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 396981 413134 425992 449720 453579 459262 464102 465329 472529 473302 474115 480434 490628 497853 504159 508845 511045 512430 512809 513881 519069 520926 521845 522751 526038 526413 527917 530032 530705 532299 534877 538172 539475 539790 540869 547013 547653 549352 550266 552052 553186 555453 555655 556418 557307 557903 564287 566101 566273 567400 572096 574443 576935 577274 577352 577458 583144 583356 583370 583884 584549 584855 585304 586121 588577 590426 591533 592218 594510 594971 595435 596829 599761 599779 599831 600232 603225 603400 605288 606904 609973 615653 617395 618040 618188 619144 629535 634471 645908 646035 646581 647348 651926 652876 654443 654838 655097 656158 663242 663494 668716 670617 672472 673954 674049 680682 684904 690824 710679 726414 752565 762568 762843 765767 768880 772718 808337 811275 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"обратно в"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"обратн в"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 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.