Query Metrics
7
Database Queries
7
Different statements
174.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.60 ms (88.40%) |
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 382432 392665 401757 402060 417730 417947 421389 423243 425395 425852 427487 436626 438978 440711 442650 443038 446049 446081 446456 447090 447908 449274 457792 458269 461306 462939 470480 472055 473966 474809 475873 476475 480844 484844 487086 491371 491374 491631 492318 492337 497140 504461 504741 504748 507456 507814 509952 512147 514608 514609 518105 521332 523302 527195 528952 532940 541096 544110 544963 545457 548723 550284 550555 551994 552373 554751 558618 562244 562430 562484 562626 564408 564409 564583 564670 566296 568304 569443 570832 571769 575997 577401 577543 580176 580294 581384 584384 597610 600227 601880 603578 603897 610121 612070 612268 615250 617617 620115 622653 630736 635686 652126 657177 658208 658223 658226 672766 702165 721241 721249 721867 730644 736470 737628 750809 758208 797750 811627 817445 819613 ] |
||||||||||||||||||||||||||||||
|
10.95 ms (6.26%) |
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 758208 402060 382432 417947 425852 476475 491374 512147 423243 443038 442650 819613 480844 446049 447908 461306 449274 514608 541096 544963 551994 558618 564583 569443 577401 580176 580294 544110 545457 550555 554751 562244 562484 575997 577543 581384 552373 562430 564408 564670 566296 568304 658208 721249 672766 652126 657177 658223 658226 721241 721867 548723 550284 564409 570832 571769 584384 601880 610121 615250 630736 600227 603578 612268 597610 617617 620115 635686 797750 737628 811627 730644 750809 736470 603897 612070 622653 702165 392665 401757 458269 473966 436626 440711 425395 447090 462939 427487 438978 421389 446081 487086 497140 491371 504741 504748 514609 523302 484844 491631 492337 504461 518105 521332 562626 527195 417730 817445 446456 457792 474809 475873 470480 472055 492318 507456 507814 532940 509952 528952 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.85%) |
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 382432 392665 401757 402060 417730 417947 421389 423243 425395 425852 427487 436626 438978 440711 442650 443038 446049 446081 446456 447090 447908 449274 457792 458269 461306 462939 470480 472055 473966 474809 475873 476475 480844 484844 487086 491371 491374 491631 492318 492337 497140 504461 504741 504748 507456 507814 509952 512147 514608 514609 518105 521332 523302 527195 528952 532940 541096 544110 544963 545457 548723 550284 550555 551994 552373 554751 558618 562244 562430 562484 562626 564408 564409 564583 564670 566296 568304 569443 570832 571769 575997 577401 577543 580176 580294 581384 584384 597610 600227 601880 603578 603897 610121 612070 612268 615250 617617 620115 622653 630736 635686 652126 657177 658208 658223 658226 672766 702165 721241 721249 721867 730644 736470 737628 750809 758208 797750 811627 817445 819613 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real худые"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real skinny"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real худые"
]
|
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.