Query Metrics
7
Database Queries
7
Different statements
152.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.40 ms (80.32%) |
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 423979 424226 425185 426726 434574 437561 438972 443768 444955 447489 447532 447555 448554 449398 451578 454771 454842 455196 455322 455473 456940 462170 463661 463737 465812 470222 473324 475223 476480 476482 476960 477182 477342 477612 478022 478129 480487 482378 483184 483286 484833 485549 486082 487440 487605 488275 489385 489876 490786 491079 492477 495823 497242 497249 498172 498236 499021 500710 501051 502662 503016 504261 507363 508138 508530 509102 509540 509663 509764 510518 511364 511921 513408 513472 513994 514313 514408 514443 516297 516778 517066 517881 519058 519297 519740 519838 520101 520414 520785 520949 521622 521901 523713 523939 524826 525290 525984 525985 526331 527022 527876 527878 527913 528846 529135 540918 551440 556440 561891 564961 565843 567219 576419 587852 588726 597557 598201 704226 782556 810685 ] |
||||||||||||||||||||||||||||||
|
19.03 ms (12.48%) |
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 480487 448554 478022 508138 516778 520785 524826 525290 527022 487440 488275 504261 509540 516297 519838 483286 489876 492477 498236 501051 520414 521622 523939 498172 499021 520101 525984 561891 556440 565843 456940 455322 424226 444955 476482 482378 434574 454771 476960 477182 447555 455196 478129 511364 519740 523713 540918 484833 500710 509764 511921 513472 517066 519297 528846 507363 508530 509102 514313 525985 495823 497249 509663 513994 517881 447489 529135 527876 527913 588726 513408 551440 449398 426726 463737 473324 454842 490786 487605 514408 527878 520949 489385 782556 587852 810685 463661 438972 462170 425185 510518 514443 519058 704226 598201 476480 443768 455473 477612 483184 503016 491079 526331 564961 567219 576419 597557 451578 475223 437561 465812 470222 423979 447532 477342 502662 485549 486082 497242 521901 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.07%) |
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 423979 424226 425185 426726 434574 437561 438972 443768 444955 447489 447532 447555 448554 449398 451578 454771 454842 455196 455322 455473 456940 462170 463661 463737 465812 470222 473324 475223 476480 476482 476960 477182 477342 477612 478022 478129 480487 482378 483184 483286 484833 485549 486082 487440 487605 488275 489385 489876 490786 491079 492477 495823 497242 497249 498172 498236 499021 500710 501051 502662 503016 504261 507363 508138 508530 509102 509540 509663 509764 510518 511364 511921 513408 513472 513994 514313 514408 514443 516297 516778 517066 517881 519058 519297 519740 519838 520101 520414 520785 520949 521622 521901 523713 523939 524826 525290 525984 525985 526331 527022 527876 527878 527913 528846 529135 540918 551440 556440 561891 564961 565843 567219 576419 587852 588726 597557 598201 704226 782556 810685 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian beautiful"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск красивая"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск красивая"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
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.