Query Metrics
7
Database Queries
7
Different statements
204.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.60 ms (87.15%) |
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 417338 422187 425654 425821 435735 436758 443744 448282 455596 458029 458574 459954 461394 461788 464481 467174 467999 468969 468982 472674 473572 475603 478753 479359 479391 479405 479410 481428 481846 482933 483227 483320 485429 492651 493191 493311 493882 493997 494680 496357 497670 499230 499695 501912 503920 504163 504328 506441 510033 513377 517185 517538 517599 519101 521076 521504 523635 526967 528671 541007 542764 542980 546609 555663 557226 564440 565757 566449 568377 570086 577400 580090 580666 581118 584016 585397 587930 589486 592056 596518 599588 605287 605654 609712 610054 613434 615660 618129 618685 619713 623193 624662 625140 625142 626331 628527 632508 632715 642177 653795 655498 657777 660070 674620 690658 691373 696178 709298 721241 721883 721935 746021 748676 759570 766453 774306 779624 788007 788063 811876 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (7.90%) |
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 605654 479391 479410 481428 494680 481846 468982 517538 493882 625142 619713 623193 468969 478753 425654 499230 501912 506441 482933 485429 496357 655498 691373 458574 492651 517185 467174 565757 568377 660070 690658 546609 584016 587930 618685 624662 585397 605287 613434 618129 626331 628527 788007 766453 774306 746021 709298 721883 513377 473572 493311 580666 632715 521504 435735 589486 455596 436758 448282 425821 483227 479359 479405 497670 528671 542764 555663 564440 566449 541007 674620 721935 653795 657777 696178 721241 580090 592056 596518 609712 599588 615660 642177 788063 811876 748676 759570 610054 779624 458029 467999 475603 504328 519101 503920 510033 523635 632508 443744 459954 526967 581118 570086 461394 461788 464481 422187 517599 521076 493191 493997 499695 542980 472674 483320 577400 557226 625140 417338 504163 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.70%) |
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 417338 422187 425654 425821 435735 436758 443744 448282 455596 458029 458574 459954 461394 461788 464481 467174 467999 468969 468982 472674 473572 475603 478753 479359 479391 479405 479410 481428 481846 482933 483227 483320 485429 492651 493191 493311 493882 493997 494680 496357 497670 499230 499695 501912 503920 504163 504328 506441 510033 513377 517185 517538 517599 519101 521076 521504 523635 526967 528671 541007 542764 542980 546609 555663 557226 564440 565757 566449 568377 570086 577400 580090 580666 581118 584016 585397 587930 589486 592056 596518 599588 605287 605654 609712 610054 613434 615660 618129 618685 619713 623193 624662 625140 625142 626331 628527 632508 632715 642177 653795 655498 657777 660070 674620 690658 691373 696178 709298 721241 721883 721935 746021 748676 759570 766453 774306 779624 788007 788063 811876 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ванная скрытая камера"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван скрыт камер"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.69%) |
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.