Query Metrics
7
Database Queries
7
Different statements
159.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.45 ms (82.34%) |
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 393775 409670 422096 435462 437416 438077 439630 442367 443068 447935 448763 448922 449697 449761 450861 452227 454296 455211 455663 455934 457192 457651 458245 458419 460824 465142 467949 468959 469655 470339 470826 471517 473678 474279 476013 476598 477743 479625 480011 480597 482997 483812 486147 489003 489015 489214 489626 491309 494174 495775 496553 498827 505425 507946 509027 510077 511427 511649 514711 517248 517384 518211 519665 519676 523307 524610 527549 527886 529105 529114 535346 535896 537282 538065 541051 541419 544862 546380 547649 548023 552941 555510 559236 560520 561191 562335 566075 568961 574170 577666 584420 586658 586695 586745 588971 591181 592446 598839 600736 603551 610931 621647 625144 633312 636554 637461 663769 679709 681370 687854 692859 714725 721967 722718 755030 775241 788252 799743 814699 814701 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (10.65%) |
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 566075 562335 577666 586658 586695 592446 610931 755030 439630 455663 454296 470826 473678 455211 476013 505425 524610 489003 498827 491309 527549 514711 393775 455934 494174 681370 568961 479625 486147 483812 541419 560520 538065 511427 529105 518211 663769 598839 603551 476598 480597 469655 517384 489214 510077 517248 529114 541051 527886 437416 814701 814699 457651 489626 559236 574170 692859 722718 687854 714725 799743 788252 636554 721967 775241 477743 471517 468959 443068 449697 482997 480011 435462 458419 535346 600736 519665 449761 457192 465142 511649 496553 537282 547649 584420 555510 561191 548023 586745 588971 438077 460824 474279 422096 447935 448763 458245 470339 519676 495775 544862 633312 409670 442367 448922 591181 523307 452227 467949 507946 509027 535896 489015 552941 679709 546380 621647 625144 637461 450861 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.93%) |
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 393775 409670 422096 435462 437416 438077 439630 442367 443068 447935 448763 448922 449697 449761 450861 452227 454296 455211 455663 455934 457192 457651 458245 458419 460824 465142 467949 468959 469655 470339 470826 471517 473678 474279 476013 476598 477743 479625 480011 480597 482997 483812 486147 489003 489015 489214 489626 491309 494174 495775 496553 498827 505425 507946 509027 510077 511427 511649 514711 517248 517384 518211 519665 519676 523307 524610 527549 527886 529105 529114 535346 535896 537282 538065 541051 541419 544862 546380 547649 548023 552941 555510 559236 560520 561191 562335 566075 568961 574170 577666 584420 586658 586695 586745 588971 591181 592446 598839 600736 603551 610931 621647 625144 633312 636554 637461 663769 679709 681370 687854 692859 714725 721967 722718 755030 775241 788252 799743 814699 814701 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum public pickups"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum на pickups улиц"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum на pickups улиц"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.