Query Metrics
7
Database Queries
7
Different statements
170.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.69 ms (84.14%) |
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 14328 392754 394228 394258 395701 397880 397916 400125 400474 400948 407682 407707 408765 413908 414946 417018 418958 420767 421841 421845 421858 421869 421881 421884 421931 421954 422146 422155 422179 427536 428920 431481 433347 438219 439648 439670 439768 440614 443184 443935 444703 449717 454552 460156 460728 462082 462110 464354 474498 474792 475266 475924 477987 489381 489960 490929 493136 493166 493167 493181 494315 506055 506126 509042 513143 513852 514838 516478 516712 516886 518155 519242 521134 522168 523184 523829 523837 523845 524357 525551 525878 526517 526524 527155 528355 531685 532064 533425 538002 544420 549648 549825 550223 560396 560512 563142 577051 581723 586617 589681 591258 594813 600965 601076 640941 671572 680702 709458 716324 727016 728291 730352 731073 737152 743811 746685 801399 813918 815353 ] |
||||||||||||||||||||||||||||||
|
16.57 ms (9.70%) |
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 560512 523829 438219 439648 400474 516478 394228 460156 550223 563142 737152 474792 477987 443935 549825 526517 422155 601076 560396 400948 431481 433347 413908 422146 443184 414946 516712 493166 523837 709458 640941 731073 524357 531685 544420 439670 421954 421841 421881 591258 489381 589681 454552 439768 444703 526524 392754 813918 489960 728291 716324 533425 421869 421931 397880 421858 421845 506055 523845 538002 522168 417018 815353 519242 525878 400125 475266 440614 509042 528355 493167 494315 521134 462082 586617 493136 475924 577051 600965 397916 420767 407682 394258 395701 518155 514838 460728 427536 418958 516886 490929 14328 449717 421884 493181 680702 523184 462110 671572 407707 746685 743811 422179 474498 408765 428920 510295 513852 527155 506126 464354 730352 513143 532064 525551 549648 581723 594813 727016 801399 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.74%) |
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 14328 392754 394228 394258 395701 397880 397916 400125 400474 400948 407682 407707 408765 413908 414946 417018 418958 420767 421841 421845 421858 421869 421881 421884 421931 421954 422146 422155 422179 427536 428920 431481 433347 438219 439648 439670 439768 440614 443184 443935 444703 449717 454552 460156 460728 462082 462110 464354 474498 474792 475266 475924 477987 489381 489960 490929 493136 493166 493167 493181 494315 506055 506126 509042 513143 513852 514838 516478 516712 516886 518155 519242 521134 522168 523184 523829 523837 523845 524357 525551 525878 526517 526524 527155 528355 531685 532064 533425 538002 544420 549648 549825 550223 560396 560512 563142 577051 581723 586617 589681 591258 594813 600965 601076 640941 671572 680702 709458 716324 727016 728291 730352 731073 737152 743811 746685 801399 813918 815353 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son fuck"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son секс"
]
|
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.