Query Metrics
7
Database Queries
7
Different statements
167.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.69 ms (81.85%) |
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 365865 385208 398355 416887 418714 419246 422392 443118 448499 458652 459627 460524 462066 471057 475109 483774 483960 486556 492440 498811 499594 501055 501137 505666 508635 509009 509571 510936 511287 528360 528568 529189 535345 539282 542289 545947 554849 557193 559397 572208 574362 578525 582745 582747 583894 583966 584010 584120 585261 610806 614510 619318 619322 630326 632503 636649 636674 641346 644144 646538 674899 676680 689020 689054 689570 693367 695438 696293 696294 700134 704422 705491 705495 713216 714927 715163 720355 720553 723637 725219 727554 727560 728497 729972 731158 733317 734322 740166 743973 747981 757992 765580 767692 778481 778490 789564 794433 794754 795230 795249 798798 799752 801579 802905 803824 806910 810717 814374 816809 817249 817895 819323 823753 824562 824733 824953 825986 826204 826499 826532 ] |
||||||||||||||||||||||||||||||
|
16.75 ms (10.03%) |
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 475109 443118 492440 471057 486556 542289 557193 578525 574362 582747 584010 585261 636674 641346 803824 729972 727560 734322 814374 498811 460524 676680 619322 802905 806910 728497 765580 733317 422392 458652 509009 483774 674899 535345 539282 511287 528568 554849 559397 731158 727554 700134 714927 418714 705491 583894 583966 816809 819323 385208 448499 825986 545947 689020 696293 789564 799752 757992 419246 528360 510936 817895 824562 508635 646538 704422 696294 720355 644144 614510 801579 636649 619318 584120 582745 823753 826532 826204 462066 689054 630326 795249 743973 705495 509571 499594 398355 723637 824953 501055 572208 689570 713216 695438 693367 632503 778481 795230 767692 725219 747981 715163 810717 459627 505666 365865 610806 416887 826499 817249 824733 483960 501137 529189 720553 794433 794754 798798 740166 778490 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (2.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер беремен"
]
|
||||||||||||||||||||||||||||||
|
3.47 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 365865 385208 398355 416887 418714 419246 422392 443118 448499 458652 459627 460524 462066 471057 475109 483774 483960 486556 492440 498811 499594 501055 501137 505666 508635 509009 509571 510936 511287 528360 528568 529189 535345 539282 542289 545947 554849 557193 559397 572208 574362 578525 582745 582747 583894 583966 584010 584120 585261 610806 614510 619318 619322 630326 632503 636649 636674 641346 644144 646538 674899 676680 689020 689054 689570 693367 695438 696293 696294 700134 704422 705491 705495 713216 714927 715163 720355 720553 723637 725219 727554 727560 728497 729972 731158 733317 734322 740166 743973 747981 757992 765580 767692 778481 778490 789564 794433 794754 795230 795249 798798 799752 801579 802905 803824 806910 810717 814374 816809 817249 817895 819323 823753 824562 824733 824953 825986 826204 826499 826532 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер беремен"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam pregnant"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.