Query Metrics
7
Database Queries
7
Different statements
144.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.22 ms (83.32%) |
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 185494 310671 345851 382613 385475 395242 395781 401219 403129 403343 403663 417754 418464 418858 420417 420865 422149 423211 427046 427857 429211 429301 430562 432190 432196 432435 433048 433304 433618 433768 433787 433855 433885 434230 435929 438428 438683 439580 440802 440890 441192 442011 442444 444132 444420 445448 448885 448900 451615 452728 455185 456315 456869 457631 459799 459894 460009 460196 460406 461250 461253 461555 461962 462020 464652 466424 469046 472398 472416 474854 476434 476694 477754 478296 478394 478830 480046 480096 480966 484911 487309 493301 498631 499893 504816 505959 510703 512604 518794 525595 543963 546721 547674 551188 552731 553598 558076 562702 563743 563985 566607 566945 573274 577988 582641 584534 584535 588706 589159 591937 592870 595398 598495 602571 605050 623157 659934 722375 776141 801487 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (9.91%) |
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 417754 461253 403343 418464 433787 448900 461250 461555 478394 310671 382613 444132 444420 457631 422149 525595 499893 512604 484911 510703 487309 395242 395781 403663 420865 423211 438428 439580 442011 442444 420417 441192 440890 433304 435929 459894 480966 493301 451615 472398 472416 459799 460196 474854 476694 478830 498631 505959 504816 518794 469046 478296 546721 584534 584535 563743 563985 566607 582641 543963 552731 553598 558076 562702 566945 577988 722375 659934 547674 551188 573274 589159 591937 592870 605050 588706 595398 602571 598495 623157 776141 801487 345851 427046 432190 433048 433768 438683 456869 464652 466424 476434 401219 403129 440802 477754 185494 385475 418858 432196 432435 445448 452728 460009 462020 480046 480096 427857 429211 429301 430562 433618 433855 433885 434230 448885 455185 456315 460406 461962 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.65%) |
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 185494 310671 345851 382613 385475 395242 395781 401219 403129 403343 403663 417754 418464 418858 420417 420865 422149 423211 427046 427857 429211 429301 430562 432190 432196 432435 433048 433304 433618 433768 433787 433855 433885 434230 435929 438428 438683 439580 440802 440890 441192 442011 442444 444132 444420 445448 448885 448900 451615 452728 455185 456315 456869 457631 459799 459894 460009 460196 460406 461250 461253 461555 461962 462020 464652 466424 469046 472398 472416 474854 476434 476694 477754 478296 478394 478830 480046 480096 480966 484911 487309 493301 498631 499893 504816 505959 510703 512604 518794 525595 543963 546721 547674 551188 552731 553598 558076 562702 563743 563985 566607 566945 573274 577988 582641 584534 584535 588706 589159 591937 592870 595398 598495 602571 605050 623157 659934 722375 776141 801487 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra 1990"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
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.