Query Metrics
7
Database Queries
7
Different statements
163.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.29 ms (80.92%) |
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 385197 413139 415520 415588 417711 420241 420543 424566 428710 429250 430490 432766 432791 432997 446012 448859 452244 453157 453299 455876 456864 457097 458414 462689 464945 465602 486185 486883 489272 491589 497924 501253 503056 503250 503801 506772 510205 511898 513757 518086 526896 529008 533396 540273 552399 553064 561714 561887 564306 564735 566022 566318 568046 580589 581270 589031 598985 601043 601074 603340 604002 604138 605335 607590 608429 608729 609792 613485 620210 620310 622285 628701 631692 633120 634533 637063 639825 644375 644499 647675 647982 650332 653265 668888 668986 672745 673983 674127 681897 692419 695613 699588 710861 712332 715528 716181 716899 717410 717780 720434 723751 724038 724143 727698 736408 740604 742031 744607 745051 748221 750867 751768 752928 755108 756171 779737 784788 788255 792563 810744 ] |
||||||||||||||||||||||||||||||
|
17.53 ms (10.72%) |
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 644499 604002 608729 628701 779737 751768 756171 752928 740604 608429 639825 420543 448859 385197 432997 464945 420241 424566 510205 561714 455876 489272 503056 511898 750867 501253 428710 503250 491589 415588 413139 453299 503801 710861 727698 792563 715528 716181 457097 717410 429250 486185 540273 564306 668986 613485 634533 605335 526896 674127 415520 432766 458414 486883 566022 552399 432791 453157 462689 518086 456864 446012 529008 533396 497924 465602 553064 561887 566318 647982 653265 699588 672745 692419 695613 647675 650332 668888 673983 681897 712332 720434 564735 581270 589031 601074 622285 631692 598985 603340 620210 633120 644375 601043 604138 607590 784788 810744 723751 724038 724143 736408 744607 748221 742031 755108 745051 620310 716899 717780 788255 417711 430490 580589 637063 568046 609792 452244 513757 506772 ] |
||||||||||||||||||||||||||||||
|
4.70 ms (2.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон кастинг"
]
|
||||||||||||||||||||||||||||||
|
3.98 ms (2.43%) |
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 385197 413139 415520 415588 417711 420241 420543 424566 428710 429250 430490 432766 432791 432997 446012 448859 452244 453157 453299 455876 456864 457097 458414 462689 464945 465602 486185 486883 489272 491589 497924 501253 503056 503250 503801 506772 510205 511898 513757 518086 526896 529008 533396 540273 552399 553064 561714 561887 564306 564735 566022 566318 568046 580589 581270 589031 598985 601043 601074 603340 604002 604138 605335 607590 608429 608729 609792 613485 620210 620310 622285 628701 631692 633120 634533 637063 639825 644375 644499 647675 647982 650332 653265 668888 668986 672745 673983 674127 681897 692419 695613 699588 710861 712332 715528 716181 716899 717410 717780 720434 723751 724038 724143 727698 736408 740604 742031 744607 745051 748221 750867 751768 752928 755108 756171 779737 784788 788255 792563 810744 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits casting"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
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.