SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507299 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507299 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994152,3891,474913,716393,374548,741963,463632,691704,173236,572852,116498,653041,524659,793546,977354,475531,809616,719491,730978,328723,515972,100282,411478,762294,930996,431809,30410,770815,200289,176148,414728,250459,414059,944753,907028,948016,852307,38308,133346,892025,854899,102051,494842,622376,737048,500895,325059,534972,35780,255060,934257,207106,883184,376993,917054,756852,264737,828054,110842,351959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]