Query Metrics
7
Database Queries
7
Different statements
160.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.42 ms (83.18%) |
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 420880 424314 428319 435244 437310 437344 442611 443599 444044 450587 450723 452928 455039 457335 461144 462008 462995 463057 463663 466941 471652 472620 475556 479954 481726 487525 489648 492529 493169 495121 495434 496527 502587 503739 504333 504825 506131 509387 510297 511016 512012 512478 513351 514677 515580 516550 518328 519200 519768 520427 520943 522498 522776 524751 525049 525547 525868 526325 527054 527213 541241 545645 547824 548422 552348 554881 555736 559103 559568 559934 561488 561898 562505 562866 565779 566086 567563 569408 571843 571976 574301 579965 581552 585771 588090 589723 592981 593792 595099 595723 596987 600449 601180 603684 603852 605378 605442 607377 609807 612490 612507 613555 613977 615680 619201 621494 623229 625594 634725 641910 650056 661382 666714 670821 675926 684868 723892 724481 751572 779012 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (10.58%) |
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 592981 625594 723892 442611 462008 463057 444044 472620 481726 520943 525868 513351 525547 516550 420880 437310 435244 487525 466941 509387 511016 495121 510297 492529 567563 555736 561898 569408 545645 548422 562505 670821 684868 554881 593792 612490 589723 609807 724481 751572 779012 452928 462995 471652 455039 479954 450587 504333 525049 502587 506131 512012 495434 519768 661382 595099 522776 585771 603684 603852 600449 621494 615680 641910 612507 634725 443599 559568 437344 461144 519200 581552 650056 571976 601180 457335 526325 489648 475556 428319 607377 493169 518328 503739 504825 512478 514677 496527 541241 559103 561488 566086 571843 562866 574301 675926 613555 619201 605378 605442 588090 595723 596987 613977 623229 463663 520427 515580 522498 524751 424314 450723 527213 527054 552348 565779 579965 547824 666714 559934 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.75%) |
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 420880 424314 428319 435244 437310 437344 442611 443599 444044 450587 450723 452928 455039 457335 461144 462008 462995 463057 463663 466941 471652 472620 475556 479954 481726 487525 489648 492529 493169 495121 495434 496527 502587 503739 504333 504825 506131 509387 510297 511016 512012 512478 513351 514677 515580 516550 518328 519200 519768 520427 520943 522498 522776 524751 525049 525547 525868 526325 527054 527213 541241 545645 547824 548422 552348 554881 555736 559103 559568 559934 561488 561898 562505 562866 565779 566086 567563 569408 571843 571976 574301 579965 581552 585771 588090 589723 592981 593792 595099 595723 596987 600449 601180 603684 603852 605378 605442 607377 609807 612490 612507 613555 613977 615680 619201 621494 623229 625594 634725 641910 650056 661382 666714 670821 675926 684868 723892 724481 751572 779012 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск hotel"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск hotel"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hotel"
]
|
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.