Query Metrics
7
Database Queries
7
Different statements
188.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.14 ms (87.39%) |
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 130289 187636 191599 218768 310758 326134 381777 383111 385889 389875 393778 394646 396595 397302 400960 401843 409652 410430 421253 422331 438656 443387 447901 453695 467628 469415 470585 470647 471366 471974 474551 474673 476112 482804 483655 484560 504964 506301 510261 513901 514710 517582 521418 522868 531960 533384 542816 543356 544604 548756 549225 557978 559372 560087 562372 565541 566575 567396 572038 599999 600401 601106 603174 603190 604331 606417 606826 613375 636322 640858 645235 649543 659079 660427 669391 711891 715662 720264 720308 721990 722511 722551 726322 731844 733033 734117 745245 748210 748342 767185 775140 775787 775940 775943 775981 784308 787715 795574 799362 801934 801950 803353 803360 803469 806268 807386 811486 815452 816568 816904 817351 817489 818367 820678 820778 820962 823942 824130 827201 827480 ] |
||||||||||||||||||||||||||||||
|
14.42 ms (7.63%) |
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 467628 513901 572038 600401 807386 471366 557978 542816 543356 566575 548756 562372 636322 383111 823942 817489 601106 803353 733033 604331 748210 483655 522868 606417 603174 731844 748342 191599 447901 385889 393778 381777 504964 400960 474673 401843 453695 471974 715662 720264 484560 510261 394646 310758 389875 396595 422331 817351 820678 824130 827201 816568 818367 820778 482804 469415 506301 533384 474551 567396 559372 669391 721990 645235 660427 711891 649543 599999 613375 640858 775787 801950 775140 775981 801934 745245 784308 806268 811486 720308 799362 397302 438656 514710 517582 549225 187636 827480 815452 816904 820962 531960 544604 560087 722551 659079 606826 603190 803469 775943 803360 734117 787715 767185 726322 722511 775940 795574 130289 326134 409652 410430 476112 470647 218768 443387 470585 421253 521418 565541 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.34%) |
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 130289 187636 191599 218768 310758 326134 381777 383111 385889 389875 393778 394646 396595 397302 400960 401843 409652 410430 421253 422331 438656 443387 447901 453695 467628 469415 470585 470647 471366 471974 474551 474673 476112 482804 483655 484560 504964 506301 510261 513901 514710 517582 521418 522868 531960 533384 542816 543356 544604 548756 549225 557978 559372 560087 562372 565541 566575 567396 572038 599999 600401 601106 603174 603190 604331 606417 606826 613375 636322 640858 645235 649543 659079 660427 669391 711891 715662 720264 720308 721990 722511 722551 726322 731844 733033 734117 745245 748210 748342 767185 775140 775787 775940 775943 775981 784308 787715 795574 799362 801934 801950 803353 803360 803469 806268 807386 811486 815452 816568 816904 817351 817489 818367 820678 820778 820962 823942 824130 827201 827480 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group mother"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group мам женщин"
]
|
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.