Query Metrics
7
Database Queries
7
Different statements
146.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.85 ms (85.25%) |
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 6684 185013 185212 185247 185458 185714 185882 185950 205430 322760 350951 381984 382059 382798 383018 387006 387636 397477 406017 406416 413247 413943 426894 447570 447842 448357 486927 499651 507133 519887 521265 529164 543063 550956 551354 551401 575135 600596 608232 610246 612684 625008 628339 628342 628344 633118 641654 642797 643426 647643 648491 651941 653240 653241 654065 654154 661099 661729 661789 662711 662757 662966 662978 662982 663082 663690 664868 665166 666331 666347 670133 672536 676929 676976 677158 677376 682482 687138 699542 701492 703877 705689 709583 710359 715353 719274 722855 724712 732431 735417 736371 738877 738960 742132 744478 746498 747366 748674 749284 749526 749550 750941 758218 758493 762873 771678 773017 773090 773215 775599 779532 784897 785776 791588 792535 792833 792838 797705 799756 800265 ] |
||||||||||||||||||||||||||||||
|
12.27 ms (8.38%) |
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 758493 773215 185950 625008 662978 628339 628344 799756 447570 661729 662757 662982 666347 719274 663690 661099 661789 670133 682482 800265 773017 791588 382798 185013 551354 448357 664868 543063 701492 665166 608232 642797 736371 742132 749550 771678 749526 738877 750941 758218 643426 775599 784897 185882 519887 387636 529164 550956 612684 732431 397477 350951 406017 205430 185247 381984 406416 654065 662711 705689 709583 715353 677158 551401 610246 628342 792838 792535 762873 749284 773090 747366 748674 699542 722855 382059 383018 703877 185458 413247 486927 575135 647643 666331 676976 653240 322760 387006 426894 499651 6684 651941 653241 654154 662966 663082 676929 648491 672536 687138 677376 600596 633118 641654 797705 792833 735417 738960 744478 746498 724712 710359 779532 785776 413943 447842 185714 185212 507133 521265 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.23%) |
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 6684 185013 185212 185247 185458 185714 185882 185950 205430 322760 350951 381984 382059 382798 383018 387006 387636 397477 406017 406416 413247 413943 426894 447570 447842 448357 486927 499651 507133 519887 521265 529164 543063 550956 551354 551401 575135 600596 608232 610246 612684 625008 628339 628342 628344 633118 641654 642797 643426 647643 648491 651941 653240 653241 654065 654154 661099 661729 661789 662711 662757 662966 662978 662982 663082 663690 664868 665166 666331 666347 670133 672536 676929 676976 677158 677376 682482 687138 699542 701492 703877 705689 709583 710359 715353 719274 722855 724712 732431 735417 736371 738877 738960 742132 744478 746498 747366 748674 749284 749526 749550 750941 758218 758493 762873 771678 773017 773090 773215 775599 779532 784897 785776 791588 792535 792833 792838 797705 799756 800265 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens массаж"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens массаж"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens massage"
]
|
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.