Query Metrics
7
Database Queries
7
Different statements
170.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.36 ms (86.41%) |
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 384046 395769 397670 399201 418464 427095 440644 470433 492420 493363 494399 517035 517796 529638 530424 531035 531655 537078 537086 538378 538739 541795 541905 541969 543679 546080 547007 549031 553160 553185 554683 554707 556251 563998 567982 569221 571304 573209 574319 575885 576540 576599 579783 582729 584031 584219 584922 588391 595163 607378 607891 609757 609761 611496 613435 614477 614536 619989 620911 623207 623343 623725 629671 636643 636765 637328 643458 647530 650719 652943 661619 662897 666491 669248 669876 684449 696960 702354 702377 702615 705372 710480 714076 730221 740823 744129 745054 749426 751351 751390 752223 753617 754830 758821 765404 772987 777164 779263 780545 785785 790447 797177 800143 801783 801842 802305 803395 807214 807283 809660 811844 811873 811893 812281 813791 814410 823890 824765 827296 827602 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (7.97%) |
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 827602 530424 537078 531035 537086 517035 517796 553185 573209 575885 579783 584031 543679 569221 650719 661619 705372 710480 714076 647530 684449 696960 702377 702615 652943 666491 669248 669876 567982 574319 582729 584219 584922 613435 611496 619989 623725 637328 607891 614477 614536 620911 623343 629671 636765 643458 588391 607378 609757 623207 780545 803395 807283 777164 812281 730221 740823 797177 800143 801783 809660 811873 811893 752223 772987 758821 765404 744129 745054 753617 749426 751351 751390 754830 609761 702354 779263 785785 790447 801842 802305 807214 811844 397670 384046 418464 440644 541969 662897 595163 636643 395769 427095 492420 494399 399201 827296 813791 824765 814410 823890 470433 493363 529638 538378 538739 531655 553160 554707 571304 541905 547007 549031 563998 541795 546080 554683 556251 576540 576599 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.66%) |
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 384046 395769 397670 399201 418464 427095 440644 470433 492420 493363 494399 517035 517796 529638 530424 531035 531655 537078 537086 538378 538739 541795 541905 541969 543679 546080 547007 549031 553160 553185 554683 554707 556251 563998 567982 569221 571304 573209 574319 575885 576540 576599 579783 582729 584031 584219 584922 588391 595163 607378 607891 609757 609761 611496 613435 614477 614536 619989 620911 623207 623343 623725 629671 636643 636765 637328 643458 647530 650719 652943 661619 662897 666491 669248 669876 684449 696960 702354 702377 702615 705372 710480 714076 730221 740823 744129 745054 749426 751351 751390 752223 753617 754830 758821 765404 772987 777164 779263 780545 785785 790447 797177 800143 801783 801842 802305 803395 807214 807283 809660 811844 811873 811893 812281 813791 814410 823890 824765 827296 827602 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam shower solo"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер shower соло"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер shower соло"
]
|
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.