Query Metrics
7
Database Queries
7
Different statements
151.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.83 ms (83.91%) |
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 12880 117596 150396 240689 389775 390625 393423 396475 397106 397838 398690 405808 412789 415345 420303 421404 465103 469546 473609 482216 482844 484398 484583 500504 509910 513474 517796 518835 519240 520130 529806 529809 530176 537625 538114 539392 546102 546188 549218 549786 552149 557311 559317 563937 575614 576780 579850 580462 582927 585828 590096 591232 591407 596284 602587 602784 605120 606970 607559 611496 612063 613670 614536 614932 615960 622288 624406 624550 626636 627928 631073 634691 635527 636358 641522 643282 644456 645175 646545 647759 652521 654222 654282 656624 659176 661064 664564 664681 665954 667990 670948 671696 673196 674272 678858 682379 692098 705127 705224 707939 709347 710278 710522 716807 718743 721254 737465 775601 778770 781053 787595 792657 792976 795249 800741 812424 813636 813751 813858 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (9.77%) |
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 737465 500504 519240 465103 469546 549786 624550 473609 509910 518835 484583 520130 484398 513474 117596 150396 240689 393423 12880 389775 390625 396475 397106 397838 398690 405808 420303 412789 415345 421404 813636 813751 813858 529809 530176 538114 517796 529806 539392 537625 482216 482844 552149 559317 563937 575614 579850 557311 576780 582927 645175 647759 654222 654282 656624 661064 665954 667990 671696 709347 710278 714087 718743 721254 646545 673196 682379 692098 705127 705224 710522 652521 659176 664564 664681 670948 674272 678858 707939 716807 546102 546188 549218 580462 590096 596284 612063 624406 631073 634691 591232 591407 602587 611496 614932 622288 635527 636358 644456 585828 607559 614536 626636 627928 602784 605120 606970 613670 615960 641522 643282 792657 792976 800741 812424 775601 778770 781053 787595 795249 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.68%) |
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 12880 117596 150396 240689 389775 390625 393423 396475 397106 397838 398690 405808 412789 415345 420303 421404 465103 469546 473609 482216 482844 484398 484583 500504 509910 513474 517796 518835 519240 520130 529806 529809 530176 537625 538114 539392 546102 546188 549218 549786 552149 557311 559317 563937 575614 576780 579850 580462 582927 585828 590096 591232 591407 596284 602587 602784 605120 606970 607559 611496 612063 613670 614536 614932 615960 622288 624406 624550 626636 627928 631073 634691 635527 636358 641522 643282 644456 645175 646545 647759 652521 654222 654282 656624 659176 661064 664564 664681 665954 667990 670948 671696 673196 674272 678858 682379 692098 705127 705224 707939 709347 710278 710522 716807 718743 721254 737465 775601 778770 781053 787595 792657 792976 795249 800741 812424 813636 813751 813858 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"подруги изменяют мужя…"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подружк жен жен"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подружк жен жен"
]
|
||||||||||||||||||||||||||||||
|
1.61 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.