SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461936 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461936 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033483,800104,170233,476885,429036,399593,602573,866170,642457,460927,991127,699443,504218,655686,41141,366954,950583,1037342,260211,380039,907610,964240,722918,806428,830671,996919,939924,279691,33376,418960,597224,805000,162445,532361,76775,947878,631101,815443,236410,482072,610659,1897,1000572,833090,126041,777295,117197,892937,927542,179690,916660,897361,363100,581587,756544,119973,59239,786129,782238,218225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]