Query Metrics
7
Database Queries
7
Different statements
187.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.98 ms (88.85%) |
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 54149 207970 339474 341118 378309 383906 386758 397642 407357 414364 418052 464704 466552 467615 468694 471317 477464 485168 561265 576530 583067 585352 586315 590172 591685 599808 604451 613854 615423 616589 628827 629279 629375 631063 631711 632497 632813 633926 633979 634036 634194 635501 643844 648490 649092 652119 652641 654547 656444 657316 657623 658006 658162 658333 659667 659701 660472 665338 668371 669216 671409 671855 673746 673809 681461 682023 682275 683592 686769 692069 692104 692240 697303 697736 707360 714549 716346 717076 719804 719830 719915 719954 722491 723357 725443 725563 725712 729293 729570 730105 730441 730717 731302 731316 732002 732451 734073 738179 739637 740466 740761 741571 746598 749034 750648 751681 753253 764343 769978 787015 796424 798393 803333 803407 807969 815564 818490 826231 ] |
||||||||||||||||||||||||||||||
|
10.19 ms (5.42%) |
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 654547 657316 657623 658006 658333 659701 660472 682023 692104 692240 697736 719830 648490 652119 652641 656444 658162 659667 668371 671855 673746 673809 681461 683592 686769 692069 719804 719954 576530 586315 616589 628827 632813 633979 634194 631711 633926 634036 591685 585352 590172 599808 613854 615423 631063 798393 807969 803333 803407 725563 725712 729293 730105 730717 740761 741571 749034 753253 769978 787015 796424 725443 732451 738179 740466 730441 731302 751681 764343 729570 732002 731316 734073 739637 746598 750648 629375 632497 635501 643844 697303 397642 477464 464704 471317 466552 407357 467615 386758 414364 468694 604451 714549 383906 207970 339474 341118 378309 54149 418052 826231 815564 818490 485168 561265 583067 649092 667269 719915 665338 666827 669216 671409 682275 716346 717076 707360 722491 723357 629279 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.28%) |
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 54149 207970 339474 341118 378309 383906 386758 397642 407357 414364 418052 464704 466552 467615 468694 471317 477464 485168 561265 576530 583067 585352 586315 590172 591685 599808 604451 613854 615423 616589 628827 629279 629375 631063 631711 632497 632813 633926 633979 634036 634194 635501 643844 648490 649092 652119 652641 654547 656444 657316 657623 658006 658162 658333 659667 659701 660472 665338 668371 669216 671409 671855 673746 673809 681461 682023 682275 683592 686769 692069 692104 692240 697303 697736 707360 714549 716346 717076 719804 719830 719915 719954 722491 723357 725443 725563 725712 729293 729570 730105 730441 730717 731302 731316 732002 732451 734073 738179 739637 740466 740761 741571 746598 749034 750648 751681 753253 764343 769978 787015 796424 798393 803333 803407 807969 815564 818490 826231 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big interracial"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.78%) |
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.