Query Metrics
7
Database Queries
7
Different statements
1052.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1028.90 ms (97.80%) |
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 273080 383561 400619 412857 425843 444614 452842 457543 458541 461163 469147 500433 502752 507330 516057 517499 517878 528405 529650 529831 530134 530137 530215 530239 531704 531728 532048 533792 534015 534737 535721 536006 536260 537039 537053 538116 538286 538791 539267 540121 540204 541450 541918 542763 542986 543187 543504 543678 544955 545960 546321 546413 547570 548125 551327 554111 555409 559416 559639 562414 563460 566804 574025 575629 576133 577575 577780 578487 600414 604112 627314 646724 647230 650752 651060 653205 661527 663352 667100 670930 671170 675897 686420 692480 692543 696378 697305 701852 706008 710009 710518 710553 712881 752947 756020 757499 757857 759368 778636 783324 784122 784664 790372 791424 792740 796281 801667 804258 804399 807854 810156 812220 812244 813723 816108 818535 820066 825726 825856 826496 ] |
||||||||||||||||||||||||||||||
|
12.34 ms (1.17%) |
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 784664 502752 604112 547570 577780 517878 555409 529650 530239 538286 529831 535721 559416 575629 576133 820066 457543 458541 516057 578487 600414 784122 801667 804399 412857 452842 461163 507330 383561 825726 826496 813723 818535 816108 825856 790372 812220 757857 783324 796281 752947 757499 759368 804258 812244 273080 444614 500433 528405 543187 778636 791424 792740 807854 810156 756020 627314 400619 469147 425843 675897 712881 530134 534015 536260 533792 537039 537053 538791 540121 530137 530215 536006 538116 540204 517499 531704 531728 532048 534737 539267 542986 544955 546321 548125 562414 574025 541918 543504 545960 551327 566804 541450 542763 543678 546413 554111 559639 563460 577575 650752 661527 667100 670930 692480 710009 710518 651060 653205 663352 697305 701852 706008 710553 646724 647230 671170 686420 692543 696378 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (0.30%) |
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 273080 383561 400619 412857 425843 444614 452842 457543 458541 461163 469147 500433 502752 507330 516057 517499 517878 528405 529650 529831 530134 530137 530215 530239 531704 531728 532048 533792 534015 534737 535721 536006 536260 537039 537053 538116 538286 538791 539267 540121 540204 541450 541918 542763 542986 543187 543504 543678 544955 545960 546321 546413 547570 548125 551327 554111 555409 559416 559639 562414 563460 566804 574025 575629 576133 577575 577780 578487 600414 604112 627314 646724 647230 650752 651060 653205 661527 663352 667100 670930 671170 675897 686420 692480 692543 696378 697305 701852 706008 710009 710518 710553 712881 752947 756020 757499 757857 759368 778636 783324 784122 784664 790372 791424 792740 796281 801667 804258 804399 807854 810156 812220 812244 813723 816108 818535 820066 825726 825856 826496 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo home made"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.13%) |
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.