Query Metrics
7
Database Queries
7
Different statements
189.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.06 ms (85.22%) |
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 390813 391184 395706 395970 395981 406525 411237 414184 415746 416772 416886 419064 419550 420559 420587 420635 420695 421557 421871 423329 424428 425316 425473 427182 429449 434702 436718 442494 443163 443871 447009 447400 447401 447759 448031 448982 452474 453672 454521 455816 458309 461090 461928 462515 464368 466355 466369 467555 467558 468676 469444 469909 469918 470588 470941 471781 472333 475927 476244 482506 483352 484681 484738 489241 492050 492701 495149 496794 499566 502326 503453 504769 507646 508599 509507 509998 511810 513126 514069 517125 517567 517841 518547 521832 525133 525287 527888 534147 534823 537970 543536 544668 544863 549799 551130 561980 564203 573800 582821 583670 590469 593886 595977 603592 603635 603653 603675 610314 618561 648539 680633 695282 717636 770882 790036 797560 801471 803793 809520 810775 ] |
||||||||||||||||||||||||||||||
|
17.37 ms (9.19%) |
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 414184 803793 391184 489241 680633 770882 467558 452474 466355 395970 518547 810775 695282 427182 447400 421871 447401 549799 504769 436718 517125 717636 603592 561980 603675 517841 420635 525133 603653 458309 544863 448031 537970 462515 499566 509507 429449 419550 472333 809520 475927 423329 801471 442494 495149 595977 797560 492701 454521 420559 468676 415746 424428 434702 513126 544668 503453 583670 467555 464368 543536 416886 483352 582821 603635 492050 425473 425316 406525 420587 517567 482506 420695 447009 469918 564203 419064 471781 508599 509998 525287 461090 447759 390813 484681 648539 470941 421557 511810 443163 527888 395981 476244 590469 453672 496794 502326 514069 507646 573800 610314 534823 593886 790036 461928 469909 484738 443871 395706 411237 416772 534147 469444 521832 448982 470588 466369 455816 551130 618561 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (1.90%) |
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 390813 391184 395706 395970 395981 406525 411237 414184 415746 416772 416886 419064 419550 420559 420587 420635 420695 421557 421871 423329 424428 425316 425473 427182 429449 434702 436718 442494 443163 443871 447009 447400 447401 447759 448031 448982 452474 453672 454521 455816 458309 461090 461928 462515 464368 466355 466369 467555 467558 468676 469444 469909 469918 470588 470941 471781 472333 475927 476244 482506 483352 484681 484738 489241 492050 492701 495149 496794 499566 502326 503453 504769 507646 508599 509507 509998 511810 513126 514069 517125 517567 517841 518547 521832 525133 525287 527888 534147 534823 537970 543536 544668 544863 549799 551130 561980 564203 573800 582821 583670 590469 593886 595977 603592 603635 603653 603675 610314 618561 648539 680633 695282 717636 770882 790036 797560 801471 803793 809520 810775 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur threesome anal"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск секс втро анал"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.