Query Metrics
7
Database Queries
7
Different statements
201.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.09 ms (84.57%) |
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 70082 397331 397361 402724 405525 411849 415834 417524 418440 418528 418833 419406 420206 421118 421526 422654 422947 423269 423806 447560 447944 452499 456523 456695 456779 456925 459640 462331 462991 463000 468280 470449 471836 473037 477555 480784 484065 485542 486193 491194 493184 494815 497543 498623 499089 499734 500268 504765 505818 508522 511514 512427 514315 515170 515175 516889 516968 517650 518096 518275 518761 520011 520984 524301 526232 527003 527074 529219 539280 541540 544206 552170 553477 556680 558072 559532 559930 561155 561931 561980 562118 564719 565099 565241 566709 567503 567910 568404 571012 571724 571841 572318 572869 573411 584672 585096 587939 589074 595192 597227 603725 607377 610278 614408 616472 618718 620739 620783 621412 626064 632695 634512 646920 662048 665681 666876 709723 736564 761201 814536 ] |
||||||||||||||||||||||||||||||
|
19.79 ms (9.84%) |
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 463000 539280 512427 511514 397361 405525 411849 585096 459640 517650 559532 561931 595192 456779 480784 477555 508522 516889 529219 491194 499734 505818 524301 456925 520011 814536 516968 544206 562118 565099 553477 567503 561155 665681 709723 556680 573411 603725 616472 761201 736564 626064 423269 415834 421118 447944 571012 632695 456523 527074 70082 418440 568404 571724 566709 558072 567910 646920 620783 621412 471836 527003 418528 422947 456695 473037 518761 498623 552170 565241 462331 468280 420206 462991 486193 499089 493184 514315 397331 418833 452499 494815 497543 518096 662048 572869 597227 614408 610278 417524 515170 515175 500268 518275 421526 571841 485542 520984 561980 666876 419406 422654 607377 504765 484065 541540 564719 584672 559930 589074 620739 634512 470449 526232 572318 587939 618718 447560 423806 402724 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (1.96%) |
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 70082 397331 397361 402724 405525 411849 415834 417524 418440 418528 418833 419406 420206 421118 421526 422654 422947 423269 423806 447560 447944 452499 456523 456695 456779 456925 459640 462331 462991 463000 468280 470449 471836 473037 477555 480784 484065 485542 486193 491194 493184 494815 497543 498623 499089 499734 500268 504765 505818 508522 511514 512427 514315 515170 515175 516889 516968 517650 518096 518275 518761 520011 520984 524301 526232 527003 527074 529219 539280 541540 544206 552170 553477 556680 558072 559532 559930 561155 561931 561980 562118 564719 565099 565241 566709 567503 567910 568404 571012 571724 571841 572318 572869 573411 584672 585096 587939 589074 595192 597227 603725 607377 610278 614408 616472 618718 620739 620783 621412 626064 632695 634512 646920 662048 665681 666876 709723 736564 761201 814536 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick little"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член little"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член little"
]
|
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.