Query Metrics
7
Database Queries
7
Different statements
145.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.12 ms (83.47%) |
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 395273 396286 414103 416634 417172 418669 418817 427737 434946 435503 435724 438686 440943 441656 441702 448126 449687 449956 450529 450969 451661 453390 453504 455947 455967 456948 459046 459761 459871 463688 464849 464975 465731 467680 471830 475118 478141 479469 480004 480187 484720 485347 487534 490270 493453 494094 495337 500240 500338 501451 503444 505423 506356 508047 512163 513318 518787 519360 519878 521665 522474 523981 526291 527177 529427 538309 547142 555468 555643 558545 560671 560749 565866 567397 567908 572203 576045 577953 581306 581442 587300 587312 588436 589607 590106 591622 592362 592961 593259 595328 596260 598141 604909 607666 617441 619792 620323 627121 661054 684660 699916 730994 732648 738625 741578 748521 749150 756252 770387 775015 785074 786398 793073 795377 804554 805366 807595 812704 814981 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (10.52%) |
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 604909 587312 604621 627121 587300 592362 588436 590106 598141 617441 738625 749150 770387 775015 793073 435724 453390 464849 464975 440943 459761 449687 450529 526291 493453 522474 395273 396286 414103 435503 814981 455967 459871 487534 538309 500240 480187 560749 572203 555643 560671 577953 547142 576045 589607 593259 807595 795377 804554 732648 756252 730994 748521 741578 699916 785074 786398 427737 438686 455947 451661 448126 449956 479469 508047 519360 518787 529427 484720 490270 513318 465731 471830 467680 417172 456948 478141 503444 805366 453504 418817 485347 506356 505423 416634 555468 523981 567908 596260 595328 463688 450969 527177 500338 581306 558545 565866 661054 684660 567397 581442 591622 592961 607666 620323 619792 812704 441656 459046 475118 418669 480004 501451 521665 494094 495337 512163 519878 434946 441702 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.66%) |
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 395273 396286 414103 416634 417172 418669 418817 427737 434946 435503 435724 438686 440943 441656 441702 448126 449687 449956 450529 450969 451661 453390 453504 455947 455967 456948 459046 459761 459871 463688 464849 464975 465731 467680 471830 475118 478141 479469 480004 480187 484720 485347 487534 490270 493453 494094 495337 500240 500338 501451 503444 505423 506356 508047 512163 513318 518787 519360 519878 521665 522474 523981 526291 527177 529427 538309 547142 555468 555643 558545 560671 560749 565866 567397 567908 572203 576045 577953 581306 581442 587300 587312 588436 589607 590106 591622 592362 592961 593259 595328 596260 598141 604909 607666 617441 619792 620323 627121 661054 684660 699916 730994 732648 738625 741578 748521 749150 756252 770387 775015 785074 786398 793073 795377 804554 805366 807595 812704 814981 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ride amateur"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ride любительск"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ride любительск"
]
|
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.