Query Metrics
7
Database Queries
7
Different statements
142.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.22 ms (83.77%) |
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 530266 530319 530819 533085 533251 534211 535908 537836 542328 543904 544625 547076 549423 550654 550656 556176 563730 575044 576530 576924 580572 584213 585352 586315 590172 591685 599808 600426 601106 607627 613854 615423 616589 626794 628827 629716 630074 631063 631711 632813 632967 633926 633979 634036 634041 634194 638473 641549 643998 645453 645972 646124 646606 648490 648910 649119 651392 651485 651657 652119 652487 652641 652717 653846 654547 654662 654701 655055 655979 656444 657316 657623 658006 658162 658333 659667 659701 660472 662060 664390 664969 667371 668371 671855 673746 673809 676595 681461 682023 682272 683592 685657 686769 690760 690761 692069 692084 692104 692240 693987 695605 696249 696252 696287 697736 698896 700674 701038 703302 715251 719804 719830 719954 780673 788415 789607 798393 802978 803896 807969 ] |
||||||||||||||||||||||||||||||
|
13.09 ms (9.20%) |
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 530319 530819 533085 534211 537836 530266 533251 535908 580572 584213 542328 543904 544625 550654 556176 563730 575044 576924 547076 549423 550656 645453 646124 646606 651485 654662 654701 655055 655979 662060 664969 685657 690760 690761 693987 698896 700674 701038 715251 645972 649119 651392 651657 652717 653846 654547 657316 657623 658006 658333 659701 660472 664390 667371 676595 682023 682272 692084 692104 692240 695605 696249 697736 719830 648490 648910 652119 652487 652641 656444 658162 659667 668371 671855 673746 673809 681461 683592 686769 692069 696252 696287 703302 719804 719954 576530 586315 616589 628827 632813 632967 633979 634194 607627 631711 633926 634036 634041 643998 591685 600426 601106 626794 630074 638473 585352 590172 599808 613854 615423 629716 631063 641549 789607 798393 802978 803896 807969 780673 788415 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.09%) |
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 530266 530319 530819 533085 533251 534211 535908 537836 542328 543904 544625 547076 549423 550654 550656 556176 563730 575044 576530 576924 580572 584213 585352 586315 590172 591685 599808 600426 601106 607627 613854 615423 616589 626794 628827 629716 630074 631063 631711 632813 632967 633926 633979 634036 634041 634194 638473 641549 643998 645453 645972 646124 646606 648490 648910 649119 651392 651485 651657 652119 652487 652641 652717 653846 654547 654662 654701 655055 655979 656444 657316 657623 658006 658162 658333 659667 659701 660472 662060 664390 664969 667371 668371 671855 673746 673809 676595 681461 682023 682272 683592 685657 686769 690760 690761 692069 692084 692104 692240 693987 695605 696249 696252 696287 697736 698896 700674 701038 703302 715251 719804 719830 719954 780673 788415 789607 798393 802978 803896 807969 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial xxx"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов xxx"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"межрасов xxx"
]
|
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.