SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421896 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421896 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573599,540796,376357,987987,93923,934508,960016,36316,588425,264462,278824,622916,956371,294671,83347,368676,638125,997870,126021,825783,911934,77616,348721,364238,716805,803002,847760,618978,909200,201595,818910,142735,763414,115749,88245,967603,110650,50891,887513,684474,547581,135213,175134,610252,712304,246453,437665,448474,920750,713299,141280,56394,567427,565780,784804,406975,89215,529086,322480,823536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]