Query Metrics
7
Database Queries
7
Different statements
175.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.17 ms (84.36%) |
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 415863 425283 428300 457774 460097 461372 463778 475662 475669 483055 485400 488127 495122 497850 499720 507639 509485 511958 516569 517594 518156 518514 519808 520381 520754 522279 523192 523601 525150 527348 528031 528520 530184 533096 534652 537220 537425 538498 540012 540450 544941 546516 551151 551645 554470 557970 558448 558656 558752 559000 559056 560461 561534 561633 563115 563702 564926 566413 567713 568076 570838 571066 575283 576495 577792 579220 579448 579451 580656 580832 581583 583121 584169 584921 585035 585162 586050 586610 587996 588458 591127 591675 591742 591858 592542 592571 593035 593267 596374 596425 596523 597632 598278 599072 602189 602443 602686 604184 605138 606289 607391 607967 613152 614392 616793 617398 621158 622856 623180 628193 646049 655464 660847 666583 671525 672842 675148 683428 685750 789213 ] |
||||||||||||||||||||||||||||||
|
17.97 ms (10.23%) |
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 537220 516569 519808 527348 530184 511958 518514 520381 523601 528520 533096 534652 540012 540450 546516 551151 558752 561534 564926 568076 579451 583121 554470 558448 560461 561633 563702 571066 575283 577792 579220 579448 580656 584921 544941 557970 559056 563115 576495 580832 646049 655464 671525 675148 685750 660847 666583 672842 551645 570838 585162 596374 602189 616793 588458 591858 592571 596425 596523 599072 605138 613152 614392 617398 586050 591675 593035 593267 597632 602686 586610 587996 591127 591742 592542 604184 606289 607391 607967 621158 428300 425283 483055 488127 495122 523192 518156 581583 559000 622856 598278 789213 497850 558656 567713 584169 683428 623180 509485 566413 628193 517594 602443 415863 585035 460097 463778 457774 461372 475669 475662 485400 507639 520754 522279 525150 528031 537425 538498 499720 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.61%) |
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 415863 425283 428300 457774 460097 461372 463778 475662 475669 483055 485400 488127 495122 497850 499720 507639 509485 511958 516569 517594 518156 518514 519808 520381 520754 522279 523192 523601 525150 527348 528031 528520 530184 533096 534652 537220 537425 538498 540012 540450 544941 546516 551151 551645 554470 557970 558448 558656 558752 559000 559056 560461 561534 561633 563115 563702 564926 566413 567713 568076 570838 571066 575283 576495 577792 579220 579448 579451 580656 580832 581583 583121 584169 584921 585035 585162 586050 586610 587996 588458 591127 591675 591742 591858 592542 592571 593035 593267 596374 596425 596523 597632 598278 599072 602189 602443 602686 604184 605138 606289 607391 607967 613152 614392 616793 617398 621158 622856 623180 628193 646049 655464 660847 666583 671525 672842 675148 683428 685750 789213 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tanned wife"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"загорелые жен"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.78%) |
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.