Query Metrics
7
Database Queries
7
Different statements
166.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.94 ms (85.33%) |
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 381958 382581 382898 386558 388204 415742 420431 429739 438488 445424 454083 460128 461841 466470 471461 475137 491125 507834 516209 516401 524867 524874 529877 531842 535331 535790 536306 542739 543485 544970 546453 547795 547885 548040 548467 548478 558110 561522 561559 562550 568241 568691 573749 573990 574182 574411 575031 585231 591917 594840 603311 605285 606149 621235 636114 639657 639683 642365 646668 651327 661056 668584 672278 686763 705027 717428 726889 730848 733973 735292 738958 744370 746843 748030 749668 754235 754666 754851 757064 764716 766643 769939 770020 774917 776849 787634 787764 791562 792442 793505 794031 795035 797124 798843 799941 800669 800690 801439 802149 803710 803749 803777 810506 810604 813528 814354 816738 817638 818159 819709 820016 823737 823973 825303 825800 825954 826663 827400 827916 828455 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (8.63%) |
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 535331 491125 388204 818159 825303 827400 825954 827916 828455 460128 531842 535790 543485 568241 568691 574182 544970 558110 651327 646668 668584 547885 548040 561559 639683 642365 603311 793505 801439 813528 776849 787634 803710 730848 810506 735292 738958 748030 754235 757064 770020 733973 744370 754666 754851 746843 803749 386558 826663 524867 524874 573749 573990 621235 799941 445424 507834 516209 438488 471461 466470 605285 382898 429739 382581 381958 454083 516401 475137 542739 575031 547795 420431 415742 814354 817638 819709 823737 823973 820016 816738 825800 461841 529877 536306 548467 548478 562550 546453 661056 717428 686763 672278 705027 561522 574411 606149 636114 585231 591917 639657 594840 774917 787764 797124 798843 800669 800690 802149 803777 764716 769939 791562 792442 794031 795035 810604 749668 766643 726889 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.65%) |
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 381958 382581 382898 386558 388204 415742 420431 429739 438488 445424 454083 460128 461841 466470 471461 475137 491125 507834 516209 516401 524867 524874 529877 531842 535331 535790 536306 542739 543485 544970 546453 547795 547885 548040 548467 548478 558110 561522 561559 562550 568241 568691 573749 573990 574182 574411 575031 585231 591917 594840 603311 605285 606149 621235 636114 639657 639683 642365 646668 651327 661056 668584 672278 686763 705027 717428 726889 730848 733973 735292 738958 744370 746843 748030 749668 754235 754666 754851 757064 764716 766643 769939 770020 774917 776849 787634 787764 791562 792442 793505 794031 795035 797124 798843 799941 800669 800690 801439 802149 803710 803749 803777 810506 810604 813528 814354 816738 817638 818159 819709 820016 823737 823973 825303 825800 825954 826663 827400 827916 828455 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom on webcam"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom вебкамер"
]
|
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.