SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533680 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533680 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168105,160414,509470,1046257,1003224,764100,805459,718955,480195,661918,595623,207786,574559,553569,750306,1023910,34291,123818,672606,76290,384355,310266,872124,1014324,323077,691460,146017,814177,1007346,190963,343936,392856,584651,135926,458108,841410,679422,240338,44631,222580,789867,1046907,281642,287910,729046,879911,795659,98039,841649,110448,386846,992296,65810,926248,587170,611937,628204,871464,25676,169924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]