Query Metrics
7
Database Queries
7
Different statements
877.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
267.88 ms (30.51%) |
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 601729 590192 602993 735554 603491 705825 811293 383347 448572 451688 468004 444005 448902 462145 474181 418456 492814 509458 500794 386740 382861 385368 186416 336085 50381 391407 403582 441118 423544 499940 654049 683061 669552 564620 641753 778194 401806 481087 389676 435325 478798 641725 602608 473103 523761 494457 570698 648880 545989 395769 315866 346141 401414 444852 446447 457098 471026 476672 478633 451777 452808 468277 471461 446798 456245 476068 510945 495602 500282 468302 477137 487413 545677 547740 555886 557896 566586 681731 599145 340613 462143 475231 480498 440217 445099 403233 421386 421600 429696 447778 453002 474214 418467 423936 437791 454078 481351 411532 421216 510331 526747 484960 489378 483667 516401 520158 494399 510001 526244 527471 667097 768823 824925 826666 535953 696145 697703 692664 710494 615412 ] |
||||||||||||||||||||||||||||||
|
211.74 ms (24.12%) |
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 50381 186416 315866 336085 340613 346141 382861 383347 385368 386740 389676 391407 395769 401414 401806 403233 403582 411532 418456 418467 421216 421386 421600 423544 423936 429696 435325 437791 440217 441118 444005 444852 445099 446447 446798 447778 448572 448902 451688 451777 452808 453002 454078 456245 457098 462143 462145 468004 468277 468302 471026 471461 473103 474181 474214 475231 476068 476672 477137 478633 478798 480498 481087 481351 483667 484960 487413 489378 492814 494399 494457 495602 499940 500282 500794 509458 510001 510331 510945 516401 520158 523761 526244 526747 527471 535953 545677 545989 547740 555886 557896 564620 566586 570698 590192 599145 601729 602608 602993 603491 615412 641725 641753 648880 654049 667097 669552 681731 683061 692664 696145 697703 705825 710494 735554 768823 778194 811293 824925 ] |
||||||||||||||||||||||||||||||
|
206.05 ms (23.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam masturbation"
]
|
||||||||||||||||||||||||||||||
|
187.24 ms (21.33%) |
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 50381 186416 315866 336085 340613 346141 382861 383347 385368 386740 389676 391407 395769 401414 401806 403233 403582 411532 418456 418467 421216 421386 421600 423544 423936 429696 435325 437791 440217 441118 444005 444852 445099 446447 446798 447778 448572 448902 451688 451777 452808 453002 454078 456245 457098 462143 462145 468004 468277 468302 471026 471461 473103 474181 474214 475231 476068 476672 477137 478633 478798 480498 481087 481351 483667 484960 487413 489378 492814 494399 494457 495602 499940 500282 500794 509458 510001 510331 510945 516401 520158 523761 526244 526747 527471 535953 545677 545989 547740 555886 557896 564620 566586 570698 590192 599145 601729 602608 602993 603491 615412 641725 641753 648880 654049 667097 669552 681731 683061 692664 696145 697703 705825 710494 735554 768823 778194 811293 824925 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.