Query Metrics
7
Database Queries
7
Different statements
178.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.18 ms (85.24%) |
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 381921 388532 405990 408460 416153 418068 418780 419181 425820 427311 428741 435078 439256 440876 441623 444956 450579 451752 452382 453963 458466 464188 466688 468574 469465 474902 492719 497878 497924 501958 504488 507503 512073 517974 519872 522973 527428 531201 533944 535056 536571 537467 543476 559178 567527 575610 579457 579797 594131 594136 594221 594285 595977 596621 598524 598720 599990 606346 627724 628401 633435 633796 634804 642323 652612 653455 653560 666538 666880 669410 670534 679799 688581 693502 696103 698866 702048 703142 704275 704910 704916 710903 710920 720828 727052 733841 733851 733887 735772 744896 747313 748927 748965 754127 754470 755188 757395 760254 760612 767325 770271 770376 771452 782547 785589 785603 786524 790069 803450 803494 805300 805900 813899 815778 815816 816555 818475 820652 821195 827404 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (9.57%) |
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 771452 744896 748965 754470 704275 388532 642323 704910 653455 628401 427311 444956 517974 543476 579457 755188 439256 464188 527428 679799 450579 512073 666880 497924 594136 693502 418780 579797 696103 594285 782547 790069 760254 748927 733887 735772 757395 594131 440876 627724 408460 435078 688581 595977 599990 770271 501958 418068 425820 453963 634804 733851 710903 803494 533944 559178 633435 594221 469465 536571 698866 704916 710920 381921 754127 468574 669410 452382 535056 821195 537467 760612 786524 820652 827404 703142 652612 720828 596621 598720 805900 785603 727052 767325 428741 504488 531201 405990 416153 492719 815778 816555 813899 458466 474902 466688 497878 670534 606346 785589 803450 805300 733841 747313 770376 419181 451752 522973 598524 633796 441623 653560 519872 666538 507503 818475 815816 575610 567527 702048 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.51%) |
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 381921 388532 405990 408460 416153 418068 418780 419181 425820 427311 428741 435078 439256 440876 441623 444956 450579 451752 452382 453963 458466 464188 466688 468574 469465 474902 492719 497878 497924 501958 504488 507503 512073 517974 519872 522973 527428 531201 533944 535056 536571 537467 543476 559178 567527 575610 579457 579797 594131 594136 594221 594285 595977 596621 598524 598720 599990 606346 627724 628401 633435 633796 634804 642323 652612 653455 653560 666538 666880 669410 670534 679799 688581 693502 696103 698866 702048 703142 704275 704910 704916 710903 710920 720828 727052 733841 733851 733887 735772 744896 747313 748927 748965 754127 754470 755188 757395 760254 760612 767325 770271 770376 771452 782547 785589 785603 786524 790069 803450 803494 805300 805900 813899 815778 815816 816555 818475 820652 821195 827404 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen big squirt"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen большие сквирт оргазм"
]
|
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.