Query Metrics
7
Database Queries
7
Different statements
192.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.10 ms (86.19%) |
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 96690 122767 382255 383517 398426 405056 411384 420135 450774 452049 452082 490038 506334 513964 514697 515569 531171 532361 532670 533595 533855 534034 534961 536291 537195 537886 538888 539159 540497 544792 548455 551937 552938 559180 562846 569187 569192 570683 579088 580259 581035 591789 595741 599894 599958 600007 600962 601605 603178 603204 604493 606511 612062 614529 617800 621990 645948 647600 659072 660148 660422 661882 662604 663927 666585 667644 677703 683529 686835 691830 692208 694207 694485 704525 704953 714522 714938 716323 717836 718974 720939 721140 722465 723512 727856 734116 735385 739208 752512 753690 756766 773993 775813 775835 775873 775876 775880 789981 789983 790029 796431 798815 801231 804447 804478 804481 805343 806379 815121 817929 818847 819493 819506 820682 820767 820772 820776 823313 824156 824469 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (8.94%) |
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 818847 824156 551937 569187 548455 692208 659072 722465 570683 621990 603204 775813 775873 775876 805343 773993 806379 734116 735385 753690 752512 796431 420135 398426 452082 383517 823313 817929 819493 533595 515569 538888 540497 514697 532361 532670 490038 544792 661882 691830 718974 686835 645948 663927 694207 694485 720939 569192 595741 604493 606511 612062 614529 775880 789981 804481 775835 789983 801231 804478 727856 739208 756766 617800 721140 790029 798815 804447 122767 382255 96690 405056 411384 820772 723512 820682 820767 815121 819506 820776 824469 452049 450774 539159 506334 513964 531171 534034 536291 537195 533855 534961 537886 580259 559180 562846 581035 647600 667644 683529 714522 660148 666585 704525 704953 716323 660422 662604 677703 714938 717836 552938 579088 591789 599894 599958 600007 600962 601605 603178 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.27%) |
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 96690 122767 382255 383517 398426 405056 411384 420135 450774 452049 452082 490038 506334 513964 514697 515569 531171 532361 532670 533595 533855 534034 534961 536291 537195 537886 538888 539159 540497 544792 548455 551937 552938 559180 562846 569187 569192 570683 579088 580259 581035 591789 595741 599894 599958 600007 600962 601605 603178 603204 604493 606511 612062 614529 617800 621990 645948 647600 659072 660148 660422 661882 662604 663927 666585 667644 677703 683529 686835 691830 692208 694207 694485 704525 704953 714522 714938 716323 717836 718974 720939 721140 722465 723512 727856 734116 735385 739208 752512 753690 756766 773993 775813 775835 775873 775876 775880 789981 789983 790029 796431 798815 801231 804447 804478 804481 805343 806379 815121 817929 818847 819493 819506 820682 820767 820772 820776 823313 824156 824469 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group mother"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group мам женщин"
]
|
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.