Query Metrics
7
Database Queries
7
Different statements
184.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.21 ms (86.33%) |
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 41776 397478 415977 416512 416737 417478 427539 444536 447734 452595 452792 452873 452914 456700 466427 466563 466737 469139 469741 471687 477146 477245 480203 486243 487425 493744 498619 503836 504075 510547 511869 514946 517509 525970 530956 530990 532732 533594 534548 534578 541328 544132 545222 545473 547453 547465 548954 556899 558098 559294 559359 573193 575859 576979 577039 577344 581050 583472 586760 592245 592576 601367 605874 606405 614967 616296 624174 630564 634114 657547 660409 660441 663181 668690 672942 679051 703574 707408 713185 713298 717291 740589 740939 741252 742338 742351 747310 749245 751307 751510 751611 752655 752666 752697 752750 752759 758799 761625 770210 770395 770413 777847 778427 785610 787504 788497 795420 796930 800522 806541 806583 806686 806919 808787 814411 814418 814470 814519 824668 825442 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (8.20%) |
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 592576 778427 742338 740589 752655 761625 397478 469139 452792 416512 660409 444536 416737 415977 417478 427539 814418 814519 814411 814470 452595 452914 469741 447734 452873 456700 493744 498619 511869 517509 525970 533594 532732 534578 514946 530956 487425 547465 548954 559359 581050 583472 541328 558098 559294 573193 576979 577344 547453 713185 660441 663181 717291 657547 668690 672942 577039 592245 605874 624174 634114 586760 601367 614967 616296 630564 606405 777847 796930 806919 808787 795420 806686 742351 749245 751611 752697 758799 785610 787504 806541 741252 747310 752666 752759 751307 751510 752750 770210 740939 770395 770413 707408 788497 800522 806583 466563 477245 466737 480203 41776 477146 503836 825442 824668 471687 486243 504075 534548 530990 510547 466427 545473 575859 545222 556899 544132 679051 703574 713298 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.35%) |
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 41776 397478 415977 416512 416737 417478 427539 444536 447734 452595 452792 452873 452914 456700 466427 466563 466737 469139 469741 471687 477146 477245 480203 486243 487425 493744 498619 503836 504075 510547 511869 514946 517509 525970 530956 530990 532732 533594 534548 534578 541328 544132 545222 545473 547453 547465 548954 556899 558098 559294 559359 573193 575859 576979 577039 577344 581050 583472 586760 592245 592576 601367 605874 606405 614967 616296 624174 630564 634114 657547 660409 660441 663181 668690 672942 679051 703574 707408 713185 713298 717291 740589 740939 741252 742338 742351 747310 749245 751307 751510 751611 752655 752666 752697 752750 752759 758799 761625 770210 770395 770413 777847 778427 785610 787504 788497 795420 796930 800522 806541 806583 806686 806919 808787 814411 814418 814470 814519 824668 825442 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal solo toys"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал соло toys"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал соло toys"
]
|
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.