Query Metrics
7
Database Queries
7
Different statements
166.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.04 ms (81.66%) |
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 73990 358603 398842 401218 406645 410029 426129 426315 433956 437233 438181 447145 453451 458210 460425 460627 462065 462544 471111 484446 488467 496586 497498 499366 500519 506353 512276 514221 530442 550907 551035 552292 559452 592925 601341 608931 609361 615243 625360 631316 634702 640304 644363 650374 653829 660462 666180 667805 667979 668698 669895 671682 672897 681636 694684 697738 698862 702959 710127 711537 718416 718461 721483 721571 723355 725317 727421 727513 727689 730419 731695 733483 734620 737863 740173 740794 741877 742970 743118 746135 748197 748471 748709 748996 750781 752437 755252 755424 755659 757816 762123 762429 764271 764638 766239 766534 771966 773621 784524 786225 786353 790809 794178 795306 797891 798211 800719 801504 806097 806700 806705 810676 810974 811283 812860 813625 817526 821562 823526 ] |
||||||||||||||||||||||||||||||
|
20.06 ms (12.04%) |
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 667805 667979 668698 669895 694684 718461 625360 640304 609361 786225 794178 797891 806700 740794 755659 766534 786353 812860 734620 740173 741877 750781 757816 762123 727689 730419 743118 748197 748709 762429 766239 773621 806097 806705 810974 488467 821562 506353 698862 681636 650374 671682 702959 601341 733483 748996 771966 752437 460425 406645 484446 358603 426315 410029 817526 460627 471111 530442 551035 552292 721571 615243 634702 608931 592925 631316 784524 800719 746135 731695 764638 742970 447145 666180 790809 810676 811283 401218 514221 500519 499366 462065 559452 550907 718416 653829 660462 795306 801504 727421 727513 755424 737863 738586 755252 725317 764271 644363 723355 458210 433956 462544 497498 512276 426129 813625 453451 496586 672897 711537 721483 697738 710127 798211 748471 73990 437233 398842 438181 823526 ] |
||||||||||||||||||||||||||||||
|
4.16 ms (2.50%) |
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 73990 358603 398842 401218 406645 410029 426129 426315 433956 437233 438181 447145 453451 458210 460425 460627 462065 462544 471111 484446 488467 496586 497498 499366 500519 506353 512276 514221 530442 550907 551035 552292 559452 592925 601341 608931 609361 615243 625360 631316 634702 640304 644363 650374 653829 660462 666180 667805 667979 668698 669895 671682 672897 681636 694684 697738 698862 702959 710127 711537 718416 718461 721483 721571 723355 725317 727421 727513 727689 730419 731695 733483 734620 737863 740173 740794 741877 742970 743118 746135 748197 748471 748709 748996 750781 752437 755252 755424 755659 757816 762123 762429 764271 764638 766239 766534 771966 773621 784524 786225 786353 790809 794178 795306 797891 798211 800719 801504 806097 806700 806705 810676 810974 811283 812860 813625 817526 821562 823526 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love big"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love большие"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love большие"
]
|
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.