Query Metrics
7
Database Queries
7
Different statements
192.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.33 ms (86.07%) |
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 478452 496805 507862 509053 514161 517888 517901 529633 530089 532080 533617 533635 534911 534933 534936 535956 536745 537782 538135 541906 542211 542301 543485 543703 543741 544372 544970 549304 549454 552277 552479 552510 553155 553214 556076 556274 560713 562458 567440 569809 571423 576251 577528 579217 579784 579919 581046 648246 662572 667811 667925 668829 670939 671468 675369 678419 684302 685159 686155 688765 689093 689279 691431 693224 694138 694175 697441 698132 701543 703907 703953 704996 705104 705223 705230 706638 706965 713251 714390 716309 717864 718908 814055 814494 814609 816146 816881 817076 817477 817488 817643 818184 818725 818750 818813 818816 818881 818922 819445 819507 819869 820013 821037 822339 824714 824962 825100 825284 825835 825925 826690 826809 826932 827346 827552 828020 828065 828326 828498 828801 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (9.38%) |
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 825284 825835 825925 826690 814494 817076 817643 818184 818813 818816 820013 825100 826932 827346 827552 816881 817477 817488 818725 818922 819445 819869 821037 822339 824962 814055 814609 816146 818750 818881 819507 824714 828326 828065 828020 828801 826809 828498 478452 507862 514161 517888 517901 529633 533617 533635 534933 530089 532080 536745 538135 509053 534936 537782 496805 534911 535956 542211 543485 543741 544372 552479 560713 567440 576251 579919 542301 543703 549454 552277 556274 562458 569809 571423 577528 581046 541906 544970 549304 552510 553155 553214 556076 579217 579784 648246 667925 671468 675369 678419 684302 688765 689279 694138 701543 703907 703953 705223 706638 706965 713251 714390 716309 717864 718908 662572 667811 668829 670939 685159 686155 689093 691431 693224 694175 697441 698132 704996 705104 705230 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.12%) |
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 478452 496805 507862 509053 514161 517888 517901 529633 530089 532080 533617 533635 534911 534933 534936 535956 536745 537782 538135 541906 542211 542301 543485 543703 543741 544372 544970 549304 549454 552277 552479 552510 553155 553214 556076 556274 560713 562458 567440 569809 571423 576251 577528 579217 579784 579919 581046 648246 662572 667811 667925 668829 670939 671468 675369 678419 684302 685159 686155 688765 689093 689279 691431 693224 694138 694175 697441 698132 701543 703907 703953 704996 705104 705223 705230 706638 706965 713251 714390 716309 717864 718908 814055 814494 814609 816146 816881 817076 817477 817488 817643 818184 818725 818750 818813 818816 818881 818922 819445 819507 819869 820013 821037 822339 824714 824962 825100 825284 825835 825925 826690 826809 826932 827346 827552 828020 828065 828326 828498 828801 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скрытой камера"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт камер"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.71%) |
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.