Query Metrics
7
Database Queries
7
Different statements
452.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.03 ms (49.53%) |
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 173107 397510 402626 413044 415988 420818 422511 425780 428293 430209 433968 438052 438589 446473 451961 457213 457981 459524 459796 463752 467744 468153 473019 478437 486189 486614 496339 500688 504074 508912 509821 512552 512831 516432 527217 529602 534528 535039 538270 541971 546577 547651 550747 550753 550758 550759 551953 551973 552036 555166 559783 559910 561960 562054 568257 568864 569820 575300 577219 577783 580166 581582 582876 583468 583501 583666 584289 584481 585519 586034 590953 592393 595035 598834 600492 600622 601071 602102 602753 603199 605652 607611 610216 615600 619439 619450 620743 622106 623551 630529 636442 639252 644697 651465 653254 656626 667226 670197 672248 688371 712475 730865 736706 742848 750477 755001 757152 758732 759365 765714 766603 771981 785568 795396 795723 797010 799394 810173 812278 825331 ] |
||||||||||||||||||||||||||||||
|
206.50 ms (45.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation asian"
]
|
||||||||||||||||||||||||||||||
|
13.36 ms (2.95%) |
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 622106 785568 771981 755001 758732 799394 551953 425780 512552 496339 467744 173107 433968 486614 504074 527217 529602 534528 562054 568257 541971 555166 559783 568864 651465 667226 672248 550747 561960 577219 584289 590953 592393 607611 586034 595035 610216 639252 600622 601071 605652 600492 623551 757152 750477 766603 797010 457213 459796 438589 415988 509821 500688 463752 451961 473019 508912 422511 397510 457981 538270 810173 420818 413044 516432 653254 547651 619439 459524 430209 478437 559910 580166 583468 569820 583501 550753 550758 552036 656626 712475 550759 581582 583666 598834 630529 619450 603199 636442 730865 795723 812278 736706 742848 765714 602753 644697 795396 486189 825331 468153 551973 428293 688371 402626 446473 535039 512831 546577 582876 584481 577783 575300 670197 602102 615600 620743 585519 759365 438052 ] |
||||||||||||||||||||||||||||||
|
3.80 ms (0.84%) |
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 173107 397510 402626 413044 415988 420818 422511 425780 428293 430209 433968 438052 438589 446473 451961 457213 457981 459524 459796 463752 467744 468153 473019 478437 486189 486614 496339 500688 504074 508912 509821 512552 512831 516432 527217 529602 534528 535039 538270 541971 546577 547651 550747 550753 550758 550759 551953 551973 552036 555166 559783 559910 561960 562054 568257 568864 569820 575300 577219 577783 580166 581582 582876 583468 583501 583666 584289 584481 585519 586034 590953 592393 595035 598834 600492 600622 601071 602102 602753 603199 605652 607611 610216 615600 619439 619450 620743 622106 623551 630529 636442 639252 644697 651465 653254 656626 667226 670197 672248 688371 712475 730865 736706 742848 750477 755001 757152 758732 759365 765714 766603 771981 785568 795396 795723 797010 799394 810173 812278 825331 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.26%) |
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.