| 1 |
0.34 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.type AS type_3 FROM tariff_file_config_global t0 WHERE t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.config AS config_2, t0.type AS type_3 FROM tariff_file_config_global t0 WHERE t0.type = 'state' LIMIT 1;
|
| 2 |
0.23 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.config AS config_2, t0_.active AS active_3 FROM tariff_file_config_supplier_group t0_ WHERE t0_.active = 1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.config AS config_2, t0_.active AS active_3 FROM tariff_file_config_supplier_group t0_ WHERE t0_.active = 1;
|
| 3 |
0.22 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.dm24_id AS dm24_id_3 FROM supplier s0_ WHERE s0_.active = 1 ORDER BY s0_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.dm24_id AS dm24_id_3 FROM supplier s0_ WHERE s0_.active = 1 ORDER BY s0_.name ASC;
|
| 4 |
0.17 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 87;
|
| 5 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 88;
|
| 6 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 15;
|
| 7 |
0.14 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 59;
|
| 8 |
0.17 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 9;
|
| 9 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 76;
|
| 10 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 68;
|
| 11 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 83;
|
| 12 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 97;
|
| 13 |
0.14 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 54;
|
| 14 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 61;
|
| 15 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 29;
|
| 16 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 11;
|
| 17 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 82;
|
| 18 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 65;
|
| 19 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 84;
|
| 20 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 14;
|
| 21 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 80;
|
| 22 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 51;
|
| 23 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 24;
|
| 24 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 47;
|
| 25 |
0.14 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 52;
|
| 26 |
0.14 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 44;
|
| 27 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 62;
|
| 28 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 89;
|
| 29 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 77;
|
| 30 |
0.15 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 72;
|
| 31 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 95;
|
| 32 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 75;
|
| 33 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 96;
|
| 34 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 79;
|
| 35 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 71;
|
| 36 |
0.14 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 78;
|
| 37 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 53;
|
| 38 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 17;
|
| 39 |
0.13 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 85;
|
| 40 |
0.14 ms |
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.config AS config_2, t0.active AS active_3, t0.supplier_id AS supplier_id_4, t0.supplier_group_id AS supplier_group_id_5 FROM tariff_file_config_supplier t0 WHERE t0.supplier_id = 7;
|