Query Metrics
7
Database Queries
7
Different statements
216.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.30 ms (89.77%) |
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 137351 256898 382631 401225 436828 437265 451113 466835 477671 480083 487604 495531 495889 501513 502376 507757 509589 509949 510548 512092 513178 513809 526855 530208 530252 530993 531650 532187 533118 533663 534901 536132 536953 537411 537417 540940 542309 543299 544567 544954 552911 553443 554142 554741 559311 559347 561016 562097 562929 567617 567862 569321 569813 569952 571069 571472 571475 571514 572978 573989 577016 577093 578312 578573 579575 582887 582941 583346 584155 592142 596484 599258 601986 604563 604687 614078 615510 623898 623909 628569 635212 636483 640847 642951 646074 650297 650659 652711 661920 663155 665609 670557 671256 672774 676713 677534 683078 684693 686384 691935 692280 695080 700476 701652 723601 730979 736120 745789 748395 761916 764443 770365 777496 784168 786233 799774 802821 804808 807365 807409 ] |
||||||||||||||||||||||||||||||
|
12.32 ms (5.69%) |
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 646074 650297 691935 701652 614078 623898 807409 730979 745789 770365 748395 784168 509949 537417 530208 534901 559311 573989 583346 561016 542309 665609 671256 677534 567617 592142 786233 802821 799774 604687 582887 562097 495531 382631 466835 536953 507757 552911 562929 554741 577093 579575 804808 736120 604563 615510 777496 436828 137351 401225 437265 487604 451113 509589 533118 537411 512092 477671 571472 571069 582941 540940 543299 554142 577016 661920 684693 672774 676713 686384 692280 652711 663155 695080 544954 571514 596484 623909 640847 807365 761916 601986 700476 256898 536132 567862 683078 650659 670557 572978 578312 635212 636483 599258 628569 642951 764443 495889 723601 513178 513809 501513 502376 530993 531650 532187 533663 510548 526855 530252 480083 544567 553443 559347 578573 569952 571475 569321 569813 584155 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.04%) |
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 137351 256898 382631 401225 436828 437265 451113 466835 477671 480083 487604 495531 495889 501513 502376 507757 509589 509949 510548 512092 513178 513809 526855 530208 530252 530993 531650 532187 533118 533663 534901 536132 536953 537411 537417 540940 542309 543299 544567 544954 552911 553443 554142 554741 559311 559347 561016 562097 562929 567617 567862 569321 569813 569952 571069 571472 571475 571514 572978 573989 577016 577093 578312 578573 579575 582887 582941 583346 584155 592142 596484 599258 601986 604563 604687 614078 615510 623898 623909 628569 635212 636483 640847 642951 646074 650297 650659 652711 661920 663155 665609 670557 671256 672774 676713 677534 683078 684693 686384 691935 692280 695080 700476 701652 723601 730979 736120 745789 748395 761916 764443 770365 777496 784168 786233 799774 802821 804808 807365 807409 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"telephone sex"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"телефон секс"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"телефон секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.68%) |
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.