Query Metrics
7
Database Queries
7
Different statements
378.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.50 ms (56.14%) |
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 393148 398643 403035 427716 429705 434369 434673 435522 437867 439260 441098 446063 448247 448522 449908 450038 452747 456594 463420 465309 467929 493909 497013 499789 503486 522324 528770 533099 541567 546971 554187 554826 555044 555236 556530 556896 557582 565425 566775 566843 580934 583293 586435 588332 590412 591487 618267 620552 626108 629771 629797 634638 651587 661061 661422 662483 678836 678837 678838 703930 705427 705478 706765 714095 714238 720013 724987 728669 735776 741220 745464 747483 750653 752758 767695 767731 768881 769400 770253 773016 773059 776065 777984 777989 780553 783349 783929 783935 783937 784105 784513 785340 785663 786727 787124 793847 794217 794931 795210 796194 797006 799947 800977 801000 801636 801724 801827 803566 807008 808158 808655 813002 813203 813296 820020 820157 823272 824245 824867 825791 ] |
||||||||||||||||||||||||||||||
|
144.58 ms (38.20%) |
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 393148 398643 403035 427716 429705 434369 434673 435522 437867 439260 441098 446063 448247 448522 449908 450038 452747 456594 463420 465309 467929 493909 497013 499789 503486 522324 528770 533099 541567 546971 554187 554826 555044 555236 556530 556896 557582 565425 566775 566843 580934 583293 586435 588332 590412 591487 618267 620552 626108 629771 629797 634638 651587 661061 661422 662483 678836 678837 678838 703930 705427 705478 706765 714095 714238 720013 724987 728669 735776 741220 745464 747483 750653 752758 767695 767731 768881 769400 770253 773016 773059 776065 777984 777989 780553 783349 783929 783935 783937 784105 784513 785340 785663 786727 787124 793847 794217 794931 795210 796194 797006 799947 800977 801000 801636 801724 801827 803566 807008 808158 808655 813002 813203 813296 820020 820157 823272 824245 824867 825791 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (3.63%) |
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 770253 703930 427716 429705 452747 435522 465309 439260 820157 820020 823272 825791 497013 533099 580934 678837 634638 777984 787124 794931 801827 783349 785340 728669 767695 724987 773016 750653 618267 776065 783937 555236 546971 583293 554187 784513 796194 747483 773059 741220 793847 797006 434369 554826 586435 591487 467929 393148 398643 403035 441098 824245 824867 456594 566775 661422 662483 678836 705478 714095 651587 661061 714238 720013 556896 565425 588332 629771 590412 620552 629797 800977 807008 813002 813296 783929 783935 784105 786727 801724 803566 808158 813203 735776 767731 752758 768881 705427 795210 801000 450038 678838 706765 557582 626108 777989 780553 794217 799947 448247 449908 493909 463420 785663 745464 434673 437867 446063 448522 522324 503486 528770 499789 541567 555044 556530 566843 801636 808655 769400 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм жен"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt wife"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.