Query Metrics
7
Database Queries
7
Different statements
375.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.91 ms (56.14%) |
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 14967 29280 116701 162212 212851 221923 287979 385884 389675 392956 425392 469287 485173 521118 530696 532360 532674 533941 535026 537204 538525 539571 539576 540379 547875 564303 572876 584488 586507 591695 595975 598377 599171 599905 615716 629428 632386 632663 633466 635258 637092 643331 649166 651058 651601 656562 664457 667931 668371 673809 673910 676623 676638 677701 678854 683592 686769 689374 692069 694550 701038 704328 710882 713016 716035 718058 718931 719830 723957 725139 725941 730730 732336 733361 734795 737700 738419 739065 740194 741571 741617 742715 744327 752255 755372 764343 767494 776244 778930 780418 782749 788012 792808 795128 796546 805986 807673 810966 811094 811099 811826 812513 813195 816612 816777 817078 818385 818587 819225 821524 821695 822313 823129 823560 823837 824073 825142 825526 826031 826254 ] |
||||||||||||||||||||||||||||||
|
143.46 ms (38.19%) |
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 14967 29280 116701 162212 212851 221923 287979 385884 389675 392956 425392 469287 485173 521118 530696 532360 532674 533941 535026 537204 538525 539571 539576 540379 547875 564303 572876 584488 586507 591695 595975 598377 599171 599905 615716 629428 632386 632663 633466 635258 637092 643331 649166 651058 651601 656562 664457 667931 668371 673809 673910 676623 676638 677701 678854 683592 686769 689374 692069 694550 701038 704328 710882 713016 716035 718058 718931 719830 723957 725139 725941 730730 732336 733361 734795 737700 738419 739065 740194 741571 741617 742715 744327 752255 755372 764343 767494 776244 778930 780418 782749 788012 792808 795128 796546 805986 807673 810966 811094 811099 811826 812513 813195 816612 816777 817078 818385 818587 819225 821524 821695 822313 823129 823560 823837 824073 825142 825526 826031 826254 ] |
||||||||||||||||||||||||||||||
|
13.37 ms (3.56%) |
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 823837 826254 824073 825142 811099 14967 826031 738419 755372 718058 29280 532360 537204 591695 635258 116701 392956 539576 547875 678854 704328 632386 737700 767494 816612 816777 818385 823560 485173 564303 677701 673809 686769 713016 599171 812513 811094 734795 807673 469287 676623 615716 633466 822313 530696 825526 823129 538525 572876 689374 776244 796546 739065 730730 740194 821524 539571 710882 656562 716035 795128 805986 676638 584488 780418 818587 821695 540379 694550 701038 719830 668371 683592 692069 792808 741571 725139 723957 764343 732336 212851 811826 389675 425392 673910 813195 287979 819225 817078 586507 598377 643331 778930 788012 741617 752255 733361 744327 725941 221923 651058 742715 810966 535026 532674 629428 637092 599905 632663 651601 385884 162212 533941 521118 718931 649166 667931 664457 595975 782749 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl black"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк black"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк black"
]
|
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.