Query Metrics
7
Database Queries
7
Different statements
196.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.58 ms (83.84%) |
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 2189 38637 94529 185606 191475 233556 260590 326115 358778 370875 381855 382154 383418 383495 384234 386323 386576 386765 386852 389623 390892 392024 392031 392674 396215 398444 401468 401678 401773 402483 402926 403074 406018 406650 407171 407707 407816 408420 408425 409882 410855 411415 411941 420510 420812 427012 427152 431228 434361 437560 437725 441215 443834 444670 446080 447303 447587 449236 451166 452162 452682 452688 456690 459192 460127 460408 460601 460744 460925 461478 461802 462806 462905 465412 465829 466052 466198 466216 467191 467370 469269 469862 470250 470451 473068 479326 490187 494575 495634 495644 498104 503293 503400 504172 504290 506727 510677 516534 519139 521228 523975 527753 543835 548782 549155 552206 553957 563217 563613 566867 569991 571637 573663 573961 575766 576728 582583 598710 607125 684251 ] |
||||||||||||||||||||||||||||||
|
20.40 ms (10.39%) |
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 408420 460127 402483 386576 390892 402926 233556 411415 420510 460601 516534 504172 519139 495634 386852 461802 569991 575766 470250 389623 466216 503400 437560 573961 431228 427012 386323 326115 407707 411941 469862 571637 607125 408425 392024 392031 443834 467370 401678 449236 552206 563613 38637 407171 573663 401468 185606 384234 465829 358778 409882 381855 504290 527753 684251 370875 406018 452162 410855 452688 495644 521228 434361 403074 447587 260590 576728 427152 506727 460744 386765 406650 447303 444670 94529 566867 383418 503293 469269 392674 459192 451166 466052 407816 465412 563217 401773 548782 462806 396215 498104 383495 191475 441215 543835 446080 460925 398444 420812 452682 460408 437725 494575 470451 2189 490187 553957 582583 549155 598710 461478 382154 466198 473068 462905 456690 467191 523975 479326 510677 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.67%) |
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 2189 38637 94529 185606 191475 233556 260590 326115 358778 370875 381855 382154 383418 383495 384234 386323 386576 386765 386852 389623 390892 392024 392031 392674 396215 398444 401468 401678 401773 402483 402926 403074 406018 406650 407171 407707 407816 408420 408425 409882 410855 411415 411941 420510 420812 427012 427152 431228 434361 437560 437725 441215 443834 444670 446080 447303 447587 449236 451166 452162 452682 452688 456690 459192 460127 460408 460601 460744 460925 461478 461802 462806 462905 465412 465829 466052 466198 466216 467191 467370 469269 469862 470250 470451 473068 479326 490187 494575 495634 495644 498104 503293 503400 504172 504290 506727 510677 516534 519139 521228 523975 527753 543835 548782 549155 552206 553957 563217 563613 566867 569991 571637 573663 573961 575766 576728 582583 598710 607125 684251 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни делает парень"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс парен"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.77%) |
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.