Query Metrics
7
Database Queries
7
Different statements
163.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.27 ms (80.74%) |
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 390634 393724 405531 411930 421238 421277 421394 422626 422688 443315 445182 446257 446874 447416 447640 464732 465168 466772 471860 475714 476120 476420 486304 487439 489061 489522 490093 492234 492459 495606 496449 499585 499891 504836 506823 507963 511858 512313 514692 516336 516970 517190 518472 518501 519551 519980 525395 528455 530018 530663 530709 530756 531208 536681 537206 539278 540608 540908 545607 548092 548606 548751 550611 552114 553673 556911 560434 561813 565255 565265 566324 567082 567152 568041 576346 577391 578451 578501 581137 584537 589747 591145 592046 595192 596898 597195 597263 598828 599113 601358 603059 603663 608472 609388 614339 622223 622394 624915 629129 629934 634163 645014 653496 681843 684312 693023 729784 757896 814443 820865 824843 826333 828056 828304 828375 ] |
||||||||||||||||||||||||||||||
|
20.72 ms (12.65%) |
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 577391 581137 548092 565265 653496 693023 601358 622394 591145 614339 629934 475714 471860 499891 495606 525395 496449 519980 561813 567082 599113 624915 443315 421277 447416 490093 507963 512313 516336 828375 826333 492459 518501 566324 568041 584537 645014 681843 592046 634163 595192 411930 445182 492234 489522 825034 506823 820865 540908 422626 622223 598828 446874 517190 556911 545607 578451 589747 421238 528455 504836 486304 422688 489061 536681 548751 684312 464732 405531 476420 514692 487439 814443 465168 511858 552114 421394 548606 560434 567152 603663 393724 828304 578501 608472 603059 596898 597195 609388 629129 499585 825504 822476 824843 828056 729784 530663 531208 530018 540608 530709 537206 565255 576346 597263 476120 466772 516970 518472 824682 824207 447640 446257 519551 539278 530756 550611 553673 757896 390634 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.30%) |
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 390634 393724 405531 411930 421238 421277 421394 422626 422688 443315 445182 446257 446874 447416 447640 464732 465168 466772 471860 475714 476120 476420 486304 487439 489061 489522 490093 492234 492459 495606 496449 499585 499891 504836 506823 507963 511858 512313 514692 516336 516970 517190 518472 518501 519551 519980 525395 528455 530018 530663 530709 530756 531208 536681 537206 539278 540608 540908 545607 548092 548606 548751 550611 552114 553673 556911 560434 561813 565255 565265 566324 567082 567152 568041 576346 577391 578451 578501 581137 584537 589747 591145 592046 595192 596898 597195 597263 598828 599113 601358 603059 603663 608472 609388 614339 622223 622394 624915 629129 629934 634163 645014 653496 681843 684312 693023 729784 757896 814443 820865 824843 826333 828056 828304 828375 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck skinny"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс худые"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
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.