Query Metrics
7
Database Queries
7
Different statements
415.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.04 ms (50.80%) |
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 384808 390041 393783 395897 398231 407887 409938 411960 424006 443939 460182 461147 461939 466030 474452 482328 482918 485392 486174 489233 495178 496808 497664 505837 508652 509159 511612 517238 531957 533211 535480 541586 545931 551729 555014 558226 558366 558368 561367 566403 571634 575379 579079 580015 581573 581940 582292 582348 582399 582656 582727 583711 583798 583821 585525 590392 591667 592618 595278 596144 596537 597530 598874 603779 606965 623394 624658 627206 627710 643396 649185 661339 679245 680204 687420 687937 688980 692445 692994 693006 693509 699482 707651 710377 713652 720313 723733 732024 735150 735919 745300 749390 751817 760752 760959 769424 772343 773533 775650 777568 779945 781250 782711 783946 784504 787914 788655 788975 790082 795224 796904 797384 797592 801140 801853 804729 805564 811729 811846 812852 ] |
||||||||||||||||||||||||||||||
|
180.63 ms (43.48%) |
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 384808 390041 393783 395897 398231 407887 409938 411960 424006 443939 460182 461147 461939 466030 474452 482328 482918 485392 486174 489233 495178 496808 497664 505837 508652 509159 511612 517238 531957 533211 535480 541586 545931 551729 555014 558226 558366 558368 561367 566403 571634 575379 579079 580015 581573 581940 582292 582348 582399 582656 582727 583711 583798 583821 585525 590392 591667 592618 595278 596144 596537 597530 598874 603779 606965 623394 624658 627206 627710 643396 649185 661339 679245 680204 687420 687937 688980 692445 692994 693006 693509 699482 707651 710377 713652 720313 723733 732024 735150 735919 745300 749390 751817 760752 760959 769424 772343 773533 775650 777568 779945 781250 782711 783946 784504 787914 788655 788975 790082 795224 796904 797384 797592 801140 801853 804729 805564 811729 811846 812852 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (3.98%) |
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 777568 790082 775650 779945 772343 788975 723733 735919 735150 749390 773533 627206 713652 424006 393783 575379 582656 558226 692994 585525 606965 787914 788655 796904 804729 769424 801140 760959 732024 745300 624658 407887 482328 508652 489233 395897 485392 511612 533211 551729 561367 583711 582727 583798 687420 693006 693509 720313 582292 582348 596144 603779 781250 797384 811846 805564 812852 784504 760752 707651 783946 801853 443939 466030 535480 398231 411960 497664 509159 531957 545931 692445 661339 680204 710377 566403 579079 596537 627710 623394 782711 797592 811729 751817 795224 517238 482918 649185 384808 390041 409938 688980 461147 461939 474452 460182 496808 505837 495178 486174 555014 558366 581573 541586 558368 580015 581940 582399 699482 679245 687937 571634 583821 598874 590392 592618 595278 643396 597530 591667 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"год"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"год"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2014 год"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.37%) |
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.