Query Metrics
7
Database Queries
7
Different statements
168.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.59 ms (86.40%) |
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 26468 29280 30310 131462 383547 389661 391301 396139 396881 398247 401334 402252 404120 407279 414201 418741 419464 420549 421914 424186 425857 427912 432696 439049 442518 443968 444326 446346 446777 446900 446986 461428 462763 464913 464927 472614 472940 478656 483466 488080 488902 489230 495602 496293 496829 497270 499027 499047 500271 502299 508825 509860 511259 511357 511794 514111 514931 515672 517676 519446 519479 521094 521402 522989 523362 523513 532334 534402 534463 535309 535539 537391 540475 542099 545221 549090 549787 551723 552844 566369 567057 569193 571948 573428 574630 579011 580928 583513 585175 588224 589793 590041 591565 592371 592840 596996 601643 603997 605211 609747 618619 619541 620701 625326 633569 636323 643624 647951 652577 656470 663695 677147 685613 687466 691209 710912 712667 750843 750860 812638 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (7.74%) |
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 489230 515672 535539 30310 750860 396881 414201 418741 432696 427912 444326 542099 532334 535309 508825 511259 534463 500271 517676 519479 522989 537391 499027 511794 540475 464913 549090 573428 583513 545221 569193 647951 652577 677147 685613 691209 549787 574630 579011 603997 589793 618619 620701 636323 591565 592840 601643 421914 424186 442518 420549 446986 26468 131462 566369 663695 619541 750843 633569 710912 712667 812638 29280 389661 383547 398247 402252 407279 425857 419464 478656 472614 464927 521094 523362 534402 495602 488080 488902 571948 580928 552844 687466 656470 551723 567057 585175 605211 625326 643624 590041 596996 609747 592371 588224 391301 396139 404120 446777 446346 461428 462763 401334 439049 443968 472940 502299 509860 499047 511357 521402 523513 496293 483466 514111 519446 446900 496829 514931 497270 ] |
||||||||||||||||||||||||||||||
|
2.83 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 26468 29280 30310 131462 383547 389661 391301 396139 396881 398247 401334 402252 404120 407279 414201 418741 419464 420549 421914 424186 425857 427912 432696 439049 442518 443968 444326 446346 446777 446900 446986 461428 462763 464913 464927 472614 472940 478656 483466 488080 488902 489230 495602 496293 496829 497270 499027 499047 500271 502299 508825 509860 511259 511357 511794 514111 514931 515672 517676 519446 519479 521094 521402 522989 523362 523513 532334 534402 534463 535309 535539 537391 540475 542099 545221 549090 549787 551723 552844 566369 567057 569193 571948 573428 574630 579011 580928 583513 585175 588224 589793 590041 591565 592371 592840 596996 601643 603997 605211 609747 618619 619541 620701 625326 633569 636323 643624 647951 652577 656470 663695 677147 685613 687466 691209 710912 712667 750843 750860 812638 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волос рак"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"волосы раком"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.