SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485429 LIMIT 1 [ RunTime:0.001283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485429 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802287,469333,1013249,1024930,885654,471842,598939,1000563,1006738,825336,648519,114237,834438,1047738,591625,200084,774824,1012108,651756,738609,678948,533277,620212,842846,201080,344843,110894,855770,367893,834046,683689,455124,862239,479739,247194,459748,618252,340947,187005,72625,717525,780618,351813,512998,958544,990601,207912,764518,306320,143316,860932,673208,769203,460562,986686,1006463,425959,488475,1021442,266852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]