Query Metrics
7
Database Queries
7
Different statements
191.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.14 ms (87.74%) |
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 394514 415977 417478 420121 432939 452948 466868 467715 469479 470426 471682 475336 476298 476932 490403 492619 493789 495041 500787 504471 511014 511869 513990 517636 517703 518014 518225 519700 526164 530021 532732 532830 533594 534082 541277 541392 545001 545550 546316 547453 547465 547471 547484 548465 548534 549797 550845 551093 555343 555722 557284 557625 558098 571194 574397 576607 577039 577344 579452 581050 582314 582339 583712 600432 601729 604427 606405 618300 618948 620647 628113 629742 632289 657543 660014 664166 668663 668690 669062 672942 686807 707408 710308 714357 714493 717291 725475 726946 731204 734253 742320 742416 747310 751510 751563 751611 752598 752666 752697 752759 752940 755878 758785 758799 769959 794229 795404 795420 800735 803837 806534 806686 806943 808972 811709 812495 814491 821877 823607 825811 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (7.92%) |
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 394514 420121 415977 417478 432939 814491 821877 825811 823607 469479 452948 466868 471682 490403 492619 476932 518225 532830 495041 511869 517703 533594 534082 504471 511014 526164 530021 532732 500787 513990 517636 518014 519700 467715 470426 475336 476298 493789 541277 546316 547465 547484 549797 557625 581050 582339 583712 541392 545550 548534 555343 555722 558098 571194 576607 577344 547453 557284 579452 668663 669062 686807 660014 710308 714357 714493 717291 657543 664166 668690 672942 545001 547471 548465 550845 551093 574397 577039 582314 618948 629742 600432 601729 628113 606405 618300 620647 794229 795404 800735 808972 795420 806534 806686 812495 731204 734253 742320 751611 752697 752940 758799 803837 806943 811709 725475 751563 758785 769959 726946 742416 747310 752666 752759 755878 751510 752598 604427 632289 707408 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.28%) |
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 394514 415977 417478 420121 432939 452948 466868 467715 469479 470426 471682 475336 476298 476932 490403 492619 493789 495041 500787 504471 511014 511869 513990 517636 517703 518014 518225 519700 526164 530021 532732 532830 533594 534082 541277 541392 545001 545550 546316 547453 547465 547471 547484 548465 548534 549797 550845 551093 555343 555722 557284 557625 558098 571194 574397 576607 577039 577344 579452 581050 582314 582339 583712 600432 601729 604427 606405 618300 618948 620647 628113 629742 632289 657543 660014 664166 668663 668690 669062 672942 686807 707408 710308 714357 714493 717291 725475 726946 731204 734253 742320 742416 747310 751510 751563 751611 752598 752666 752697 752759 752940 755878 758785 758799 769959 794229 795404 795420 800735 803837 806534 806686 806943 808972 811709 812495 814491 821877 823607 825811 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature toys solo"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature toys соло"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature 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.