Query Metrics
7
Database Queries
7
Different statements
205.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.99 ms (84.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 3381 6863 263296 282481 325660 325936 388653 391745 394167 396102 396456 397678 400426 401070 401153 401976 403267 405014 408764 413732 414253 414334 417561 418538 419032 419271 419890 420874 421423 423909 425610 426894 428741 430347 432402 435816 437734 439993 441102 441452 443494 444035 444759 445020 453640 458202 461443 466161 469762 471599 472427 475784 480708 486867 490304 497641 499388 499575 505110 511501 517306 524320 525804 529051 529172 546546 547658 548609 548941 552467 552682 559661 561709 562626 574897 576042 576059 584252 587342 589392 589886 592712 592725 594775 595433 595619 596579 597983 598525 598595 600084 602898 603026 604000 605669 607928 610574 619965 624890 632902 641560 648484 652610 654408 654916 655084 656522 662826 664545 672290 675039 680374 681212 684511 728353 730224 767611 788356 824935 ] |
||||||||||||||||||||||||||||||
|
20.88 ms (10.14%) |
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 576042 584252 654408 654916 672290 675039 648484 655084 656522 662826 664545 680374 684511 546546 548941 552682 559661 561709 576059 592712 592725 594775 595619 598525 598595 607928 589886 596579 632902 587342 589392 624890 595433 597983 602898 603026 604000 605669 641560 788356 767611 728353 730224 282481 419032 458202 475784 3381 425610 432402 468318 471599 428741 435816 472427 325936 403267 405014 426894 453640 461443 486867 505110 497641 499388 511501 529051 499575 517306 525804 400426 418538 439993 480708 490304 524320 548609 562626 574897 552467 466161 547658 652610 600084 610574 619965 469762 529172 394167 391745 325660 263296 6863 388653 396102 396456 397678 401976 401153 401070 413732 420874 423909 430347 444035 441452 443494 444759 408764 414334 419271 437734 445020 414253 417561 419890 421423 441102 681212 824935 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.34%) |
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 3381 6863 263296 282481 325660 325936 388653 391745 394167 396102 396456 397678 400426 401070 401153 401976 403267 405014 408764 413732 414253 414334 417561 418538 419032 419271 419890 420874 421423 423909 425610 426894 428741 430347 432402 435816 437734 439993 441102 441452 443494 444035 444759 445020 453640 458202 461443 466161 469762 471599 472427 475784 480708 486867 490304 497641 499388 499575 505110 511501 517306 524320 525804 529051 529172 546546 547658 548609 548941 552467 552682 559661 561709 562626 574897 576042 576059 584252 587342 589392 589886 592712 592725 594775 595433 595619 596579 597983 598525 598595 600084 602898 603026 604000 605669 607928 610574 619965 624890 632902 641560 648484 652610 654408 654916 655084 656522 662826 664545 672290 675039 680374 681212 684511 728353 730224 767611 788356 824935 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen bed"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen постел"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen постел"
]
|
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.