Query Metrics
7
Database Queries
7
Different statements
500.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
249.90 ms (49.88%) |
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 148814 391317 392318 398302 414064 414067 416501 416536 416669 416689 416696 416715 420799 432283 445958 454597 456245 469055 469058 484934 505386 513758 517655 523357 524676 529498 530149 530692 530958 531732 544147 545379 577068 579253 581645 583290 584348 589991 592633 594177 598543 601550 611437 622367 623184 624302 628205 628732 630449 632312 642106 643619 655211 656893 657528 661034 664572 669545 670404 670439 675859 692985 695604 696143 697833 702336 702342 702357 707895 711133 712342 713301 717553 723266 735731 740269 744551 745139 747705 748309 749256 751411 751426 752758 753649 753681 755553 756144 756822 756832 756843 757223 758806 760756 762182 763406 765248 765251 765256 765262 765681 770860 774712 776057 781304 783690 783743 783962 787514 789219 790133 792065 793009 801313 803383 803613 811018 822304 823333 ] |
||||||||||||||||||||||||||||||
|
215.78 ms (43.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло teen toys"
]
|
||||||||||||||||||||||||||||||
|
26.98 ms (5.39%) |
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 735731 751426 756144 762182 764783 748309 749256 755553 757223 763406 770860 744551 745139 751411 753649 756822 756832 756843 711133 781304 789219 803613 811018 148814 414064 416536 416715 416669 416696 524676 523357 505386 545379 577068 416501 456245 661034 628205 420799 513758 484934 392318 822304 823333 517655 529498 530149 530958 530692 531732 581645 583290 544147 579253 584348 657528 669545 670404 670439 675859 702336 707895 712342 713301 717553 655211 656893 664572 692985 695604 696143 723266 589991 622367 628732 630449 592633 598543 601550 623184 624302 643619 594177 611437 642106 774712 783690 783743 790133 803383 776057 792065 801313 760756 765248 765262 783962 793009 765251 765256 758806 765681 747705 752758 753681 740269 632312 697833 702342 702357 787514 454597 391317 398302 469055 469058 445958 432283 416689 414067 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.56%) |
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 148814 391317 392318 398302 414064 414067 416501 416536 416669 416689 416696 416715 420799 432283 445958 454597 456245 469055 469058 484934 505386 513758 517655 523357 524676 529498 530149 530692 530958 531732 544147 545379 577068 579253 581645 583290 584348 589991 592633 594177 598543 601550 611437 622367 623184 624302 628205 628732 630449 632312 642106 643619 655211 656893 657528 661034 664572 669545 670404 670439 675859 692985 695604 696143 697833 702336 702342 702357 707895 711133 712342 713301 717553 723266 735731 740269 744551 745139 747705 748309 749256 751411 751426 752758 753649 753681 755553 756144 756822 756832 756843 757223 758806 760756 762182 763406 765248 765251 765256 765262 765681 770860 774712 776057 781304 783690 783743 783962 787514 789219 790133 792065 793009 801313 803383 803613 811018 822304 823333 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло teen toys"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo teen toys"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.34%) |
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.