Query Metrics
7
Database Queries
7
Different statements
370.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.86 ms (58.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
129.73 ms (35.06%) |
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 6919 387251 388205 388390 399399 401793 404730 405538 410953 413467 414360 422512 423269 423893 425773 430023 436461 440613 445404 446002 450317 451246 451593 453250 456084 458868 462026 462428 464193 466002 467569 468658 469572 469756 477200 478216 480204 481666 482583 488628 491026 491938 492170 499178 507163 508353 514241 519939 520816 520954 521831 523012 524419 529293 529347 531186 532943 534025 535593 536581 537934 543527 544614 544753 544788 546777 552114 552706 556403 558071 560143 561136 572530 573463 575703 579519 580855 583678 588971 597268 605344 609564 618514 618565 625521 631684 634794 642662 647430 648871 650764 656183 661570 670763 671712 672984 677002 677007 680484 684173 696995 709215 714552 719765 720424 723512 756398 765225 765807 767025 770392 775985 777043 795550 797149 799212 806271 810468 811096 827523 ] |
||||||||||||||||||||||||||||||
|
16.84 ms (4.55%) |
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 795550 797149 799212 451593 6919 399399 410953 453250 488628 445404 462026 529347 648871 507163 514241 477200 677002 499178 469756 464193 523012 529293 532943 677007 531186 680484 561136 414360 413467 827523 468658 482583 524419 534025 537934 556403 575703 647430 672984 671712 719765 684173 544614 560143 572530 625521 597268 609564 618565 631684 605344 618514 777043 806271 810468 770392 765225 709215 714552 462428 478216 456084 466002 404730 480204 767025 388205 425773 508353 558071 588971 436461 491938 583678 492170 423893 450317 552114 811096 520816 422512 634794 520954 388390 387251 401793 723512 458868 467569 469572 481666 535593 536581 546777 543527 544753 552706 573463 579519 661570 670763 696995 650764 720424 580855 775985 756398 765807 423269 446002 430023 440613 405538 451246 519939 491026 544788 642662 521831 656183 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (0.78%) |
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 6919 387251 388205 388390 399399 401793 404730 405538 410953 413467 414360 422512 423269 423893 425773 430023 436461 440613 445404 446002 450317 451246 451593 453250 456084 458868 462026 462428 464193 466002 467569 468658 469572 469756 477200 478216 480204 481666 482583 488628 491026 491938 492170 499178 507163 508353 514241 519939 520816 520954 521831 523012 524419 529293 529347 531186 532943 534025 535593 536581 537934 543527 544614 544753 544788 546777 552114 552706 556403 558071 560143 561136 572530 573463 575703 579519 580855 583678 588971 597268 605344 609564 618514 618565 625521 631684 634794 642662 647430 648871 650764 656183 661570 670763 671712 672984 677002 677007 680484 684173 696995 709215 714552 719765 720424 723512 756398 765225 765807 767025 770392 775985 777043 795550 797149 799212 806271 810468 811096 827523 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe stockings"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.