Query Metrics
7
Database Queries
7
Different statements
210.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.77 ms (89.53%) |
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 83932 285404 383588 384162 386296 386605 403869 411462 421651 422099 423595 425288 426647 433489 433768 435560 438641 441877 445819 447961 448357 451244 451568 451761 451855 454631 460908 463996 465137 466448 469177 469592 470033 471069 473420 473695 473951 474456 475715 476434 480651 482741 482866 487891 490681 491064 492836 502978 503487 504079 509518 509767 510660 514731 515663 515703 515797 516368 521341 521486 522729 524115 524657 526942 529176 529519 529771 530938 531803 534454 541427 541823 541930 544024 546735 547927 548558 548897 559270 564212 568239 574012 574926 577069 582447 585325 585812 589140 589257 596087 603018 605250 605266 620992 627419 642855 643078 646251 648352 648739 650608 652884 687098 700803 707908 724990 727053 740375 743514 751373 753507 755527 757063 780887 786434 790671 798842 799646 817581 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (6.13%) |
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 433768 476434 433489 435560 469177 475715 454631 466448 502978 503487 514731 521486 509518 521341 509767 524115 524657 487891 490681 515797 423595 605266 386605 504079 386296 384162 403869 411462 471069 491064 445819 530938 522729 529519 482866 548897 574012 541930 650608 652884 648739 585812 620992 589257 780887 799646 740375 786434 724990 757063 755527 751373 753507 473951 448357 451568 422099 425288 438641 470033 510660 383588 469592 474456 534454 648352 687098 707908 646251 598922 727053 700803 798842 285404 480651 421651 465137 515703 451855 546735 642855 743514 463996 516368 568239 564212 441877 451761 482741 526942 531803 547927 548558 541427 603018 605250 473420 451244 473695 492836 83932 574926 790671 544024 515663 541823 589140 627419 426647 643078 559270 596087 447961 582447 460908 585325 817581 529176 529771 577069 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.02%) |
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 83932 285404 383588 384162 386296 386605 403869 411462 421651 422099 423595 425288 426647 433489 433768 435560 438641 441877 445819 447961 448357 451244 451568 451761 451855 454631 460908 463996 465137 466448 469177 469592 470033 471069 473420 473695 473951 474456 475715 476434 480651 482741 482866 487891 490681 491064 492836 502978 503487 504079 509518 509767 510660 514731 515663 515703 515797 516368 521341 521486 522729 524115 524657 526942 529176 529519 529771 530938 531803 534454 541427 541823 541930 544024 546735 547927 548558 548897 559270 564212 568239 574012 574926 577069 582447 585325 585812 589140 589257 596087 603018 605250 605266 620992 627419 642855 643078 646251 648352 648739 650608 652884 687098 700803 707908 724990 727053 740375 743514 751373 753507 755527 757063 780887 786434 790671 798842 799646 817581 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в эротическом нижнем белье"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в эротик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.74%) |
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.