Query Metrics
7
Database Queries
7
Different statements
166.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.87 ms (85.40%) |
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 123029 399415 401049 403229 403240 407819 418268 421790 424436 426478 428477 430845 437344 443458 443683 448356 450400 453301 454147 454735 456291 457106 457806 460741 460923 462105 462522 463097 465347 465395 466147 466171 466212 466494 470918 470997 472595 472611 472640 474112 474964 475102 475441 475548 475852 476678 479073 479079 483902 484102 484369 484423 484439 484441 493468 497458 497816 498852 498865 502102 502729 504614 505930 507879 510406 510874 512411 513975 516239 519925 521745 528252 528380 540061 552250 554647 555377 555445 555462 562959 566374 566537 571219 577614 584491 586445 590879 592511 593516 595757 600373 601317 601721 601790 605325 605331 617391 621027 628163 644421 664562 673537 675936 677578 677587 677609 677832 681987 684232 692767 714809 727560 748695 762230 800976 813172 814378 814387 824085 827645 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (8.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 505930 502729 466212 592511 493468 644421 450400 472611 555377 584491 555462 566374 600373 443458 424436 457806 443683 677832 479079 762230 462522 677609 677578 593516 430845 502102 692767 426478 474964 466147 484439 528252 403240 566537 497458 554647 456291 399415 681987 617391 513975 507879 476678 470918 528380 748695 628163 673537 504614 571219 519925 460923 457106 577614 601790 814387 677587 418268 484102 540061 586445 813172 475548 475102 516239 448356 454147 475441 437344 552250 605325 605331 601721 466171 475852 407819 428477 621027 497816 401049 510406 474112 675936 498852 521745 800976 590879 463097 123029 462105 714809 465347 454735 472640 403229 460741 824085 684232 472595 595757 470997 555445 727560 827645 421790 814378 562959 664562 466494 510874 601317 484369 453301 512411 498865 483902 465395 479073 484423 484441 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.85%) |
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 123029 399415 401049 403229 403240 407819 418268 421790 424436 426478 428477 430845 437344 443458 443683 448356 450400 453301 454147 454735 456291 457106 457806 460741 460923 462105 462522 463097 465347 465395 466147 466171 466212 466494 470918 470997 472595 472611 472640 474112 474964 475102 475441 475548 475852 476678 479073 479079 483902 484102 484369 484423 484439 484441 493468 497458 497816 498852 498865 502102 502729 504614 505930 507879 510406 510874 512411 513975 516239 519925 521745 528252 528380 540061 552250 554647 555377 555445 555462 562959 566374 566537 571219 577614 584491 586445 590879 592511 593516 595757 600373 601317 601721 601790 605325 605331 617391 621027 628163 644421 664562 673537 675936 677578 677587 677609 677832 681987 684232 692767 714809 727560 748695 762230 800976 813172 814378 814387 824085 827645 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cunnilingus amateur hairy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс любительск волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
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.