Query Metrics
7
Database Queries
7
Different statements
165.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.88 ms (84.63%) |
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 392404 410308 428849 429419 436393 437597 444134 444717 445187 448781 453870 459614 463710 465972 469753 475032 477823 478123 478125 478129 480510 480705 486892 487428 491188 492332 492758 493113 495292 495670 496968 499707 500391 502967 505634 506093 508750 511545 511677 513091 513501 516012 519055 520456 521093 522355 523773 524436 529456 531412 533256 534040 535427 536525 536819 537424 542002 542600 542959 547561 548227 552539 556574 560063 562275 562277 562708 564688 567365 567860 568643 570013 571219 571706 571932 572322 572445 572523 573674 578817 584793 585328 591219 591380 601194 604726 605872 613239 613365 637522 639252 649964 651611 668437 677357 678166 687431 693246 710343 717620 720743 754160 778471 778994 780030 783235 784755 786359 787896 794091 801026 802120 804982 805242 806842 806919 812573 816755 816963 821044 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (9.24%) |
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 477823 480705 469753 444134 465972 478125 487428 493113 495292 500391 492332 492758 502967 513501 521093 524436 529456 491188 522355 571706 560063 568643 436393 445187 410308 429419 556574 584793 567365 552539 567860 585328 591380 591219 437597 480510 444717 478123 392404 459614 478129 505634 511545 520456 523773 536819 513091 496968 499707 511677 486892 495670 448781 506093 519055 677357 428849 816963 821044 816755 463710 453870 475032 533256 516012 536525 508750 531412 537424 534040 535427 542002 562277 571932 572322 542600 562275 562708 572445 572523 573674 542959 548227 578817 649964 668437 693246 717620 651611 720743 678166 687431 710343 547561 564688 570013 571219 637522 639252 604726 613239 601194 605872 613365 778471 778994 784755 804982 805242 806919 780030 783235 786359 787896 794091 801026 802120 806842 812573 754160 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.74%) |
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 392404 410308 428849 429419 436393 437597 444134 444717 445187 448781 453870 459614 463710 465972 469753 475032 477823 478123 478125 478129 480510 480705 486892 487428 491188 492332 492758 493113 495292 495670 496968 499707 500391 502967 505634 506093 508750 511545 511677 513091 513501 516012 519055 520456 521093 522355 523773 524436 529456 531412 533256 534040 535427 536525 536819 537424 542002 542600 542959 547561 548227 552539 556574 560063 562275 562277 562708 564688 567365 567860 568643 570013 571219 571706 571932 572322 572445 572523 573674 578817 584793 585328 591219 591380 601194 604726 605872 613239 613365 637522 639252 649964 651611 668437 677357 678166 687431 693246 710343 717620 720743 754160 778471 778994 780030 783235 784755 786359 787896 794091 801026 802120 804982 805242 806842 806919 812573 816755 816963 821044 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красотки в колготках %…"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая колготк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.89%) |
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.