Query Metrics
7
Database Queries
7
Different statements
169.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.71 ms (83.70%) |
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 403463 406650 406882 411326 414845 416791 417875 418520 424265 424429 430783 434097 438446 439605 439642 443756 449991 455313 457851 459883 463155 464757 477131 478362 480630 481937 484527 485943 487471 488653 489249 491926 497497 502753 504109 504751 507110 507111 511046 511309 511779 511797 516812 516817 518327 519262 520935 522850 524491 524499 525176 525980 528915 528917 530183 531919 532209 532993 533897 540157 546393 547873 549128 549836 550317 551933 552495 553972 556010 556021 556816 557463 560444 561439 562291 562343 562993 564655 566958 568052 568320 569038 569568 571820 574432 577617 578496 582369 582554 582787 583607 584563 591052 591519 593050 599167 600977 606333 609815 615974 617375 623643 632734 638578 663429 665442 667942 668660 695868 697002 721537 725135 726538 730961 731105 766734 782777 790026 796105 799553 ] |
||||||||||||||||||||||||||||||
|
17.13 ms (10.12%) |
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 504109 504751 507110 511779 511797 519262 522850 530183 533897 497497 502753 511309 516812 528917 531919 532993 540157 507111 511046 525176 525980 528915 532209 524491 524499 459883 546393 551933 553972 568320 569038 569568 577617 578496 584563 547873 549128 557463 564655 571820 582369 582787 560444 561439 562343 562993 566958 663429 665442 668660 695868 721537 667942 549836 550317 552495 556010 556021 556816 562291 568052 574432 582554 583607 609815 615974 617375 591052 591519 599167 600977 606333 632734 593050 623643 638578 782777 790026 796105 799553 725135 731105 726538 766734 730961 697002 414845 424429 438446 443756 477131 478362 481937 439605 463155 464757 403463 416791 418520 430783 449991 411326 424265 434097 439642 457851 480630 406650 406882 417875 455313 518327 485943 487471 488653 516817 520935 484527 489249 491926 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.75%) |
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 403463 406650 406882 411326 414845 416791 417875 418520 424265 424429 430783 434097 438446 439605 439642 443756 449991 455313 457851 459883 463155 464757 477131 478362 480630 481937 484527 485943 487471 488653 489249 491926 497497 502753 504109 504751 507110 507111 511046 511309 511779 511797 516812 516817 518327 519262 520935 522850 524491 524499 525176 525980 528915 528917 530183 531919 532209 532993 533897 540157 546393 547873 549128 549836 550317 551933 552495 553972 556010 556021 556816 557463 560444 561439 562291 562343 562993 564655 566958 568052 568320 569038 569568 571820 574432 577617 578496 582369 582554 582787 583607 584563 591052 591519 593050 599167 600977 606333 609815 615974 617375 623643 632734 638578 663429 665442 667942 668660 695868 697002 721537 725135 726538 730961 731105 766734 782777 790026 796105 799553 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf brunette maid"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf черноволосая горничн"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf черноволосая горничн"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.