Query Metrics
7
Database Queries
7
Different statements
186.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.47 ms (85.29%) |
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 185563 185820 205147 282864 357943 367863 385538 389165 390112 390178 390731 391064 401492 404053 405088 405224 406404 408043 409630 409646 415934 417022 420753 427219 430285 447357 447548 449254 451001 451892 453697 464634 484355 489606 493031 493814 494392 494771 497029 499834 501799 504681 505042 507129 507165 509675 510049 511931 512593 519848 520726 521918 526824 531725 545809 551360 551386 551741 557337 560101 560136 564631 569824 573930 574902 578437 578493 580372 584200 587879 592054 596618 600628 606637 606809 608071 610365 620105 621418 623327 636798 636836 641663 643835 653250 654331 663371 679702 681411 684572 689591 711057 714471 720535 722896 727394 727454 728067 732379 740007 740485 744475 747372 747376 757977 773024 782420 785711 793591 794425 799956 800069 803595 811675 813949 817702 817734 818390 822737 825704 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (9.57%) |
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 447548 494771 587879 185563 610365 608071 643835 409630 681411 654331 636836 606809 811675 727394 740007 740485 747372 722896 390178 408043 569824 684572 711057 621418 782420 727454 641663 799956 800069 531725 592054 484355 526824 507165 519848 409646 551360 405224 501799 497029 499834 185820 653250 390112 449254 406404 813949 714471 803595 744475 757977 728067 793591 451001 507129 584200 489606 453697 817702 391064 578493 679702 560136 494392 794425 825704 390731 578437 636798 357943 560101 606637 401492 415934 509675 447357 573930 427219 505042 205147 282864 557337 689591 551386 574902 600628 773024 620105 404053 822737 817734 818390 663371 747376 367863 405088 512593 732379 493031 551741 580372 720535 623327 785711 417022 493814 521918 389165 545809 564631 420753 511931 520726 596618 430285 451892 504681 464634 385538 510049 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.47%) |
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 185563 185820 205147 282864 357943 367863 385538 389165 390112 390178 390731 391064 401492 404053 405088 405224 406404 408043 409630 409646 415934 417022 420753 427219 430285 447357 447548 449254 451001 451892 453697 464634 484355 489606 493031 493814 494392 494771 497029 499834 501799 504681 505042 507129 507165 509675 510049 511931 512593 519848 520726 521918 526824 531725 545809 551360 551386 551741 557337 560101 560136 564631 569824 573930 574902 578437 578493 580372 584200 587879 592054 596618 600628 606637 606809 608071 610365 620105 621418 623327 636798 636836 641663 643835 653250 654331 663371 679702 681411 684572 689591 711057 714471 720535 722896 727394 727454 728067 732379 740007 740485 744475 747372 747376 757977 773024 782420 785711 793591 794425 799956 800069 803595 811675 813949 817702 817734 818390 822737 825704 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage oil sex"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж масл секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
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.