Query Metrics
7
Database Queries
7
Different statements
194.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.47 ms (86.73%) |
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 391926 420538 439608 442573 458797 462031 470989 471061 471713 473244 480476 481441 485453 485878 488920 491219 491767 497666 498943 502318 503733 504358 504574 505530 505988 507440 507714 508272 508378 511927 512819 512902 513087 513146 514396 516996 518953 519800 519801 520678 521493 522114 522561 524970 525374 525746 527287 527572 527574 527859 528128 528952 528958 529065 530307 530578 532300 532334 533124 533969 534581 535309 538263 538454 539634 539942 544857 548614 550361 553299 554219 554506 557190 557512 557912 560088 562456 564275 565126 565977 566071 567176 568699 570845 572276 574145 575541 577637 577875 577912 585473 586157 587196 589680 590888 590919 592345 592617 595514 601278 604783 604887 605250 613850 619484 619809 621661 633450 642409 645893 661264 667253 667880 673244 673314 680992 684060 684298 685982 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (7.67%) |
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 471061 470989 491219 473244 505530 511927 513087 522114 524970 530578 532334 533969 534581 525746 532300 497666 502318 516996 538263 504358 507440 527287 530307 488920 554219 565126 570845 572276 575541 577637 544857 557190 566071 577912 557912 564275 574145 577875 667880 673314 680992 684298 645893 667253 673244 684060 685982 661264 557512 568699 601278 604887 613850 619809 642409 589680 590919 595514 633450 586157 587196 592345 604783 605250 585473 590888 592617 621661 619484 420538 462031 391926 439608 508378 514396 527859 485878 512819 519801 485453 507714 442573 458797 480476 491767 503733 505988 508272 512902 521493 525374 529065 533124 535309 504574 510295 513146 519800 520678 522561 527574 528952 538454 518953 539942 498943 527572 528128 528958 539634 471713 481441 548614 550361 553299 554506 560088 562456 565977 567176 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.02%) |
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 391926 420538 439608 442573 458797 462031 470989 471061 471713 473244 480476 481441 485453 485878 488920 491219 491767 497666 498943 502318 503733 504358 504574 505530 505988 507440 507714 508272 508378 511927 512819 512902 513087 513146 514396 516996 518953 519800 519801 520678 521493 522114 522561 524970 525374 525746 527287 527572 527574 527859 528128 528952 528958 529065 530307 530578 532300 532334 533124 533969 534581 535309 538263 538454 539634 539942 544857 548614 550361 553299 554219 554506 557190 557512 557912 560088 562456 564275 565126 565977 566071 567176 568699 570845 572276 574145 575541 577637 577875 577912 585473 586157 587196 589680 590888 590919 592345 592617 595514 601278 604783 604887 605250 613850 619484 619809 621661 633450 642409 645893 661264 667253 667880 673244 673314 680992 684060 684298 685982 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в юбк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в юбки"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в юбк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.