SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347860 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347860 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89623,338710,51153,700036,576038,660627,498695,235596,608047,403145,405280,894933,447209,822055,438615,287510,998809,260965,750967,86154,269294,186868,423005,738813,628321,121788,1649,929500,193587,397546,810144,169082,954327,736317,177431,258094,226363,885494,54241,184819,202817,956172,910546,20397,551348,11959,940605,197911,927075,392228,562087,863696,923031,916209,851118,302747,417826,59426,615437,642331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]