Query Metrics
7
Database Queries
7
Different statements
145.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.72 ms (80.14%) |
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 7092 339821 385448 392775 395698 396313 396400 400703 400923 413623 417836 423968 427221 428335 429584 429930 433721 435864 437233 437529 442353 443902 457720 462304 463115 464658 470683 470833 486613 487328 488493 491193 492754 494587 495158 495732 496202 499338 506781 508706 509586 519069 519969 520513 520658 522088 524702 526137 526393 528505 529491 529514 530705 531270 533274 534465 534653 534877 539186 540869 541125 541203 543897 545456 546659 550227 551625 552443 552486 552727 553779 553896 554817 559105 559661 562314 563273 564287 566242 567875 568932 569648 575575 583000 585574 586376 586707 587309 587342 588666 589392 589996 592136 592416 592712 594018 594448 594971 597223 601463 606179 607180 608945 613837 618188 620371 620549 624890 625816 626217 628901 634656 641560 646581 647105 650063 655466 656522 710034 802777 ] |
||||||||||||||||||||||||||||||
|
19.95 ms (13.70%) |
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 597223 339821 442353 562314 587309 417836 462304 494587 522088 464658 575575 546659 551625 646581 710034 553896 566242 625816 592136 594448 589392 620549 641560 396400 423968 495732 519969 7092 429930 433721 463115 529514 531270 520658 533274 534465 543897 552486 568932 541203 552727 559105 655466 552443 586376 608945 588666 620371 585574 589996 594018 601463 626217 586707 606179 618188 802777 437233 443902 492754 396313 427221 486613 392775 491193 400923 429584 428335 540869 487328 470683 488493 529491 530705 534653 534877 528505 539186 519069 520513 526137 499338 509586 564287 567875 569648 541125 553779 563273 545456 583000 647105 656522 559661 592712 607180 613837 634656 587342 594971 624890 628901 592416 413623 435864 457720 470833 496202 506781 524702 526393 508706 495158 550227 554817 650063 437529 395698 400703 385448 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.64%) |
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 7092 339821 385448 392775 395698 396313 396400 400703 400923 413623 417836 423968 427221 428335 429584 429930 433721 435864 437233 437529 442353 443902 457720 462304 463115 464658 470683 470833 486613 487328 488493 491193 492754 494587 495158 495732 496202 499338 506781 508706 509586 519069 519969 520513 520658 522088 524702 526137 526393 528505 529491 529514 530705 531270 533274 534465 534653 534877 539186 540869 541125 541203 543897 545456 546659 550227 551625 552443 552486 552727 553779 553896 554817 559105 559661 562314 563273 564287 566242 567875 568932 569648 575575 583000 585574 586376 586707 587309 587342 588666 589392 589996 592136 592416 592712 594018 594448 594971 597223 601463 606179 607180 608945 613837 618188 620371 620549 624890 625816 626217 628901 634656 641560 646581 647105 650063 655466 656522 710034 802777 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мужик себя трах"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин секс"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.91%) |
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.