Query Metrics
7
Database Queries
7
Different statements
364.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
337.20 ms (92.55%) |
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 390413 408460 410608 411445 413944 415207 415401 422711 425320 425715 425820 426409 426654 429123 431077 434001 443103 447955 449210 450930 453356 453358 456633 456642 468593 468608 469566 471861 472531 472721 475704 475716 476767 478787 482090 482174 487072 487197 487858 489263 489893 491458 494622 494695 500767 503003 503419 506659 508199 508487 508541 509940 510214 511044 512495 515170 516598 518470 519841 519982 520775 523056 526004 527355 529846 530493 530757 531174 532843 532984 533207 533531 537208 544788 545804 547687 550343 556030 556423 559159 560157 561351 562768 564473 565332 568061 568537 568554 569211 571053 580727 580747 581423 586596 598031 599912 604460 609874 612844 621410 622397 623251 624834 632699 633114 635988 647850 649838 659215 667750 674943 676492 683438 710524 716030 759639 788604 790036 807985 812922 ] |
||||||||||||||||||||||||||||||
|
17.23 ms (4.73%) |
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 807985 609874 622397 390413 422711 533207 489263 564473 612844 812922 415401 510214 519841 503003 413944 450930 530493 487197 453356 456633 511044 516598 526004 500767 519982 547687 565332 545804 447955 468593 468608 491458 515170 509940 476767 533531 586596 487858 560157 632699 635988 456642 478787 512495 506659 710524 425820 544788 425320 523056 408460 532984 571053 559159 561351 569211 580727 649838 676492 683438 647850 659215 556423 759639 604460 716030 790036 518470 568554 621410 624834 434001 429123 527355 410608 443103 471861 537208 530757 529846 508487 482090 426409 472531 472721 475716 494695 508541 568061 623251 449210 562768 453358 425715 426654 489893 487072 581423 667750 788604 431077 475704 411445 469566 415207 494622 568537 580747 599912 633114 550343 598031 674943 503419 532843 531174 508199 482174 556030 520775 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (0.91%) |
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 390413 408460 410608 411445 413944 415207 415401 422711 425320 425715 425820 426409 426654 429123 431077 434001 443103 447955 449210 450930 453356 453358 456633 456642 468593 468608 469566 471861 472531 472721 475704 475716 476767 478787 482090 482174 487072 487197 487858 489263 489893 491458 494622 494695 500767 503003 503419 506659 508199 508487 508541 509940 510214 511044 512495 515170 516598 518470 519841 519982 520775 523056 526004 527355 529846 530493 530757 531174 532843 532984 533207 533531 537208 544788 545804 547687 550343 556030 556423 559159 560157 561351 562768 564473 565332 568061 568537 568554 569211 571053 580727 580747 581423 586596 598031 599912 604460 609874 612844 621410 622397 623251 624834 632699 633114 635988 647850 649838 659215 667750 674943 676492 683438 710524 716030 759639 788604 790036 807985 812922 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits petite"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ petite"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ petite"
]
|
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.