SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520698 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520698 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001222,959854,351815,99706,358967,163996,31374,261016,708298,716391,718319,134812,703253,505547,540902,447387,119432,77320,334882,275534,157677,346188,428445,759125,547963,991570,415229,947129,840611,303967,790649,926173,397348,347119,800172,724316,609625,963664,569561,795702,859397,114308,592214,449488,92729,173135,483291,536352,81150,88675,540520,293436,710507,524105,166228,409543,854249,548149,889770,352829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]