Query Metrics
7
Database Queries
7
Different statements
363.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.40 ms (58.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая vintage"
]
|
||||||||||||||||||||||||||||||
|
131.36 ms (36.15%) |
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 489468 522914 526114 538902 538905 538926 539402 539624 541309 541334 541403 542482 543660 543685 544289 544297 544321 544355 544587 548278 550328 551920 557372 561026 561740 563958 565123 566860 567388 568018 568337 571434 572424 574282 576711 576713 581279 581621 582769 590555 590575 592449 592490 594186 598028 608344 618970 620175 621608 621698 622692 622847 622980 623872 625488 627746 628809 636266 641747 643033 644323 646042 648463 650369 652856 652971 653220 653977 659262 661902 668562 670067 670393 670727 670731 671098 671708 672095 672717 674072 685318 687192 690774 690823 690931 691998 692123 692222 693028 693486 693985 694143 694197 695191 695204 696248 696278 696358 698513 699540 699581 699764 703085 703522 703533 716570 716786 717859 720375 720378 722452 730224 730524 737590 744443 747102 750064 754424 772574 790991 ] |
||||||||||||||||||||||||||||||
|
10.52 ms (2.89%) |
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 636266 592449 737590 699581 644323 750064 567388 539402 541309 543660 551920 565123 581279 544321 563958 574282 582769 543685 544355 661902 685318 692123 692222 695204 716786 670067 670731 672717 687192 690823 690931 693985 722452 572424 620175 590575 643033 625488 641747 747102 720378 790991 526114 566860 542482 730224 522914 541334 548278 576713 571434 576711 489468 538905 561740 717859 627746 618970 772574 538902 538926 544289 544587 541403 568018 653220 670727 671098 690774 694143 650369 653977 671708 696358 698513 699540 699764 693028 696248 550328 592490 628809 622980 594186 622847 754424 730524 744443 703522 561026 621698 539624 557372 544297 568337 581621 646042 648463 659262 668562 670393 672095 674072 696278 703533 716570 693486 694197 720375 652856 652971 691998 695191 703085 598028 621608 608344 622692 623872 590555 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (0.76%) |
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 489468 522914 526114 538902 538905 538926 539402 539624 541309 541334 541403 542482 543660 543685 544289 544297 544321 544355 544587 548278 550328 551920 557372 561026 561740 563958 565123 566860 567388 568018 568337 571434 572424 574282 576711 576713 581279 581621 582769 590555 590575 592449 592490 594186 598028 608344 618970 620175 621608 621698 622692 622847 622980 623872 625488 627746 628809 636266 641747 643033 644323 646042 648463 650369 652856 652971 653220 653977 659262 661902 668562 670067 670393 670727 670731 671098 671708 672095 672717 674072 685318 687192 690774 690823 690931 691998 692123 692222 693028 693486 693985 694143 694197 695191 695204 696248 696278 696358 698513 699540 699581 699764 703085 703522 703533 716570 716786 717859 720375 720378 722452 730224 730524 737590 744443 747102 750064 754424 772574 790991 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette vintage"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая vintage"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.45%) |
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.