SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458601 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458601 [ RunTime:0.006308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160698,517752,812152,781285,32655,127471,747655,414371,425614,1000766,436985,814566,667574,20260,225510,553688,350914,908007,504454,356778,904553,885501,966637,903299,1025840,907636,484980,667323,462803,961114,437112,124257,492150,349098,641116,565900,989470,362127,117993,516197,1019382,784332,304492,604609,669043,839158,140339,1039745,482984,824579,1046826,216533,757155,646080,346457,109446,380161,957946,835387,676886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]