Query Metrics
7
Database Queries
7
Different statements
179.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.42 ms (86.81%) |
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 384581 417162 437670 439569 439655 443182 443711 443969 444707 445709 446297 451271 453740 456058 459133 462489 464200 464805 473483 478972 482554 502788 507088 511790 512343 517518 518944 523905 526181 526449 531995 532004 532028 532041 532060 532131 536330 537116 549648 549719 552299 554400 560363 561453 563423 571708 576995 586314 592933 595574 601076 603307 619778 623714 633412 640941 646067 659197 660070 661987 661991 693257 701222 706560 708161 708582 709458 714489 715459 718130 719977 720313 725229 725442 725448 725456 725473 725484 725499 725513 725536 729664 731019 731070 731073 731079 731093 731129 731204 735840 735908 736378 738395 741044 741769 742760 743429 744404 746028 746165 746176 746594 746601 760425 779576 779768 784819 787762 795983 796202 796205 796759 800719 800743 800926 801098 801112 803437 808859 824810 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (7.54%) |
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 532041 536330 537116 502788 549719 560363 715459 646067 714489 718130 603307 784819 800926 725536 741044 796759 803437 808859 731093 738395 744404 746028 741769 459133 532028 453740 417162 444707 443969 482554 549648 693257 708582 719977 661991 701222 720313 592933 633412 623714 601076 801098 800719 725229 725448 725484 725499 731019 731079 736378 746594 760425 725473 743429 746176 742760 439655 507088 511790 462489 384581 437670 824810 451271 517518 512343 518944 523905 526449 532131 531995 532060 478972 659197 660070 661987 708161 554400 779768 787762 800743 725513 731070 801112 729664 735840 746165 746601 731129 706560 443711 526181 439569 443182 445709 446297 464805 473483 456058 532004 464200 571708 576995 552299 709458 561453 563423 619778 586314 595574 640941 779576 795983 796205 796202 725442 731204 735908 725456 731073 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.69%) |
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 384581 417162 437670 439569 439655 443182 443711 443969 444707 445709 446297 451271 453740 456058 459133 462489 464200 464805 473483 478972 482554 502788 507088 511790 512343 517518 518944 523905 526181 526449 531995 532004 532028 532041 532060 532131 536330 537116 549648 549719 552299 554400 560363 561453 563423 571708 576995 586314 592933 595574 601076 603307 619778 623714 633412 640941 646067 659197 660070 661987 661991 693257 701222 706560 708161 708582 709458 714489 715459 718130 719977 720313 725229 725442 725448 725456 725473 725484 725499 725513 725536 729664 731019 731070 731073 731079 731093 731129 731204 735840 735908 736378 738395 741044 741769 742760 743429 744404 746028 746165 746176 746594 746601 760425 779576 779768 784819 787762 795983 796202 796205 796759 800719 800743 800926 801098 801112 803437 808859 824810 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son webcam"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son вебкамер"
]
|
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.