Query Metrics
7
Database Queries
7
Different statements
152.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.66 ms (81.19%) |
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 388769 402735 414201 427869 432518 440788 440862 447848 458516 459311 460489 462630 463415 469173 470871 476487 479369 483259 490217 494600 494633 507024 508282 509634 514210 516542 518802 521109 524576 524779 526561 527012 531949 539593 543882 545673 549859 552334 552819 554002 557749 557994 560282 566220 569320 574767 576746 580275 583313 584980 587012 587214 591930 592968 593987 599180 601950 602457 604363 605055 605062 605115 605129 605172 605179 605204 605207 605235 605247 605263 605272 605274 615971 618104 618291 634254 639648 644224 657743 658793 659351 669062 670360 675124 675125 675141 675438 675721 679220 685404 701184 713727 718059 724809 725825 726177 734322 744930 749332 755022 756978 757974 760687 769303 790459 790485 790499 790710 792135 793992 798559 801184 803594 806385 807262 807345 808293 809354 810392 810787 ] |
||||||||||||||||||||||||||||||
|
18.92 ms (12.42%) |
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 554002 557749 557994 560282 569320 574767 658793 669062 675721 679220 685404 713727 718059 657743 670360 675124 675125 701184 659351 675141 675438 552334 566220 576746 580275 583313 593987 602457 604363 605172 605207 591930 599180 605129 605263 605272 634254 592968 605055 605179 605204 618104 587012 587214 605235 605247 605274 615971 618291 639648 644224 790459 801184 807345 792135 803594 809354 756978 757974 790499 807262 808293 810787 744930 749332 755022 760687 725825 734322 769303 724809 726177 601950 605062 605115 790485 790710 793992 798559 806385 810392 402735 432518 469173 476487 447848 479369 460489 388769 427869 459311 470871 509634 516542 514210 483259 508282 521109 524576 526561 494600 494633 524779 527012 440788 414201 440862 584980 458516 462630 463415 490217 507024 518802 531949 539593 545673 549859 552819 543882 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.80%) |
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 388769 402735 414201 427869 432518 440788 440862 447848 458516 459311 460489 462630 463415 469173 470871 476487 479369 483259 490217 494600 494633 507024 508282 509634 514210 516542 518802 521109 524576 524779 526561 527012 531949 539593 543882 545673 549859 552334 552819 554002 557749 557994 560282 566220 569320 574767 576746 580275 583313 584980 587012 587214 591930 592968 593987 599180 601950 602457 604363 605055 605062 605115 605129 605172 605179 605204 605207 605235 605247 605263 605272 605274 615971 618104 618291 634254 639648 644224 657743 658793 659351 669062 670360 675124 675125 675141 675438 675721 679220 685404 701184 713727 718059 724809 725825 726177 734322 744930 749332 755022 756978 757974 760687 769303 790459 790485 790499 790710 792135 793992 798559 801184 803594 806385 807262 807345 808293 809354 810392 810787 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in dress"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dress"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dress"
]
|
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.