SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 864581 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 864581 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404651,428337,107296,626996,1010893,719457,727400,935277,986324,447909,339131,627169,108993,379712,259985,962803,871862,106609,616074,706362,719139,180918,582666,847295,194752,362232,541846,480100,98741,898468,52251,631016,769468,255490,136119,584259,115328,844348,992511,498907,23829,930212,339866,728756,191079,394783,296463,927702,784195,870865,440859,180396,590994,92611,987451,7932,981323,667495,361762,806327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 864581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 864581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]