Query Metrics
7
Database Queries
7
Different statements
357.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.82 ms (58.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс friends"
]
|
||||||||||||||||||||||||||||||
|
126.79 ms (35.49%) |
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 233446 285885 359062 387068 390192 395788 396430 402015 410745 411416 421491 422280 428033 443870 447928 449352 450213 453613 454289 463700 469689 482782 484054 484110 498287 507088 509210 516302 516428 517582 530599 533690 537638 542473 545011 545981 546667 548619 551603 552005 552727 558790 558908 559674 569985 570419 588433 594553 600725 608301 612089 621949 625131 627815 628591 628768 632568 635854 640149 641207 644421 649056 650880 651155 653437 663951 666741 668059 668467 668640 672490 676345 678374 682057 683696 686076 698086 698104 699549 710833 711671 718040 718828 721188 721822 723603 724317 730797 731687 732822 745243 745526 745906 747987 749032 749658 762051 763613 765170 766306 773105 773554 773965 786137 790679 797361 798089 803595 804525 805117 807547 808227 808432 810512 811238 817446 818530 821232 821798 823920 ] |
||||||||||||||||||||||||||||||
|
12.19 ms (3.41%) |
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 551603 710833 762051 732822 233446 387068 537638 628591 640149 641207 810512 749658 421491 545981 676345 668640 797361 786137 808227 745526 773105 747987 628768 395788 422280 396430 821798 463700 484054 516428 805117 803595 749032 818530 450213 482782 453613 668059 730797 552005 721188 663951 285885 447928 542473 644421 698104 569985 411416 428033 530599 807547 765170 612089 545011 588433 745243 484110 507088 443870 410745 449352 552727 558908 686076 718040 718828 721822 650880 668467 594553 763613 625131 632568 711671 509210 516302 653437 533690 570419 773554 390192 498287 649056 621949 608301 627815 804525 798089 808432 811238 766306 724317 731687 723603 558790 546667 672490 682057 698086 548619 635854 600725 454289 817446 823920 559674 666741 678374 651155 699549 683696 745906 773965 790679 517582 359062 402015 821232 469689 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (0.82%) |
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 233446 285885 359062 387068 390192 395788 396430 402015 410745 411416 421491 422280 428033 443870 447928 449352 450213 453613 454289 463700 469689 482782 484054 484110 498287 507088 509210 516302 516428 517582 530599 533690 537638 542473 545011 545981 546667 548619 551603 552005 552727 558790 558908 559674 569985 570419 588433 594553 600725 608301 612089 621949 625131 627815 628591 628768 632568 635854 640149 641207 644421 649056 650880 651155 653437 663951 666741 668059 668467 668640 672490 676345 678374 682057 683696 686076 698086 698104 699549 710833 711671 718040 718828 721188 721822 723603 724317 730797 731687 732822 745243 745526 745906 747987 749032 749658 762051 763613 765170 766306 773105 773554 773965 786137 790679 797361 798089 803595 804525 805117 807547 808227 808432 810512 811238 817446 818530 821232 821798 823920 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex friends"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс friends"
]
|
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.