Query Metrics
7
Database Queries
7
Different statements
182.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.17 ms (87.07%) |
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 37730 350287 392208 398622 423531 435523 441359 459651 490511 572270 572671 578744 578756 578789 591341 591963 595440 597047 604552 606265 609291 609864 610023 616595 633822 634385 635004 641881 645667 647788 651766 656566 677919 698207 700208 702128 704138 704840 705531 710859 710864 714929 715907 717033 717712 721977 722109 725065 725156 726327 727579 727738 732594 734347 734661 736780 737997 738218 742719 748908 750129 750808 752828 755119 759719 760899 760934 760988 761484 762272 763797 764207 764748 765219 766591 766599 767138 767154 767257 768637 769036 770774 770835 773691 776216 777033 778954 781359 781515 781522 781587 783000 783368 783378 783679 788163 788730 789368 790298 791422 791506 791932 792469 794859 794924 795881 795916 796131 796593 797045 798019 798891 800832 801553 803145 804228 810039 812149 812161 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (7.69%) |
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 698207 704138 714929 715907 717033 722109 645667 647788 651766 656566 677919 702128 704840 710859 710864 721977 572270 572671 578744 578756 578789 604552 606265 641881 633822 591963 595440 609291 610023 597047 609864 635004 776216 781587 783000 788730 790298 791932 792469 794859 796131 798891 801553 777033 778954 781359 783679 796593 798019 800832 804228 725065 725156 727738 734661 755119 761484 762272 767138 767154 767257 770774 781515 783368 783378 788163 791506 794924 795881 810039 726327 734347 736780 737997 760988 766599 768637 769036 750129 759719 760934 760972 764207 765219 766591 770835 773691 732594 738218 748908 750808 752828 760899 727579 742719 763797 764748 616595 634385 700208 705531 717712 781522 789368 791422 795916 797045 803145 812149 812161 37730 392208 350287 591341 490511 459651 398622 441359 423531 435523 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.64%) |
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 37730 350287 392208 398622 423531 435523 441359 459651 490511 572270 572671 578744 578756 578789 591341 591963 595440 597047 604552 606265 609291 609864 610023 616595 633822 634385 635004 641881 645667 647788 651766 656566 677919 698207 700208 702128 704138 704840 705531 710859 710864 714929 715907 717033 717712 721977 722109 725065 725156 726327 727579 727738 732594 734347 734661 736780 737997 738218 742719 748908 750129 750808 752828 755119 759719 760899 760934 760988 761484 762272 763797 764207 764748 765219 766591 766599 767138 767154 767257 768637 769036 770774 770835 773691 776216 777033 778954 781359 781515 781522 781587 783000 783368 783378 783679 788163 788730 789368 790298 791422 791506 791932 792469 794859 794924 795881 795916 796131 796593 797045 798019 798891 800832 801553 803145 804228 810039 812149 812161 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy creampie"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак creampie"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак creampie"
]
|
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.