Query Metrics
7
Database Queries
7
Different statements
174.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.27 ms (83.37%) |
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 395704 411701 419459 421569 446182 446786 450886 457306 459072 466533 467179 470472 476553 484686 493553 498036 500524 504895 505579 506495 513283 516500 523517 524510 532399 536828 537840 541481 544975 548879 551559 556455 563690 570901 571659 577735 581410 587211 589400 592608 593151 596189 596941 601320 602942 605247 607922 610193 614627 620338 620818 620838 624420 624421 625878 631609 635856 639252 646228 646876 646880 662385 662592 672330 675634 683696 686807 693554 695901 696178 704029 706006 712526 720923 721109 722401 725307 727667 740671 756952 758667 760439 760920 772573 774912 778243 779310 780803 781859 782512 783998 784117 784200 786048 787309 790812 791352 795761 801305 802503 802734 802750 805171 805942 809455 809496 809845 810402 810772 812604 813491 814103 814252 814968 815591 817716 821193 822986 824749 824870 ] |
||||||||||||||||||||||||||||||
|
18.07 ms (10.37%) |
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 720923 551559 601320 620838 587211 810772 774912 805942 809496 727667 787309 756952 772573 758667 620818 721109 802734 459072 446786 457306 476553 523517 484686 504895 470472 589400 421569 498036 395704 419459 411701 824870 814968 815591 824749 814103 817716 821193 822986 814252 493553 446182 450886 466533 500524 532399 505579 506495 524510 513283 516500 536828 537840 467179 581410 541481 544975 646228 646880 672330 675634 686807 706006 646876 662385 662592 695901 704029 683696 693554 696178 712526 722401 548879 556455 563690 570901 571659 577735 614627 631609 602942 620338 624420 635856 639252 592608 596189 596941 607922 610193 624421 593151 605247 625878 778243 779310 781859 782512 783998 784117 784200 790812 791352 795761 805171 812604 813491 780803 786048 801305 802503 802750 809455 809845 810402 725307 740671 760439 760920 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (2.11%) |
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 395704 411701 419459 421569 446182 446786 450886 457306 459072 466533 467179 470472 476553 484686 493553 498036 500524 504895 505579 506495 513283 516500 523517 524510 532399 536828 537840 541481 544975 548879 551559 556455 563690 570901 571659 577735 581410 587211 589400 592608 593151 596189 596941 601320 602942 605247 607922 610193 614627 620338 620818 620838 624420 624421 625878 631609 635856 639252 646228 646876 646880 662385 662592 672330 675634 683696 686807 693554 695901 696178 704029 706006 712526 720923 721109 722401 725307 727667 740671 756952 758667 760439 760920 772573 774912 778243 779310 780803 781859 782512 783998 784117 784200 786048 787309 790812 791352 795761 801305 802503 802734 802750 805171 805942 809455 809496 809845 810402 810772 812604 813491 814103 814252 814968 815591 817716 821193 822986 824749 824870 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red panties"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red трусик нижн бел"
]
|
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.