Query Metrics
7
Database Queries
7
Different statements
638.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
405.85 ms (63.54%) |
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 34462 154707 155198 282038 382014 388642 393314 402631 403087 407423 410305 410310 411039 411885 421038 423307 428267 431639 445083 447853 448266 457581 467978 486643 488933 490692 492246 492440 494540 506310 517693 518601 525822 528871 528881 530635 532399 532838 537857 537872 541468 542880 547028 553440 563902 563916 565111 569199 574318 574706 576572 576637 577408 582444 584592 589234 592930 595189 607676 607685 614990 615964 622733 626253 626257 627076 631740 634849 635230 643018 644876 652540 662847 664835 664967 666791 667574 668292 668620 668809 684343 684731 689660 707356 715138 722330 732161 732293 736836 740956 743834 747325 748155 749909 750078 752094 752656 752876 755165 758170 758330 760123 761027 765243 771213 775529 778384 781783 781898 788113 788839 800780 801341 802701 804445 807402 807894 808752 814151 827290 ] |
||||||||||||||||||||||||||||||
|
212.56 ms (33.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные boobs"
]
|
||||||||||||||||||||||||||||||
|
12.49 ms (1.95%) |
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 407423 402631 403087 410305 411885 431639 421038 492246 457581 467978 448266 528871 530635 528881 563916 569199 574706 553440 666791 707356 722330 664835 664967 652540 662847 667574 576572 614990 627076 589234 635230 643018 626253 781783 781898 802701 808752 740956 748155 760123 765243 801341 758170 771213 743834 750078 732293 736836 752876 749909 755165 761027 615964 622733 626257 715138 34462 423307 486643 411039 155198 814151 595189 775529 788113 788839 804445 807894 758330 747325 752094 752656 807402 800780 582444 584592 684343 388642 532838 732161 778384 154707 393314 282038 382014 410310 428267 445083 644876 827290 492440 447853 490692 494540 506310 517693 537857 537872 518601 525822 532399 488933 542880 547028 541468 565111 576637 574318 689660 668292 668809 684731 668620 563902 577408 592930 607676 631740 634849 607685 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.38%) |
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 34462 154707 155198 282038 382014 388642 393314 402631 403087 407423 410305 410310 411039 411885 421038 423307 428267 431639 445083 447853 448266 457581 467978 486643 488933 490692 492246 492440 494540 506310 517693 518601 525822 528871 528881 530635 532399 532838 537857 537872 541468 542880 547028 553440 563902 563916 565111 569199 574318 574706 576572 576637 577408 582444 584592 589234 592930 595189 607676 607685 614990 615964 622733 626253 626257 627076 631740 634849 635230 643018 644876 652540 662847 664835 664967 666791 667574 668292 668620 668809 684343 684731 689660 707356 715138 722330 732161 732293 736836 740956 743834 747325 748155 749909 750078 752094 752656 752876 755165 758170 758330 760123 761027 765243 771213 775529 778384 781783 781898 788113 788839 800780 801341 802701 804445 807402 807894 808752 814151 827290 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge boobs"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие огромные boobs"
]
|
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.