Query Metrics
7
Database Queries
7
Different statements
184.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.87 ms (87.12%) |
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 410234 412662 418707 437294 438401 439488 439632 441210 443548 448076 454296 454403 456366 456572 456688 456859 457192 458148 459176 459178 460462 460531 461324 461722 462701 463108 463216 463984 466527 466551 469846 470233 475338 475371 475514 477673 479254 481791 484078 486625 486691 487470 489553 490000 491387 491874 494576 497652 502614 503805 504853 505443 509945 510617 513458 517345 518587 518771 519021 520983 523088 526801 528620 528879 535353 543356 543757 544064 549175 550052 551194 551632 556072 558884 559480 561615 562369 566347 566996 569012 569471 578129 578132 588033 588710 592730 595026 601893 610582 614142 614244 614380 619785 630024 636481 654671 656123 658894 661882 690373 691244 695929 696121 705787 705801 705804 705814 728281 731528 743079 757548 758268 761479 769867 776426 802711 803469 804765 807308 817641 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (7.84%) |
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 705787 761479 654671 494576 558884 566996 454296 491387 550052 510617 544064 505443 484078 656123 460462 466551 561615 776426 456688 460531 418707 588033 466527 459178 614244 477673 439488 456859 556072 438401 475371 439632 691244 504853 461324 543356 497652 695929 690373 479254 443548 487470 528879 523088 491874 490000 696121 817641 705804 705814 619785 519021 463108 526801 513458 569471 528620 461722 562369 614380 803469 757548 658894 595026 614142 489553 566347 454403 463216 588710 458148 412662 503805 486691 456572 437294 441210 535353 636481 802711 509945 569012 475514 410234 758268 630024 486625 481791 463984 578132 804765 457192 728281 518587 610582 470233 543757 475338 520983 661882 462701 551632 592730 502614 551194 448076 518771 549175 743079 456366 769867 807308 731528 705801 578129 601893 559480 459176 469846 517345 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.17%) |
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 410234 412662 418707 437294 438401 439488 439632 441210 443548 448076 454296 454403 456366 456572 456688 456859 457192 458148 459176 459178 460462 460531 461324 461722 462701 463108 463216 463984 466527 466551 469846 470233 475338 475371 475514 477673 479254 481791 484078 486625 486691 487470 489553 490000 491387 491874 494576 497652 502614 503805 504853 505443 509945 510617 513458 517345 518587 518771 519021 520983 523088 526801 528620 528879 535353 543356 543757 544064 549175 550052 551194 551632 556072 558884 559480 561615 562369 566347 566996 569012 569471 578129 578132 588033 588710 592730 595026 601893 610582 614142 614244 614380 619785 630024 636481 654671 656123 658894 661882 690373 691244 695929 696121 705787 705801 705804 705814 728281 731528 743079 757548 758268 761479 769867 776426 802711 803469 804765 807308 817641 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в лесу групповой миньет"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в лес природ группов минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
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.