Query Metrics
7
Database Queries
7
Different statements
362.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
337.92 ms (93.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 96452 188462 357886 386896 390286 396251 407683 415966 416523 416631 416668 416708 421152 421993 423435 423784 430178 450948 452810 466639 468943 471654 486721 488342 488820 495467 497906 498318 506063 513256 513842 516818 518471 521682 526188 528936 545428 545439 549091 552800 556880 568962 573192 576848 590803 595215 597190 598141 598461 600348 604824 606275 608550 628553 641997 642035 648869 653047 653925 660382 662850 669017 669035 669057 670366 671045 672950 677343 679676 684422 699397 707357 707432 713195 722395 725604 725631 733582 739131 739145 745126 749070 749219 749254 751546 752602 752633 752644 752665 752676 758778 760238 761432 761706 765714 766415 770250 770253 770410 770804 775922 776209 785591 787466 788118 789466 794390 795211 796057 796744 799693 801686 801898 808331 808971 808998 811459 828086 828394 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (4.10%) |
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 722395 648869 670366 713195 660382 662850 669017 669035 669057 671045 672950 545439 552800 556880 573192 576848 600348 604824 616047 642035 608550 590803 597190 595215 598141 628553 641997 788118 794390 776209 733582 752665 752676 770804 785591 796057 799693 808998 766415 770250 725631 739131 739145 745126 749070 749219 751546 761432 770253 749254 752602 752633 752644 758778 765714 770410 707432 808331 811459 96452 416708 188462 357886 386896 390286 396251 450948 468943 407683 421152 423784 452810 466639 471654 416523 416631 416668 421993 423435 495467 513256 498318 506063 513842 521682 488820 497906 516818 518471 725604 761706 801686 488342 549091 801898 828394 415966 526188 606275 430178 545428 699397 828086 653925 679676 787466 795211 808971 528936 486721 568962 653047 677343 684422 707357 598461 796744 775922 789466 760238 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (0.89%) |
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 96452 188462 357886 386896 390286 396251 407683 415966 416523 416631 416668 416708 421152 421993 423435 423784 430178 450948 452810 466639 468943 471654 486721 488342 488820 495467 497906 498318 506063 513256 513842 516818 518471 521682 526188 528936 545428 545439 549091 552800 556880 568962 573192 576848 590803 595215 597190 598141 598461 600348 604824 606275 608550 628553 641997 642035 648869 653047 653925 660382 662850 669017 669035 669057 670366 671045 672950 677343 679676 684422 699397 707357 707432 713195 722395 725604 725631 733582 739131 739145 745126 749070 749219 749254 751546 752602 752633 752644 752665 752676 758778 760238 761432 761706 765714 766415 770250 770253 770410 770804 775922 776209 785591 787466 788118 789466 794390 795211 796057 796744 799693 801686 801898 808331 808971 808998 811459 828086 828394 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор riding"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hardcore riding"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор riding"
]
|
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.