Query Metrics
7
Database Queries
7
Different statements
239.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.51 ms (88.57%) |
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 172191 383333 398135 398414 399061 406799 452303 457392 459838 477579 477581 478985 478990 478992 482180 482182 484795 488565 494700 494717 494748 512797 522395 522397 526411 529698 530472 542802 542818 542830 542831 542832 543012 543013 543029 543059 543073 543079 543080 543089 543100 543113 543114 543189 543204 543208 543275 543444 543474 543484 543491 543506 543521 543790 552045 552607 556934 562348 562354 565972 566573 566575 567580 567604 567606 574983 574986 576615 577077 578130 583743 584352 585103 586463 586473 586495 586515 587954 588561 590727 591798 603302 604419 605579 613724 615331 617111 619816 621246 622932 626382 630570 637802 641094 642456 644679 644910 645650 650346 660436 660834 660837 667974 670853 671331 671334 671344 671354 729121 736752 742515 744774 751354 793578 797109 798033 809338 813826 813858 827861 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (6.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 543275 576615 562354 744774 478992 543444 793578 567580 577077 671344 650346 586473 637802 591798 751354 406799 543113 660834 494700 522397 543089 543506 543491 813826 459838 671334 645650 613724 583743 512797 543012 605579 478990 494748 542832 543080 670853 552045 556934 644679 621246 587954 604419 585103 457392 542831 542830 543474 567606 542818 543521 566573 671354 478985 488565 530472 543100 383333 484795 615331 729121 736752 586515 529698 641094 552607 562348 543059 543079 543208 588561 642456 543484 574983 542802 543204 603302 586463 617111 398414 399061 827861 482182 543029 798033 622932 565972 522395 477581 566575 567604 586495 809338 452303 494717 477579 644910 543790 543114 584352 671331 543073 660837 630570 742515 626382 813858 797109 543013 482180 667974 543189 574986 578130 619816 590727 172191 526411 660436 398135 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.47%) |
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 172191 383333 398135 398414 399061 406799 452303 457392 459838 477579 477581 478985 478990 478992 482180 482182 484795 488565 494700 494717 494748 512797 522395 522397 526411 529698 530472 542802 542818 542830 542831 542832 543012 543013 543029 543059 543073 543079 543080 543089 543100 543113 543114 543189 543204 543208 543275 543444 543474 543484 543491 543506 543521 543790 552045 552607 556934 562348 562354 565972 566573 566575 567580 567604 567606 574983 574986 576615 577077 578130 583743 584352 585103 586463 586473 586495 586515 587954 588561 590727 591798 603302 604419 605579 613724 615331 617111 619816 621246 622932 626382 630570 637802 641094 642456 644679 644910 645650 650346 660436 660834 660837 667974 670853 671331 671334 671344 671354 729121 736752 742515 744774 751354 793578 797109 798033 809338 813826 813858 827861 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab big as"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"араб большие"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.67%) |
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.