Query Metrics
7
Database Queries
7
Different statements
312.05 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 204.12 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.89 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chinese hair"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.14 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 780715 781488 419906 586639 595252 518949 521048 421298 458094 422543 461899 536652 583491 771236 423196 418648 425823 420658 458384 458623 475443 802111 32994 504963 534815 557211 422958 418323 813787 813803 568034 528316 427299 429628 429386 482824 779560 801890 557207 527484 676241 778383 803268 510266 815137 682936 574033 634215 422746 425786 437828 546085 695725 547768 606493 785525 589769 590859 531083 815096 534023 581185 754135 752596 757362 541854 614603 457981 447273 497656 609121 598133 538653 665781 544964 615447 754168 756113 508926 562149 583289 567357 558201 541863 623261 ] |
||||||||||||||||||||||||||||||
| 4 | 2.64 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 32994 418323 418648 419906 420658 421298 422543 422746 422958 423196 425786 425823 427299 429386 429628 437828 447273 457981 458094 458384 458623 461899 475443 482824 497656 504963 508926 510266 518949 521048 527484 528316 531083 534023 534815 536652 538653 541854 541863 544964 546085 547768 557207 557211 558201 562149 567357 568034 574033 581185 583289 583491 586639 589769 590859 595252 598133 606493 609121 614603 615447 623261 634215 665781 676241 682936 695725 752596 754135 754168 756113 757362 771236 778383 779560 780715 781488 785525 801890 802111 803268 813787 813803 815096 815137 ] |
||||||||||||||||||||||||||||||
| 5 | 87.36 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 32994 418323 418648 419906 420658 421298 422543 422746 422958 423196 425786 425823 427299 429386 429628 437828 447273 457981 458094 458384 458623 461899 475443 482824 497656 504963 508926 510266 518949 521048 527484 528316 531083 534023 534815 536652 538653 541854 541863 544964 546085 547768 557207 557211 558201 562149 567357 568034 574033 581185 583289 583491 586639 589769 590859 595252 598133 606493 609121 614603 615447 623261 634215 665781 676241 682936 695725 752596 754135 754168 756113 757362 771236 778383 779560 780715 781488 785525 801890 802111 803268 813787 813803 815096 815137 ] |
||||||||||||||||||||||||||||||
| 6 | 1.46 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"китаянк азиатк hair"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"китаянк азиатк hair"
]
|
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.