SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191012 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191012 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907215,792176,172913,341772,952021,324971,237964,186325,502102,214479,283680,792584,629976,518388,28378,129869,341333,66761,880721,738657,227817,202647,959598,30268,427158,981011,1028220,620682,593160,254583,634932,618636,577961,955942,501666,820817,135549,442262,498834,966835,823592,720071,699479,951602,938503,516723,841027,442948,707143,414725,262988,796167,249593,283495,593817,152095,723896,43547,239052,429649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]