Query Metrics
7
Database Queries
7
Different statements
157.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.12 ms (85.43%) |
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 97156 103696 391939 392109 394488 403245 426716 443838 457230 460830 470194 471545 477360 478562 491027 495195 495741 503791 504161 504228 505064 506800 508720 510059 518499 521780 530828 531368 531860 534074 534132 534640 535612 536959 537104 537405 542346 544748 545090 546544 547947 547966 547980 548747 555691 557946 562591 566445 568180 585013 585269 585751 587723 590871 590881 591174 596556 604985 605616 617487 622348 635830 635859 636576 647980 649094 649266 653624 653758 654695 659287 661382 666714 670719 676289 676804 685220 687440 690885 692452 694265 703211 704044 714542 716829 722104 729659 732751 733045 733179 736798 742677 748432 748541 749557 749639 766944 767868 775899 775904 781372 781902 782783 784279 785381 790619 790761 794247 794799 802655 804512 811208 817405 818932 819146 819633 821857 824228 824325 825690 ] |
||||||||||||||||||||||||||||||
|
13.74 ms (8.75%) |
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 491027 505064 506800 659287 785381 585013 704044 818932 714542 685220 716829 775904 775899 749639 733179 802655 443838 824325 566445 781372 676804 585751 596556 508720 531860 530828 542346 546544 703211 819633 460830 666714 392109 531368 545090 391939 692452 547947 426716 548747 557946 478562 504228 544748 670719 649266 635830 617487 661382 103696 824228 821857 825690 521780 537104 547980 562591 653624 604985 781902 782783 790761 794799 729659 749557 767868 732751 605616 403245 819146 534640 547966 722104 694265 587723 733045 635859 457230 794247 736798 742677 748432 811208 97156 585269 471545 504161 510059 518499 622348 748541 394488 817405 537405 676289 590881 591174 784279 495195 555691 790619 804512 495741 636576 690885 590871 766944 535612 568180 534132 534074 536959 653758 654695 687440 649094 477360 503791 470194 647980 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.65%) |
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 97156 103696 391939 392109 394488 403245 426716 443838 457230 460830 470194 471545 477360 478562 491027 495195 495741 503791 504161 504228 505064 506800 508720 510059 518499 521780 530828 531368 531860 534074 534132 534640 535612 536959 537104 537405 542346 544748 545090 546544 547947 547966 547980 548747 555691 557946 562591 566445 568180 585013 585269 585751 587723 590871 590881 591174 596556 604985 605616 617487 622348 635830 635859 636576 647980 649094 649266 653624 653758 654695 659287 661382 666714 670719 676289 676804 685220 687440 690885 692452 694265 703211 704044 714542 716829 722104 729659 732751 733045 733179 736798 742677 748432 748541 749557 749639 766944 767868 775899 775904 781372 781902 782783 784279 785381 790619 790761 794247 794799 802655 804512 811208 817405 818932 819146 819633 821857 824228 824325 825690 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome amateur"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро любительск"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.