Query Metrics
7
Database Queries
7
Different statements
203.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.14 ms (85.44%) |
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 386134 387014 390001 390667 390980 393391 399152 401049 407124 410602 415209 418963 421164 424751 431335 431643 434358 446948 447565 448489 450988 451663 457203 458530 458922 459656 460608 462349 463079 463825 466404 470568 470992 471392 472956 473242 474520 474557 483006 484667 484719 490011 490897 491925 491931 495070 496613 500477 504139 506295 508786 509552 510581 514660 517859 525287 525348 525634 526440 529792 530369 532666 532893 533186 533746 534986 535434 536666 544502 559228 566246 566264 566664 574021 582277 586679 587852 588068 599002 599052 600011 603244 604550 606608 613859 614029 615909 619747 623262 631243 634546 637553 640691 641930 641978 650785 653596 653726 659385 663370 663437 663441 664957 667290 667476 675008 702621 718698 732777 733217 744360 748242 759731 781990 792655 803074 809478 815204 815789 816086 ] |
||||||||||||||||||||||||||||||
|
20.03 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 401049 587852 631243 390980 451663 424751 566246 640691 781990 410602 393391 599002 815789 470568 559228 659385 663437 803074 600011 615909 457203 653726 748242 447565 387014 458530 470992 431643 634546 744360 399152 390667 509552 532893 533186 792655 732777 458922 460608 490897 510581 586679 809478 525348 702621 604550 514660 815204 496613 606608 446948 491931 733217 434358 534986 415209 472956 525287 466404 526440 574021 759731 463079 484667 431335 484719 474520 544502 390001 588068 533746 529792 675008 641978 462349 473242 500477 421164 463825 495070 582277 483006 667290 614029 599052 508786 407124 530369 386134 637553 471392 474557 448489 603244 532666 566264 667476 664957 653596 623262 490011 566664 663370 650785 718698 450988 506295 536666 418963 535434 619747 663441 613859 491925 641930 816086 459656 525634 504139 517859 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.30%) |
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 386134 387014 390001 390667 390980 393391 399152 401049 407124 410602 415209 418963 421164 424751 431335 431643 434358 446948 447565 448489 450988 451663 457203 458530 458922 459656 460608 462349 463079 463825 466404 470568 470992 471392 472956 473242 474520 474557 483006 484667 484719 490011 490897 491925 491931 495070 496613 500477 504139 506295 508786 509552 510581 514660 517859 525287 525348 525634 526440 529792 530369 532666 532893 533186 533746 534986 535434 536666 544502 559228 566246 566264 566664 574021 582277 586679 587852 588068 599002 599052 600011 603244 604550 606608 613859 614029 615909 619747 623262 631243 634546 637553 640691 641930 641978 650785 653596 653726 659385 663370 663437 663441 664957 667290 667476 675008 702621 718698 732777 733217 744360 748242 759731 781990 792655 803074 809478 815204 815789 816086 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс дилд"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни самотык"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс дилд"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.75%) |
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.