Query Metrics
7
Database Queries
7
Different statements
159.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.08 ms (82.16%) |
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 33459 384419 388492 390844 391744 396728 396962 401101 408238 416238 418838 418853 419144 427997 429475 436883 443134 443405 443959 451262 452388 452816 453082 453695 454275 454373 454668 456832 459159 459176 464532 466738 466770 466956 468355 471847 472631 472678 472685 473341 473429 474546 474813 474851 474894 475655 475662 475666 475673 475681 475684 475690 476195 477118 478339 478576 479077 479087 481879 482074 482368 486757 488889 489956 492739 493199 493488 496729 500339 504474 507659 510776 511028 511392 511572 511855 517003 524474 525657 526071 526478 540247 541102 541370 543614 544510 545648 546180 546442 549137 562973 566298 567754 569003 571135 580638 585960 589771 592490 595043 597123 598416 599429 605137 605614 612996 652541 667928 668706 674117 697168 698528 717118 719300 796338 814991 817268 823149 824555 826938 ] |
||||||||||||||||||||||||||||||
|
18.56 ms (11.63%) |
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 482368 479087 507659 33459 418838 814991 474546 481879 525657 540247 476195 543614 545648 569003 541370 562973 674117 652541 546442 571135 595043 585960 451262 511028 384419 391744 388492 408238 443405 419144 427997 429475 436883 418853 817268 464532 472678 472685 473341 474894 475666 475684 492739 493488 474851 475673 479077 452816 453695 454373 454668 456832 475662 478576 488889 493199 504474 511392 511855 466738 473429 475655 475681 475690 482074 544510 549137 567754 580638 667928 566298 597123 598416 599429 612996 390844 454275 477118 401101 459159 443959 452388 453082 466770 474813 478339 396728 443134 459176 472631 468355 500339 486757 489956 496729 510776 517003 526071 526478 524474 396962 416238 823149 826938 824555 466956 511572 471847 541102 717118 719300 697168 698528 668706 546180 592490 589771 605614 605137 796338 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.52%) |
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 33459 384419 388492 390844 391744 396728 396962 401101 408238 416238 418838 418853 419144 427997 429475 436883 443134 443405 443959 451262 452388 452816 453082 453695 454275 454373 454668 456832 459159 459176 464532 466738 466770 466956 468355 471847 472631 472678 472685 473341 473429 474546 474813 474851 474894 475655 475662 475666 475673 475681 475684 475690 476195 477118 478339 478576 479077 479087 481879 482074 482368 486757 488889 489956 492739 493199 493488 496729 500339 504474 507659 510776 511028 511392 511572 511855 517003 524474 525657 526071 526478 540247 541102 541370 543614 544510 545648 546180 546442 549137 562973 566298 567754 569003 571135 580638 585960 589771 592490 595043 597123 598416 599429 605137 605614 612996 652541 667928 668706 674117 697168 698528 717118 719300 796338 814991 817268 823149 824555 826938 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation mature"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк mature"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк mature"
]
|
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.