Query Metrics
7
Database Queries
7
Different statements
143.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.21 ms (84.24%) |
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 82307 246657 389719 418182 451536 471069 522156 527789 528405 531032 532822 533114 534007 539330 551128 557921 560359 562574 562605 580346 585685 591023 591660 592035 600277 601540 605354 606795 613689 615572 615949 624354 629069 633402 638440 643699 646801 650949 652959 655444 662586 664137 665326 666604 670810 670942 671532 698112 709314 709725 715597 718392 733400 734846 735928 735994 738500 740374 745052 745543 745784 750866 752093 752947 752992 754039 754391 754580 754616 754739 754790 755004 755045 755324 757499 757857 758944 759368 760585 770443 772178 772386 772769 774039 774049 776466 778381 778638 778674 778691 780888 783324 784147 788765 790420 791496 792508 793510 796790 804797 810497 811601 811878 812220 812240 812246 812512 813723 814199 816813 816843 816858 816867 817645 818535 819157 823241 824214 825856 827124 ] |
||||||||||||||||||||||||||||||
|
12.19 ms (8.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 816813 816843 816867 824214 533114 534007 562605 652959 709725 718392 698112 560359 562574 591660 615949 585685 776466 778674 778691 784147 790420 812512 772386 735994 745784 754039 752093 754391 754739 754790 770443 772769 605354 613689 715597 788765 792508 246657 580346 670942 745543 755045 780888 816858 823241 814199 827124 813723 818535 825856 532822 531032 539330 527789 551128 666604 671532 646801 650949 655444 670810 662586 664137 665326 709314 591023 606795 624354 629069 643699 592035 633402 600277 601540 638440 615572 812220 812240 778638 793510 810497 812246 733400 740374 754580 757857 774049 783324 734846 750866 752947 755004 758944 738500 772178 774039 735928 745052 755324 757499 759368 752992 754616 760585 778381 791496 796790 804797 811601 811878 82307 389719 418182 817645 819157 451536 471069 522156 528405 557921 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.62%) |
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 82307 246657 389719 418182 451536 471069 522156 527789 528405 531032 532822 533114 534007 539330 551128 557921 560359 562574 562605 580346 585685 591023 591660 592035 600277 601540 605354 606795 613689 615572 615949 624354 629069 633402 638440 643699 646801 650949 652959 655444 662586 664137 665326 666604 670810 670942 671532 698112 709314 709725 715597 718392 733400 734846 735928 735994 738500 740374 745052 745543 745784 750866 752093 752947 752992 754039 754391 754580 754616 754739 754790 755004 755045 755324 757499 757857 758944 759368 760585 770443 772178 772386 772769 774039 774049 776466 778381 778638 778674 778691 780888 783324 784147 788765 790420 791496 792508 793510 796790 804797 810497 811601 811878 812220 812240 812246 812512 813723 814199 816813 816843 816858 816867 817645 818535 819157 823241 824214 825856 827124 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair solo"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair соло"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair соло"
]
|
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.