Query Metrics
7
Database Queries
7
Different statements
407.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.99 ms (50.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
176.52 ms (43.32%) |
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 16851 82091 166675 382432 393999 395332 398992 399152 401052 402060 405048 409613 412460 413938 417800 419320 420324 420849 421412 423243 426672 428095 431963 432745 432955 434992 438767 439685 439759 440441 440749 440805 440867 440902 441342 443038 443392 443801 443951 445719 445721 445760 445992 447094 449190 450160 452364 453316 453381 455645 458230 459073 461867 462569 462658 463312 464251 465348 465381 465540 469716 470609 470810 471554 474645 474801 477903 478146 479956 481644 482639 490155 490968 491374 492135 492289 493168 497096 497236 497544 497584 498900 505039 505578 509230 509271 509609 513176 517832 518589 521927 523740 525439 526393 543839 549648 551281 552211 553708 554723 564557 589674 601444 602554 636951 661991 682877 701917 705691 719456 723077 727330 746235 761088 765347 788007 791463 794396 799145 807982 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (3.87%) |
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 553708 549648 682877 705691 723077 661991 791463 727330 719456 794396 799145 807982 393999 445992 405048 434992 465540 453316 462658 498900 509271 505578 419320 439759 523740 428095 443392 412460 440441 449190 455645 447094 474645 525439 509609 497236 551281 601444 761088 16851 417800 438767 465348 479956 431963 439685 443801 465381 443951 518589 490968 505039 521927 492289 497096 497544 497584 517832 166675 395332 440749 441342 440902 482639 445721 450160 453381 459073 461867 478146 445719 452364 458230 469716 471554 481644 493168 552211 554723 543839 701917 564557 602554 636951 788007 765347 746235 402060 426672 477903 382432 399152 409613 445760 470609 421412 440805 464251 470810 474801 463312 509230 491374 513176 492135 526393 490155 462569 589674 82091 398992 401052 420849 423243 432955 440867 443038 413938 420324 432745 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (0.66%) |
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 16851 82091 166675 382432 393999 395332 398992 399152 401052 402060 405048 409613 412460 413938 417800 419320 420324 420849 421412 423243 426672 428095 431963 432745 432955 434992 438767 439685 439759 440441 440749 440805 440867 440902 441342 443038 443392 443801 443951 445719 445721 445760 445992 447094 449190 450160 452364 453316 453381 455645 458230 459073 461867 462569 462658 463312 464251 465348 465381 465540 469716 470609 470810 471554 474645 474801 477903 478146 479956 481644 482639 490155 490968 491374 492135 492289 493168 497096 497236 497544 497584 498900 505039 505578 509230 509271 509609 513176 517832 518589 521927 523740 525439 526393 543839 549648 551281 552211 553708 554723 564557 589674 601444 602554 636951 661991 682877 701917 705691 719456 723077 727330 746235 761088 765347 788007 791463 794396 799145 807982 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real boy"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real парен"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real парен"
]
|
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.