Query Metrics
7
Database Queries
7
Different statements
147.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.20 ms (80.32%) |
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 346141 391393 415978 416032 416738 420394 420835 424593 427539 428223 428231 431485 439056 441110 441131 442510 445727 446407 446778 447315 448791 451358 452540 452637 459203 459429 460716 466731 466991 468680 469087 470405 473213 475052 475335 475646 478510 481935 483711 497667 497693 500324 500327 505137 505597 505599 505800 506321 507956 510532 512346 513576 514085 514257 515571 529988 531823 533519 533554 534567 536377 536783 540928 541278 541755 542124 542709 547236 547467 547485 547847 547855 556338 556876 561273 571166 576493 584183 586557 587407 588514 590281 590299 595145 596610 599834 602241 609582 618259 628106 630564 632046 632588 634026 634068 636982 639729 639762 646884 647914 649546 649579 656921 660410 666490 666880 669026 670357 672954 678099 709628 728385 736302 741247 748961 752626 788181 788767 805144 825514 ] |
||||||||||||||||||||||||||||||
|
18.76 ms (12.75%) |
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 447315 468680 510532 415978 473213 500324 531823 709628 634068 420835 547855 618259 788181 736302 428231 515571 541278 556338 561273 672954 678099 752626 741247 748961 639729 497667 646884 649546 825514 459429 547236 576493 670357 584183 634026 636982 586557 590299 505597 505599 427539 439056 500327 536377 542124 540928 666490 571166 596610 431485 470405 505800 507956 346141 424593 445727 506321 514257 469087 541755 656921 669026 391393 536783 666880 441110 441131 428223 446778 452637 475646 481935 448791 466731 478510 512346 547847 556876 599834 728385 788767 460716 416032 483711 632588 632046 513576 533519 534567 529988 542709 547467 547485 660410 649579 647914 590281 639762 805144 416738 420394 442510 446407 451358 466991 475052 514085 497693 505137 533554 475335 587407 602241 588514 609582 630564 595145 628106 459203 452540 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.57%) |
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 346141 391393 415978 416032 416738 420394 420835 424593 427539 428223 428231 431485 439056 441110 441131 442510 445727 446407 446778 447315 448791 451358 452540 452637 459203 459429 460716 466731 466991 468680 469087 470405 473213 475052 475335 475646 478510 481935 483711 497667 497693 500324 500327 505137 505597 505599 505800 506321 507956 510532 512346 513576 514085 514257 515571 529988 531823 533519 533554 534567 536377 536783 540928 541278 541755 542124 542709 547236 547467 547485 547847 547855 556338 556876 561273 571166 576493 584183 586557 587407 588514 590281 590299 595145 596610 599834 602241 609582 618259 628106 630564 632046 632588 634026 634068 636982 639729 639762 646884 647914 649546 649579 656921 660410 666490 666880 669026 670357 672954 678099 709628 728385 736302 741247 748961 752626 788181 788767 805144 825514 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг девушк"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting girls"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.