Query Metrics
7
Database Queries
7
Different statements
143.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.16 ms (84.50%) |
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 205 160126 319102 382938 383042 386147 386786 387436 388208 389249 389877 392658 393323 398199 403999 410561 418545 479724 486143 493182 530165 531737 533506 533880 537538 542283 544402 546165 564791 567314 603746 604627 605142 609097 615813 618376 621502 624603 642212 648742 650246 652268 666089 666375 670391 676482 687123 689279 697149 697945 698100 712566 712659 715173 716309 718229 722372 727381 729681 729907 738513 739859 740334 741150 742128 742734 743966 744342 745215 746116 747582 748175 749469 754256 754380 754982 766116 770089 771468 774783 780146 780478 782991 787741 789492 789675 799167 800281 801055 802424 802446 802888 804561 805245 809642 810486 813847 816704 817186 817304 817873 818296 818707 819240 819254 821034 821221 821343 822440 822442 822473 822865 822916 824559 826504 827227 827718 828725 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (8.67%) |
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 715173 718229 392658 387436 729907 754256 382938 817873 821343 826504 827227 827718 819254 821221 817304 821034 828725 486143 530165 531737 537538 533880 546165 542283 697945 666089 698100 722372 642212 618376 603746 605142 621502 787741 800281 804561 810486 774783 801055 740334 746116 749469 771468 805245 729681 727381 738513 741150 744342 386147 383042 160126 567314 687123 666375 742734 809642 403999 386786 393323 388208 418545 712659 670391 789675 742128 780478 802446 205 609097 604627 389877 813847 818707 824559 816704 818296 822865 479724 533506 564791 544402 689279 716309 652268 676482 697149 648742 650246 624603 615813 780146 789492 802888 747582 782991 799167 748175 745215 755279 770089 739859 766116 743966 754380 754982 765910 712566 802424 398199 410561 493182 319102 389249 817186 819240 822440 822442 822473 822916 ] |
||||||||||||||||||||||||||||||
|
2.89 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 205 160126 319102 382938 383042 386147 386786 387436 388208 389249 389877 392658 393323 398199 403999 410561 418545 479724 486143 493182 530165 531737 533506 533880 537538 542283 544402 546165 564791 567314 603746 604627 605142 609097 615813 618376 621502 624603 642212 648742 650246 652268 666089 666375 670391 676482 687123 689279 697149 697945 698100 712566 712659 715173 716309 718229 722372 727381 729681 729907 738513 739859 740334 741150 742128 742734 743966 744342 745215 746116 747582 748175 749469 754256 754380 754982 766116 770089 771468 774783 780146 780478 782991 787741 789492 789675 799167 800281 801055 802424 802446 802888 804561 805245 809642 810486 813847 816704 817186 817304 817873 818296 818707 819240 819254 821034 821221 821343 822440 822442 822473 822865 822916 824559 826504 827227 827718 828725 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toys sex"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"toys секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"toys секс"
]
|
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.