Query Metrics
17
Database Queries
10
Different statements
106.04 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.69 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.plain_password AS plain_password_6, t0.is_active AS is_active_7, t8.id AS id_9, t8.name AS name_10, t8.email AS email_11, t8.user_id AS user_id_12 FROM symfony_user t0 LEFT JOIN person t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 92.20 ms |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.description AS description_5, t0.slug AS slug_6, t0.short_title AS short_title_7, t0.modified_at AS modified_at_8, t0.priority AS priority_9, t0.url AS url_10, t0.is_published AS is_published_11, t0.bitrix_id AS bitrix_id_12, t0.keywords AS keywords_13, t0.menu_title AS menu_title_14, t0.is_problems AS is_problems_15, t0.is_ready AS is_ready_16, t0.problems_string AS problems_string_17, t0.search_string AS search_string_18, t0.vote_count AS vote_count_19, t0.vote_sum AS vote_sum_20, t0.meta_ok AS meta_ok_21, t0.notice_field AS notice_field_22, t0.voc_code AS voc_code_23, t0.is_ready_pm AS is_ready_pm_24, t0.is_ready_cm AS is_ready_cm_25, t0.og_title AS og_title_26, t0.og_description AS og_description_27, t0.short_code AS short_code_28, t0.source_link AS source_link_29, t0.created_at AS created_at_30, t0.no_index AS no_index_31, t0.not_menu AS not_menu_32, t0.is_private AS is_private_33, t0.filtered_elements_count AS filtered_elements_count_34, t0.is_no_page AS is_no_page_35, t0.is_no_list AS is_no_list_36, t0.is_no_filter AS is_no_filter_37, t0.list_title AS list_title_38, t0.child_placeholder AS child_placeholder_39, t0.sort_order AS sort_order_40, t41.id AS id_42, t41.value AS value_43, t41.content_id AS content_id_44, t0.seo_type_id AS seo_type_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.xml_id AS xml_id_49, t47.price_base AS price_base_50, t47.price_old AS price_old_51, t47.price_min AS price_min_52, t47.price_d1 AS price_d1_53, t47.price_d2 AS price_d2_54, t47.price_d1_from AS price_d1_from_55, t47.price_d2_from AS price_d2_from_56, t47.stock AS stock_57, t47.custom AS custom_58, t47.is_hit AS is_hit_59, t47.is_new AS is_new_60, t47.is_sale AS is_sale_61, t47.title AS title_62, t47.search AS search_63, t47.by_count AS by_count_64, t47.price_personal_from AS price_personal_from_65, t47.exclusive_dev AS exclusive_dev_66, t47.weight AS weight_67, t47.transport_length AS transport_length_68, t47.transport_width AS transport_width_69, t47.transport_height AS transport_height_70, t47.param_desc AS param_desc_71, t47.zakaz_days AS zakaz_days_72, t47.vendor_code AS vendor_code_73, t47.external_code AS external_code_74, t47.sort_order AS sort_order_75, t47.length AS length_76, t47.width AS width_77, t47.height AS height_78, t47.size_count AS size_count_79, t47.content_id AS content_id_80, t47.color_id AS color_id_81, t47.mark_id AS mark_id_82, t47.fluid_id AS fluid_id_83, t47.construction_id AS construction_id_84, t0.last_edit_user_id AS last_edit_user_id_85, t86.id AS id_87, t86.development AS development_88, t86.case_type AS case_type_89, t86.content_id AS content_id_90, t0.merge_to_id AS merge_to_id_91, t0.real_type_id AS real_type_id_92, t93.id AS id_94, t93.er_id AS er_id_95, t93.er_sku AS er_sku_96, t93.er_name AS er_name_97, t93.er_data AS er_data_98, t93.er_prices AS er_prices_99, t93.weight AS weight_100, t93.volume AS volume_101, t93.er_code AS er_code_102, t93.price_group AS price_group_103, t93.content_id AS content_id_104, t105.id AS id_106, t105.content_id AS content_id_107, t108.id AS id_109, t108.start_at AS start_at_110, t108.end_at AS end_at_111, t108.banner_title AS banner_title_112, t108.banner_badge AS banner_badge_113, t108.banner_comment AS banner_comment_114, t108.banner_image AS banner_image_115, t108.is_catalog_banner AS is_catalog_banner_116, t108.banner_link AS banner_link_117, t108.banner_link_text AS banner_link_text_118, t108.banner_delay AS banner_delay_119, t108.sort_order AS sort_order_120, t108.content_id AS content_id_121, t108.template_id AS template_id_122 FROM seo_content t0 LEFT JOIN seo_raw t41 ON t41.content_id = t0.id LEFT JOIN seo_product t47 ON t47.content_id = t0.id LEFT JOIN seo_portfolio t86 ON t86.content_id = t0.id LEFT JOIN erpzdc_prod t93 ON t93.content_id = t0.id LEFT JOIN seo_pseudo_category_group t105 ON t105.content_id = t0.id LEFT JOIN promo_action t108 ON t108.content_id = t0.id
Parameters:
[] |
| 3 | 1.58 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 609 681 265 287 680 310 598 628 11 679 677 536 626 797 875 496 136 464 182 562 795 276 459 273 270 179 695 267 266 176 705 262 552 551 550 260 172 259 543 692 169 542 481 144 691 207 541 540 539 538 537 881 880 535 723 142 534 533 832 846 202 532 199 531 879 272 271 196 629 195 641 874 455 249 513 666 664 618 512 26 872 616 510 873 488 248 623 871 244 869 243 866 451 621 450 280 158 449 863 433 ] |
| 4 | 0.67 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 237 235 278 325 231 739 504 226 622 502 25 500 644 498 227 861 431 814 225 725 672 716 860 857 715 847 434 700 693 678 676 673 669 668 495 218 862 229 216 494 663 661 659 656 493 492 491 297 490 619 489 224 219 487 217 858 80 486 877 597 427 545 670 485 855 430 854 484 462 209 208 460 596 544 853 206 258 100 852 648 483 415 849 257 197 414 848 285 482 36 98 284 191 283 91 845 480 282 844 476 ] |
| 5 | 0.70 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 843 479 228 281 478 842 477 178 88 279 475 269 20 19 777 595 268 256 18 17 15 14 264 263 13 12 10 841 9 8 255 7 5 4 3 253 840 2 1 251 424 250 839 411 410 838 585 89 876 837 870 836 308 820 864 789 31 474 77 835 307 665 416 223 222 221 305 220 833 378 787 277 827 824 303 151 66 37 473 472 627 300 65 736 658 732 728 726 727 823 718 714 713 712 711 708 707 706 704 703 ] |
| 6 | 0.62 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 699 698 697 696 64 689 688 687 686 675 674 671 667 662 660 657 275 299 655 654 467 746 465 466 821 60 360 108 126 461 356 59 650 353 252 834 57 620 733 646 878 104 56 74 106 99 463 254 507 518 350 514 95 156 457 357 94 201 70 717 647 563 261 92 859 819 90 337 546 87 86 133 624 132 366 29 364 444 355 611 610 889 443 891 442 440 363 890 817 367 27 130 362 131 361 129 127 645 887 124 ] |
| 7 | 0.64 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 612 52 122 606 119 49 48 47 649 118 46 453 115 113 368 112 516 604 333 45 589 110 608 602 605 44 601 41 617 109 753 816 599 588 590 813 157 382 592 369 370 582 373 888 39 574 33 372 375 78 376 567 614 377 379 566 111 448 447 561 446 886 153 558 152 529 528 525 556 445 523 522 117 555 520 554 155 519 150 812 509 302 154 811 603 435 387 437 511 809 149 593 76 165 807 286 75 428 426 806 ] |
| 8 | 0.48 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 371 148 418 352 329 805 351 802 569 171 690 798 796 794 793 404 93 146 587 594 246 398 397 141 432 557 140 138 242 334 885 139 241 304 240 147 288 145 143 137 245 238 374 685 239 236 684 709 234 792 730 729 683 553 721 710 324 323 212 233 694 682 134 577 232 632 322 321 318 790 784 615 613 135 194 128 190 189 788 125 247 183 527 526 786 785 123 185 120 549 215 214 293 116 548 850 783 781 851 213 ] |
| 9 | 0.48 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 114 211 210 782 184 780 779 778 205 776 181 166 775 180 774 773 771 769 204 425 768 423 203 336 767 327 24 766 316 200 402 198 829 765 403 770 581 571 830 570 815 23 761 828 326 760 161 309 193 107 396 192 22 764 401 105 81 21 306 399 274 394 395 560 393 79 188 392 763 469 391 187 230 530 121 524 521 517 83 390 186 389 301 762 388 177 559 386 759 385 175 868 758 752 384 383 547 317 757 756 ] |
| 10 | 0.56 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 755 754 867 751 750 497 174 6 173 170 503 168 572 515 508 506 505 501 499 468 167 458 456 882 454 749 436 584 164 607 163 452 162 748 438 160 422 420 747 28 591 421 380 586 330 471 583 419 865 745 417 580 579 578 576 575 744 573 315 314 470 354 313 743 742 741 320 103 101 319 97 96 740 312 738 413 856 883 701 296 311 295 292 291 290 831 408 737 822 735 734 818 409 731 724 642 405 289 722 50 ] |
| 11 | 0.62 ms |
SELECT t0.id AS id_1, t0.factor AS factor_2, t0.product_id AS product_id_3, t4.id AS id_5, t4.xml_id AS xml_id_6, t4.price_base AS price_base_7, t4.price_old AS price_old_8, t4.price_min AS price_min_9, t4.price_d1 AS price_d1_10, t4.price_d2 AS price_d2_11, t4.price_d1_from AS price_d1_from_12, t4.price_d2_from AS price_d2_from_13, t4.stock AS stock_14, t4.custom AS custom_15, t4.is_hit AS is_hit_16, t4.is_new AS is_new_17, t4.is_sale AS is_sale_18, t4.title AS title_19, t4.search AS search_20, t4.by_count AS by_count_21, t4.price_personal_from AS price_personal_from_22, t4.exclusive_dev AS exclusive_dev_23, t4.weight AS weight_24, t4.transport_length AS transport_length_25, t4.transport_width AS transport_width_26, t4.transport_height AS transport_height_27, t4.param_desc AS param_desc_28, t4.zakaz_days AS zakaz_days_29, t4.vendor_code AS vendor_code_30, t4.external_code AS external_code_31, t4.sort_order AS sort_order_32, t4.length AS length_33, t4.width AS width_34, t4.height AS height_35, t4.size_count AS size_count_36, t4.content_id AS content_id_37, t4.color_id AS color_id_38, t4.mark_id AS mark_id_39, t4.fluid_id AS fluid_id_40, t4.construction_id AS construction_id_41, t0.category_id AS category_id_42 FROM seo_product_sort t0 LEFT JOIN seo_product t4 ON t0.product_id = t4.id WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 365 400 638 826 43 348 799 381 825 347 42 346 345 720 344 343 342 810 702 341 340 339 719 335 800 653 791 328 652 651 85 84 82 633 634 359 32 30 808 358 643 631 640 804 568 803 439 73 801 441 71 429 68 35 630 34 639 67 637 349 636 62 635 298 625 294 72 69 51 565 61 338 58 331 412 332 53 564 407 55 40 406 54 38 884 772 600 159 102 63 ] |
| 12 | 1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.base_path AS base_path_4, t0.short_title AS short_title_5, t0.is_list AS is_list_6, t0.is_search AS is_search_7, t0.is_cart AS is_cart_8, t0.is_side_menu AS is_side_menu_9, t0.fast_order_title AS fast_order_title_10, t0.is_active AS is_active_11, t0.meta_title_template AS meta_title_template_12, t0.meta_description_template AS meta_description_template_13, t0.sort_order AS sort_order_14, t0.child_type_id AS child_type_id_15, t16.id AS id_17, t16.name AS name_18, t16.title AS title_19, t16.base_path AS base_path_20, t16.short_title AS short_title_21, t16.is_list AS is_list_22, t16.is_search AS is_search_23, t16.is_cart AS is_cart_24, t16.is_side_menu AS is_side_menu_25, t16.fast_order_title AS fast_order_title_26, t16.is_active AS is_active_27, t16.meta_title_template AS meta_title_template_28, t16.meta_description_template AS meta_description_template_29, t16.sort_order AS sort_order_30, t16.child_type_id AS child_type_id_31, t16.root_content_id AS root_content_id_32, t0.root_content_id AS root_content_id_33 FROM seo_type t0 LEFT JOIN seo_type t16 ON t16.child_type_id = t0.id
Parameters:
[] |
| 13 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.base_path AS base_path_4, t0.short_title AS short_title_5, t0.is_list AS is_list_6, t0.is_search AS is_search_7, t0.is_cart AS is_cart_8, t0.is_side_menu AS is_side_menu_9, t0.fast_order_title AS fast_order_title_10, t0.is_active AS is_active_11, t0.meta_title_template AS meta_title_template_12, t0.meta_description_template AS meta_description_template_13, t0.sort_order AS sort_order_14, t0.child_type_id AS child_type_id_15, t16.id AS id_17, t16.name AS name_18, t16.title AS title_19, t16.base_path AS base_path_20, t16.short_title AS short_title_21, t16.is_list AS is_list_22, t16.is_search AS is_search_23, t16.is_cart AS is_cart_24, t16.is_side_menu AS is_side_menu_25, t16.fast_order_title AS fast_order_title_26, t16.is_active AS is_active_27, t16.meta_title_template AS meta_title_template_28, t16.meta_description_template AS meta_description_template_29, t16.sort_order AS sort_order_30, t16.child_type_id AS child_type_id_31, t16.root_content_id AS root_content_id_32, t0.root_content_id AS root_content_id_33 FROM seo_type t0 LEFT JOIN seo_type t16 ON t16.child_type_id = t0.id WHERE t0.child_type_id = ?
Parameters:
[
1
]
|
| 14 | 0.39 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.plain_password AS plain_password_6, t0.is_active AS is_active_7, t8.id AS id_9, t8.name AS name_10, t8.email AS email_11, t8.user_id AS user_id_12 FROM symfony_user t0 LEFT JOIN person t8 ON t8.user_id = t0.id
Parameters:
[] |
| 15 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_id AS user_id_4 FROM person t0
Parameters:
[] |
| 16 | 1.63 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ? ORDER BY s0_.id DESC LIMIT 25
Parameters:
[ 1 25 ] |
| 17 | 1.05 ms |
SELECT count(*) AS sclr_0 FROM seo_content s0_ WHERE s0_.is_published = ? AND s0_.seo_type_id = ?
Parameters:
[ 1 25 ] |
Database Connections
| Name | Service |
|---|---|
| litedb | doctrine.dbal.litedb_connection |
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| litedb | doctrine.orm.litedb_entity_manager |
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
litedb entity manager
No loaded entities.