Query Metrics
7
Database Queries
7
Different statements
179.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.83 ms (84.46%) |
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 400912 408994 417414 418740 419855 422233 424608 427601 427970 432157 433745 434676 436139 443572 445814 446709 447340 447484 447800 448439 451854 454683 459497 459813 463867 465158 465171 474378 474553 475089 480960 482913 483551 487916 488282 491457 491650 492573 493873 497096 497338 498468 499378 499668 499771 501960 503152 503870 506299 508457 514400 514951 515205 517727 519794 523752 524003 524021 525267 525748 527443 527994 532252 537821 538340 544368 545539 548984 551199 552311 552919 554001 554426 555814 560019 560442 560835 563464 564001 564010 567196 567883 569268 569559 571024 571724 573917 576990 577978 580855 581967 582848 584915 586601 586695 587965 588190 588989 591795 592402 595412 596543 596669 598722 599339 601200 602705 604026 605941 616396 617921 619012 619221 621814 652213 677332 691335 727082 810119 811606 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (9.83%) |
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 576990 577978 544368 554001 554426 564010 569559 582848 584915 677332 652213 691335 555814 563464 573917 580855 587965 588190 596669 617921 586601 591795 592402 595412 598722 602705 619012 599339 604026 616396 619221 586695 588989 596543 601200 605941 621814 810119 811606 727082 400912 417414 422233 447800 475089 448439 451854 480960 424608 427970 446709 459497 459813 474378 418740 434676 447340 447484 454683 465158 499771 503870 519794 527443 537821 523752 538340 482913 491457 491650 492573 497338 498468 499668 514400 483551 488282 497096 499378 506299 508457 514951 515205 517727 524003 524021 525267 525748 433745 408994 419855 436139 443572 427601 432157 474553 487916 445814 463867 465171 503152 501960 527994 532252 493873 545539 548984 552919 560019 560835 567883 571724 581967 551199 552311 560442 567196 569268 571024 564001 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (2.04%) |
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 400912 408994 417414 418740 419855 422233 424608 427601 427970 432157 433745 434676 436139 443572 445814 446709 447340 447484 447800 448439 451854 454683 459497 459813 463867 465158 465171 474378 474553 475089 480960 482913 483551 487916 488282 491457 491650 492573 493873 497096 497338 498468 499378 499668 499771 501960 503152 503870 506299 508457 514400 514951 515205 517727 519794 523752 524003 524021 525267 525748 527443 527994 532252 537821 538340 544368 545539 548984 551199 552311 552919 554001 554426 555814 560019 560442 560835 563464 564001 564010 567196 567883 569268 569559 571024 571724 573917 576990 577978 580855 581967 582848 584915 586601 586695 587965 588190 588989 591795 592402 595412 596543 596669 598722 599339 601200 602705 604026 605941 616396 617921 619012 619221 621814 652213 677332 691335 727082 810119 811606 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tight skinny"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tight худые"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tight худые"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
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.