Query Metrics
7
Database Queries
7
Different statements
156.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.30 ms (83.28%) |
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 511388 519246 538847 538856 538930 538935 538960 539516 541398 541402 542471 542489 544307 544483 544496 544502 544586 546153 547980 548277 549307 549784 554804 556777 557993 560085 560958 561993 563152 563184 563201 563203 563212 563433 563435 564565 565227 566399 567751 572543 572548 573911 574237 574257 574263 574291 576669 576671 576699 576705 581281 581386 583079 583827 583872 589640 592390 592419 592462 592526 592636 593514 598407 603200 606290 606417 610310 612413 615737 620140 620154 621700 623934 644643 644894 644922 648463 649956 653450 654092 665751 668154 670062 670090 670274 671749 671758 671878 672122 673497 674119 677740 690783 690822 691518 692103 692258 692265 694023 695191 695196 695923 696240 696350 698548 703040 703109 703540 705295 708435 714504 719059 724135 727436 735919 772554 772574 791002 807976 811492 ] |
||||||||||||||||||||||||||||||
|
16.57 ms (10.59%) |
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 563435 583872 592526 772574 772554 549784 544586 593514 542471 583079 620154 598407 564565 574263 554804 566399 574257 563203 560085 538960 539516 538930 538935 556777 583827 544307 541402 549307 565227 648463 649956 692258 695196 695923 703040 694023 698548 705295 665751 677740 695191 563433 606417 621700 592419 620140 603200 615737 791002 811492 727436 724135 735919 703109 714504 544502 567751 563184 690783 589640 644922 572548 563212 671749 672122 703540 563201 592462 623934 606290 644643 807976 519246 574291 612413 576699 573911 576669 560958 581281 544483 544496 557993 574237 576705 581386 690822 670274 546153 548277 561993 563152 572543 592390 610310 592636 511388 541398 644894 538856 538847 542489 547980 576671 671758 691518 692103 696240 696350 708435 719059 668154 653450 654092 670062 670090 671878 673497 674119 692265 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.61%) |
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 511388 519246 538847 538856 538930 538935 538960 539516 541398 541402 542471 542489 544307 544483 544496 544502 544586 546153 547980 548277 549307 549784 554804 556777 557993 560085 560958 561993 563152 563184 563201 563203 563212 563433 563435 564565 565227 566399 567751 572543 572548 573911 574237 574257 574263 574291 576669 576671 576699 576705 581281 581386 583079 583827 583872 589640 592390 592419 592462 592526 592636 593514 598407 603200 606290 606417 610310 612413 615737 620140 620154 621700 623934 644643 644894 644922 648463 649956 653450 654092 665751 668154 670062 670090 670274 671749 671758 671878 672122 673497 674119 677740 690783 690822 691518 692103 692258 692265 694023 695191 695196 695923 696240 696350 698548 703040 703109 703540 705295 708435 714504 719059 724135 727436 735919 772554 772574 791002 807976 811492 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings vintage"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел vintage"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел vintage"
]
|
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.