Query Metrics
7
Database Queries
7
Different statements
212.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.77 ms (87.33%) |
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 98871 146508 191715 203645 236765 327659 358757 384455 385427 386172 387230 395134 397999 399923 400735 403381 422996 424740 431046 449342 454195 467032 474794 477908 480780 482609 492272 493876 496108 505818 508669 511417 515904 523950 529035 531325 536377 540791 542764 545538 546969 552250 554321 556405 557514 558037 563160 563421 564188 565998 569519 569954 575077 577366 577388 577409 578007 579359 582804 588389 605581 607096 609962 621350 621467 628175 633165 651887 663916 663921 664817 665101 665188 665214 665215 665224 665233 665273 665416 665444 665940 667212 667546 667833 669786 673990 676432 687430 690682 711671 713990 715455 716299 716324 721280 732361 734146 741191 750189 756877 757891 762248 763283 785879 788007 789740 790752 804991 806356 808449 810285 814848 815263 815318 816376 817050 818815 824427 824466 825092 ] |
||||||||||||||||||||||||||||||
|
17.20 ms (8.08%) |
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 492272 505818 508669 385427 395134 327659 98871 824466 815263 817050 482609 511417 515904 531325 569954 563160 565998 578007 665940 667546 669786 664817 665101 665214 667833 663916 663921 667212 715455 546969 605581 588389 607096 609962 621467 785879 788007 804991 810285 732361 734146 756877 789740 790752 808449 763283 741191 750189 621350 711671 716299 716324 721280 806356 203645 146508 477908 556405 431046 422996 540791 523950 529035 545538 577366 577409 579359 582804 628175 633165 757891 762248 386172 384455 236765 191715 358757 387230 397999 399923 400735 403381 424740 815318 814848 816376 818815 824427 825092 474794 449342 480780 454195 536377 496108 467032 493876 542764 575077 554321 563421 552250 557514 558037 569519 577388 665188 665233 665273 665416 673990 651887 665215 665224 713990 665444 676432 687430 690682 564188 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.33%) |
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 98871 146508 191715 203645 236765 327659 358757 384455 385427 386172 387230 395134 397999 399923 400735 403381 422996 424740 431046 449342 454195 467032 474794 477908 480780 482609 492272 493876 496108 505818 508669 511417 515904 523950 529035 531325 536377 540791 542764 545538 546969 552250 554321 556405 557514 558037 563160 563421 564188 565998 569519 569954 575077 577366 577388 577409 578007 579359 582804 588389 605581 607096 609962 621350 621467 628175 633165 651887 663916 663921 664817 665101 665188 665214 665215 665224 665233 665273 665416 665444 665940 667212 667546 667833 669786 673990 676432 687430 690682 711671 713990 715455 716299 716324 721280 732361 734146 741191 750189 756877 757891 762248 763283 785879 788007 789740 790752 804991 806356 808449 810285 814848 815263 815318 816376 817050 818815 824427 824466 825092 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom young"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван young"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван young"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.