Query Metrics
7
Database Queries
7
Different statements
163.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.18 ms (85.00%) |
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 34353 147128 181693 383299 383406 384462 388079 388672 389536 392696 395769 398558 401395 403233 411096 411166 413163 416924 418663 420061 421545 421639 423460 426271 426897 428976 429106 436068 438513 439387 444097 444501 445265 446519 446788 447621 448079 448577 449572 454728 457252 460356 461199 462383 463290 469777 471060 473025 475058 475639 477255 477429 480984 486891 490146 493339 495170 513450 515319 518057 523485 525128 525167 525466 526460 526664 527237 527516 534732 535277 537480 544069 546046 546844 549803 554187 556417 558322 562529 569824 570409 572566 578514 581553 581638 581641 581745 584023 585666 585831 585842 587547 590110 590804 596414 601932 606176 607589 608006 610256 617144 630444 654333 665094 671518 684492 686972 735338 738101 750471 759115 760176 767008 773253 789317 792779 800654 809005 810016 810964 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (9.52%) |
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 421545 423460 421639 438513 444097 448079 461199 462383 471060 513450 523485 549803 546046 572566 585666 596414 608006 590110 607589 617144 760176 759115 767008 800654 444501 525167 562529 665094 584023 585831 606176 610256 630444 792779 810016 735338 401395 383406 389536 428976 416924 436068 411096 486891 527237 515319 526664 534732 493339 546844 569824 581553 585842 810964 773253 384462 439387 420061 480984 392696 388672 426271 426897 475639 477429 446519 449572 454728 490146 525128 537480 527516 558322 554187 581745 684492 671518 654333 556417 587547 601932 590804 789317 809005 738101 460356 581638 686972 395769 477255 581641 570409 750471 447621 475058 429106 463290 495170 518057 388079 445265 418663 446788 457252 473025 469777 526460 535277 578514 544069 411166 383299 403233 448577 525466 181693 147128 34353 398558 413163 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.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 34353 147128 181693 383299 383406 384462 388079 388672 389536 392696 395769 398558 401395 403233 411096 411166 413163 416924 418663 420061 421545 421639 423460 426271 426897 428976 429106 436068 438513 439387 444097 444501 445265 446519 446788 447621 448079 448577 449572 454728 457252 460356 461199 462383 463290 469777 471060 473025 475058 475639 477255 477429 480984 486891 490146 493339 495170 513450 515319 518057 523485 525128 525167 525466 526460 526664 527237 527516 534732 535277 537480 544069 546046 546844 549803 554187 556417 558322 562529 569824 570409 572566 578514 581553 581638 581641 581745 584023 585666 585831 585842 587547 590110 590804 596414 601932 606176 607589 608006 610256 617144 630444 654333 665094 671518 684492 686972 735338 738101 750471 759115 760176 767008 773253 789317 792779 800654 809005 810016 810964 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"finger girl"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.