Query Metrics
7
Database Queries
7
Different statements
186.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.41 ms (87.13%) |
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 156688 383638 391306 398992 437585 450219 452277 456737 460026 460541 460689 467303 474959 475176 479067 479889 479964 489621 491637 492167 493299 500531 507140 507182 514264 514693 515335 517596 518401 519851 525437 526571 530305 533227 533954 535399 536947 536980 537608 537645 540523 542695 545210 545979 546720 547814 550127 550310 551532 556001 557345 557830 562925 566431 574396 574399 577460 587727 588767 589598 591855 594561 594980 599792 601361 602986 603560 604991 605019 605696 606018 606784 607511 609566 609589 619061 621779 625381 625552 627846 630326 630379 630696 635587 635850 650528 654217 697024 707297 710313 712687 713444 714040 714951 716841 719858 724872 729170 732551 732697 733243 733529 734700 744464 748454 750794 755011 759562 768578 769559 789064 789113 795202 796506 802054 806412 809745 812894 813426 823174 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (7.62%) |
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 605696 606784 630326 625381 609566 744464 635850 547814 491637 566431 604991 603560 479964 391306 156688 537608 719858 759562 750794 724872 500531 514264 519851 551532 514693 650528 588767 748454 518401 526571 489621 493299 556001 630696 530305 550127 697024 714951 535399 542695 562925 545979 707297 607511 602986 605019 630379 475176 479889 557345 812894 755011 732697 627846 383638 460026 492167 525437 557830 591855 533954 550310 574399 712687 599792 635587 619061 734700 802054 536947 507140 450219 621779 517596 574396 769559 467303 823174 460541 789064 789113 795202 806412 733529 768578 813426 536980 533227 540523 654217 594980 601361 710313 606018 716841 398992 474959 546720 437585 452277 456737 537645 594561 587727 577460 545210 714040 609589 625552 796506 809745 729170 732551 733243 713444 479067 460689 515335 507182 589598 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.91%) |
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 156688 383638 391306 398992 437585 450219 452277 456737 460026 460541 460689 467303 474959 475176 479067 479889 479964 489621 491637 492167 493299 500531 507140 507182 514264 514693 515335 517596 518401 519851 525437 526571 530305 533227 533954 535399 536947 536980 537608 537645 540523 542695 545210 545979 546720 547814 550127 550310 551532 556001 557345 557830 562925 566431 574396 574399 577460 587727 588767 589598 591855 594561 594980 599792 601361 602986 603560 604991 605019 605696 606018 606784 607511 609566 609589 619061 621779 625381 625552 627846 630326 630379 630696 635587 635850 650528 654217 697024 707297 710313 712687 713444 714040 714951 716841 719858 724872 729170 732551 732697 733243 733529 734700 744464 748454 750794 755011 759562 768578 769559 789064 789113 795202 796506 802054 806412 809745 812894 813426 823174 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск milf куколд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur milf cuckold"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск milf куколд"
]
|
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.