Query Metrics
7
Database Queries
7
Different statements
175.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.60 ms (83.42%) |
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 6976 379330 383356 388219 396106 399016 410657 417482 418450 420345 424791 425316 425353 437855 443649 446198 446856 447904 448121 448215 448864 459527 464650 465605 467632 468754 475724 477464 481143 481151 482727 500431 506143 506762 508179 512057 512781 515329 516666 517932 521805 522883 523190 524846 530500 531136 535505 537654 540572 540575 540785 541202 544827 545611 547523 555847 558437 562796 566035 569929 583503 586398 594584 597121 597246 599994 600296 600355 601040 604497 604574 605461 612726 615961 619199 621426 629330 630280 630765 630866 632021 632978 633124 633796 633806 634115 634116 634153 634198 634782 637143 642060 646025 646242 647830 647879 647952 672710 674968 675002 676024 676097 681298 681313 687257 696579 719841 719857 731663 732319 732326 740779 742428 743836 750060 788570 800331 811826 817096 818793 ] |
||||||||||||||||||||||||||||||
|
17.95 ms (10.22%) |
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 447904 642060 646242 475724 443649 388219 535505 687257 696579 600355 633124 383356 500431 634115 448864 512781 516666 681298 632021 743836 517932 558437 410657 459527 524846 634782 788570 647830 740779 506143 417482 418450 530500 512057 531136 477464 481143 540575 600296 506762 547523 482727 467632 681313 541202 555847 750060 634116 601040 676024 521805 448215 732326 446856 481151 675002 446198 583503 544827 630765 633806 540785 719841 537654 674968 545611 515329 676097 465605 647879 637143 597246 425353 633796 562796 437855 646025 424791 647952 615961 540572 817096 396106 468754 604497 672710 508179 634153 719857 800331 522883 742428 379330 732319 6976 629330 605461 464650 630280 599994 811826 632978 399016 425316 612726 604574 621426 619199 566035 818793 731663 597121 634198 523190 569929 630866 586398 594584 420345 448121 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (2.03%) |
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 6976 379330 383356 388219 396106 399016 410657 417482 418450 420345 424791 425316 425353 437855 443649 446198 446856 447904 448121 448215 448864 459527 464650 465605 467632 468754 475724 477464 481143 481151 482727 500431 506143 506762 508179 512057 512781 515329 516666 517932 521805 522883 523190 524846 530500 531136 535505 537654 540572 540575 540785 541202 544827 545611 547523 555847 558437 562796 566035 569929 583503 586398 594584 597121 597246 599994 600296 600355 601040 604497 604574 605461 612726 615961 619199 621426 629330 630280 630765 630866 632021 632978 633124 633796 633806 634115 634116 634153 634198 634782 637143 642060 646025 646242 647830 647879 647952 672710 674968 675002 676024 676097 681298 681313 687257 696579 719841 719857 731663 732319 732326 740779 742428 743836 750060 788570 800331 811826 817096 818793 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc blowjob anal"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc минет оральн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc минет оральн секс анал"
]
|
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.