Query Metrics
7
Database Queries
7
Different statements
191.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.72 ms (83.94%) |
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 389567 392066 394031 395780 396075 400446 402434 403653 411552 415815 419028 419955 420824 421144 426011 427081 427129 432887 434470 436444 437948 438023 438062 441942 442003 443958 450149 451279 452655 452656 452719 452872 455597 456350 461809 465692 469333 469361 469710 470489 472362 472383 475213 475571 478212 492164 496472 498670 500994 501079 507519 509652 514066 520206 521036 521722 522439 525599 530194 531364 532614 536989 541546 542509 549490 551834 553239 555110 557809 557901 564304 569122 579557 590761 592963 593557 594167 598300 607481 613015 613208 613848 615963 621099 628589 633764 634536 635041 645258 653330 661613 666418 669784 670234 689136 689606 700752 708450 710805 715824 716546 723589 725425 729123 747044 763378 764486 766628 767769 777482 784280 787754 798631 800470 807663 809702 809910 810531 813621 813625 ] |
||||||||||||||||||||||||||||||
|
20.47 ms (10.69%) |
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 525599 394031 438062 723589 813625 469361 509652 520206 557809 551834 669784 716546 670234 590761 592963 809910 747044 392066 475213 438023 514066 522439 400446 469333 492164 455597 536989 521036 569122 653330 689136 700752 634536 598300 729123 809702 725425 807663 427129 419028 434470 436444 452719 403653 420824 441942 443958 402434 437948 530194 541546 579557 542509 661613 666418 555110 613015 613208 621099 635041 787754 800470 784280 763378 764486 633764 389567 415815 421144 426011 427081 470489 395780 411552 419955 813621 452655 450149 500994 521722 501079 531364 532614 557901 549490 564304 689606 708450 645258 715824 710805 553239 593557 628589 607481 613848 594167 615963 798631 810531 767769 766628 777482 451279 461809 442003 478212 432887 452656 456350 472383 475571 472362 498670 496472 507519 396075 465692 469710 452872 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (1.87%) |
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 389567 392066 394031 395780 396075 400446 402434 403653 411552 415815 419028 419955 420824 421144 426011 427081 427129 432887 434470 436444 437948 438023 438062 441942 442003 443958 450149 451279 452655 452656 452719 452872 455597 456350 461809 465692 469333 469361 469710 470489 472362 472383 475213 475571 478212 492164 496472 498670 500994 501079 507519 509652 514066 520206 521036 521722 522439 525599 530194 531364 532614 536989 541546 542509 549490 551834 553239 555110 557809 557901 564304 569122 579557 590761 592963 593557 594167 598300 607481 613015 613208 613848 615963 621099 628589 633764 634536 635041 645258 653330 661613 666418 669784 670234 689136 689606 700752 708450 710805 715824 716546 723589 725425 729123 747044 763378 764486 766628 767769 777482 784280 787754 798631 800470 807663 809702 809910 810531 813621 813625 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swallow fuck"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глота секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.