Query Metrics
7
Database Queries
7
Different statements
181.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.84 ms (85.83%) |
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 373905 381789 383360 384905 385608 387650 388847 389891 390717 395310 397063 400668 401940 407885 409590 428224 441829 441847 441864 454699 454784 456263 462914 467952 468352 474672 475482 478298 485281 491583 510547 516716 518504 519332 531794 531882 541270 545198 545217 546838 550339 564731 566764 583554 587755 588278 588446 589079 592275 593116 597700 605256 605312 621066 621081 625765 629194 630685 632108 635124 636816 642689 655184 660702 665959 678959 682924 702571 707616 711458 715098 717545 719996 724854 726926 727887 748340 749457 750168 750727 758495 758498 758538 758567 760965 761040 761066 765715 767189 767220 767279 774689 774698 774702 775188 788176 788248 792179 792180 793472 793727 798365 800492 800796 800856 801213 801348 803327 804327 810214 810249 810320 811540 813879 814965 815014 817246 817331 827588 ] |
||||||||||||||||||||||||||||||
|
13.74 ms (7.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 774702 468352 775188 665959 519332 541270 660702 774689 792179 750727 804327 815014 531794 726926 719996 765715 767279 383360 456263 395310 707616 531882 801213 632108 711458 588278 800796 629194 491583 441829 682924 583554 775033 758567 625765 475482 397063 748340 516716 655184 605256 545198 678959 454784 564731 593116 636816 592275 597700 792180 788248 800492 758495 750168 724854 758498 642689 385608 381789 630685 800856 441847 810214 811540 400668 774698 605312 621081 635124 588446 749457 817246 389891 550339 810320 388847 390717 441864 793472 761040 474672 454699 510547 717545 788176 793727 727887 758538 407885 827588 401940 428224 462914 545217 546838 566764 589079 587755 801348 767220 810249 761066 409590 485281 817331 373905 467952 478298 518504 384905 715098 813879 814965 702571 621066 798365 803327 767189 760965 387650 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.02%) |
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 373905 381789 383360 384905 385608 387650 388847 389891 390717 395310 397063 400668 401940 407885 409590 428224 441829 441847 441864 454699 454784 456263 462914 467952 468352 474672 475482 478298 485281 491583 510547 516716 518504 519332 531794 531882 541270 545198 545217 546838 550339 564731 566764 583554 587755 588278 588446 589079 592275 593116 597700 605256 605312 621066 621081 625765 629194 630685 632108 635124 636816 642689 655184 660702 665959 678959 682924 702571 707616 711458 715098 717545 719996 724854 726926 727887 748340 749457 750168 750727 758495 758498 758538 758567 760965 761040 761066 765715 767189 767220 767279 774689 774698 774702 775188 788176 788248 792179 792180 793472 793727 798365 800492 800796 800856 801213 801348 803327 804327 810214 810249 810320 811540 813879 814965 815014 817246 817331 827588 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в жопу латинку"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал латинская"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал латинская"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
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.