Query Metrics
7
Database Queries
7
Different statements
179.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.33 ms (86.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 3576 5344 6597 39126 96431 96843 114730 134506 181584 191082 203497 203516 204545 204605 204662 237950 238244 311746 313189 327502 376405 382373 383355 384506 385360 390537 391837 395587 402123 462826 465925 466174 471804 482975 485074 485078 485087 505944 505983 512623 515661 520938 520939 521174 522571 522599 522601 522611 522620 555652 559433 571940 576131 588334 588340 588362 591330 595131 596732 596894 600750 600813 605013 621381 621390 621462 626573 644598 644628 644643 658468 680562 683850 689291 695393 697390 698616 705536 706021 710351 711589 712306 715448 715472 716055 716199 716231 718339 718739 718764 718842 723661 736071 742247 743946 751012 753600 759935 759972 759975 760226 760776 761890 772234 774114 777717 778210 786416 786875 789790 791455 799047 803425 808692 810479 815074 815127 818376 828660 828789 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (7.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 828660 751012 204605 600750 571940 376405 576131 384506 799047 723661 777717 591330 786875 522571 311746 204662 706021 743946 621462 772234 383355 485087 683850 803425 759935 808692 520938 3576 588334 555652 689291 134506 313189 385360 828789 237950 791455 778210 718339 588340 644643 485074 522620 815074 390537 588362 39126 810479 522611 774114 203497 596732 520939 712306 626573 736071 818376 605013 621381 621390 644628 716231 644598 711589 203516 6597 789790 462826 718842 471804 753600 515661 705536 382373 512623 505983 697390 716199 559433 181584 695393 698616 718764 759972 238244 96431 191082 5344 522599 680562 718739 391837 465925 466174 815127 759975 786416 395587 402123 505944 521174 716055 327502 482975 595131 761890 96843 204545 485078 715472 658468 710351 600813 742247 760226 760776 715448 114730 522601 596894 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.66%) |
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 3576 5344 6597 39126 96431 96843 114730 134506 181584 191082 203497 203516 204545 204605 204662 237950 238244 311746 313189 327502 376405 382373 383355 384506 385360 390537 391837 395587 402123 462826 465925 466174 471804 482975 485074 485078 485087 505944 505983 512623 515661 520938 520939 521174 522571 522599 522601 522611 522620 555652 559433 571940 576131 588334 588340 588362 591330 595131 596732 596894 600750 600813 605013 621381 621390 621462 626573 644598 644628 644643 658468 680562 683850 689291 695393 697390 698616 705536 706021 710351 711589 712306 715448 715472 716055 716199 716231 718339 718739 718764 718842 723661 736071 742247 743946 751012 753600 759935 759972 759975 760226 760776 761890 772234 774114 777717 778210 786416 786875 789790 791455 799047 803425 808692 810479 815074 815127 818376 828660 828789 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office secretary stockings"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш секретарш чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секретарш секретарш чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
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.