Query Metrics
7
Database Queries
7
Different statements
374.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.87 ms (55.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy brunette"
]
|
||||||||||||||||||||||||||||||
|
140.64 ms (37.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 287315 381838 390320 402093 402664 403736 403891 410452 411685 415552 417435 418559 419979 420131 420142 421795 428616 428710 429288 429747 431604 434006 435948 441454 445387 447551 451050 451624 453719 454756 455632 455922 457092 457202 461036 461037 464548 465154 466142 466405 470145 478663 479469 480788 484762 485461 490272 492841 494418 494720 495023 496682 497034 500197 501801 507452 509060 515004 518061 519520 522835 526197 554079 569498 572556 576545 581520 587058 589349 591003 594293 595088 598261 599105 602314 603702 604904 605758 608038 615031 625169 626119 630777 630871 643488 646022 654174 660359 668398 669071 670366 670372 674941 695868 705669 710638 716459 719141 731371 732323 742281 748257 756230 757365 758133 759870 759948 761598 765298 780475 780595 796129 797437 799190 801974 803784 810408 810983 814790 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (4.59%) |
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 669071 695868 705669 719141 670366 670372 674941 646022 654174 660359 710638 554079 569498 572556 576545 581520 591003 598261 602314 589349 599105 604621 625169 643488 594293 595088 603702 604904 605758 626119 630777 587058 608038 630871 780475 780595 803784 759948 761598 765298 796129 810408 810983 731371 758133 759870 742281 756230 732323 748257 757365 615031 716459 797437 799190 801974 420131 435948 454756 464548 287315 421795 431604 466142 480788 381838 410452 457202 466405 470145 390320 402664 403736 420142 429288 451050 478663 479469 447551 451624 457092 465154 500197 501801 507452 522835 492841 515004 485461 494720 496682 509060 490272 494418 495023 497034 518061 526197 668398 455922 402093 403891 428616 429747 441454 415552 428710 417435 411685 419979 434006 418559 445387 814790 453719 461037 455632 461036 484762 519520 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (0.98%) |
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 287315 381838 390320 402093 402664 403736 403891 410452 411685 415552 417435 418559 419979 420131 420142 421795 428616 428710 429288 429747 431604 434006 435948 441454 445387 447551 451050 451624 453719 454756 455632 455922 457092 457202 461036 461037 464548 465154 466142 466405 470145 478663 479469 480788 484762 485461 490272 492841 494418 494720 495023 496682 497034 500197 501801 507452 509060 515004 518061 519520 522835 526197 554079 569498 572556 576545 581520 587058 589349 591003 594293 595088 598261 599105 602314 603702 604904 605758 608038 615031 625169 626119 630777 630871 643488 646022 654174 660359 668398 669071 670366 670372 674941 695868 705669 710638 716459 719141 731371 732323 742281 748257 756230 757365 758133 759870 759948 761598 765298 780475 780595 796129 797437 799190 801974 803784 810408 810983 814790 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.