Query Metrics
7
Database Queries
7
Different statements
386.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.81 ms (54.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
154.97 ms (40.10%) |
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 397811 409227 417337 428809 437258 455614 457698 459525 460699 462297 464231 464508 469212 469332 473074 478569 478885 479241 480111 481455 482772 483902 484044 484753 487028 487464 490952 492593 493550 496003 496427 497687 500055 500897 501669 502260 504033 505109 505201 505618 506179 506604 509916 514179 515838 523776 526740 532215 535247 536840 536967 539994 541121 542345 545058 545104 545821 549178 551478 554516 558108 558519 558556 558652 558668 560000 560952 562385 565004 566296 568228 568342 568955 575286 576981 577541 577884 583064 589212 589989 592725 597634 597786 598412 599710 600941 601721 604943 606894 615427 616674 618046 618249 621163 623063 626345 628525 630116 630726 631719 632780 637959 638000 639951 644901 650875 655294 660080 660441 668771 680254 701253 714629 716841 731239 757971 761553 781246 781291 810382 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (3.56%) |
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 810382 757971 761553 601721 606894 714629 437258 504033 523776 487464 509916 397811 409227 464231 464508 484044 487028 484753 496003 500897 514179 532215 505618 536840 505201 526740 473074 551478 554516 562385 541121 545821 560952 568342 575286 576981 583064 542345 545058 566296 568955 577884 650875 660441 660080 549178 558519 558556 558668 568228 598412 599710 615427 589989 639951 626345 631719 589212 597634 597786 616674 618249 621163 623063 637959 781291 781246 731239 618046 632780 638000 701253 462297 469332 469212 460699 478885 417337 479241 481455 455614 505109 501669 502260 500055 515838 457698 459525 478569 536967 506179 535247 558108 565004 577541 558652 560000 655294 668771 680254 592725 604943 600941 628525 630116 630726 716841 490952 496427 428809 644901 545104 539994 483902 482772 480111 492593 493550 497687 506604 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (0.79%) |
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 397811 409227 417337 428809 437258 455614 457698 459525 460699 462297 464231 464508 469212 469332 473074 478569 478885 479241 480111 481455 482772 483902 484044 484753 487028 487464 490952 492593 493550 496003 496427 497687 500055 500897 501669 502260 504033 505109 505201 505618 506179 506604 509916 514179 515838 523776 526740 532215 535247 536840 536967 539994 541121 542345 545058 545104 545821 549178 551478 554516 558108 558519 558556 558652 558668 560000 560952 562385 565004 566296 568228 568342 568955 575286 576981 577541 577884 583064 589212 589989 592725 597634 597786 598412 599710 600941 601721 604943 606894 615427 616674 618046 618249 621163 623063 626345 628525 630116 630726 631719 632780 637959 638000 639951 644901 650875 655294 660080 660441 668771 680254 701253 714629 716841 731239 757971 761553 781246 781291 810382 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"телефон секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"telephone sex"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.39%) |
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.