Query Metrics
7
Database Queries
7
Different statements
178.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.82 ms (85.12%) |
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 75664 117479 391134 396276 396905 397283 402373 408278 410953 412238 417682 435644 439472 439484 440683 443987 447738 448145 448177 449270 449277 449299 449320 466602 469646 472372 475052 475462 485241 488239 496787 504405 506486 511155 514945 519582 526706 527207 533331 533332 537510 541861 555377 560360 591771 591911 592582 594980 595069 596584 603481 609868 613751 616793 619040 626097 635973 636308 641418 650028 650983 653009 653257 662118 669275 674111 687150 704658 715350 718720 719322 721386 722799 724266 725002 728143 732421 734661 738009 740743 740952 742144 743039 750769 756321 757090 757210 758812 760210 764909 766651 773668 773940 780979 782464 783625 785229 785530 785744 785945 787272 788029 788610 790032 790053 790056 795916 799268 800189 801529 803339 803571 805271 806011 807699 808167 810991 823447 824190 824315 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (8.75%) |
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 734661 740743 740952 785744 750769 760210 738009 758812 721386 795916 803339 117479 641418 728143 408278 439484 412238 824315 475052 526706 533331 560360 650983 790032 807699 783625 766651 732421 808167 75664 396276 410953 449277 514945 496787 715350 687150 718720 616793 595069 591771 782464 785945 724266 800189 810991 472372 391134 440683 511155 485241 504405 488239 636308 527207 650028 439472 443987 449320 519582 397283 396905 417682 823447 824190 537510 533332 674111 653009 609868 594980 596584 613751 591911 788029 790053 785229 773668 790056 742144 743039 773940 757210 603481 626097 722799 780979 801529 803571 806011 402373 506486 449299 435644 447738 448145 466602 555377 541861 653257 704658 669275 719322 662118 619040 592582 785530 788610 725002 757090 799268 805271 756321 764909 635973 787272 475462 449270 448177 469646 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (2.11%) |
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 75664 117479 391134 396276 396905 397283 402373 408278 410953 412238 417682 435644 439472 439484 440683 443987 447738 448145 448177 449270 449277 449299 449320 466602 469646 472372 475052 475462 485241 488239 496787 504405 506486 511155 514945 519582 526706 527207 533331 533332 537510 541861 555377 560360 591771 591911 592582 594980 595069 596584 603481 609868 613751 616793 619040 626097 635973 636308 641418 650028 650983 653009 653257 662118 669275 674111 687150 704658 715350 718720 719322 721386 722799 724266 725002 728143 732421 734661 738009 740743 740952 742144 743039 750769 756321 757090 757210 758812 760210 764909 766651 773668 773940 780979 782464 783625 785229 785530 785744 785945 787272 788029 788610 790032 790053 790056 795916 799268 800189 801529 803339 803571 805271 806011 807699 808167 810991 823447 824190 824315 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie pussy лиза"
]
|
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.