Query Metrics
7
Database Queries
7
Different statements
189.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.05 ms (85.47%) |
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 45306 143291 181569 266183 384988 385915 395668 397902 421672 424415 432393 442551 449896 452046 452081 460027 464263 469352 470668 472889 474137 476032 477708 485349 489729 490410 491907 513243 513531 516772 521226 526963 534959 537148 539151 546736 558369 568434 570845 572764 585535 593411 594777 600763 600825 600871 600878 607466 608815 612413 613865 619423 637110 640521 644922 647986 664548 665297 667631 670493 670504 681118 690314 692225 701890 702352 703522 709331 709686 710489 716190 717007 718755 721771 721772 725374 730104 732832 735901 736795 741050 742553 744093 744208 746048 746062 748197 752502 755134 756497 756728 757750 759459 759845 760549 760764 760807 761589 762020 762261 763222 770100 772051 773363 781792 782702 789517 791452 805206 807619 808798 815105 815148 815320 815980 816579 818391 819606 823176 823567 ] |
||||||||||||||||||||||||||||||
|
17.78 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 762261 735901 744093 755134 761589 703522 709686 710489 464263 470668 585535 485349 469352 526963 647986 489729 45306 477708 452081 600825 600763 476032 432393 472889 490410 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 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 568434 516772 460027 266183 421672 442551 474137 546736 570845 593411 397902 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.61%) |
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 45306 143291 181569 266183 384988 385915 395668 397902 421672 424415 432393 442551 449896 452046 452081 460027 464263 469352 470668 472889 474137 476032 477708 485349 489729 490410 491907 513243 513531 516772 521226 526963 534959 537148 539151 546736 558369 568434 570845 572764 585535 593411 594777 600763 600825 600871 600878 607466 608815 612413 613865 619423 637110 640521 644922 647986 664548 665297 667631 670493 670504 681118 690314 692225 701890 702352 703522 709331 709686 710489 716190 717007 718755 721771 721772 725374 730104 732832 735901 736795 741050 742553 744093 744208 746048 746062 748197 752502 755134 756497 756728 757750 759459 759845 760549 760764 760807 761589 762020 762261 763222 770100 772051 773363 781792 782702 789517 791452 805206 807619 808798 815105 815148 815320 815980 816579 818391 819606 823176 823567 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"secretary stockings"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
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.