Query Metrics
7
Database Queries
7
Different statements
160.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.44 ms (86.10%) |
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 405525 407444 407721 411845 412396 415566 419710 419950 420515 424927 435211 442414 443649 456448 456616 457310 457825 457975 459357 460079 460893 464388 464424 467564 468480 468540 469483 469586 472266 472543 473660 475752 478473 478665 481766 482610 491401 491429 495686 497469 497531 504825 505827 509503 510461 514097 514106 515669 518745 519877 521316 521810 522134 525624 525634 526556 531065 533978 534561 534680 535014 537481 538703 541808 543518 548848 550633 551817 554912 559575 561391 561452 562898 564741 566140 569919 570737 571042 571358 572189 575441 579123 579648 581876 585637 586553 586910 590954 591875 592862 594933 597839 598422 600586 601347 602194 604431 604436 605639 606467 606482 606929 609165 610039 610766 611950 614097 616097 617137 618293 620150 625443 626849 637460 640837 642702 664444 673577 681104 690902 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (8.54%) |
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 457310 472543 456616 464388 538703 515669 519877 468480 475752 566140 571358 579123 579648 562898 569919 581876 600586 594933 602194 642702 419710 459357 509503 526556 525624 521810 591875 592862 534680 495686 505827 605639 420515 481766 442414 457825 457975 468540 473660 521316 537481 571042 664444 618293 610039 597839 611950 472266 478665 586553 497469 514106 535014 550633 548848 572189 620150 616097 625443 510461 637460 606482 405525 407721 424927 570737 690902 681104 610766 626849 443649 617137 531065 407444 419950 460893 467564 673577 590954 614097 585637 604431 412396 456448 561452 469586 575441 606467 601347 533978 609165 478473 497531 435211 469483 491401 514097 554912 559575 598422 640837 604436 534561 491429 522134 541808 606929 464424 586910 543518 415566 411845 482610 460079 525634 504825 518745 564741 551817 561391 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.51%) |
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 405525 407444 407721 411845 412396 415566 419710 419950 420515 424927 435211 442414 443649 456448 456616 457310 457825 457975 459357 460079 460893 464388 464424 467564 468480 468540 469483 469586 472266 472543 473660 475752 478473 478665 481766 482610 491401 491429 495686 497469 497531 504825 505827 509503 510461 514097 514106 515669 518745 519877 521316 521810 522134 525624 525634 526556 531065 533978 534561 534680 535014 537481 538703 541808 543518 548848 550633 551817 554912 559575 561391 561452 562898 564741 566140 569919 570737 571042 571358 572189 575441 579123 579648 581876 585637 586553 586910 590954 591875 592862 594933 597839 598422 600586 601347 602194 604431 604436 605639 606467 606482 606929 609165 610039 610766 611950 614097 616097 617137 618293 620150 625443 626849 637460 640837 642702 664444 673577 681104 690902 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ðÁð▒ÐâÐé Ðü Ðüð©ð╗ð©ð║ð¥ð¢ð¥ð▓ð¥ð╣ ð¢ð░ÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс силиконов на"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.82%) |
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.