Query Metrics
7
Database Queries
7
Different statements
233.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.64 ms (90.60%) |
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 184735 311176 365839 383045 386678 392579 398057 403778 416240 418862 419201 420327 421940 423949 424146 425814 437568 441249 442136 444858 447149 450136 450193 453990 454127 462303 470000 470951 471897 472064 478274 479514 479564 483093 487309 490736 496781 498954 506743 514205 514602 520987 521400 522344 525308 526020 529136 535176 535222 535227 538117 538674 542766 542940 543166 543289 544153 545994 546535 552245 552844 553331 554326 555655 556670 557011 557277 557367 563514 566335 567019 567740 567854 568783 571725 571933 574751 575183 576245 577052 577638 578079 584214 589137 589766 589837 591031 591556 591700 591990 593111 598597 600197 601725 605510 607074 608542 611918 613858 614205 615143 615513 623320 624292 626356 628497 629276 634526 641548 646052 654126 662865 676687 685533 686578 723092 736785 783981 794923 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (5.32%) |
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 567740 567854 576245 591031 589137 593111 629276 311176 365839 441249 487309 471897 472064 535176 535222 506743 514602 526388 529136 521400 526020 557011 563514 577052 574751 542940 543289 566335 568783 577638 676687 545994 591556 607074 614205 623320 634526 589837 600197 608542 783981 601725 421940 392579 490736 403778 419201 420327 418862 424146 416240 447149 450136 450193 470000 479564 483093 453990 538117 496781 546535 542766 553331 578079 544153 557367 571933 686578 556670 557277 591990 598597 613858 615143 591700 605510 736785 641548 479514 423949 425814 444858 498954 514205 454127 522344 398057 442136 646052 723092 383045 478274 437568 470951 525308 628497 554326 543166 552245 571725 589766 611918 386678 520987 538674 535227 555655 575183 584214 552844 662865 654126 685533 567019 624292 626356 794923 615513 462303 184735 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.13%) |
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 184735 311176 365839 383045 386678 392579 398057 403778 416240 418862 419201 420327 421940 423949 424146 425814 437568 441249 442136 444858 447149 450136 450193 453990 454127 462303 470000 470951 471897 472064 478274 479514 479564 483093 487309 490736 496781 498954 506743 514205 514602 520987 521400 522344 525308 526020 529136 535176 535222 535227 538117 538674 542766 542940 543166 543289 544153 545994 546535 552245 552844 553331 554326 555655 556670 557011 557277 557367 563514 566335 567019 567740 567854 568783 571725 571933 574751 575183 576245 577052 577638 578079 584214 589137 589766 589837 591031 591556 591700 591990 593111 598597 600197 601725 605510 607074 608542 611918 613858 614205 615143 615513 623320 624292 626356 628497 629276 634526 641548 646052 654126 662865 676687 685533 686578 723092 736785 783981 794923 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стоят секс"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сто секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.66%) |
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.