Query Metrics
7
Database Queries
7
Different statements
180.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.00 ms (83.99%) |
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 398811 399083 407423 411751 415177 419128 420540 423653 425353 427832 428139 428397 433188 433302 435592 454710 464659 475140 491208 508442 510396 513629 513641 513646 516140 516226 518550 518807 524324 532797 536576 536923 545537 547485 547754 549771 550221 554319 556806 570149 573753 576721 577393 579317 587418 590396 591668 593544 597683 598940 599934 600276 600340 601548 603149 604369 606583 606880 613432 614858 621966 629658 629886 631919 632681 637060 644244 644971 650470 663399 669016 678767 694056 698531 699397 699625 720258 731663 732357 739946 745661 748812 756230 756491 760667 763739 770149 770663 770901 776731 777055 781792 782653 783312 785877 786454 787274 788119 788790 789214 789526 798598 800307 801348 801953 801957 806239 807711 807958 809415 810899 810983 811007 812565 812885 813084 815905 820772 820776 824915 ] |
||||||||||||||||||||||||||||||
|
19.39 ms (10.71%) |
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 629658 629886 632681 587418 590396 601548 606880 781792 782653 800307 801348 807711 813084 776731 788790 798598 801957 809415 812565 760667 783312 785877 786454 788119 789526 801953 810983 812885 770901 756230 756491 770149 763739 770663 613432 811007 475140 536923 516140 815905 787274 427832 545537 428397 631919 644244 407423 454710 423653 820772 820776 464659 532797 536576 550221 554319 650470 694056 720258 678767 699625 598940 600276 606583 621966 597683 810899 731663 399083 415177 513646 513629 518807 513641 518550 524324 549771 600340 604369 411751 789214 807958 433302 547485 573753 510396 398811 420540 669016 698531 739946 748812 806239 824915 579317 570149 637060 591668 603149 699397 614858 732357 491208 433188 644971 516226 577393 547754 576721 556806 663399 599934 593544 777055 745661 425353 435592 419128 428139 508442 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.49%) |
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 398811 399083 407423 411751 415177 419128 420540 423653 425353 427832 428139 428397 433188 433302 435592 454710 464659 475140 491208 508442 510396 513629 513641 513646 516140 516226 518550 518807 524324 532797 536576 536923 545537 547485 547754 549771 550221 554319 556806 570149 573753 576721 577393 579317 587418 590396 591668 593544 597683 598940 599934 600276 600340 601548 603149 604369 606583 606880 613432 614858 621966 629658 629886 631919 632681 637060 644244 644971 650470 663399 669016 678767 694056 698531 699397 699625 720258 731663 732357 739946 745661 748812 756230 756491 760667 763739 770149 770663 770901 776731 777055 781792 782653 783312 785877 786454 787274 788119 788790 789214 789526 798598 800307 801348 801953 801957 806239 807711 807958 809415 810899 810983 811007 812565 812885 813084 815905 820772 820776 824915 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom gape ass"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom большая большие дырк жоп"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom большая большие дырк жоп"
]
|
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.