SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482081 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482081 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629676,774006,670845,930408,703742,102510,798088,173253,743713,1034806,1009450,227177,1030836,411215,708309,807653,491306,979760,975909,740529,28662,270654,97850,670550,656289,598137,52545,513482,963488,868802,813296,871675,605427,78891,379809,342988,968138,1016194,701740,609010,281083,480437,479965,959324,53632,882354,213691,450206,345072,269381,278741,228273,558582,835504,283780,1045074,859465,386410,54143,895104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]