Query Metrics
7
Database Queries
7
Different statements
175.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.68 ms (87.34%) |
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 396441 402046 402672 409121 415544 419192 437515 447560 460142 464306 465631 466831 467373 471352 476931 485262 486889 487543 491591 501404 505750 516976 521219 521676 524247 524693 531361 541373 543185 554974 555952 560958 561638 575056 582583 587058 587927 588176 589464 591664 591900 592428 595950 596041 600081 600281 601080 615810 620636 624481 632936 635236 645852 648326 662158 662557 667497 671625 675084 675481 676778 680934 693340 700328 705702 716911 717085 720775 720784 720994 726646 726947 727624 727923 727965 728097 728506 729253 729587 734565 735545 736281 736999 737371 737697 743324 743875 744571 744821 745844 746473 747292 748631 749121 751943 754841 756721 759842 759880 765444 770464 777036 788663 801383 803453 810984 811004 813349 813530 815288 815920 817227 817628 817666 818831 819039 819207 819855 820356 820724 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (7.33%) |
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 734565 743324 726646 746473 754841 632936 717085 720784 788663 803453 620636 396441 819855 531361 465631 543185 554974 705702 555952 588176 635236 587927 727965 735545 745844 747292 759842 716911 471352 524693 541373 595950 600281 464306 419192 447560 409121 815288 817628 817666 817227 818831 819039 820356 819207 815920 820724 460142 680934 648326 675481 676778 693340 662158 700328 720775 592428 596041 589464 615810 801383 813349 777036 737371 749121 751943 811004 729587 737697 744571 744821 748631 759880 727624 728097 728506 743875 765444 726947 729253 736999 756721 770464 720994 402046 415544 466831 476931 485262 487543 491591 516976 521219 521676 582583 560958 561638 575056 662557 671625 675084 645852 667497 591664 601080 624481 587058 591900 600081 813530 736281 810984 727923 437515 402672 467373 505750 486889 501404 524247 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.50%) |
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 396441 402046 402672 409121 415544 419192 437515 447560 460142 464306 465631 466831 467373 471352 476931 485262 486889 487543 491591 501404 505750 516976 521219 521676 524247 524693 531361 541373 543185 554974 555952 560958 561638 575056 582583 587058 587927 588176 589464 591664 591900 592428 595950 596041 600081 600281 601080 615810 620636 624481 632936 635236 645852 648326 662158 662557 667497 671625 675084 675481 676778 680934 693340 700328 705702 716911 717085 720775 720784 720994 726646 726947 727624 727923 727965 728097 728506 729253 729587 734565 735545 736281 736999 737371 737697 743324 743875 744571 744821 745844 746473 747292 748631 749121 751943 754841 756721 759842 759880 765444 770464 777036 788663 801383 803453 810984 811004 813349 813530 815288 815920 817227 817628 817666 818831 819039 819207 819855 820356 820724 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock licking"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock лиза"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock лиза"
]
|
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.