Query Metrics
7
Database Queries
7
Different statements
242.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.11 ms (88.06%) |
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 6874 117806 383742 387473 389775 402625 414269 416718 428179 428224 435539 439031 439038 439981 441071 441113 441799 444524 445406 447159 447973 449068 452547 460084 465497 466732 496344 497686 498697 502212 512072 512935 514258 517658 519312 529795 529799 530310 530481 530942 531789 531880 534557 534566 536404 541325 547483 547486 548455 549081 554851 556884 559355 561287 566822 571846 576545 576932 581006 581477 586914 587851 590396 590729 592369 597163 599906 600087 600348 603691 614328 633887 634071 639381 639804 641997 642035 643187 643200 648869 658789 660373 660405 660411 660412 660419 661036 661915 666016 669056 669071 671018 671045 672950 680164 680423 686106 702157 708069 709559 713142 717535 722280 723930 725629 730118 735124 745806 747151 752667 762294 770260 770265 782790 791370 796837 796853 806437 817352 817671 ] |
||||||||||||||||||||||||||||||
|
19.67 ms (8.13%) |
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 389775 387473 817671 817352 517658 566822 548455 661036 709559 639381 643187 643200 796837 796853 735124 730118 708069 117806 6874 383742 402625 414269 439038 428179 435539 439031 441071 428224 441799 444524 416718 439981 441113 445406 447973 465497 447159 449068 452547 460084 466732 497686 512072 529795 530481 496344 512935 529799 536404 502212 530942 534566 498697 514258 519312 530310 531789 531880 534557 547486 554851 571846 581006 541325 547483 576932 549081 559355 561287 660405 669071 648869 660412 660419 669056 680423 702157 713142 717535 722280 658789 660373 660411 661915 666016 671018 671045 672950 680164 686106 556884 576545 581477 586914 599906 600348 634071 642035 587851 592369 614328 597163 603691 639804 590396 590729 600087 633887 641997 782790 806437 762294 770265 791370 723930 745806 747151 752667 770260 725629 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.25%) |
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 6874 117806 383742 387473 389775 402625 414269 416718 428179 428224 435539 439031 439038 439981 441071 441113 441799 444524 445406 447159 447973 449068 452547 460084 465497 466732 496344 497686 498697 502212 512072 512935 514258 517658 519312 529795 529799 530310 530481 530942 531789 531880 534557 534566 536404 541325 547483 547486 548455 549081 554851 556884 559355 561287 566822 571846 576545 576932 581006 581477 586914 587851 590396 590729 592369 597163 599906 600087 600348 603691 614328 633887 634071 639381 639804 641997 642035 643187 643200 648869 658789 660373 660405 660411 660412 660419 661036 661915 666016 669056 669071 671018 671045 672950 680164 680423 686106 702157 708069 709559 713142 717535 722280 723930 725629 730118 735124 745806 747151 752667 762294 770260 770265 782790 791370 796837 796853 806437 817352 817671 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фистит"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг"
]
|
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.