SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671628 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671628 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307027,273433,288607,592187,876784,570859,250084,60391,238628,861863,866046,539281,809807,159890,518189,337249,373143,961476,810963,441006,177365,548051,304241,517278,432992,998225,1033810,129350,159680,443355,732597,198165,701253,916805,805285,591425,240076,504489,725384,575809,949305,202933,311613,536580,131267,910764,599683,714514,774398,560565,1983,429225,378193,776765,681108,157646,899938,1025625,328528,863371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]