Query Metrics
7
Database Queries
7
Different statements
225.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.70 ms (89.43%) |
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 82143 383246 421355 427967 428996 431672 433610 448541 452247 454824 454877 454970 457291 463139 466425 466612 468558 468778 471866 474393 474610 474735 476697 477676 483708 484494 500712 505296 509412 510669 514747 527753 528506 530470 530838 535643 550375 550413 559645 564794 564795 565205 571210 571212 578043 582779 588615 589031 593915 599882 601424 601664 602049 603004 605314 605323 605335 613485 622137 625774 631132 631692 634546 650489 663520 673149 673364 674120 677322 701158 709207 710246 711875 716528 716911 717025 720384 720580 721778 724659 724811 725587 727633 727786 730249 730261 730855 731766 732099 733597 733613 737064 739928 740228 740598 741010 741978 743117 744511 744607 745411 748159 749468 752112 755436 756000 757556 758961 767302 774009 774099 777248 782699 793640 798585 799349 800450 803015 815091 ] |
||||||||||||||||||||||||||||||
|
12.34 ms (5.47%) |
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 798585 82143 454970 466612 588615 602049 799349 383246 468558 514747 500712 509412 565205 730261 716911 559645 691555 711875 717025 663520 674120 720580 550413 582779 605314 733613 740598 741978 767302 793640 800450 732099 737064 740228 724659 733597 745411 752112 774099 701158 510669 477676 749468 431672 448541 454824 571210 673149 613485 601424 605335 774009 484494 720384 721778 589031 631692 744607 471866 476697 468778 474393 748159 421355 427967 466425 463139 428996 483708 528506 505296 527753 564794 550375 578043 622137 625774 782699 803015 725587 727786 730855 741010 724811 731766 755436 757556 758961 739928 631132 709207 777248 474735 452247 457291 535643 571212 673364 599882 605323 634546 603004 433610 474610 454877 650489 677322 716528 710246 593915 601664 756000 730249 743117 744511 727633 815091 530470 530838 564795 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (1.70%) |
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 82143 383246 421355 427967 428996 431672 433610 448541 452247 454824 454877 454970 457291 463139 466425 466612 468558 468778 471866 474393 474610 474735 476697 477676 483708 484494 500712 505296 509412 510669 514747 527753 528506 530470 530838 535643 550375 550413 559645 564794 564795 565205 571210 571212 578043 582779 588615 589031 593915 599882 601424 601664 602049 603004 605314 605323 605335 613485 622137 625774 631132 631692 634546 650489 663520 673149 673364 674120 677322 701158 709207 710246 711875 716528 716911 717025 720384 720580 721778 724659 724811 725587 727633 727786 730249 730261 730855 731766 732099 733597 733613 737064 739928 740228 740598 741010 741978 743117 744511 744607 745411 748159 749468 752112 755436 756000 757556 758961 767302 774009 774099 777248 782699 793640 798585 799349 800450 803015 815091 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг hair pussy"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting hair pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг hair pussy"
]
|
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.