Query Metrics
7
Database Queries
7
Different statements
177.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.13 ms (85.79%) |
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 21323 33727 38263 61369 83163 92038 148793 194652 210052 218742 237293 360205 381972 383621 384494 385053 385737 386782 386936 389760 391241 397209 398128 398576 401167 402060 403142 403293 408701 411944 415911 417900 421783 426169 435737 435968 436047 439450 439628 439677 440776 443947 444426 444582 448090 454785 455826 457067 460307 464096 465475 465534 471455 472575 477759 479613 488475 499252 502885 506487 507513 507897 510584 517575 525011 527919 528600 530438 530451 531844 532107 545434 548834 552078 555728 561013 564255 564293 572204 578432 578436 584795 601285 607438 623300 623749 633611 634229 640935 662047 685509 700305 705119 709917 711957 713503 717182 720200 724836 725236 732715 733542 738296 738435 739888 746183 747356 752617 755821 756683 759748 793727 796715 797631 800543 800593 804552 805536 817492 827848 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (8.52%) |
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 506487 488475 738296 386782 389760 398128 218742 61369 398576 443947 793727 725236 800543 746183 384494 578432 517575 439628 436047 471455 391241 435737 532107 578436 385737 383621 360205 403293 732715 738435 756683 724836 403142 477759 465475 555728 709917 435968 507513 507897 634229 804552 739888 510584 448090 385053 444426 623300 455826 464096 415911 817492 584795 386936 527919 717182 194652 530438 530451 564255 713503 640935 733542 528600 381972 38263 401167 408701 499252 561013 633611 747356 402060 479613 83163 210052 421783 827848 472575 460307 548834 711957 705119 720200 662047 623749 601285 800593 755821 759748 752617 797631 805536 417900 444582 148793 525011 439450 411944 457067 572204 685509 700305 92038 426169 454785 502885 439677 465534 552078 237293 21323 33727 397209 440776 531844 564293 545434 607438 796715 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.76%) |
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 21323 33727 38263 61369 83163 92038 148793 194652 210052 218742 237293 360205 381972 383621 384494 385053 385737 386782 386936 389760 391241 397209 398128 398576 401167 402060 403142 403293 408701 411944 415911 417900 421783 426169 435737 435968 436047 439450 439628 439677 440776 443947 444426 444582 448090 454785 455826 457067 460307 464096 465475 465534 471455 472575 477759 479613 488475 499252 502885 506487 507513 507897 510584 517575 525011 527919 528600 530438 530451 531844 532107 545434 548834 552078 555728 561013 564255 564293 572204 578432 578436 584795 601285 607438 623300 623749 633611 634229 640935 662047 685509 700305 705119 709917 711957 713503 717182 720200 724836 725236 732715 733542 738296 738435 739888 746183 747356 752617 755821 756683 759748 793727 796715 797631 800543 800593 804552 805536 817492 827848 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge tits doggy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные сиськ рак"
]
|
||||||||||||||||||||||||||||||
|
1.42 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.