Query Metrics
7
Database Queries
7
Different statements
144.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.02 ms (83.05%) |
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 145314 383818 386719 409948 422233 425003 434281 447562 451748 453513 457953 461696 467544 471347 471916 479029 479176 484355 498867 500191 501784 503277 503395 503887 504994 505042 506629 506702 510362 511599 512593 513072 519848 524380 525208 551419 552232 554146 554764 561667 568369 569867 574890 575801 576014 576280 576379 576381 578843 595516 600403 601313 605961 609896 612574 613850 626891 651924 653260 654315 655418 660522 660959 669858 672475 672486 675359 676499 676927 677029 677039 677400 679706 681525 701487 701873 706668 709769 716033 716127 718967 719162 720985 721408 721447 723013 726398 727523 728681 731604 735625 736260 738432 740587 741596 741823 742602 745268 747421 750922 751918 755587 758314 764137 764158 768163 770438 770579 781583 782524 789240 789450 790569 795243 795696 799726 799778 800738 808761 809802 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.82%) |
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 660522 790569 795696 799778 735625 471916 554146 576280 551419 651924 677029 720985 676927 677400 721408 721447 568369 576014 601313 609896 434281 479176 461696 383818 503395 505042 524380 500191 512593 672486 719162 672475 612574 768163 726398 727523 764137 654315 600403 576379 409948 506702 513072 595516 576381 422233 479029 467544 471347 457953 447562 503887 503277 552232 660959 681525 675359 716127 718967 741823 795243 755587 731604 770579 758314 747421 574890 569867 575801 554764 613850 626891 453513 501784 525208 510362 511599 519848 386719 504994 506629 578843 701487 655418 677039 561667 799726 781583 728681 742602 750922 741596 751918 740587 745268 782524 451748 425003 484355 716033 605961 736260 498867 653260 679706 669858 676499 706668 709769 789450 808761 800738 789240 764158 738432 770438 701873 723013 809802 145314 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.76%) |
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 145314 383818 386719 409948 422233 425003 434281 447562 451748 453513 457953 461696 467544 471347 471916 479029 479176 484355 498867 500191 501784 503277 503395 503887 504994 505042 506629 506702 510362 511599 512593 513072 519848 524380 525208 551419 552232 554146 554764 561667 568369 569867 574890 575801 576014 576280 576379 576381 578843 595516 600403 601313 605961 609896 612574 613850 626891 651924 653260 654315 655418 660522 660959 669858 672475 672486 675359 676499 676927 677029 677039 677400 679706 681525 701487 701873 706668 709769 716033 716127 718967 719162 720985 721408 721447 723013 726398 727523 728681 731604 735625 736260 738432 740587 741596 741823 742602 745268 747421 750922 751918 755587 758314 764137 764158 768163 770438 770579 781583 782524 789240 789450 790569 795243 795696 799726 799778 800738 808761 809802 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian massage"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск массаж"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.19%) |
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.