Query Metrics
7
Database Queries
7
Different statements
199.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.60 ms (87.48%) |
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 384046 419220 443127 443915 445099 446772 448077 464790 465323 468254 468353 468453 471461 474261 482772 487028 488160 495581 497918 510507 522462 523581 531561 534426 534633 537780 548876 550538 552513 555014 559733 570167 581579 588056 595619 595881 597663 601211 613002 615494 620775 623830 646270 650305 656603 663185 663425 663938 669370 671437 673838 675547 675705 679381 679445 681059 681212 700930 708573 710770 711220 712108 712157 712800 717134 717814 720384 721609 722899 726123 726214 728620 730806 735924 740059 740493 740502 741966 745293 745478 745682 747091 750248 751023 752229 752627 756436 756504 756704 760598 762917 763740 767142 767148 769892 770607 770671 773045 775240 782407 785324 788140 793023 793899 794736 796488 797000 800242 800344 800497 801083 801557 801921 804335 804356 805996 815799 823857 825907 827654 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (7.56%) |
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 770607 804356 752229 534426 597663 613002 623830 773045 769892 751023 726123 595619 671437 712157 801921 495581 656603 712800 588056 804335 760598 801557 767148 740502 793023 730806 745682 550538 722899 794736 443127 679381 681059 720384 741966 827654 785324 762917 770671 646270 650305 721609 775240 788140 805996 740059 615494 497918 384046 464790 756504 756704 465323 675547 679445 708573 800242 740493 735924 488160 570167 793899 487028 548876 745478 531561 750248 474261 523581 815799 446772 710770 712108 796488 726214 763740 752627 797000 700930 801083 468353 825907 534633 552513 669370 663185 717134 745293 747091 782407 445099 522462 675705 663938 448077 823857 471461 581579 595881 800344 756436 728620 443915 800497 559733 620775 601211 673838 711220 468254 681212 482772 537780 555014 767142 419220 468453 510507 663425 717814 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.34%) |
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 384046 419220 443127 443915 445099 446772 448077 464790 465323 468254 468353 468453 471461 474261 482772 487028 488160 495581 497918 510507 522462 523581 531561 534426 534633 537780 548876 550538 552513 555014 559733 570167 581579 588056 595619 595881 597663 601211 613002 615494 620775 623830 646270 650305 656603 663185 663425 663938 669370 671437 673838 675547 675705 679381 679445 681059 681212 700930 708573 710770 711220 712108 712157 712800 717134 717814 720384 721609 722899 726123 726214 728620 730806 735924 740059 740493 740502 741966 745293 745478 745682 747091 750248 751023 752229 752627 756436 756504 756704 760598 762917 763740 767142 767148 769892 770607 770671 773045 775240 782407 785324 788140 793023 793899 794736 796488 797000 800242 800344 800497 801083 801557 801921 804335 804356 805996 815799 823857 825907 827654 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy and ass"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy жоп"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy жоп"
]
|
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.