Query Metrics
7
Database Queries
7
Different statements
218.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.26 ms (87.25%) |
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 16883 96272 96484 96755 365995 381771 386232 388106 388122 388687 389482 390980 391715 391877 395489 395639 395646 395919 396565 396732 400426 400642 400935 400940 401655 404829 404927 404968 409615 409995 418538 419378 420381 423414 428381 428703 431904 435664 444231 446112 446359 447086 447466 449060 451588 469917 471323 472343 478048 479462 479844 484813 491474 496032 497874 510862 514069 522939 535466 536614 556795 561416 565251 583592 587795 595853 598067 598559 618483 619397 622645 628407 632028 636269 636545 637047 640806 644259 644303 646900 649114 662562 665984 666049 666871 670112 672469 678915 679102 688105 698095 699583 705832 712158 713014 716868 717828 720340 721443 725599 728272 733889 733891 736837 740584 741280 741538 744594 746980 746991 748530 766605 771670 775772 777140 784247 785337 799284 803454 817445 ] |
||||||||||||||||||||||||||||||
|
19.29 ms (8.85%) |
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 565251 637047 628407 409995 395919 391877 479462 688105 698095 728272 666871 404829 679102 672469 396565 388122 803454 395489 721443 740584 665984 646900 451588 391715 817445 632028 644303 478048 744594 428703 720340 649114 678915 713014 716868 636269 587795 622645 799284 736837 446359 712158 619397 741280 381771 662562 775772 766605 386232 536614 784247 777140 733889 746980 479844 491474 598559 522939 400940 401655 400426 598067 96272 535466 741538 561416 388687 390980 497874 447466 583592 447086 514069 428381 419378 404968 644259 636545 388106 400642 472343 510862 705832 449060 96755 423414 717828 666049 746991 725599 404927 444231 16883 446112 484813 640806 733891 748530 96484 595853 418538 420381 431904 699583 556795 618483 771670 396732 409615 670112 395639 435664 496032 389482 400935 471323 785337 395646 365995 469917 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.10%) |
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 16883 96272 96484 96755 365995 381771 386232 388106 388122 388687 389482 390980 391715 391877 395489 395639 395646 395919 396565 396732 400426 400642 400935 400940 401655 404829 404927 404968 409615 409995 418538 419378 420381 423414 428381 428703 431904 435664 444231 446112 446359 447086 447466 449060 451588 469917 471323 472343 478048 479462 479844 484813 491474 496032 497874 510862 514069 522939 535466 536614 556795 561416 565251 583592 587795 595853 598067 598559 618483 619397 622645 628407 632028 636269 636545 637047 640806 644259 644303 646900 649114 662562 665984 666049 666871 670112 672469 678915 679102 688105 698095 699583 705832 712158 713014 716868 717828 720340 721443 725599 728272 733889 733891 736837 740584 741280 741538 744594 746980 746991 748530 766605 771670 775772 777140 784247 785337 799284 803454 817445 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen mmf anal"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen мжм секс втро анал"
]
|
||||||||||||||||||||||||||||||
|
1.17 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen мжм секс втро анал"
]
|
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.