Query Metrics
7
Database Queries
7
Different statements
175.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.57 ms (85.62%) |
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 391980 423703 427634 435620 441315 445638 446815 449628 453216 458634 468357 471461 479914 481225 489804 498648 500747 508803 513017 514031 515409 516151 520469 525198 531730 532385 542043 545453 546975 546986 547570 556162 563345 565014 566586 567602 569306 572231 574076 576490 577780 579255 579376 579725 580206 581456 582744 588417 589820 591320 592906 594349 598950 599653 599667 608070 615700 620041 626212 659401 672857 674208 689073 689973 691450 692531 694751 700965 702145 710571 714348 715175 716825 719443 725448 732787 733437 734259 736020 739675 740313 740986 745301 749430 751012 752913 754321 759013 770517 779961 780243 782404 784794 784969 785255 785674 786432 787526 787771 789054 789259 793494 802315 804435 804696 804702 808540 809002 809548 810092 810635 810646 811644 812038 813370 814188 814378 824532 824892 827968 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (8.82%) |
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 520469 468357 563345 572231 579255 579376 582744 542043 689073 692531 579725 598950 615700 588417 591320 599667 589820 784794 787526 787771 779961 784969 785674 809548 725448 732787 740986 759013 785255 786432 734259 740313 751012 733437 736020 780243 782404 810635 423703 479914 514031 489804 556162 714348 592906 565014 427634 435620 441315 814188 515409 525198 694751 716825 672857 700965 569306 581456 626212 789054 804702 808540 809002 810646 793494 813370 770517 802315 804696 811644 754321 739675 745301 749430 715175 789259 810092 812038 481225 516151 498648 827968 674208 719443 689973 702145 567602 620041 508803 513017 546975 547570 577780 804435 391980 445638 659401 691450 580206 599653 594349 608070 752913 710571 449628 500747 814378 824892 824532 458634 471461 446815 453216 531730 532385 545453 546986 566586 574076 576490 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.55%) |
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 391980 423703 427634 435620 441315 445638 446815 449628 453216 458634 468357 471461 479914 481225 489804 498648 500747 508803 513017 514031 515409 516151 520469 525198 531730 532385 542043 545453 546975 546986 547570 556162 563345 565014 566586 567602 569306 572231 574076 576490 577780 579255 579376 579725 580206 581456 582744 588417 589820 591320 592906 594349 598950 599653 599667 608070 615700 620041 626212 659401 672857 674208 689073 689973 691450 692531 694751 700965 702145 710571 714348 715175 716825 719443 725448 732787 733437 734259 736020 739675 740313 740986 745301 749430 751012 752913 754321 759013 770517 779961 780243 782404 784794 784969 785255 785674 786432 787526 787771 789054 789259 793494 802315 804435 804696 804702 808540 809002 809548 810092 810635 810646 811644 812038 813370 814188 814378 824532 824892 827968 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск masturbating"
]
|
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.