Query Metrics
7
Database Queries
7
Different statements
198.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.88 ms (84.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 172164 265933 401201 408433 417874 424299 432020 435940 441449 442944 443128 444558 448975 449605 451503 452322 452355 455587 456214 456647 459411 459419 460248 462630 465074 472012 472409 472568 476613 477209 478805 479343 481464 481747 483844 483982 483989 487575 491818 497209 497233 498603 501696 502194 503792 506909 506940 506946 512028 512804 517458 518828 525654 526007 530046 532068 534359 535029 536768 546580 549687 549738 556554 556565 557782 562732 565621 565703 565981 566504 566582 566743 568163 580782 587209 598259 602417 607262 609227 612232 612467 612795 619713 620042 623810 637490 673858 688668 689011 696565 707617 716354 717199 717410 724467 726348 732715 733900 742034 742383 743819 748159 748478 761211 770630 774287 780655 793182 794943 794978 796243 799171 801345 805198 805772 806686 808019 809891 811271 813018 ] |
||||||||||||||||||||||||||||||
|
18.53 ms (9.33%) |
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 483982 566743 619713 724467 774287 748478 432020 801345 517458 733900 796243 732715 532068 688668 455587 568163 620042 726348 478805 442944 451503 566582 580782 673858 805198 806686 742034 770630 793182 435940 452322 456214 452355 483844 483989 498603 449605 562732 265933 401201 408433 479343 506940 811271 444558 813018 497209 518828 565621 761211 809891 441449 526007 612467 506946 417874 456647 465074 459411 460248 487575 497233 502194 530046 536768 501696 481464 549687 556554 689011 546580 609227 612795 607262 808019 707617 443128 476613 424299 448975 472409 472012 481747 512028 506909 525654 565981 612232 799171 556565 565703 566504 748159 743819 172164 477209 459419 462630 491818 472568 503792 534359 535029 512804 557782 549738 717410 696565 716354 717199 623810 587209 598259 637490 780655 794978 805772 742383 602417 794943 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.76%) |
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 172164 265933 401201 408433 417874 424299 432020 435940 441449 442944 443128 444558 448975 449605 451503 452322 452355 455587 456214 456647 459411 459419 460248 462630 465074 472012 472409 472568 476613 477209 478805 479343 481464 481747 483844 483982 483989 487575 491818 497209 497233 498603 501696 502194 503792 506909 506940 506946 512028 512804 517458 518828 525654 526007 530046 532068 534359 535029 536768 546580 549687 549738 556554 556565 557782 562732 565621 565703 565981 566504 566582 566743 568163 580782 587209 598259 602417 607262 609227 612232 612467 612795 619713 620042 623810 637490 673858 688668 689011 696565 707617 716354 717199 717410 724467 726348 732715 733900 742034 742383 743819 748159 748478 761211 770630 774287 780655 793182 794943 794978 796243 799171 801345 805198 805772 806686 808019 809891 811271 813018 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big busty wife"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие busty жен"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие busty жен"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.