Query Metrics
7
Database Queries
7
Different statements
165.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.29 ms (85.84%) |
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 17250 96623 117073 263296 314552 326305 382057 387678 387951 391677 392964 393108 393848 395861 396139 396212 398089 398364 398557 399418 401108 402159 403965 404209 408009 408586 409843 415790 421866 423505 423909 427252 428044 428582 440749 440932 441584 445285 447145 447543 448370 452971 453785 453833 456567 457146 457516 457942 458387 459233 460330 460763 465157 466679 466974 467606 468088 468341 468699 470052 471685 473450 476142 478411 479682 483559 491639 493658 493899 499884 504025 508177 508193 508966 509725 510679 511481 512458 512948 518762 521834 533733 534064 534609 541874 547420 547431 549126 550207 555220 555337 559685 561002 561861 562228 566770 566875 567226 569132 569225 571166 571430 580628 582479 591353 591992 592472 597584 599072 602602 606651 607254 610052 629458 653261 654388 674110 740607 745352 776099 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (8.78%) |
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 479682 460763 478411 457942 468341 465157 562228 592472 610052 314552 445285 452971 569132 393108 263296 17250 398089 398557 401108 403965 423909 428044 408009 427252 440932 448370 453785 460330 476142 473450 493658 453833 458387 466974 508966 508193 509725 512948 533733 499884 534609 508177 511481 521834 466679 549126 567226 555337 561002 561861 566875 582479 547431 566770 571430 654388 674110 653261 571166 597584 591353 591992 599072 607254 740607 117073 326305 387951 392964 421866 423505 457146 391677 393848 395861 402159 409843 447543 471685 456567 491639 534064 550207 541874 483559 606651 602602 382057 396212 398364 399418 440749 447145 467606 470052 518762 504025 468088 547420 559685 580628 569225 555220 629458 387678 396139 408586 441584 459233 428582 468699 404209 415790 457516 510679 512458 493899 776099 745352 96623 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.59%) |
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 17250 96623 117073 263296 314552 326305 382057 387678 387951 391677 392964 393108 393848 395861 396139 396212 398089 398364 398557 399418 401108 402159 403965 404209 408009 408586 409843 415790 421866 423505 423909 427252 428044 428582 440749 440932 441584 445285 447145 447543 448370 452971 453785 453833 456567 457146 457516 457942 458387 459233 460330 460763 465157 466679 466974 467606 468088 468341 468699 470052 471685 473450 476142 478411 479682 483559 491639 493658 493899 499884 504025 508177 508193 508966 509725 510679 511481 512458 512948 518762 521834 533733 534064 534609 541874 547420 547431 549126 550207 555220 555337 559685 561002 561861 562228 566770 566875 567226 569132 569225 571166 571430 580628 582479 591353 591992 592472 597584 599072 602602 606651 607254 610052 629458 653261 654388 674110 740607 745352 776099 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð░ð¢ð░ð╗Ðîð¢Ðïð╣ ÐüðÁð║Ðü ð▓ð¥ð╗ð¥Ðüð░ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал волос"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.87%) |
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.