Query Metrics
7
Database Queries
7
Different statements
183.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.74 ms (87.44%) |
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 8347 61625 319841 350700 367863 382292 385389 386747 388919 389487 390832 391025 404053 404304 404722 405534 406237 406433 406993 407054 407141 413104 415189 418400 427179 428583 430618 430989 441005 447350 447548 448061 449254 450530 454714 459231 465886 467273 469675 489618 490706 494771 498605 499371 501720 508568 510043 510244 511263 516536 517998 520599 524003 526669 527029 530718 535672 551292 554758 560186 564459 566321 568348 569412 572010 572015 572016 573776 573932 575730 576039 583280 599327 600607 608595 625452 628343 628989 632696 634162 634842 636804 643396 645847 653251 654331 661092 661579 663381 663469 663535 668905 682493 690148 696102 708800 715853 716753 722810 723011 725570 726520 727924 749522 753443 753784 756363 800066 808241 810842 813228 814758 814806 815691 815790 817478 817734 825002 825210 828714 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (7.86%) |
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 600607 404722 406237 415189 448061 449254 516536 494771 501720 489618 817478 825210 825002 815691 815790 828714 661092 645847 661579 663535 753784 723011 389487 418400 490706 576039 572016 575730 572010 663381 682493 572015 583280 628343 808241 625452 535672 628989 61625 404053 407141 817734 663469 367863 459231 749522 498605 551292 810842 800066 386747 319841 8347 427179 814806 814758 465886 564459 568348 573932 569412 653251 696102 715853 560186 599327 634842 643396 608595 726520 727924 753443 725570 632696 634162 708800 382292 441005 467273 391025 404304 407054 428583 430989 450530 454714 499371 510244 510043 526669 527029 530718 566321 573776 554758 813228 469675 405534 430618 447350 388919 406433 447548 508568 511263 517998 520599 524003 385389 413104 756363 350700 390832 636804 406993 716753 722810 654331 668905 690148 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.32%) |
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 8347 61625 319841 350700 367863 382292 385389 386747 388919 389487 390832 391025 404053 404304 404722 405534 406237 406433 406993 407054 407141 413104 415189 418400 427179 428583 430618 430989 441005 447350 447548 448061 449254 450530 454714 459231 465886 467273 469675 489618 490706 494771 498605 499371 501720 508568 510043 510244 511263 516536 517998 520599 524003 526669 527029 530718 535672 551292 554758 560186 564459 566321 568348 569412 572010 572015 572016 573776 573932 575730 576039 583280 599327 600607 608595 625452 628343 628989 632696 634162 634842 636804 643396 645847 653251 654331 661092 661579 663381 663469 663535 668905 682493 690148 696102 708800 715853 716753 722810 723011 725570 726520 727924 749522 753443 753784 756363 800066 808241 810842 813228 814758 814806 815691 815790 817478 817734 825002 825210 828714 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж член"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage dick"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.76%) |
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.