Query Metrics
7
Database Queries
7
Different statements
178.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.19 ms (87.17%) |
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 383318 384462 399887 399948 403843 415926 417616 418459 421759 422397 427425 428932 435643 438455 438646 439345 441800 442586 454745 459339 461209 468163 468251 473738 485297 494482 495163 499013 500308 515300 528451 530936 538354 541136 551586 555037 556193 560364 561756 561905 564215 564625 566129 580519 580629 582018 583185 583606 584322 585790 585835 587587 590409 594941 595577 598504 600512 603542 603984 607926 608467 620547 620808 651762 652129 652131 666925 676769 678807 679697 680029 680677 680749 680753 681204 683724 684898 695339 695872 697242 701292 712212 715899 730871 731456 737216 737996 738255 740032 740131 740603 740709 744372 745280 749713 749719 750637 760471 762035 765084 768010 772729 774833 775237 779452 779611 782094 782585 784513 785267 786895 791376 792309 796463 806597 806635 806683 806823 806882 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (7.41%) |
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 680677 651762 585790 779611 745280 740131 740603 749713 749719 765084 422397 383318 680753 680749 620808 792309 772729 762035 760471 680029 676769 603542 791376 806597 785267 786895 784513 738255 768010 782585 384462 441800 555037 435643 468251 564625 652129 681204 608467 774833 731456 712212 403843 499013 459339 561905 541136 697242 551586 600512 468163 515300 684898 594941 782901 737216 744372 538354 473738 461209 679697 564215 583185 528451 500308 417616 427425 683724 678807 715899 620547 775237 806882 740032 737996 806823 399887 442586 494482 566129 580629 580519 695339 695872 590409 796463 740709 806683 806635 428932 399948 454745 438455 485297 415926 582018 583606 652131 587587 603984 779452 782094 438646 418459 495163 556193 560364 584322 701292 730871 421759 666925 561756 607926 750637 439345 530936 585835 598504 595577 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.64%) |
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 383318 384462 399887 399948 403843 415926 417616 418459 421759 422397 427425 428932 435643 438455 438646 439345 441800 442586 454745 459339 461209 468163 468251 473738 485297 494482 495163 499013 500308 515300 528451 530936 538354 541136 551586 555037 556193 560364 561756 561905 564215 564625 566129 580519 580629 582018 583185 583606 584322 585790 585835 587587 590409 594941 595577 598504 600512 603542 603984 607926 608467 620547 620808 651762 652129 652131 666925 676769 678807 679697 680029 680677 680749 680753 681204 683724 684898 695339 695872 697242 701292 712212 715899 730871 731456 737216 737996 738255 740032 740131 740603 740709 744372 745280 749713 749719 750637 760471 762035 765084 768010 772729 774833 775237 779452 779611 782094 782585 784513 785267 786895 791376 792309 796463 806597 806635 806683 806823 806882 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер cute девушк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam cute girl"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер cute девушк"
]
|
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.