SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550640 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550640 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156297,40972,114741,544291,398772,454944,622234,1031720,960782,191046,688403,1044805,263371,215403,844558,523062,321083,873731,744831,940641,639531,261152,863877,241168,730108,23339,638304,434220,614805,774746,226984,168287,789841,81129,477012,447853,109289,11956,46337,910821,868244,971470,605565,1032394,1012566,262477,500428,814818,658801,459376,998346,296876,942201,683543,1032009,676182,976999,195058,813935,934528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]