Query Metrics
7
Database Queries
7
Different statements
149.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.59 ms (82.71%) |
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 34296 82091 378401 382275 384082 392802 395184 398869 400483 401767 402364 408339 411323 413128 417372 418667 419277 420197 420836 423771 424847 432631 434135 434278 444237 445135 448796 449442 450030 450830 451719 453234 456261 456581 456683 460173 464870 465663 470396 472960 474763 474946 475298 484867 489389 489767 491696 493822 493972 495572 498538 500083 506002 507204 508070 512173 512195 515606 519366 520117 521101 522413 524206 525925 526880 527287 527516 527541 528947 528948 532057 533143 533711 535316 535330 536433 536764 542392 547385 548165 550040 552806 552937 553174 559744 562417 563454 564283 565333 567676 567740 568594 570163 570241 574263 575865 577481 581579 584088 588973 592157 596377 599591 599710 601143 603333 603385 604654 609058 609296 613837 618040 622280 628321 646939 647147 651678 687316 794786 825545 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (10.04%) |
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 512173 532057 533711 535316 533143 484867 577481 647147 548165 552937 553174 601143 603333 794786 420197 418667 444237 395184 411323 470396 525925 526880 491696 450030 559744 651678 592157 613837 378401 489767 599591 423771 82091 402364 401767 434278 456261 453234 474763 493822 512195 568594 542392 567676 382275 34296 408339 448796 419277 474946 508070 536433 498538 520117 524206 456581 456683 400483 445135 420836 495572 547385 562417 570163 599710 609296 628321 398869 521101 609058 413128 432631 424847 417372 500083 519366 528948 528947 535330 536764 506002 465663 489389 552806 570241 581579 687316 596377 618040 384082 472960 475298 493972 527287 392802 434135 825545 451719 460173 464870 450830 449442 515606 507204 527516 527541 522413 564283 584088 563454 565333 575865 646939 550040 567740 574263 588973 604654 603385 622280 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (2.11%) |
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 34296 82091 378401 382275 384082 392802 395184 398869 400483 401767 402364 408339 411323 413128 417372 418667 419277 420197 420836 423771 424847 432631 434135 434278 444237 445135 448796 449442 450030 450830 451719 453234 456261 456581 456683 460173 464870 465663 470396 472960 474763 474946 475298 484867 489389 489767 491696 493822 493972 495572 498538 500083 506002 507204 508070 512173 512195 515606 519366 520117 521101 522413 524206 525925 526880 527287 527516 527541 528947 528948 532057 533143 533711 535316 535330 536433 536764 542392 547385 548165 550040 552806 552937 553174 559744 562417 563454 564283 565333 567676 567740 568594 570163 570241 574263 575865 577481 581579 584088 588973 592157 596377 599591 599710 601143 603333 603385 604654 609058 609296 613837 618040 622280 628321 646939 647147 651678 687316 794786 825545 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skirt big ass"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"юбк большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
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.