Query Metrics
7
Database Queries
7
Different statements
178.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.13 ms (85.79%) |
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 488130 496324 497792 531858 534963 535744 536306 543282 543656 544135 544175 544239 546495 547046 548081 549896 550655 550659 553439 560121 561511 567553 577268 582900 584177 587759 591474 591576 599809 606875 610553 614359 614360 618278 626807 627343 634699 634700 643292 654648 662903 663357 663362 663478 663971 664518 665184 665307 665478 667397 667559 667896 669741 683372 714220 715466 715540 717092 717589 718444 719913 725437 725787 726824 728142 732942 732963 733350 733470 733481 733526 734255 734272 734352 740111 740662 742574 743011 744353 751524 752178 753750 753784 756391 756809 759697 759727 763553 770126 770201 771691 776419 776730 776754 776761 781806 781821 781988 784902 788317 792584 793624 794174 796325 797337 803322 804430 804579 804584 806309 808656 826370 826379 828037 828342 828422 828712 828714 828824 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (7.29%) |
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 826370 826379 828037 828422 828342 828117 828824 828714 828712 488130 497792 536306 496324 534963 531858 535744 543656 544135 544239 546495 550655 560121 561511 577268 584177 543282 544175 550659 553439 567553 582900 665307 667559 654648 662903 663357 663971 665184 669741 718444 663362 663478 664518 665478 667397 667896 683372 714220 719913 547046 548081 549896 606875 634700 587759 599809 610553 614359 626807 627343 591474 643292 591576 614360 776419 781821 784902 803322 804430 781806 788317 793624 796325 804579 806309 808656 734255 740111 742574 743011 752178 794174 797337 725437 726824 732942 734272 744353 756391 771691 732963 733470 733481 733526 734352 753750 756809 728142 759727 770126 770201 725787 733350 740662 751524 753784 759697 763553 618278 634699 715466 715540 717092 717589 776730 776754 776761 781988 792584 804584 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (2.52%) |
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 488130 496324 497792 531858 534963 535744 536306 543282 543656 544135 544175 544239 546495 547046 548081 549896 550655 550659 553439 560121 561511 567553 577268 582900 584177 587759 591474 591576 599809 606875 610553 614359 614360 618278 626807 627343 634699 634700 643292 654648 662903 663357 663362 663478 663971 664518 665184 665307 665478 667397 667559 667896 669741 683372 714220 715466 715540 717092 717589 718444 719913 725437 725787 726824 728142 732942 732963 733350 733470 733481 733526 734255 734272 734352 740111 740662 742574 743011 744353 751524 752178 753750 753784 756391 756809 759697 759727 763553 770126 770201 771691 776419 776730 776754 776761 781806 781821 781988 784902 788317 792584 793624 794174 796325 797337 803322 804430 804579 804584 806309 808656 826370 826379 828037 828342 828422 828712 828714 828824 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits chubby"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон chubby"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон chubby"
]
|
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.