Query Metrics
7
Database Queries
7
Different statements
175.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.99 ms (83.67%) |
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 382355 396358 396609 401842 404459 407357 411747 414357 416098 417999 419483 419854 426405 428387 428392 428415 429766 447124 453473 455085 458916 459488 463073 464704 466552 467583 468637 472341 473735 475630 476143 478534 478930 493197 496060 510463 511318 511810 516767 516770 516781 517609 517869 520217 522381 522903 523948 524213 527464 531170 532101 532783 533339 534993 536292 536640 537113 537196 537906 540053 542591 543392 544640 548577 552703 556421 557526 564078 565101 565355 565373 568307 568309 572027 575441 583724 583901 589345 590149 591612 600293 600346 605453 610290 613566 619577 630915 633753 634156 634793 636286 640716 640723 645327 646875 646920 648855 648867 649110 649188 650333 650774 651204 666575 674414 677827 720245 732316 761004 765604 788132 792554 806087 808077 808757 811506 813152 815330 827850 827855 ] |
||||||||||||||||||||||||||||||
|
19.06 ms (10.85%) |
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 537113 537196 511318 516781 533339 537906 540053 527464 536292 536640 464704 478930 583901 542591 544640 556421 564078 646920 650333 677827 720245 649110 645327 649188 666575 600293 634156 640723 590149 610290 636286 589345 634793 808757 811506 732316 761004 396358 428415 401842 407357 516770 511810 523948 827855 827850 411747 419854 429766 467583 468637 476143 478534 493197 517609 520217 531170 532101 516767 575441 548577 583724 543392 565373 568307 648867 619577 600346 605453 792554 808077 458916 382355 472341 419483 447124 428387 428392 522903 591612 404459 815330 463073 532783 534993 496060 568309 648855 651204 646875 565355 630915 788132 806087 417999 466552 453473 522381 426405 552703 565101 674414 813152 765604 396609 640716 455085 475630 510463 414357 459488 572027 557526 473735 416098 650774 613566 633753 517869 524213 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.42%) |
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 382355 396358 396609 401842 404459 407357 411747 414357 416098 417999 419483 419854 426405 428387 428392 428415 429766 447124 453473 455085 458916 459488 463073 464704 466552 467583 468637 472341 473735 475630 476143 478534 478930 493197 496060 510463 511318 511810 516767 516770 516781 517609 517869 520217 522381 522903 523948 524213 527464 531170 532101 532783 533339 534993 536292 536640 537113 537196 537906 540053 542591 543392 544640 548577 552703 556421 557526 564078 565101 565355 565373 568307 568309 572027 575441 583724 583901 589345 590149 591612 600293 600346 605453 610290 613566 619577 630915 633753 634156 634793 636286 640716 640723 645327 646875 646920 648855 648867 649110 649188 650333 650774 651204 666575 674414 677827 720245 732316 761004 765604 788132 792554 806087 808077 808757 811506 813152 815330 827850 827855 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро bbc"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome bbc"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро bbc"
]
|
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.