Query Metrics
7
Database Queries
7
Different statements
164.24 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.68 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.07 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage vintage"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.31 ms |
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 573321 581279 542487 544257 544290 544312 544321 544482 550036 563958 565661 566685 567615 574238 574282 581374 582769 542461 543685 544258 544270 544351 544355 547840 548285 568032 573187 577231 652173 653577 668590 671249 685255 692208 692813 693859 694112 694130 694478 695219 695242 695950 698516 699383 699698 718272 651603 651681 652536 652958 661902 671237 677738 681791 685318 686721 691136 691509 692123 692222 692485 693298 694110 694124 695204 695270 695614 695921 697301 701297 701489 703542 710878 711894 711906 716786 722142 648209 649933 651205 651902 652589 652991 670067 670731 672717 672852 674131 685262 687192 690823 690850 690931 691521 692214 692331 693040 693060 693985 698396 722452 556986 565345 566672 568172 568269 572424 576122 581329 584232 587973 592539 597218 609208 621715 622370 624754 624958 628291 628300 ] |
||||||||||||||||||||||||||||||
| 4 | 2.72 ms |
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 542461 542487 543685 544257 544258 544270 544290 544312 544321 544351 544355 544482 547840 548285 550036 556986 563958 565345 565661 566672 566685 567615 568032 568172 568269 572424 573187 573321 574238 574282 576122 577231 581279 581329 581374 582769 584232 587973 592539 597218 609208 621715 622370 624754 624958 628291 628300 648209 649933 651205 651603 651681 651902 652173 652536 652589 652958 652991 653577 661902 668590 670067 670731 671237 671249 672717 672852 674131 677738 681791 685255 685262 685318 686721 687192 690823 690850 690931 691136 691509 691521 692123 692208 692214 692222 692331 692485 692813 693040 693060 693298 693859 693985 694110 694112 694124 694130 694478 695204 695219 695242 695270 695614 695921 695950 697301 698396 698516 699383 699698 701297 701489 703542 710878 711894 711906 716786 718272 722142 722452 ] |
||||||||||||||||||||||||||||||
| 5 | 137.95 ms |
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 542461 542487 543685 544257 544258 544270 544290 544312 544321 544351 544355 544482 547840 548285 550036 556986 563958 565345 565661 566672 566685 567615 568032 568172 568269 572424 573187 573321 574238 574282 576122 577231 581279 581329 581374 582769 584232 587973 592539 597218 609208 621715 622370 624754 624958 628291 628300 648209 649933 651205 651603 651681 651902 652173 652536 652589 652958 652991 653577 661902 668590 670067 670731 671237 671249 672717 672852 674131 677738 681791 685255 685262 685318 686721 687192 690823 690850 690931 691136 691509 691521 692123 692208 692214 692222 692331 692485 692813 693040 693060 693298 693859 693985 694110 694112 694124 694130 694478 695204 695219 695242 695270 695614 695921 695950 697301 698396 698516 699383 699698 701297 701489 703542 710878 711894 711906 716786 718272 722142 722452 ] |
||||||||||||||||||||||||||||||
| 6 | 1.87 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage vintage"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage vintage"
]
|
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.