Query Metrics
7
Database Queries
7
Different statements
143.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.37 ms (83.02%) |
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 95991 382434 389519 400513 407903 411321 411356 411394 421823 421835 421884 422154 422187 423777 428883 429333 429598 438455 439787 444140 444888 445390 450657 451030 451477 451494 456328 456408 459790 460728 460762 463458 464303 466893 467489 467503 469199 469277 469372 476013 476776 479928 480988 481186 481316 481451 484123 485297 486340 487656 488128 490436 490948 491914 492057 492507 493228 494015 495239 495256 496028 502755 504055 504635 506693 506894 507412 511152 512030 513616 515343 516550 516658 516835 517798 518598 519582 524446 524520 528476 528620 536457 540977 542987 546783 547617 547754 549849 551652 552799 553003 554233 554261 557032 558505 563057 563154 563400 566997 567072 570328 570626 573113 573451 581925 582068 582587 590573 605364 609071 611422 613356 622302 624876 686573 730688 750756 778699 789925 794665 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (10.63%) |
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 464303 516658 491914 496028 488128 493228 494015 515343 546783 573113 542987 554233 553003 570626 551652 566997 609071 789925 730688 476776 481451 423777 451477 400513 407903 481316 451030 490948 506894 517798 502755 487656 528476 570328 686573 563154 778699 750756 429333 459790 460762 563400 411394 450657 513616 495256 582068 492057 95991 567072 495239 422154 421884 439787 554261 557032 558505 563057 582587 552799 549849 547617 573451 605364 622302 624876 421823 460728 466893 429598 467489 480988 421835 444888 445390 469372 456328 463458 481186 422187 476013 512030 536457 484123 524446 506693 485297 492507 516550 516835 524520 528620 540977 794665 469277 581925 611422 444140 451494 479928 438455 504055 507412 467503 511152 519582 490436 518598 547754 613356 590573 382434 428883 469199 411321 456408 389519 411356 504635 486340 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.67%) |
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 95991 382434 389519 400513 407903 411321 411356 411394 421823 421835 421884 422154 422187 423777 428883 429333 429598 438455 439787 444140 444888 445390 450657 451030 451477 451494 456328 456408 459790 460728 460762 463458 464303 466893 467489 467503 469199 469277 469372 476013 476776 479928 480988 481186 481316 481451 484123 485297 486340 487656 488128 490436 490948 491914 492057 492507 493228 494015 495239 495256 496028 502755 504055 504635 506693 506894 507412 511152 512030 513616 515343 516550 516658 516835 517798 518598 519582 524446 524520 528476 528620 536457 540977 542987 546783 547617 547754 549849 551652 552799 553003 554233 554261 557032 558505 563057 563154 563400 566997 567072 570328 570626 573113 573451 581925 582068 582587 590573 605364 609071 611422 613356 622302 624876 686573 730688 750756 778699 789925 794665 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская красное белье…"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск красн бел"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.96%) |
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.