Query Metrics
7
Database Queries
7
Different statements
179.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.17 ms (85.67%) |
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 6840 95864 343078 382642 385129 390907 391043 391572 396553 401105 405466 415254 416157 420233 429800 429844 430324 444349 445002 447111 448038 448853 453604 454173 462738 465128 467782 468071 470382 472381 473035 473550 473943 478239 481339 486694 486981 488637 489403 490035 490247 492435 492820 496432 500169 501785 502236 505867 512345 512664 514352 514799 514907 515570 517097 522813 524082 524722 529050 535938 538209 545530 549022 549804 551628 552145 552186 552226 552239 553213 554746 557043 557545 559945 560880 561935 562221 562280 562303 564128 564593 565354 566031 567773 568351 569868 570015 570041 570385 570444 571233 571913 572121 572315 572801 573011 573115 573263 573544 573661 573695 573703 573855 574680 575771 577689 579181 581168 584495 589377 591677 593198 593965 625868 654352 661694 674909 699787 755832 778681 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (8.93%) |
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 500169 490247 549022 570444 552226 568351 572801 573703 577689 552145 552186 553213 562221 562280 569868 571913 573011 573115 573661 573695 661694 674909 699787 552239 554746 570015 570041 570385 572121 573544 573855 589377 591677 755832 390907 391043 415254 444349 447111 448853 470382 473550 343078 6840 420233 454173 472381 473943 405466 429800 462738 467782 473035 382642 385129 391572 396553 445002 478239 453604 502236 515570 517097 529050 496432 505867 488637 492435 492820 514352 522813 538209 489403 512664 514907 524082 535938 562303 654352 593965 625868 593198 468071 549804 564128 778681 557043 567773 572315 551628 575771 579181 559945 571233 584495 95864 416157 501785 514799 486981 524722 401105 430324 429844 465128 490035 481339 448038 512345 486694 545530 561935 564593 565354 557545 566031 573263 574680 581168 560880 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.59%) |
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 6840 95864 343078 382642 385129 390907 391043 391572 396553 401105 405466 415254 416157 420233 429800 429844 430324 444349 445002 447111 448038 448853 453604 454173 462738 465128 467782 468071 470382 472381 473035 473550 473943 478239 481339 486694 486981 488637 489403 490035 490247 492435 492820 496432 500169 501785 502236 505867 512345 512664 514352 514799 514907 515570 517097 522813 524082 524722 529050 535938 538209 545530 549022 549804 551628 552145 552186 552226 552239 553213 554746 557043 557545 559945 560880 561935 562221 562280 562303 564128 564593 565354 566031 567773 568351 569868 570015 570041 570385 570444 571233 571913 572121 572315 572801 573011 573115 573263 573544 573661 573695 573703 573855 574680 575771 577689 579181 581168 584495 589377 591677 593198 593965 625868 654352 661694 674909 699787 755832 778681 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая красотка"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
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.