|
0.0007 |
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
]
}
|