Query Metrics
7
Database Queries
7
Different statements
169.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.31 ms (85.17%) |
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 83499 117831 188610 393039 398040 398689 401814 409151 409379 410128 413262 414702 424744 429252 433964 443949 451579 451584 453084 458795 461321 462297 469840 474551 478086 481291 487173 489166 493043 500277 504729 504745 507132 514700 514941 516066 522402 522644 525516 525647 526487 533867 534039 546840 547464 548619 551180 551942 556311 559115 559204 564951 579685 584014 585397 595778 603574 606053 609799 611573 616629 618005 620240 622690 623221 626291 630194 635480 637437 644327 649129 649135 649847 651630 653720 658469 659078 659258 661262 661943 664193 669045 670097 670761 671724 672130 672181 674514 677564 688262 689645 693539 694221 695924 703537 703547 705516 705537 707292 708775 710509 717731 717849 718529 720467 720481 721990 753051 756091 759470 774209 775492 775775 798703 807847 811936 813460 815298 815505 827897 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (8.79%) |
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 649129 649135 630194 525516 807847 623221 398040 815505 551942 653720 661943 672130 659078 622690 827897 669045 664193 756091 661262 547464 618005 584014 522644 616629 401814 514700 429252 649847 413262 83499 117831 433964 409379 658469 611573 753051 393039 546840 526487 677564 717731 710509 443949 451584 525647 514941 774209 533867 798703 478086 462297 522402 559204 595778 620240 717849 493043 458795 461321 813460 500277 579685 516066 585397 693539 424744 559115 489166 188610 414702 551180 811936 708775 469840 635480 775492 410128 474551 670097 672181 720481 556311 705516 674514 548619 451579 534039 481291 659258 487173 504729 703537 707292 718529 720467 671724 504745 721990 689645 694221 705537 637437 644327 398689 409151 453084 670761 688262 775775 759470 603574 626291 703547 507132 815298 564951 651630 695924 606053 609799 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.57%) |
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 83499 117831 188610 393039 398040 398689 401814 409151 409379 410128 413262 414702 424744 429252 433964 443949 451579 451584 453084 458795 461321 462297 469840 474551 478086 481291 487173 489166 493043 500277 504729 504745 507132 514700 514941 516066 522402 522644 525516 525647 526487 533867 534039 546840 547464 548619 551180 551942 556311 559115 559204 564951 579685 584014 585397 595778 603574 606053 609799 611573 616629 618005 620240 622690 623221 626291 630194 635480 637437 644327 649129 649135 649847 651630 653720 658469 659078 659258 661262 661943 664193 669045 670097 670761 671724 672130 672181 674514 677564 688262 689645 693539 694221 695924 703537 703547 705516 705537 707292 708775 710509 717731 717849 718529 720467 720481 721990 753051 756091 759470 774209 775492 775775 798703 807847 811936 813460 815298 815505 827897 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex public security"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс на security улиц"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс на security улиц"
]
|
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.