Query Metrics
7
Database Queries
7
Different statements
398.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.76 ms (52.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
163.39 ms (40.97%) |
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 389590 406040 413288 416214 417765 418994 424054 429941 431754 432525 436476 437782 438979 443867 445053 450383 455099 455103 457133 458488 462053 462056 462338 462819 463250 467814 469216 469844 470644 471565 472349 472795 473947 476156 476161 477794 478852 479481 479959 481292 490205 491104 491438 491983 494656 494796 499742 501427 504184 504886 509165 511879 513399 515915 517548 522548 526036 533739 534124 548676 548703 552843 553275 553493 553955 554877 558324 560390 560394 561721 563417 563570 564994 566088 567523 568304 569862 569874 570470 570669 571591 571924 572515 573653 573844 574732 581558 609159 616699 621949 625568 630904 634804 650076 678539 679058 679098 682964 685263 692150 693145 698880 699248 715397 715455 721421 721500 726734 734192 739886 750452 755101 781648 781704 782204 782287 789117 792214 804877 809342 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (4.20%) |
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 455103 491438 522548 509165 467814 416214 458488 479959 494796 553275 569874 570470 685263 573653 804877 417765 472795 469216 470644 558324 564994 561721 566088 570669 406040 476161 477794 413288 432525 438979 443867 445053 462053 463250 478852 479481 476156 491983 526036 491104 457133 533739 534124 517548 568304 574732 389590 462338 436476 473947 469844 429941 450383 513399 494656 554877 571591 548676 548703 563570 567523 569862 571924 573844 581558 679058 699248 721500 650076 679098 682964 692150 715397 721421 678539 693145 715455 552843 563417 572515 621949 616699 630904 625568 634804 781704 782204 792214 726734 734192 750452 755101 782287 789117 809342 739886 609159 698880 781648 424054 431754 472349 437782 462819 471565 455099 462056 504184 515915 501427 490205 499742 504886 418994 481292 511879 553493 553955 560390 560394 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (0.83%) |
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 389590 406040 413288 416214 417765 418994 424054 429941 431754 432525 436476 437782 438979 443867 445053 450383 455099 455103 457133 458488 462053 462056 462338 462819 463250 467814 469216 469844 470644 471565 472349 472795 473947 476156 476161 477794 478852 479481 479959 481292 490205 491104 491438 491983 494656 494796 499742 501427 504184 504886 509165 511879 513399 515915 517548 522548 526036 533739 534124 548676 548703 552843 553275 553493 553955 554877 558324 560390 560394 561721 563417 563570 564994 566088 567523 568304 569862 569874 570470 570669 571591 571924 572515 573653 573844 574732 581558 609159 616699 621949 625568 630904 634804 650076 678539 679058 679098 682964 685263 692150 693145 698880 699248 715397 715455 721421 721500 726734 734192 739886 750452 755101 781648 781704 782204 782287 789117 792214 804877 809342 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian natural"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.43%) |
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.