SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023604 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023604 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832541,464131,1003926,996990,1029366,326612,665233,17610,618206,226682,701170,831944,34026,719895,298407,709161,1033089,397128,377667,815347,834026,451118,623685,505288,9112,420875,21985,881530,892127,1005457,230872,805787,489866,830848,847374,510931,204069,913847,818330,659358,951051,67518,416977,839545,977062,57807,148483,508729,403492,897849,213916,93210,206327,173628,872533,670274,635879,61649,337566,752789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]