Query Metrics
7
Database Queries
7
Different statements
233.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.78 ms (86.48%) |
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 383719 395842 399641 419777 421326 427199 430683 432393 447679 454555 456148 456937 460175 460201 467283 467293 469321 472229 476079 480787 486424 487730 489108 489871 490728 490946 491938 494786 496103 499816 502305 502764 502778 512176 512957 515592 516034 519268 519413 521681 522013 524217 527014 533848 534309 537562 540579 541074 541188 541781 553303 553314 556421 562829 563552 567321 572767 576264 580280 580424 581260 581269 581972 585482 586469 586483 586645 587142 587519 589116 590712 591270 594836 594887 594906 599882 600225 600763 600864 601258 605093 606608 606611 607052 608758 612051 612413 615744 619466 619467 623610 631919 633150 646447 667889 679708 681084 682222 696308 699573 715786 731817 732832 774104 796492 798614 802117 802277 807378 814741 814760 814798 814921 815063 815108 815252 817097 819778 820173 826407 ] |
||||||||||||||||||||||||||||||
|
20.58 ms (8.82%) |
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 430683 454555 460201 472229 489871 502764 486424 519413 819778 774104 817097 537562 731817 383719 395842 814741 814798 815252 534309 460175 487730 553303 580424 581260 572767 541188 576264 681084 699573 696308 715786 562829 605093 607052 594836 594887 606608 619467 586483 590712 586469 594906 600225 619466 623610 798614 802117 802277 732832 612051 467283 421326 480787 456148 515592 502778 519268 447679 467293 476079 499816 679708 580280 512176 521681 399641 427199 820173 814760 815063 814921 815108 469321 456937 512957 502305 516034 533848 541074 556421 581269 541781 567321 581972 646447 682222 553314 563552 586645 591270 608758 631919 585482 589116 599882 633150 587142 600864 601258 606611 587519 600763 612413 615744 419777 432393 489108 494786 540579 490728 491938 524217 490946 496103 527014 826407 667889 807378 796492 522013 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.49%) |
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 383719 395842 399641 419777 421326 427199 430683 432393 447679 454555 456148 456937 460175 460201 467283 467293 469321 472229 476079 480787 486424 487730 489108 489871 490728 490946 491938 494786 496103 499816 502305 502764 502778 512176 512957 515592 516034 519268 519413 521681 522013 524217 527014 533848 534309 537562 540579 541074 541188 541781 553303 553314 556421 562829 563552 567321 572767 576264 580280 580424 581260 581269 581972 585482 586469 586483 586645 587142 587519 589116 590712 591270 594836 594887 594906 599882 600225 600763 600864 601258 605093 606608 606611 607052 608758 612051 612413 615744 619466 619467 623610 631919 633150 646447 667889 679708 681084 682222 696308 699573 715786 731817 732832 774104 796492 798614 802117 802277 807378 814741 814760 814798 814921 815063 815108 815252 817097 819778 820173 826407 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom office"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom секретарш"
]
|
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.