|
0.0009 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_custom AS is_custom_3, t0.`order` AS order_4, t0.weight AS weight_5, t0.invoices_limit AS invoices_limit_6, t0.clients_limit AS clients_limit_7, t0.users_limit AS users_limit_8, t0.storage_limit AS storage_limit_9, t0.price AS price_10, t0.currency AS currency_11, t0.promo_period AS promo_period_12, t0.is_upgradeable AS is_upgradeable_13, t0.name FROM plans t0 WHERE t0.name IN ('FREE1', 'SILVER1', 'GOLD1', 'PLATINUM1', 'CUSTOM')
|
|
0.0008 |
SELECT `ff`.`firm_id` AS `id`, IF(`f`.`firm_name` = '' OR `f`.`firm_name` IS NULL , `f`.`subdomain`, `f`.`firm_name`) AS `name`, `ff`.`feature_id` FROM firms_has_feature ff INNER JOIN firms f ON f.id = ff.firm_id WHERE feature_id IN (:ids)
Parameters:{
"ids": [
108,
33,
173,
141,
39,
156,
110,
77,
100,
117,
164,
105,
45,
20,
147,
101,
168,
166,
103,
181,
2,
176,
31,
174,
180,
3,
111,
175,
171,
182,
106,
107,
179,
22,
123,
187,
184,
139,
172,
149,
96,
177,
83,
102,
178,
170,
90,
185,
186,
97,
66,
98,
99,
95,
92
]
}
|
|
0.0005 |
SELECT `ff`.`firm_id` AS `id`, IF(`f`.`firm_name` = '' OR `f`.`firm_name` IS NULL , `f`.`subdomain`, `f`.`firm_name`) AS `name`, `ff`.`feature_id` FROM firms_ignore_feature ff INNER JOIN firms f ON f.id = ff.firm_id WHERE feature_id IN (:ids)
Parameters:{
"ids": [
108,
33,
173,
141,
39,
156,
110,
77,
100,
117,
164,
105,
45,
20,
147,
101,
168,
166,
103,
181,
2,
176,
31,
174,
180,
3,
111,
175,
171,
182,
106,
107,
179,
22,
123,
187,
184,
139,
172,
149,
96,
177,
83,
102,
178,
170,
90,
185,
186,
97,
66,
98,
99,
95,
92
]
}
|