Query Metrics
7
Database Queries
7
Different statements
379.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.33 ms (56.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
142.18 ms (37.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 393058 425003 432404 435358 448561 469828 477810 478952 481813 492940 504994 506669 507549 513540 525239 529676 532110 533193 538588 542737 542944 544047 561157 561399 561595 574689 590029 590813 591778 591968 599669 600795 603021 604864 609935 610215 610223 611448 612574 616118 619913 621453 621538 628677 631129 637956 644225 644536 644780 662401 669858 690179 692958 695051 697916 700598 707250 709372 709835 710066 710881 712157 714958 726398 727523 728171 729559 731652 732976 733309 738432 739551 745347 746207 747421 748450 749003 750376 755364 758306 761607 762205 763427 764137 764158 765522 767470 767720 767748 768163 771584 772314 773187 776042 782524 785667 786390 786549 789240 789450 791774 793153 794421 794574 795354 795374 796865 797221 798121 798197 799727 800738 801126 802179 802825 808761 809877 814570 817146 825715 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (3.60%) |
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 432404 533193 507549 791774 797221 798197 749003 732976 748450 782524 809877 697916 644225 621538 731652 729559 738432 761607 448561 599669 513540 525239 799727 538588 669858 710881 794574 789450 795374 786390 802179 789240 764158 767470 771584 796865 435358 481813 478952 591968 612574 532110 695051 604864 628677 637956 621453 590029 610215 600795 603021 768163 609935 611448 616118 644536 644780 709372 709835 710066 504994 393058 814570 477810 469828 808761 798121 800738 802825 793153 767748 765522 755364 767720 750376 801126 542944 561399 726398 727523 764137 506669 825715 529676 574689 662401 785667 733309 758306 772314 728171 762205 745347 763427 739551 776042 795354 492940 542737 590813 425003 544047 561595 692958 690179 712157 561157 610223 591778 619913 794421 747421 631129 700598 707250 786549 817146 714958 773187 746207 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.78%) |
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 393058 425003 432404 435358 448561 469828 477810 478952 481813 492940 504994 506669 507549 513540 525239 529676 532110 533193 538588 542737 542944 544047 561157 561399 561595 574689 590029 590813 591778 591968 599669 600795 603021 604864 609935 610215 610223 611448 612574 616118 619913 621453 621538 628677 631129 637956 644225 644536 644780 662401 669858 690179 692958 695051 697916 700598 707250 709372 709835 710066 710881 712157 714958 726398 727523 728171 729559 731652 732976 733309 738432 739551 745347 746207 747421 748450 749003 750376 755364 758306 761607 762205 763427 764137 764158 765522 767470 767720 767748 768163 771584 772314 773187 776042 782524 785667 786390 786549 789240 789450 791774 793153 794421 794574 795354 795374 796865 797221 798121 798197 799727 800738 801126 802179 802825 808761 809877 814570 817146 825715 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage home made"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.