Query Metrics
7
Database Queries
7
Different statements
220.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.05 ms (87.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 143291 181569 266183 384988 385915 388300 395668 397902 407515 419590 421672 424415 432393 442551 448818 449896 452046 452081 460027 467427 467512 472889 474137 475279 476032 477708 479999 490410 491907 513243 513531 515733 515737 516772 519403 521226 522784 527235 534959 537148 539151 546736 558369 568434 570845 571822 572764 593411 594777 600763 600825 600871 600878 607466 608815 612413 613865 619423 637110 640521 644636 644922 664548 665297 667631 668518 670493 670504 681118 690314 692225 701890 702352 709331 716190 717007 718755 721771 721772 725374 730104 732832 736795 741050 742553 744208 746048 746062 748197 752502 756497 756728 757750 759459 759845 760549 760764 760807 762020 763222 770100 772051 773363 781792 782702 789517 791452 805206 807619 808798 815105 815148 815320 815980 816579 818391 819606 823176 823567 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (7.91%) |
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 477708 452081 600825 600763 476032 432393 472889 490410 419590 600878 619423 594777 521226 732832 716190 644922 815148 815320 452046 534959 572764 665297 692225 702352 607466 608815 781792 730104 757750 759845 760807 772051 736795 759459 640521 807619 424415 491907 513531 407515 513243 612413 384988 181569 143291 395668 818391 823567 823176 815105 815980 816579 819606 449896 537148 539151 558369 667631 670504 681118 721772 701890 717007 664548 670493 690314 637110 600871 613865 805206 808798 789517 725374 744208 746062 763222 773363 791452 741050 756728 762020 770100 748197 752502 756497 760764 742553 746048 760549 709331 718755 721771 782702 385915 828527 568434 516772 460027 266183 421672 442551 474137 546736 570845 593411 397902 448818 479999 388300 467427 467512 475279 519403 522784 515737 515733 527235 571822 668518 644636 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.17%) |
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 143291 181569 266183 384988 385915 388300 395668 397902 407515 419590 421672 424415 432393 442551 448818 449896 452046 452081 460027 467427 467512 472889 474137 475279 476032 477708 479999 490410 491907 513243 513531 515733 515737 516772 519403 521226 522784 527235 534959 537148 539151 546736 558369 568434 570845 571822 572764 593411 594777 600763 600825 600871 600878 607466 608815 612413 613865 619423 637110 640521 644636 644922 664548 665297 667631 668518 670493 670504 681118 690314 692225 701890 702352 709331 716190 717007 718755 721771 721772 725374 730104 732832 736795 741050 742553 744208 746048 746062 748197 752502 756497 756728 757750 759459 759845 760549 760764 760807 762020 763222 770100 772051 773363 781792 782702 789517 791452 805206 807619 808798 815105 815148 815320 815980 816579 818391 819606 823176 823567 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings secretary"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.63%) |
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.