SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508332 LIMIT 1 [ RunTime:0.001736s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508332 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401532,793268,975128,386001,844637,196995,989108,696724,382501,286006,718266,320006,344123,940222,974115,184849,370174,770639,376502,1012396,77836,907521,127183,982558,242898,57143,40379,656795,588673,481238,20844,685532,862065,653978,775965,197161,327946,402931,955891,638856,775126,348800,484765,653336,359048,418458,718782,800459,894928,857366,841213,867835,682848,1031199,145791,665713,533528,134525,216865,1030250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]