SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409894 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409894 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711596,609955,195040,837514,596423,259118,240256,383264,369838,233959,1042891,337243,25792,512587,770563,553786,809565,175160,440538,362026,668988,683930,740213,823358,655374,825479,270930,851796,856091,875137,154899,190605,15369,342519,999006,416843,181250,14364,59622,412381,32285,433571,348376,594753,96253,802930,325093,943490,274501,868957,491786,1032633,230735,528461,42728,31767,38114,373785,603989,601167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]