Query Metrics
7
Database Queries
7
Different statements
151.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.24 ms (82.24%) |
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 396927 401644 418024 418158 418663 419445 420432 422197 423812 423814 423837 425529 426127 433967 435734 436639 439378 443317 444839 445805 451146 452565 452906 456928 457022 460459 469150 471041 473636 473675 477149 478785 482145 484277 485277 486846 487548 488512 489797 494193 494204 499309 502630 502823 503758 505218 507895 508986 514407 517447 520578 522040 524562 526457 526544 527707 528390 539875 542090 550834 553131 555057 556573 558323 564988 577105 579381 580355 586298 588767 600125 601185 601555 602395 604190 605706 606912 612675 614612 617045 618579 626383 632090 633934 643488 651692 659981 662782 665810 666496 670853 673006 680570 701204 707545 708585 712423 714289 726549 726701 734253 739779 742671 745397 748046 749038 753051 753751 757502 760385 769567 777733 790459 790710 796096 797341 801229 803163 814464 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (11.10%) |
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 753051 760385 726701 777733 420432 502630 494193 553131 665810 701204 796096 790710 433967 486846 489797 502823 423837 418663 556573 712423 586298 749038 814464 445805 451146 528390 539875 503758 526457 579381 577105 580355 666496 651692 673006 670853 680570 708585 714289 600125 606912 626383 601555 734253 797341 741919 739779 757502 742671 707545 803163 452565 456928 473675 423812 425529 452906 508986 485277 524562 484277 482145 602395 618579 790459 769567 605706 426127 418024 488512 555057 460459 617045 457022 469150 659981 633934 522040 423814 473636 520578 588767 643488 478785 435734 527707 401644 443317 542090 564988 550834 632090 801229 748046 753751 726549 439378 477149 422197 436639 505218 499309 514407 487548 494204 517447 396927 419445 471041 507895 526544 558323 662782 614612 601185 604190 612675 745397 444839 418158 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.83%) |
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 396927 401644 418024 418158 418663 419445 420432 422197 423812 423814 423837 425529 426127 433967 435734 436639 439378 443317 444839 445805 451146 452565 452906 456928 457022 460459 469150 471041 473636 473675 477149 478785 482145 484277 485277 486846 487548 488512 489797 494193 494204 499309 502630 502823 503758 505218 507895 508986 514407 517447 520578 522040 524562 526457 526544 527707 528390 539875 542090 550834 553131 555057 556573 558323 564988 577105 579381 580355 586298 588767 600125 601185 601555 602395 604190 605706 606912 612675 614612 617045 618579 626383 632090 633934 643488 651692 659981 662782 665810 666496 670853 673006 680570 701204 707545 708585 712423 714289 726549 726701 734253 739779 742671 745397 748046 749038 753051 753751 757502 760385 769567 777733 790459 790710 796096 797341 801229 803163 814464 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbate sex"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"masturbate секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"masturbate секс"
]
|
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.