Query Metrics
7
Database Queries
7
Different statements
144.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.41 ms (83.96%) |
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 49426 88226 89421 154123 154442 382298 384336 419167 436639 438181 455887 458376 465127 465429 474911 475280 477348 480450 497019 511584 513010 516571 517437 519625 527524 535381 537003 541513 542321 545010 546455 550941 552922 554766 562043 563597 567033 571707 572269 574203 575028 576574 581048 582636 583350 584593 586086 588401 595258 596610 602600 606227 607244 613615 614199 615781 615831 617045 619802 623277 628221 629794 634456 637608 643026 647213 649914 650270 653720 661331 662046 664384 668690 669936 670769 692744 707390 717595 732926 734123 736864 741609 743188 746000 749575 751441 752864 753702 756895 757500 769335 770918 772483 777007 780889 781017 786266 786310 790696 791804 792405 798151 799677 801114 804386 805440 806057 812040 813587 813899 818732 819089 819123 819437 819488 822633 826608 827713 828068 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (9.52%) |
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 550941 584593 563597 575028 581048 661331 606227 734123 749575 732926 751441 474911 813899 668690 613615 596610 806057 465127 772483 617045 790696 436639 384336 154442 88226 154123 571707 545010 583350 511584 516571 519625 419167 480450 458376 619802 89421 562043 542321 669936 607244 615831 465429 475280 438181 455887 649914 813587 812040 818732 826608 827713 819123 822633 819089 819437 828068 828117 497019 527524 535381 574203 541513 552922 572269 647213 707390 567033 576574 628221 629794 634456 602600 588401 614199 643026 781017 780889 792405 801114 804386 770918 786266 805440 736864 741609 757500 769335 743188 752864 753702 746000 756895 615781 637608 786310 791804 799677 662046 586086 819488 477348 582636 653720 664384 670769 623277 595258 777007 798151 513010 382298 49426 517437 537003 546455 692744 717595 650270 554766 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.93%) |
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 49426 88226 89421 154123 154442 382298 384336 419167 436639 438181 455887 458376 465127 465429 474911 475280 477348 480450 497019 511584 513010 516571 517437 519625 527524 535381 537003 541513 542321 545010 546455 550941 552922 554766 562043 563597 567033 571707 572269 574203 575028 576574 581048 582636 583350 584593 586086 588401 595258 596610 602600 606227 607244 613615 614199 615781 615831 617045 619802 623277 628221 629794 634456 637608 643026 647213 649914 650270 653720 661331 662046 664384 668690 669936 670769 692744 707390 717595 732926 734123 736864 741609 743188 746000 749575 751441 752864 753702 756895 757500 769335 770918 772483 777007 780889 781017 786266 786310 790696 791804 792405 798151 799677 801114 804386 805440 806057 812040 813587 813899 818732 819089 819123 819437 819488 822633 826608 827713 828068 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public dildo masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц дилд мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.83%) |
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.