Query Metrics
7
Database Queries
7
Different statements
254.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
228.35 ms (89.56%) |
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 65580 404455 415942 419535 420615 422732 423480 436091 441768 449358 449697 452261 453426 453569 453764 453770 454395 455149 455762 456813 456829 458331 459042 461737 464157 464584 464918 467449 468407 471413 474743 477514 478076 478255 478652 479637 480503 480862 482690 482900 487628 488131 490218 490672 491322 493218 493349 494074 495121 495679 496780 499084 501048 506073 506258 507524 510043 510238 510783 510881 511076 511936 511951 512231 512463 515450 515862 516208 516742 516870 517131 519085 519531 520668 521429 522037 522569 524578 524597 525781 529170 529256 529558 534702 537035 538936 543181 543191 543773 545889 552387 552799 559191 559552 560206 564064 565178 565936 570048 571042 572927 579940 579943 582270 585216 586632 588449 589129 589140 589647 591242 591387 599458 608497 625826 626564 647027 669175 675797 813067 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (6.13%) |
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 499084 510043 520668 537035 538936 494074 495121 516208 516742 519531 464918 468407 480503 545889 559191 570048 572927 543773 552799 564064 565178 543191 559552 565936 571042 647027 669175 675797 552387 560206 579940 579943 582270 586632 589140 589647 591387 608497 585216 589129 588449 591242 599458 626564 625826 813067 441768 453426 453764 453770 456829 458331 464157 471413 420615 478255 480862 404455 436091 455149 455762 456813 461737 464584 474743 415942 419535 423480 449358 459042 467449 478652 449697 477514 478076 510238 515862 487628 488131 493349 495679 496780 501048 506073 511936 511951 522037 525781 529170 482900 491322 493218 510783 510881 512231 512463 521429 522569 524578 524597 529256 490672 506258 507524 511076 515450 516870 517131 519085 529558 534702 65580 422732 543181 482690 454395 479637 490218 452261 453569 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.20%) |
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 65580 404455 415942 419535 420615 422732 423480 436091 441768 449358 449697 452261 453426 453569 453764 453770 454395 455149 455762 456813 456829 458331 459042 461737 464157 464584 464918 467449 468407 471413 474743 477514 478076 478255 478652 479637 480503 480862 482690 482900 487628 488131 490218 490672 491322 493218 493349 494074 495121 495679 496780 499084 501048 506073 506258 507524 510043 510238 510783 510881 511076 511936 511951 512231 512463 515450 515862 516208 516742 516870 517131 519085 519531 520668 521429 522037 522569 524578 524597 525781 529170 529256 529558 534702 537035 538936 543181 543191 543773 545889 552387 552799 559191 559552 560206 564064 565178 565936 570048 571042 572927 579940 579943 582270 585216 586632 588449 589129 589140 589647 591242 591387 599458 608497 625826 626564 647027 669175 675797 813067 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кругл"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кругл"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.