Query Metrics
7
Database Queries
7
Different statements
159.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.82 ms (84.95%) |
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 32874 381865 383019 384758 385605 387823 390215 392238 393284 396575 397290 406793 417943 421539 423615 433253 446877 447242 455787 469098 473208 473973 497645 502334 516615 533571 539294 539950 541547 549050 559179 563870 564401 565243 574979 576055 577778 583186 585094 595359 595424 595882 597818 598784 600167 603696 604295 609901 621086 622887 624144 625950 628421 636791 639803 639809 641737 641828 651875 653966 655346 656045 664781 668453 671609 671612 671633 674119 676443 676775 680146 683371 684052 691915 694213 702688 704619 712462 717936 720753 727614 729904 732319 736802 741952 742929 747324 748738 754470 755109 756298 758010 761488 761595 766609 766703 766915 767125 769749 782410 785981 795542 796817 798675 800423 805310 806197 809133 810125 810189 810679 810705 814134 814339 815071 821128 821588 823341 824864 826188 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (9.00%) |
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 565243 595359 563870 676443 676775 684052 583186 639809 603696 604295 423615 433253 600167 446877 473973 814134 549050 683371 639803 795542 767125 761595 769749 393284 539294 564401 469098 447242 473208 383019 717936 390215 815071 502334 559179 651875 720753 664781 712462 674119 691915 598784 609901 595424 595882 622887 727614 742929 810125 766915 754470 755109 736802 397290 577778 625950 497645 810189 455787 417943 516615 385605 396575 406793 384758 597818 421539 32874 585094 826188 823341 814339 824864 821128 821588 539950 533571 576055 574979 541547 694213 704619 653966 671609 702688 655346 656045 668453 671612 671633 680146 636791 624144 628421 805310 810679 810705 785981 798675 806197 809133 729904 782410 800423 741952 766609 766703 748738 756298 732319 747324 758010 761488 621086 641737 641828 796817 381865 392238 387823 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.49%) |
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 32874 381865 383019 384758 385605 387823 390215 392238 393284 396575 397290 406793 417943 421539 423615 433253 446877 447242 455787 469098 473208 473973 497645 502334 516615 533571 539294 539950 541547 549050 559179 563870 564401 565243 574979 576055 577778 583186 585094 595359 595424 595882 597818 598784 600167 603696 604295 609901 621086 622887 624144 625950 628421 636791 639803 639809 641737 641828 651875 653966 655346 656045 664781 668453 671609 671612 671633 674119 676443 676775 680146 683371 684052 691915 694213 702688 704619 712462 717936 720753 727614 729904 732319 736802 741952 742929 747324 748738 754470 755109 756298 758010 761488 761595 766609 766703 766915 767125 769749 782410 785981 795542 796817 798675 800423 805310 806197 809133 810125 810189 810679 810705 814134 814339 815071 821128 821588 823341 824864 826188 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep throat teen"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс teen"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глубокийминет минет оральн секс teen"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.