Query Metrics
7
Database Queries
7
Different statements
157.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.07 ms (82.18%) |
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 386627 391150 399909 405860 414067 414104 417474 418741 421594 422662 423505 426127 427656 429759 437518 442855 443012 443024 444690 444802 444923 445444 446509 447040 448604 449970 451331 451715 453214 457346 458473 458883 459195 459334 462153 464670 464874 465516 466369 468658 468818 471672 472536 475805 476649 477488 477775 477892 479255 479584 479654 482583 482919 482929 483416 483780 487633 492677 495648 495709 500518 502497 506876 509673 511309 512111 514568 518173 519168 519595 519685 521607 521633 521643 522349 524180 524359 525785 525811 526544 528609 529359 529757 533124 539471 543022 543204 550451 552081 553251 557955 558654 559315 560062 560684 560917 563595 565287 565824 566593 567253 572530 576848 579419 580791 581220 581750 584812 586959 589942 598370 598388 609564 647430 662405 689750 695146 707688 827523 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (10.76%) |
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 446509 423505 426127 468818 399909 443012 444802 444923 448604 457346 471672 479255 422662 451331 453214 458473 459334 477488 500518 518173 521643 524180 502497 509673 522349 525811 482929 483416 529359 483780 492677 521607 524359 528609 429759 466369 476649 386627 391150 405860 414104 417474 418741 427656 437518 444690 421594 443024 414067 442855 827523 447040 449970 451715 462153 468658 479584 482583 445444 459195 477775 479654 482919 458883 464670 464874 465516 477892 487633 512111 533124 495709 511309 519595 519685 539471 495648 521633 525785 529757 506876 514568 519168 526544 472536 475805 543022 550451 553251 558654 559315 565287 579419 580791 543204 560062 560684 563595 567253 581220 584812 552081 557955 565824 581750 647430 695146 689750 662405 707688 560917 566593 572530 576848 586959 598388 598370 609564 589942 636661 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (2.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 386627 391150 399909 405860 414067 414104 417474 418741 421594 422662 423505 426127 427656 429759 437518 442855 443012 443024 444690 444802 444923 445444 446509 447040 448604 449970 451331 451715 453214 457346 458473 458883 459195 459334 462153 464670 464874 465516 466369 468658 468818 471672 472536 475805 476649 477488 477775 477892 479255 479584 479654 482583 482919 482929 483416 483780 487633 492677 495648 495709 500518 502497 506876 509673 511309 512111 514568 518173 519168 519595 519685 521607 521633 521643 522349 524180 524359 525785 525811 526544 528609 529359 529757 533124 539471 543022 543204 550451 552081 553251 557955 558654 559315 560062 560684 560917 563595 565287 565824 566593 567253 572530 576848 579419 580791 581220 581750 584812 586959 589942 598370 598388 609564 647430 662405 689750 695146 707688 827523 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe webcam"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe вебкамер"
]
|
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.