Query Metrics
7
Database Queries
7
Different statements
442.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.65 ms (47.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
201.93 ms (45.68%) |
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 395291 413649 413826 414651 417482 418009 418363 418596 418597 420638 421363 424682 427530 437810 437864 443112 448821 448832 449150 450441 451173 452895 457160 468614 469023 470414 476797 483542 486741 491678 491790 516291 521581 524508 527198 529846 530625 531129 531251 533685 534215 537204 537663 544404 544680 544825 545410 545441 550298 550531 556447 559453 562491 569223 570704 584348 595369 597204 598728 603685 604370 610577 614867 617410 628366 629398 630550 632649 632657 632691 633451 633736 634116 634151 636294 639716 639798 640793 644913 645858 647084 647355 647906 648825 649546 650155 654430 656568 666535 666883 666895 674953 675000 676022 676026 676090 676112 676638 676641 678143 679810 685714 688255 696582 702677 708753 711283 716087 719333 738952 765222 765251 765262 765364 779114 787511 797291 804464 811497 814010 ] |
||||||||||||||||||||||||||||||
|
18.20 ms (4.12%) |
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 395291 414651 427530 443112 418009 420638 469023 450441 470414 468614 529846 530625 531129 545441 559453 569223 562491 645858 656568 674953 676090 679810 676112 719333 648825 666883 685714 610577 614867 632657 632691 628366 603685 634116 811497 604370 617410 634151 804464 448832 418597 424682 437864 418596 417482 451173 491678 765222 716087 814010 797291 738952 765364 437810 452895 457160 483542 448821 491790 516291 527198 537204 531251 544825 544680 550298 666535 678143 696582 676026 702677 711283 647355 647906 676641 597204 632649 633736 636294 640793 633451 418363 421363 413649 521581 629398 556447 647084 708753 654430 787511 550531 595369 544404 644913 524508 533685 534215 537663 570704 666895 676022 676638 649546 630550 639798 639716 449150 476797 413826 486741 584348 688255 598728 765262 765251 779114 545410 650155 675000 ] |
||||||||||||||||||||||||||||||
|
4.33 ms (0.98%) |
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 395291 413649 413826 414651 417482 418009 418363 418596 418597 420638 421363 424682 427530 437810 437864 443112 448821 448832 449150 450441 451173 452895 457160 468614 469023 470414 476797 483542 486741 491678 491790 516291 521581 524508 527198 529846 530625 531129 531251 533685 534215 537204 537663 544404 544680 544825 545410 545441 550298 550531 556447 559453 562491 569223 570704 584348 595369 597204 598728 603685 604370 610577 614867 617410 628366 629398 630550 632649 632657 632691 633451 633736 634116 634151 636294 639716 639798 640793 644913 645858 647084 647355 647906 648825 649546 650155 654430 656568 666535 666883 666895 674953 675000 676022 676026 676090 676112 676638 676641 678143 679810 685714 688255 696582 702677 708753 711283 716087 719333 738952 765222 765251 765262 765364 779114 787511 797291 804464 811497 814010 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen squirt"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen сквирт оргазм"
]
|
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.