Query Metrics
7
Database Queries
7
Different statements
151.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.25 ms (84.42%) |
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 399416 401423 416113 417495 419462 425573 433363 433814 433854 442464 445838 448466 451213 454404 460681 464169 464613 466901 481101 490468 502568 502613 507608 509508 509593 511092 513822 517883 524240 525958 527435 530396 533196 539348 539632 541121 543274 548408 559745 564364 566743 569265 569298 570131 575269 577493 578764 582457 583352 584339 585917 592935 594018 594204 594258 597723 600951 601205 601222 606308 607499 607503 607633 612675 619995 622488 625909 629826 631985 634930 642186 644199 648167 655471 663830 664215 664240 665012 692840 694614 696091 698123 698128 711617 713833 716297 720051 726790 727144 729974 753060 753068 753779 763427 764889 774006 775160 781874 781879 784836 788439 794179 795287 796674 799094 800860 802733 803806 804506 806081 807746 807755 807973 808198 809243 812408 813310 814115 816622 820313 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (9.00%) |
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 530396 720051 569265 575269 592935 607503 644199 642186 796674 804506 726790 764889 716297 502613 800860 419462 509508 433814 816622 584339 597723 601222 799094 525958 541121 665012 606308 809243 820313 543274 559745 570131 548408 583352 696091 694614 713833 711617 564364 607633 781874 808198 753068 763427 775160 806081 794179 612675 448466 655471 812408 401423 451213 481101 698128 594204 594258 788439 753060 619995 569298 795287 425573 814115 513822 524240 539348 577493 692840 648167 663830 664215 600951 625909 622488 802733 807746 803806 813310 727144 807755 774006 629826 631985 784836 464613 507608 533196 527435 566743 729974 445838 464169 399416 781879 753779 607499 502568 539632 807973 442464 460681 582457 698123 664240 601205 634930 594018 585917 417495 416113 433363 433854 511092 517883 454404 490468 466901 509593 578764 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.08%) |
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 399416 401423 416113 417495 419462 425573 433363 433814 433854 442464 445838 448466 451213 454404 460681 464169 464613 466901 481101 490468 502568 502613 507608 509508 509593 511092 513822 517883 524240 525958 527435 530396 533196 539348 539632 541121 543274 548408 559745 564364 566743 569265 569298 570131 575269 577493 578764 582457 583352 584339 585917 592935 594018 594204 594258 597723 600951 601205 601222 606308 607499 607503 607633 612675 619995 622488 625909 629826 631985 634930 642186 644199 648167 655471 663830 664215 664240 665012 692840 694614 696091 698123 698128 711617 713833 716297 720051 726790 727144 729974 753060 753068 753779 763427 764889 774006 775160 781874 781879 784836 788439 794179 795287 796674 799094 800860 802733 803806 804506 806081 807746 807755 807973 808198 809243 812408 813310 814115 816622 820313 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov chubby girl"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов chubby девушк"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.99%) |
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.