Query Metrics
7
Database Queries
7
Different statements
162.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.12 ms (86.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 56632 383388 387409 390176 395506 396447 397564 398947 407995 423940 423943 424404 425505 426715 434091 448314 452211 462763 469214 476438 483589 503546 507241 509516 512566 518003 525507 528452 531150 531570 533657 534255 535550 542764 547698 554321 556450 560070 560699 562542 563076 574833 577048 579886 581760 587103 595588 598049 601438 602960 602964 608177 615516 629387 635977 642048 654230 662436 663293 664658 672369 685916 688997 689565 693935 695820 699534 700028 702966 706000 710389 714323 716192 722360 724086 724740 727399 729612 733022 741035 744261 745305 754434 754843 756958 764028 764190 766180 768548 772991 779330 779435 781907 781928 782305 784520 787064 787360 788586 788882 790171 790319 801760 805163 806291 807649 812679 813198 814704 817889 818368 818661 819362 819614 821193 821395 823630 824870 826028 827648 ] |
||||||||||||||||||||||||||||||
|
13.74 ms (8.44%) |
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 664658 722360 608177 788586 801760 745305 754434 744261 56632 387409 397564 426715 476438 574833 563076 423940 503546 507241 518003 396447 819362 821395 535550 531150 714323 663293 685916 706000 702966 560070 779330 779435 812679 729612 764028 782305 784520 790171 813198 724086 741035 766180 642048 781907 398947 448314 602964 383388 407995 826028 817889 818661 827648 531570 579886 556450 562542 547698 695820 577048 581760 807649 727399 733022 772991 787360 806291 768548 710389 788882 452211 424404 509516 512566 602960 819614 823630 483589 688997 693935 699534 672369 689565 700028 560699 587103 598049 601438 635977 629387 790319 805163 724740 787064 754843 756958 764190 615516 716192 781928 425505 462763 423943 595588 528452 395506 390176 434091 824870 818368 814704 821193 469214 533657 525507 534255 542764 554321 654230 662436 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.63%) |
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 56632 383388 387409 390176 395506 396447 397564 398947 407995 423940 423943 424404 425505 426715 434091 448314 452211 462763 469214 476438 483589 503546 507241 509516 512566 518003 525507 528452 531150 531570 533657 534255 535550 542764 547698 554321 556450 560070 560699 562542 563076 574833 577048 579886 581760 587103 595588 598049 601438 602960 602964 608177 615516 629387 635977 642048 654230 662436 663293 664658 672369 685916 688997 689565 693935 695820 699534 700028 702966 706000 710389 714323 716192 722360 724086 724740 727399 729612 733022 741035 744261 745305 754434 754843 756958 764028 764190 766180 768548 772991 779330 779435 781907 781928 782305 784520 787064 787360 788586 788882 790171 790319 801760 805163 806291 807649 812679 813198 814704 817889 818368 818661 819362 819614 821193 821395 823630 824870 826028 827648 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рыжеволосая в туалете…"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая туалет"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.