Query Metrics
7
Database Queries
7
Different statements
198.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.56 ms (84.25%) |
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 318892 385141 400992 415563 419545 420155 422774 429214 429665 432422 432910 437161 437476 438369 439608 443165 445620 445919 446006 446632 447529 450754 450825 451030 451033 451438 453599 455213 455777 456264 457110 457202 457609 459699 461005 461388 461556 461793 462865 463800 467773 468638 469497 469695 470771 471995 472466 473971 474964 475866 475876 476521 476974 478507 480263 481288 481527 481536 481554 483130 483610 484134 484429 484591 484638 484931 485074 485332 485353 486562 487334 488090 488201 488566 488700 488858 490823 491320 492717 493911 500146 500665 501393 501394 501716 504797 505930 506250 507004 508078 508630 509378 509636 510208 510406 510676 511233 512069 512782 513529 513552 513612 514058 514076 514792 516140 516916 517149 517581 517912 518218 521546 522962 523934 525290 525807 526655 527322 536278 539058 ] |
||||||||||||||||||||||||||||||
|
20.26 ms (10.19%) |
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 429214 432422 432910 439608 446632 447529 450825 451438 455777 457202 457609 462865 463800 469497 469695 473971 480263 481288 318892 385141 400992 415563 419545 420155 422774 437161 438369 455213 456264 461005 461388 461556 461793 471995 472466 474964 475866 476974 478507 481536 481554 429665 437476 443165 445620 445919 446006 450754 451030 451033 453599 457110 459699 467773 468638 470771 475876 476521 481527 500146 500665 501393 501394 501716 504797 508630 509378 510208 510406 510676 511233 512069 513552 514058 514076 517149 517581 517912 521546 525290 525807 526655 539058 484429 484591 484638 485074 486562 487334 490823 491320 493911 505930 506250 507004 508078 509636 512782 513529 513612 514792 516140 516916 518218 522962 523934 527322 536278 483130 483610 484134 484931 485332 485353 488090 488201 488566 488700 488858 492717 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.71%) |
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 318892 385141 400992 415563 419545 420155 422774 429214 429665 432422 432910 437161 437476 438369 439608 443165 445620 445919 446006 446632 447529 450754 450825 451030 451033 451438 453599 455213 455777 456264 457110 457202 457609 459699 461005 461388 461556 461793 462865 463800 467773 468638 469497 469695 470771 471995 472466 473971 474964 475866 475876 476521 476974 478507 480263 481288 481527 481536 481554 483130 483610 484134 484429 484591 484638 484931 485074 485332 485353 486562 487334 488090 488201 488566 488700 488858 490823 491320 492717 493911 500146 500665 501393 501394 501716 504797 505930 506250 507004 508078 508630 509378 509636 510208 510406 510676 511233 512069 512782 513529 513552 513612 514058 514076 514792 516140 516916 517149 517581 517912 518218 521546 522962 523934 525290 525807 526655 527322 536278 539058 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"щеку"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"щек"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
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.