Query Metrics
7
Database Queries
7
Different statements
142.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.55 ms (85.34%) |
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 101816 420147 424720 427540 442608 448369 456319 458127 459871 459996 460063 462118 462135 463839 469170 470680 470932 474985 475320 478146 478715 479299 479498 484245 484256 485967 486736 489772 489783 489792 490159 490270 492082 500252 506734 517324 526720 527278 529507 530185 534701 538615 539650 541047 544905 545869 555164 557903 560251 577526 577607 590412 594911 599510 599808 600842 602226 606890 609207 609220 615770 617972 629069 629468 631219 636625 637819 637998 638113 638496 640890 645472 648978 653818 665067 667052 667097 667140 668022 669914 671913 679916 695410 699413 709504 719786 719849 719880 721810 725094 731429 731442 732959 739922 740709 749078 749151 749633 751318 751426 751429 751805 753196 762636 763803 767384 767772 768945 772876 773464 780901 788682 796510 796518 798946 802262 803156 804415 817389 827916 ] |
||||||||||||||||||||||||||||||
|
11.78 ms (8.27%) |
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 594911 638113 788682 751426 749151 751318 637998 492082 462118 474985 648978 458127 500252 577607 560251 667140 709504 617972 590412 640890 600842 796510 739922 721810 817389 484245 545869 665067 667097 629069 459871 534701 667052 606890 475320 448369 463839 427540 462135 479498 490270 506734 489792 732959 798946 101816 424720 541047 669914 577526 780901 725094 749078 530185 679916 653818 719786 763803 602226 637819 486736 489783 719849 629468 638496 751805 442608 459996 484256 529507 517324 526720 527278 460063 599510 731442 609220 420147 478715 479299 485967 538615 555164 695410 671913 753196 751429 615770 827916 645472 699413 668022 544905 609207 636625 631219 599808 796518 802262 804415 772876 767772 768945 762636 731429 719880 803156 469170 490159 478146 489772 539650 557903 740709 749633 767384 773464 470680 456319 470932 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.55%) |
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 101816 420147 424720 427540 442608 448369 456319 458127 459871 459996 460063 462118 462135 463839 469170 470680 470932 474985 475320 478146 478715 479299 479498 484245 484256 485967 486736 489772 489783 489792 490159 490270 492082 500252 506734 517324 526720 527278 529507 530185 534701 538615 539650 541047 544905 545869 555164 557903 560251 577526 577607 590412 594911 599510 599808 600842 602226 606890 609207 609220 615770 617972 629069 629468 631219 636625 637819 637998 638113 638496 640890 645472 648978 653818 665067 667052 667097 667140 668022 669914 671913 679916 695410 699413 709504 719786 719849 719880 721810 725094 731429 731442 732959 739922 740709 749078 749151 749633 751318 751426 751429 751805 753196 762636 763803 767384 767772 768945 772876 773464 780901 788682 796510 796518 798946 802262 803156 804415 817389 827916 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam car"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.98%) |
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.