Query Metrics
7
Database Queries
7
Different statements
153.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.00 ms (82.78%) |
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 78824 81656 152157 161552 209171 384282 386082 390290 392822 393458 395136 395380 395449 395699 395704 396178 400470 400703 400860 401956 402137 402393 402877 404116 409227 409701 411511 411544 415710 417997 419078 426525 426868 427147 427171 427281 427701 428296 428672 429050 431488 432392 432564 437361 438528 440977 441210 441300 442015 442526 442795 444247 446104 446299 454497 456121 456323 456985 458747 459301 459917 460458 465031 465098 466346 467808 468801 470110 473905 477186 480087 482443 485406 486327 490205 491414 493878 495626 499092 503909 506440 508803 509210 509860 511151 513549 515574 522347 522819 524715 528616 529480 541420 543827 545904 551470 553014 563019 567683 567830 568809 573633 573666 574308 575594 576084 577484 579332 606897 628772 736054 749576 752655 765172 768008 769004 781683 787532 791319 799365 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (10.95%) |
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 573666 574308 579332 543827 545904 553014 567683 567830 568809 573633 576084 551470 563019 575594 577484 628772 799365 787532 781683 791319 765172 749576 736054 752655 768008 769004 606897 395380 409701 427171 427281 432392 459301 400860 393458 396178 402877 415710 465098 467808 468801 470110 477186 480087 411511 432564 446104 456985 459917 465031 466346 473905 390290 444247 458747 427147 456323 460458 509210 509860 513549 541420 486327 491414 508803 524715 529480 485406 490205 499092 506440 511151 515574 522819 528616 493878 495626 503909 522347 386082 78824 81656 384282 209171 161552 152157 395136 395449 395699 392822 395704 400703 400470 401956 402137 402393 404116 411544 419078 426525 426868 427701 431488 438528 440977 441210 441300 428672 429050 442526 409227 428296 437361 442015 417997 442795 482443 446299 454497 456121 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.64%) |
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 78824 81656 152157 161552 209171 384282 386082 390290 392822 393458 395136 395380 395449 395699 395704 396178 400470 400703 400860 401956 402137 402393 402877 404116 409227 409701 411511 411544 415710 417997 419078 426525 426868 427147 427171 427281 427701 428296 428672 429050 431488 432392 432564 437361 438528 440977 441210 441300 442015 442526 442795 444247 446104 446299 454497 456121 456323 456985 458747 459301 459917 460458 465031 465098 466346 467808 468801 470110 473905 477186 480087 482443 485406 486327 490205 491414 493878 495626 499092 503909 506440 508803 509210 509860 511151 513549 515574 522347 522819 524715 528616 529480 541420 543827 545904 551470 553014 563019 567683 567830 568809 573633 573666 574308 575594 576084 577484 579332 606897 628772 736054 749576 752655 765172 768008 769004 781683 787532 791319 799365 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"и ряд"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.03%) |
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.