Query Metrics
7
Database Queries
7
Different statements
165.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.60 ms (84.20%) |
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 47606 405272 407136 407687 419197 419587 429162 441626 442441 443107 443801 444399 445475 451813 452619 453914 454917 457282 457676 466573 468836 470443 472792 474509 474826 475183 477395 477831 478126 478213 493942 494496 495469 496902 497779 500245 501259 501713 504482 505107 506436 507309 508468 509726 510588 510609 511899 513047 514997 515137 515791 517565 517887 519334 520701 522238 528003 528420 535960 539240 540155 542275 548606 553056 554805 556502 557243 561338 561364 562106 562362 562765 565947 569312 569686 574243 575133 578795 579717 584087 587595 593275 595011 595863 597015 598833 600837 601365 603121 614065 615729 615778 616292 619102 621449 623150 623757 628399 630639 633818 635577 647305 649991 655591 661286 675123 699611 707280 716882 726475 726589 745042 762400 ] |
||||||||||||||||||||||||||||||
|
17.42 ms (10.51%) |
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 623150 628399 726589 457282 509726 515791 517887 496902 510609 517565 519334 477395 578795 575133 579717 542275 561364 565947 707280 649991 699611 661286 615778 635577 614065 595863 598833 762400 726475 616292 407687 451813 478126 47606 443801 444399 445475 454917 470443 504482 495469 528420 597015 419197 407136 419587 475183 477831 466573 562765 561338 562362 569312 647305 655591 556502 630639 633818 601365 603121 453914 472792 443107 442441 452619 468836 478213 501713 506436 494496 515137 493942 441626 474826 501259 508468 535960 500245 548606 557243 562106 716882 574243 595011 623757 593275 615729 745042 429162 505107 520701 511899 405272 539240 474509 554805 675123 619102 540155 510588 528003 553056 507309 522238 584087 600837 587595 497779 513047 569686 621449 514997 457676 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.33%) |
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 47606 405272 407136 407687 419197 419587 429162 441626 442441 443107 443801 444399 445475 451813 452619 453914 454917 457282 457676 466573 468836 470443 472792 474509 474826 475183 477395 477831 478126 478213 493942 494496 495469 496902 497779 500245 501259 501713 504482 505107 506436 507309 508468 509726 510588 510609 511899 513047 514997 515137 515791 517565 517887 519334 520701 522238 528003 528420 535960 539240 540155 542275 548606 553056 554805 556502 557243 561338 561364 562106 562362 562765 565947 569312 569686 574243 575133 578795 579717 584087 587595 593275 595011 595863 597015 598833 600837 601365 603121 614065 615729 615778 616292 619102 621449 623150 623757 628399 630639 633818 635577 647305 649991 655591 661286 675123 699611 707280 716882 726475 726589 745042 762400 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucking and licking"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucking лиза"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucking лиза"
]
|
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.